Question: Product mix model Input data Hourly wage rate $8.00 Cost per oz of metal $0.50 Cost per oz of glass $0.75 Frame type Frame 1
| Product mix model | |||||
| Input data | |||||
| Hourly wage rate | $8.00 | ||||
| Cost per oz of metal | $0.50 | ||||
| Cost per oz of glass | $0.75 | ||||
| Frame type | Frame 1 | Frame 2 | Frame 3 | Frame 4 | |
| Labor hours per frame | 2 | 1 | 3 | 2 | |
| Metal (oz.) per frame | 4 | 2 | 1 | 2 | |
| Glass (oz.) per frame | 6 | 2 | 1 | 2 | |
| Unit selling price | $28.50 | $12.50 | $29.25 | $21.50 | |
| Production plan | |||||
| Frames produced | |||||
| Maximum sales | 1000 | 2000 | 500 | 1000 | |
| Minimum frames required | 250 | 250 | 250 | 250 | |
| Resource constraints | Resources used | Resources available | |||
| Labor hours | 4444 | ||||
| Metal (oz.) | 6666 | ||||
| Glass (oz.) | 11111 | ||||
| Revenue, cost summary | |||||
| Frame type | Frame 1 | Frame 2 | Frame 3 | Frame 4 | Totals |
| Revenue | |||||
| Costs of inputs | |||||
| Labor | |||||
| Metal | |||||
| Glass | |||||
| Profit | |||||
The Monet Company produces four types of picture frames, which are labeled 1, 2, 3, and 4. The four types of frames differ with respect of size, shape, and materials used. Each type requires a certain amount of skilled labor, metal, and glass, as shown in the table. The table also lists the unit selling price Monet charges for each type of frame.
During the coming week, Monet can purchase up to 4444 hours of skilled labor, 6666 ounces of metal, and 11,111 ounces of glass. The unit costs are $8.00 per labor hour, $0.50 per ounce of metal, and $0.75 per ounce of glass. Also, market constraints are such that it's impossible to sell more than 1000 type 1 frames, 2000 type 2 frames, 500 type 3 frames, and 1000 type 4 frames. To provide a mix of inventory, at least 250 of each type of frame must be produced. Monet does not want to keep any frames in inventory at the end of the week. What should the company do to maximize its profit for this week?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
