Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

B DF GH M N PThis is a typical fixed-cost product mix model. The company must decide how much, if any, of each product to

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

Step by Step Solution

3.37 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

ALL PICTURE ARE IN EXCEL A 1 Product 2 B D Demand Profit 400000 Fixed ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transport Operations

Authors: Allen Stuart

2nd Edition

978-0470115398, 0470115394

More Books

Students also viewed these General Management questions