A company makes two different models of a product: standard and deluxe. Each unit of standard model requires 60 minutes of cutting and sewing, 31 minutes of finishing, and 8 minutes of packaging and shipping. On the other hand, each unit of deluxe model requires 88 minutes of cutting and sewing, 40 minutes of finishing, and 15 minutes of packaging and shipping. In the next production period, the company has 900 hours in the cutting and sewing department, 500 hours in the finishing department, and 120 hours in the packaging and shipping department. Each unit of standard model will generate a profit of $125 and each unit of deluxe model will generate a profit of $190.
a] Can the company produce S units of standard model and D units of deluxe model in the next production period?
b] What is the profit if the company produce S units of standard model and D units of deluxe model in next production period?
c] How many units of standard model and how many units of deluxe model should the company produce if the company wants to maximize its profit?
Can you show me step by step how to use the solver in excel by putting the information in the spread sheet and what information i need to put in the solver parameter and what formula to use to put in the solver so that it can calculate the information.