Please provide excell file to understand more the problems.

.JL.53 Bob's Bumpers has a repetitive manufacturing facility in Kentucky that makes automobile bumpers and other auto body parts. The facility operates 330 days per year and has annual demand oft-34,000 bumpers. They can produce up to 410 bumpers each day. It oosts $5? to set up the production line to produce bumpers. The cost ofeach bumper is $13? and annual holding costs are $40 per unit. Setup labor cost is $23 per hour. What is the optimal size of the production run for bumpers? (Display your answer to the nearest whole number.) 588 9 Based on your answer to the previous question, and assuming the manufacturer holds no safety stock: what would be the average inventory forthese bumpers? (Display your answer to the nearest whole number.) 294 9 Based on your answer two questions back, how many production runs will be required each year to satisfy demand? HINT: As a general rule, whenever calculating a value that is based on previous calculations in Excel. always be sure to use oell references rather than a rounded value as a calculation input. (Display your answer to the appropriate whole number.) 109 9 Suppose the customer (an auto manufacturer) wants to purchase in lots of 390 and that Bob's Bumpers is able to reduce setup COSTS t0 the point where 390 is now the optimal production run quantity. How much will they save in annual holding oosts with this new lower production quantity? (Display your answer to two decimal places.) 3966.48 9 How much will they save in annual setup costs with this nev.r lower production quantity? {Display your answer to hire decimal places.) 1249.69 9 Pregunta 5 LM.97 Each week the ABC Company, from Albuquerque, NM receives 63 separate parcel shipments from a number of different suppliers in the Dallas, TX area. Each parcel shipment from Dallas to Albuquerque costs $97. 3 puntos Ayuda de numeros Alternate Shipping Method A Dallas-based 3PL provider has approached ABC Company with a proposal to run a consolidation operation where they would pick up the supplier shipments each week and load them on to one truck for shipment to Albuquerque. The relative data for this alternative shipping method are as follows: Local pickup fee = $33 pickup fee Average weight per supplier shipment = 125 lbs. . Local consolidation fee = $38 per hundred-weight Consolidated TL shipment from Dallas to Albuquerque = $970 What is the total cost of shipping the separate parcel shipments from the Dallas-area suppliers to the ABC company location in Albuquerque? (Display your answer as a whole number.) 6111 How much money would ABC Company save to hire the 3PL to pickup the shipments from each supplier and consolidate them into one bulk shipment to Albuquerque? (Display your answer as a whole number.) 70 At what number of shipments is the cost the same for the two options? (Display your answer as a whole number.) 34F075 The Rexburg Taco Bell wants to forecastby time of day or "season"the total number of Crunchy Tacos it will sell in July, based on the previous 5 months of sales as found in the table below: Meal Tlme Jan Lunch 2.012 fternoon 851 Dinner | 2,079 FourthMeal 463 What is the seasonal index for the lunch season? (Display your answer to two decimal places.) 1.47 a What is the seasonal index for the dinner season? (Display your answerto two decimal places.) 1.49 o What is the seasonal index for the FourthMeal season? {Display your answer to two decimal places.) 0.36 0 Taco Bell believes that total July sales of Crunchy Tacos will be 5600. Based on this forecast for July, how many Crunchy Tacos should they expect to sell during the afternoon "season" in that month? {Display your answer to two decimal places.) 940] o