Question: Please answer #2 and #3 in excel format with the formulas showing. Screenshots work perfectly! 2. Orion Manufacturing Inc., a fictional company, has scheduled production

Please answer #2 and #3 in excel format with the formulas showing. Screenshots work perfectly!
2. Orion Manufacturing Inc., a fictional company, has scheduled production of the following three of its products for the 4 weeks of January as shown in the following table: Week Product 2 4 3 200 70 120 160 75 55 25 30 35 20 70 90 The two key work centers for producing these three products are fabrication and assembly. The fabrication work station has capacity efficiency and utilization rates of 90% and 95%. The efficiency and utilization rates of the assembly work station are 94% and 90%. The standard hours per unit of time required for the three products in each of the two work centers are given in the following table: Product Assembly Fabrication 0.3 0.4 0.2 0.25 0.1 02 If each work center is available for 8 hours, 5 days a week, determine the work load per week in each work center in January. 3. Firebird Bicycle Company, a fictional company, produces three brands of bicycles: Racing, Mountain, and Cruiser bicycles. The master schedule in the following table shows the demand requirements for the month of March for the three brands of bicycles. The standard labor hours per unit required for each brand in the two key work centers of welding and assembly are also given in the second table: Master Schedule Requirements Brand Demand Requirements Racing Bicycles 100 Mountain Bicycles 150 Cruiser Bicycles 200 Standard Labor Hours per Unit in Each Work Center Brand Welding Assembly Racing Bicycles 0.6 17 Mountain Bicycles 10 1.9 Cruiser Bicycles 0.5 13 Assuming an 8-hour work day and 20 working days in the month of March, how many workers would be needed in each work center to meet the master schedule requirements? If there is a capacity overload or underload in any of the work centers, what are some approaches you would take to level capacityStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
