Question: please, solve using excel and show the formulas you enter 2) A company manufactures and sells two products. The company manager needs to decide how
please, solve using excel and show the formulas you enter
2) A company manufactures and sells two products. The company manager needs to decide how many of each product to produce during his next production cycle to maximize the profit. The company makes a profit of $10 for each unit of product 1 sold and a profit of $ 4.5 for each unit of product 2. Each product 1 requires one hour of labor from Department 1, one hour from department 2, and two hours from department 3. Each product 2 requires two hours of labor from Department 1, three hours from department 2, and three hours from department 3. The Manager has estimated the following labor hours will be available next production cycle. Department 1: 750 hours, Department 2: 510 hours, Department 3: 1200 hours, In order to produce product 1, the manager should purchase a piece of equipment for $800, and in order to produce product 2, the manager should purchase a piece of equipment for $900. a) Formulate an ILP for this problem. b) Implement your model in a spreadsheet and solve it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
