I just need question 4 - Please show your work in excel to know where the numbers come from. JL.53 Bob's Bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other auto body parts. The facility operates320 days per year and has annual demand of 52,000 bumpers. They can produce up to 385 bumpers each day. It costs $66 to set up the production line toproduce bumpers. The cost of each bumper is $84 and annual holding costs are $32 per unit. Setup labor cost is $27 per hour.What is the optimal size of the production run for bumpers? (Display your answer to the nearest whole number.)609Based on your answer to the previous question, and assuming the manufacturer holds no safety stock, what would be the average inventory for thesebumpers? (Display your answer to the nearest whole number.)305Based on your answer two questions back, how many production runs will be required each year to satisfy demand? HINT: As a general rule, whenevercalculating a value that is based on previous calculations in Excel, always be sure to use cell references rather than a rounded value as a calculation input.(Display your answer to the nearest whole number.)85Suppose the customer (an auto manufacturer) wants to purchase in lots of 370 and that Bob's Bumpers is able to reduce setup costs to the point where 370is now the optimal production run quantity. How much will they save in annual holding costs with this new lower production quantity? (Display your answer totwo decimal places.)2212.07How much will they save in annual setup costs with this new lower production quantity? (Display your answer to two decimal places.)2212.07

Given, Annual demand D = 52000 bumpers Daily demand d = 52000/320 = 162.5 Production capacity p =…

Suppose the customer (an auto manufacturer) wants to purchase in lots of 370 and that Bob's Bumpers is able to reduce setup costs to the point where 370 is now the optimal production run quantity. How much will they save in annual holding costs with this new lower production quantity?? (Display your answer to two decimal places.) 2212.07

Suppose the customer (an auto manufacturer) wants to purchase in lots of 370 and that Bob's Bumpers is able to reduce setup costs to the point where 370 is now the optimal production run quantity. How much will they save in annual holding costs with this new lower production quantity?? (Display your answer to two decimal places.) 2212.07

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

13.4. The Sofaworld Company purchases upholstery material from Barrett Textiles. The company uses 45,000 yards of material per year to make sofas. The cost of ordering material from the textile company is $1500 per order. It costs Sofaworld $0.70 annually to hold a yard of material in inventory. Determine the optimal number of yards of mate- rial Sofaworld should order, the minimum total inventory cost, the opti- mal number of orders per year, and the optimal time between orders.
Sharpe Cutter is a small company that produces specialty knives for paper cutting machinery. The annual demand for a particular type of knife is 100,000 units. The demand is uniform over the 250 working days in a year. Sharpe Cutter produces this type of knife in lots and, on average, can produce 450 knives a day. The cost to set up a production lot is $300,and the annual holding cost is $1.20 per knife.a. Determine the economic production lot size (ELS).b. Determine the total annual setup and inventory holding cost for this item.c. Determine the TBO, or cycle length, for the ELS.d. Determine the production time per lot.
3) The TCC Art Gallery prints a brochure for visitors to the senior art showcase it sponsors at thecollege. There are about 16000 visitors per year to this event (held year round). Holding costs for thebrochures are 25% and it costs $40 to place an order with the printer. The printer has offered thefollowing discount schedule:Category Order Size Unit Cost1 0 - 1499 $2.602 1500 - 2999 $2.303 3000 and over $1.90Answer the following questions in a text box in the worksheet.A) How many orders should be made?B) How many brochures should be printed at a time?C) Please copy these two numbers and include them on the executive summary (the first worksheet).
3. Tamjid manufactures scented candles and sells these candles in his own retail store. His annual sales volume is 4,800 boxes of candles and he operates 240 days per year. He can manufacture these candles at a rate of 48 boxes per day. Assume that demand is uniform. Setup cost is Tk. 32 for a run, and holding cost is 400 paisa per box. a) Figure out the optimum production size. b) Minimum total annual cost for carrying and set up. ed for quotatic c) What is the run time? d) What is the cycle time? e) How much the company can save annually if the setup cost could be reduced to Tk 25 per run?
Basic EOQ. This type of problem can be recognized when annual demand (D), ordering cost (S), andholding or carrying cost per unit (H) are given. Use Formula 13–2 for order quantity, Formula 13–1for total cost, and D/Q for number of orders a year.A toy manufacturer uses approximately 32,000 silicon chips annually. The chips are used at asteady rate during the 240 days a year that the plant operates. Annual holding cost is $3 per chip, andordering cost is $120. Determine the following:a. The optimal order quantityb. The number of workdays in an order cycle
Catlea Merchandising is engaged in selling school shoesfor both boys and girls in their teenage years. Catlea needs 32,000 pairs of shoes in a year in order to satisfy the market demand. It costs ₱ 48 to place an order while ₱ 8 is needed to hold each quantity of shoe in Catlea's inventory. Upon checking on Catlea's supplier, it takes 8 days in between placing an order and eventually receiving it. a. Determine the Economic Order Quantityb. Determine the number of order per monthc. Determine the reorder point
Billl's Ice Cream makes 4 different flavors of ice cream using their secret process and top secret recipes. Each of their flavors is equally popular and experiences a demand of 12000 kg/year. Bill's process is capable of producing 300 kg/day once they incur the $140 setup cost. The ice cream holding cost is 20% of the $17 per kg price. Bill's plant runs 300 days a year. a. Determine the economic production quantity.b. If Bill chooses to use the economic production quantity, what is the annual cost?c. What would be the production run time?
In the basic EOQ model, if annual demand is 185, holding cost is $4.22 (per unit per year), and total inventory related cost on the basis of EOQ is $410, the EOQ(rounded to the next whole number) is: a. 205 b. 10 c. 92 d. 98
35) Oman Apparels needs to place order for materials for their operations. The material costs OMR 1,000, and the annual holding cost is 25%, annual demand is 10,000 units, and the order cost is OMR 150 per order. Find out the approximate economic order quantity of the company? a. 250 units b. 110 units c. 12,000 units d. 70 units
Roybow Corporation sells lawn mowers that cost $160 each to purchase and prepare for sale. Annual sales are 5,000 mowers , carrying costs are 20 percent of inventory costs , and Roybow icurs a cost of $32 each time an order is placed. a) what is the EOQ for the mowers b) what will be the total inventory costs if the EOQ amount is ordered?
Gamin Inc. produces various GPS devices with a wide assortment of different models for its customers. One item, RC1 is very popular. Keen of keeping its stock under control, a decision is taken to order only the optimum economic quantity, for this item, each time. You have the following information. Annual demand (units) 115,200 Purchase price per unit $ 300 Carrying/Holding costs per unit $ 8 Cost per order $ 200 Required: a.Determine the EOQ using the equation method. b.Fill the blanks in the following table using the above data. No. of orders 1 10 20 30 90 120 Order size Average stock Carrying (Holding) costs Order costs Total costs Calculate the holding, ordering cost & their total cost at the EOQ level. Plot the graph at the EOQ level showing the…
Q2) Groundz Coffee Shop uses 4 kgs of a specialty tea weekly; each kg costs $16. Carrying costs are $1 per kg per week because space is very scarce. It costs the firm $8 to prepare an order. Assume 52 weeks per year. How many kgs of tea should Groundz order at a time? What is total annual cost. How many orders should Groundz place annually. Q2) Groundz Coffee Shop uses 4 kgs of a specialty tea weekly; each kg costs $16. Carrying costs are $1 per kg per week because space is very scarce. It costs the firm $8 to prepare an order. Assume 52 weeks per year. How many kgs of tea should Groundz order at a time? What is total annual cost. How many orders should Groundz place annually.