The deliverable for this assignment is an Excel file, named Ch5__.xlsx. The Excel file should contain one
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 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
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel