Question: please solve in Excel and upload excel sheet Question 4: Drolet Manufacturing Company. in Saint-Hubert, Quebec. makes flashing lights for toys. The company operates its

please solve in Excel and upload excel sheet

please solve in Excel and upload excel sheet
Question 4: Drolet Manufacturing Company. in Saint-Hubert, Quebec. makes flashing lights for toys. The company operates its production facility 300 days per year. It has orders for about 12000 tflashing lights per year and has the capability of producing 200 per day. Setting up the light production costs $100. The cost of each light 1s $1. The holding cost 1s $0.10 per light per year. a) What 1s the optimal size of the production run? b) What is the total cost per year, including the cost of the lights? ) What 1s the maximum level of inventory

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!