Question: Question 1: Model Formulation and Computer Solution (15 Points) Problem statement A company produces two types of dishwashers: Standard and Turbo. The production of a

Question 1: Model Formulation and Computer Solution (15 Points) Problem statement A company produces two types of dishwashers: Standard and Turbo. The production of a dishwasher from either model goes through three operations. The following table shows the time required for each operation in minutes. Standard 3 Stamping Motor installation Wiring Turbo 6 10 15 10 10 The time available for Stamping is 30 minutes per hour. The time available for Motor installation is 60 minutes per hour. The company has two stations for Wiring and each of them is available for 45 minutes per hour. The profit made is $20 from each Standard dishwasher and $30 from each Turbo dishwasher. a. Define Decision Variables. Your definition must be complete. (2 points) b. Develop the Objective Function. (2 points) c. Develop the constraints. (6 points) d. Solve the model using Excel solver. Include excel file with your submission. (5 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
