Question: You may use Microsoft Excel or any other technology to complete the question as long as the explanation is clear. Please complete the following problems:
You may use Microsoft Excel or any other technology to complete the question as long as the explanation is clear. Please complete the following problems: 1. The profit function for two products is:
where x_1 represents units of production of product 1, and x_2 represents units of production of product 2. Producing one unit of product 1 requires 4 labor-hours and producing one unit of product 2 requires 6 labor-hours. Currently, 24 labor-hours are available. The cost of labor-hours is already factored into the profit function, but it is possible to schedule overtime at a premium of $5 per hour.
a. Formulate an optimization problem that can be used to find the optimal production quantity of products 1 and 2 and the optimal number of overtime hours to schedule.
b. Solve the optimization model you formulated in part (a). How much should be produced and how many overtime hours should be scheduled?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
