This is a typical fixed-cost product mix model. The company must decide how much, if any, of each product to produce, where a fixed cost is charged for each product that is produced at a positive level. The problem is to maximize total profit, subject to the resource constraints and the maximum production constraints. Which of the following is true when comparing the model with fixed costs to the with no fixed costs? Note: When you run Solver for the fixed-cost model, make sure the Integer Optimality % is set to 0, to ensure that you find the optimal solution.

Transcribed Image Text:

Pl B D F G H M This is a typical fixed-cost product mix model. The company must decide how much, if any, of each product to produce, where a fixed cost is charged for each product that is produced at a positive level. The problem is to maximize total profit, subject to the resource constraints and the maximum production constraints. Which of the following is true when comparing the model with fixed costs to the with no fixed costs? Note: When you run Solver for the fixed-cost model, make sure the Integer Optimality % is set to 0, to ensure that you find the optimal solution. 1 Click here to reference the data needed to answer the question. a. In both models, all products produced at a positive level are produced at their maximum production levels. 4 b. Both models have exactly the same optimal production levels. 5 c. When there are no fixed costs, the optimal total profit is at least $6,000 larger than when there are fixed costs. d. All of these choices are true. 7 Product mix model with fixed costs 9 Resources used per unit of product produced 10 11 Resource 1 12 Resource 2 Product 1 Product 2 Product 3 Product 4 Product 5 Product 6 Product 7 Product 8 2,0 2,5 2,3 2,0 2,2 2,5 2,4 2,8 2,5 2,3 2,0 2,9 2,9 2,1 2,5 2,6 2,5 13 Resource 3 2,2 2,1 2,4 2,3 2,0 2,9 2,6 14 Resource 4 15 16 Inputs on products 17 Unit revenue 2,8 2,4 2,4 2,7 2,1 2,0 2,2 2,5 $25,30 $15,90 $9,40 $1.800 $22,50 $13,80 $8,70 $1.600 $29,60 $21,90 $7,70 $1.400 $22,70 $21,80 $12,90 $8,90 $1.000 $27,30 $23,00 $17,50 $5,50 $20,70 $16,00 $6,70 $1.800 18 Unit variable cost 19 Unit margin 20 Fixed cost 21 Maximum production 22 23 Decisions 24 Produce any? 25 26 Units produced 27 28 Effective capacity 29 $19,50 $7,80 $1.100 $15,20 $5,50 $1.700 $1.400 560 550 550 500 490 400 570 410 80 Constraints on resources 31 32 Resource 1 Used Available 12500 83 Resource 2 6000 34 Resource 3 35 Resource 4 36 87 Monetary outputs 38 Total revenue 11000 イー 5000 39 Total variable cost a0 Total fixed cost 31 Total profit 42 Pl B D F G H M This is a typical fixed-cost product mix model. The company must decide how much, if any, of each product to produce, where a fixed cost is charged for each product that is produced at a positive level. The problem is to maximize total profit, subject to the resource constraints and the maximum production constraints. Which of the following is true when comparing the model with fixed costs to the with no fixed costs? Note: When you run Solver for the fixed-cost model, make sure the Integer Optimality % is set to 0, to ensure that you find the optimal solution. 1 Click here to reference the data needed to answer the question. a. In both models, all products produced at a positive level are produced at their maximum production levels. 4 b. Both models have exactly the same optimal production levels. 5 c. When there are no fixed costs, the optimal total profit is at least $6,000 larger than when there are fixed costs. d. All of these choices are true. 7 Product mix model with fixed costs 9 Resources used per unit of product produced 10 11 Resource 1 12 Resource 2 Product 1 Product 2 Product 3 Product 4 Product 5 Product 6 Product 7 Product 8 2,0 2,5 2,3 2,0 2,2 2,5 2,4 2,8 2,5 2,3 2,0 2,9 2,9 2,1 2,5 2,6 2,5 13 Resource 3 2,2 2,1 2,4 2,3 2,0 2,9 2,6 14 Resource 4 15 16 Inputs on products 17 Unit revenue 2,8 2,4 2,4 2,7 2,1 2,0 2,2 2,5 $25,30 $15,90 $9,40 $1.800 $22,50 $13,80 $8,70 $1.600 $29,60 $21,90 $7,70 $1.400 $22,70 $21,80 $12,90 $8,90 $1.000 $27,30 $23,00 $17,50 $5,50 $20,70 $16,00 $6,70 $1.800 18 Unit variable cost 19 Unit margin 20 Fixed cost 21 Maximum production 22 23 Decisions 24 Produce any? 25 26 Units produced 27 28 Effective capacity 29 $19,50 $7,80 $1.100 $15,20 $5,50 $1.700 $1.400 560 550 550 500 490 400 570 410 80 Constraints on resources 31 32 Resource 1 Used Available 12500 83 Resource 2 6000 34 Resource 3 35 Resource 4 36 87 Monetary outputs 38 Total revenue 11000 イー 5000 39 Total variable cost a0 Total fixed cost 31 Total profit 42

Answer rating: 100% (QA)

ALL PICTURE ARE IN EXCEL A 1 Product 2 B D Demand Profit 400000 Fixed ... View the full answer