Question: The deliverable for this assignment is an Excel file, named Ch5__.xlsx. The Excel file should contain one worksheet per answer to Exercise 1 (i.e., one
The deliverable for this assignment is an Excel file, named "Ch5__.xlsx". The Excel file should contain one worksheet per answer to Exercise 1 (i.e., one worksheet "Answer a)", a second worksheet "Answer b), etc.). The file must be submitted on Canvas by the deadline. Total Points: 10 Assignment Exercise 1 A company manufactures two products on two machines. The number of hours of machine time and labor depends on the machine and product as shown in the table below. The cost of producing a unit of each product depends on which machine produces it. These unit costs also appear in the table below. Product 1 Product 2 Machine 1 Machine 2 Machine 1 Machine 2 Machine Time (hours) 0.7 0.8 0.75 0.9 Labor (hours) 0.75 1.2 0.75 1 Unit Costs $1.5 $2.2 $0.4 $4 There are 200 hours available on each of the two machines, and there are 400 labor hours available total. This month at least 200 units of product 1 and at least 240 units of product 2 must be produced. a) Write down a mathematical formulation for minimizing the costs of the company. (Remember to specify what the decision variables are, what the
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
