Question: How do I solve this using Excel and Excel Solver? Thank you!! The Gourmet Grill Company manufactures and sells two different types of grills: propane
How do I solve this using Excel and Excel Solver? Thank you!!
The Gourmet Grill Company manufactures and sells two different types of grills: propane and electric. Each propane grill sells for $320 and costs $220 to manufacture. Each electric grill sells for $260 and costs $180 to manufacture. Each grill goes through four operations in the manufacturing process. The hours required by each type of grill in each of these manufacturing processes is summarized as follows: Hours Required per Unit Manufacturing Process Propane Electric Machine Press 2. 1 Fabrication 4 LO 5 Assembly 2 3 Testing 1 1 In the next production cycle, there are 2,400 hours of machine press time available, 6,000 hours of fabrication, 3,300 hours of assembly, and 1,500 hours of testing capacity. Assume Gourmet Grill can sell everything it makes and would like to determine the production plan that would maximize profit. a. Formulate an LP model for this problem. b. Sketch the feasible region for this problem. c. Determine the optimal solution to this problem using level curves
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
