Question: please show in excel for the various aspects!! 17. The MN plant manufactures two different products: M and N. Selling prices and weekly market demands
please show in excel for the various aspects!!
17. The MN plant manufactures two different products: M and N. Selling prices and weekly market demands are shown in the following diagram. Each product uses raw materials with costs as shown. The plant has three different machines: A, B, and C. Each performs different tasks and can work on only one unit of material at a time. Process times for each task are shown in the diagram. Each machine is available 2,400 minutes per week. There are no "Murphys" (major opportunities for the system to foul up). Setup and transfer times are zero. Demand is constant. Operating expenses (including labor) total a constant $12,000 per week. Raw materials are not included in weekly operating expenses. (Answers in Appendix E) a. Where is the constraint in this plant? b. What product mix provides the highest profit? c. What is the maximum weekly profit this plant can earn? Resources: A, B, C (one each) Availability: 2,400 min/week Operating expense: $12,000 week

Step 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
