1. How many of each product should be sold to maximize the total contribution margin? If a product should not be produced at all, enter "0" for your answer. Number of basic units: 1,601,000 Number of standard units: Number of deluxe units: What is the contribution margin per machine hour for each of these products? If required, round your answers to the nearest cent. Basic units: 52.20 per machine hour Standard units: Deluxe units: 32.2 per machine hour 38.72 per machine hour What is the total contribution margin for this product mix? 8,357,220 2. Suppose that Patz can sell no more than 263,000 units of each type at the prices indicated. What product mix would you recommend? Number of basic units: Number of standard units: Number of deluxe units: What would be the total contribution margin? 3. What data analytic type(s) are being used in Requirements 1 and 2? Choose from the following types: descriptive, diagnostic, predictive, and prescriptive. Explain your choices. See Exhibits 2.5 and 2.6, for a brief review of data analytics. In both requirements, the optimal product mix is calculated by the model; thus, the mix is what should be used and accordingly corresponds to the prescriptive type.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints
Section: Chapter Questions
Problem 16E
icon
Related questions
Question
None
Product Mix Decision, Single Constraint
Patz Company makes three types of stainless steel frying pans. Each of the three types of pans requires the use of a special machine that has total operating capacity of 160,100 hours per year. Information on each of the three products is as follows:
Basic Standard Deluxe
Selling price
Unit variable cost
Machine hours required
$12.44
$17.44
$32.96
$7.22
$11.00
$13.60
0.10
0.20
0.50
The marketing manager has determined that the company can sell all that it can produce of each of the three products.
Required:
1. How many of each product should be sold to maximize the total contribution margin? If a product should not be produced at all, enter "0" for your answer.
Number of basic units:
Number of standard units:
Number of deluxe units:
1,601,000
0
What is the contribution margin per machine hour for each of these products? If required, round your answers to the nearest cent.
Basic units:
52.20 per machine hour
Standard units:
32.2 per machine hour
Deluxe units:
38.72 per machine hour
What is the total contribution margin for this product mix?
8,357,220
2. Suppose that Patz can sell no more than 263,000 units of each type at the prices indicated. What product mix would you recommend?
Number of basic units:
Number of standard units:
Number of deluxe units:
What would be the total contribution margin?
3. What data analytic type(s) are being used in Requirements 1 and 2? Choose from the following types: descriptive, diagnostic, predictive, and prescriptive. Explain your choices. See Exhibits 2.5 and 2.6, for a brief review of data analytics.
In both requirements, the optimal product mix is calculated by the model; thus, the mix is what should be
used and accordingly corresponds to the prescriptive ✓ type.
Transcribed Image Text:Product Mix Decision, Single Constraint Patz Company makes three types of stainless steel frying pans. Each of the three types of pans requires the use of a special machine that has total operating capacity of 160,100 hours per year. Information on each of the three products is as follows: Basic Standard Deluxe Selling price Unit variable cost Machine hours required $12.44 $17.44 $32.96 $7.22 $11.00 $13.60 0.10 0.20 0.50 The marketing manager has determined that the company can sell all that it can produce of each of the three products. Required: 1. How many of each product should be sold to maximize the total contribution margin? If a product should not be produced at all, enter "0" for your answer. Number of basic units: Number of standard units: Number of deluxe units: 1,601,000 0 What is the contribution margin per machine hour for each of these products? If required, round your answers to the nearest cent. Basic units: 52.20 per machine hour Standard units: 32.2 per machine hour Deluxe units: 38.72 per machine hour What is the total contribution margin for this product mix? 8,357,220 2. Suppose that Patz can sell no more than 263,000 units of each type at the prices indicated. What product mix would you recommend? Number of basic units: Number of standard units: Number of deluxe units: What would be the total contribution margin? 3. What data analytic type(s) are being used in Requirements 1 and 2? Choose from the following types: descriptive, diagnostic, predictive, and prescriptive. Explain your choices. See Exhibits 2.5 and 2.6, for a brief review of data analytics. In both requirements, the optimal product mix is calculated by the model; thus, the mix is what should be used and accordingly corresponds to the prescriptive ✓ type.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning