Please show your work in excel. (with the formulas)

JL.54 Altec Lansing makes a variety of speakers for computer systems and they are looking to adopt Lean Production principles into their main production facility. This production facility operates 290 days per year one of their bestselling speaker systems has annual demand of 30,000 units. They can produce up to 1,250 of these systems each day. It costs $18.26 to set up a work cell to produce this system. The cost of each system is $41 and annual holding costs are $9.10 per unit. Setup labor cost is $13 per hour What is the optimal size of the production run for this system? (Display your answer to the nearest whole number). Nmero Given your answer to the previous question, how many production runs will be required each year in order to meet the annual demand? (Round your answer UP to the next whole number.) Nmero How much time (in minutes) does it take to set up a work cell? (Display your answer to the nearest whole number.) Nmero The large retailers who are wholesale customers of Altec Lansing are pressing the company to sell this and other speaker systems in much smaller quantities to support their JIT distribution models. For example, for this particular speaker system wholesale customers want to purchase in lots of 120. In order to meet this requirement, what would be the required setup time (in minutes) to make this order quantity an optimal production run quantity? (Display your answer to the nearest whole number.) Nmero