Question

In: Accounting

PARAMETERS FOR BASELINE CASE The following numbers are estimates for the upcoming year for a manufacturing...

PARAMETERS FOR BASELINE CASE
The following numbers are estimates for the upcoming year for a manufacturing company.
Since the company is effective at implementing a JIT inventory system, assume there is
no beginning or ending inventory.
No. of units sold 120,000
Selling price per unit $240.00
                           Fixed Expenses Variable Expenses         (per unit sold
Production costs:
Direct materials $18.00
Direct labor 36.00
Factory overhead $2,160,000 24.00
Marketing expenses:
Sales salaries and commissions 540,000 7.50
Advertising 360,000
Miscellaneous mktg. expenses 108,000
Administration expenses:
Office salaries 720,000
Supplies 105,000 1.50
Miscellaneous admin. expenses 72,000              
     TOTAL EXPENSES $4,065,000 $87.00
Contribution Margin Income Statement
Sales Revenues (120,000 Units at $240) $28,800,000.00
Variable Costs:
    Direct Materials (120,000 Units at $18) $2,160,000
    Direct Labor (120,000 Units at $36) $4,320,000
    Variable factory Overhead (120,000 x $24) $2,880,000
    Variable selling expenses (120,000 x 7.50) $900,000
    Variable Adminstrative Expenses (120,000 x 1.50) $180,000
Total Variable Cost $10,440,000.00
Contribution Margin (Sales - Total Variable Cost) $18,360,000.00
Total Fixed Costs $4,065,000.00
Operating Income $14,295,000.00
Contribution Margin Per Unit (B11 - C26)
    =Unit selling price – Unit total variable cost
    =$240 - $87
    =$153 per unit
Contribution Margin Percentage (A43 / B11 * 100)
    =Unit Contribution Margin / Unit Selling Price * 100
    =$153 / $240 * 100
    =63.75%
Breakeven Point in Units (C40 / A51)
    =Total Fixed Costs / Contribution Percentage
    =$4,065,000 / 63.75%
    =$6,376,471

You want to determine whether the following four suggestions (i.e., e, f, g, h) would improve the company’s performance. Determine the effects of each suggestion on operating income, contribution margin per unit, contribution margin percentage, breakeven point in units, and breakeven point in sales dollars.

Calculate the effects of each suggestion independently of the other suggestions. In other words, use the original baseline case data and make the first change (e); use the original baseline case data and make the second change (f); and so on. However, do not overwrite the original baseline case. The easiest way to do this is to copy the original data to a new sheet and then replace the original data parameters. To copy a sheet, click on the sheet name. Select “Move or Copy.” Click on the “Create a copy” box. Click OK. Rename your new sheet to indicate the name of the new scenario. For example, you could name the sheet for (e) ‘Commission.’ To rename a sheet, right click on the sheet name. Select “Rename.” Key in the new name.

Put all personnel on commission. This action would affect the sales salaries and commissions expense by eliminating the fixed portion and increasing the variable portion by $4.50 per unit. Sales would increase by 44,000 units.

Redesign the package for the product. This would decrease the variable direct materials cost by $1.50 per unit but would increase the fixed factory overhead by $36,000.

Launch a new advertising campaign. This would increase fixed advertising expense by $348,000 but would increase sales volume by 4,800 units.

Reduce the selling price of the product by $15.00 per unit. This would increase sales volume by 16,800 units.

Solutions

Expert Solution

Note: in case of any clarification, please do comment. Thank you.

1st cas No. of units sold 2nd case No. of units sold 1,64,000 240.00 1,20,000 240.00 Selling price per unit Selling price per unit Fized EzpensesYariable Expenses Fized EzpensesYariable Expenses (P.U sold) (P.U sold) Production costs: Production costs: Direct labor 36.00 Direct labor 36.00 21,60,000.00 21,96,000.00 Marketing expenses: Sales salaries and commissions Marketing expenses: Sales salaries and commissions 5,40,000.00 3,60,000.00 3,60,000.00 1,08,000.00 Miscellaneous mktq. expenses Administration expenses: Miscellaneous mktq. expenses Administration expenses: 7,20,000.00 1,05,000.00 72000.00 35,25,000.00 7,20,000.00 1,05,000.00 72000.00 41,01,000.00 Miscellaneous admin. expenses Miscellaneous admin. expenses TOTALEXPENSES TOTALEXPENSES 85.50 Contribution Margin Income Statement Contribution Margin Income Statement Sales Revenues 120,000 Units at $240 393,60,000.00 Sales Revenues 120,000 Units at $240 288,00,000.00 ariable Costs: Direct Materials (120,000 Units at $18 Direct Labor (120,000 Units at $36 ariable Costs: Direct Materials (120,000 Units at $18 Direct Labor (120,000 Units at $36 29.52.000.00 59,04,000.00 39.36.000.00 19,68,000.00 19,80,000.00 43,20,000.00 2880,000.00 9,00,000.00 Variable Factory Overhead (120,000% $24 Variable selling expenses (120,000% 7.50 Variable Factory Overhead (120,000% $24 Variable selling expenses (120,000% 7.50 Variable Adminstrative Expenses 1120,000% 1.50 2,46,000.00 Variable Adminstrative Expenses 1120,000% 1.50 1,80,000.00 Total Variable Cost Contribution Margin [Sales Total Variable Cost Total Fixed Costs 150,06,000.00 243,54,000.00 35,25,000.00 208,29,000.00 Total Variable Cost Contribution Margin [Sales Total Variable Cost Total Fixed Costs 02,60,000.00 185.40,000.00 41,01,000.00 144,39,000.00 erating Income erating Income Contribution Margin Per Unit Contribution Margin Per Unit ce - Unit total variable cost ce - Unit total variable cost $240 $91.50 148.50 $240 $85.50 154.50


Related Solutions

PARAMETERS FOR BASELINE CASE The following numbers are estimates for the upcoming year for a manufacturing...
PARAMETERS FOR BASELINE CASE The following numbers are estimates for the upcoming year for a manufacturing company. Since the company is effective at implementing a JIT inventory system, assume there is no beginning or ending inventory. No. of units sold 36,000 Selling price per unit $243.00                            Fixed Expenses Variable Expenses         (per unit sold Production costs: Direct materials $18.23 Direct labor 36.45 Factory overhead $2,187,000 24.30 Marketing expenses: Sales salaries and commissions 546,750 7.60 Advertising 364,500 Miscellaneous mktg. expenses 109,350...
PARAMETERS FOR BASELINE CASE The following numbers are estimates for the upcoming year for a manufacturing...
PARAMETERS FOR BASELINE CASE The following numbers are estimates for the upcoming year for a manufacturing company. Since the company is effective at implementing a JIT inventory system, assume there is no beginning or ending inventory. No. of units sold 120,000 Selling price per unit $240.00                            Fixed Expenses Variable Expenses         (per unit sold Production costs: Direct materials $18.00 Direct labor 36.00 Factory overhead $2,160,000 24.00 Marketing expenses: Sales salaries and commissions 540,000 7.50 Advertising 360,000 Miscellaneous mktg. expenses 108,000...
Complete four other scenarios (i.e., what-if analyses), and recommend the best scenario PARAMETERS FOR BASELINE CASE...
Complete four other scenarios (i.e., what-if analyses), and recommend the best scenario PARAMETERS FOR BASELINE CASE The following numbers are estimates for the upcoming year for a manufacturing company. Since the company is effective at implementing a JIT inventory system, assume there is no beginning or ending inventory. No. of units sold 120,000 Selling price per unit $240.00                            Fixed Expenses Variable Expenses         (per unit sold Production costs: Direct materials $18.00 Direct labor 36.00 Factory overhead $2,160,000 24.00 Marketing expenses:...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $4,460 Accounts receivable, net. . . . . . . . . . . . . $46,000 Inventory....
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations: Current Assets of December 31 (prior year): Cash $4,460 Accounts receivable, net $52,000 Inventory $15,400 Property, plant and equipment, net $122,000 Accounts payable $44,000 Common stock $126,860 Retained earning $23,000 a. Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period. Sales for the...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations: Current Assets as of December 31 (prior year):      Cash            $4,460      Accounts receivable, net $52,000      Inventory $15,400 Property, plant, and equipment, net $122,000 Accounts payable $44,000 Common stock $126,860 Retained earnings $23,000 Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period. Sales for the...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Decker ​Manufacturing's operations:    LOADING... ​(Click the icon to view additional​ data.)Read the requirements LOADING... . Requirement 1. Prepare a schedule of cash collections for​ January, February, and​ March, and for the quarter in total. Decker Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales $24,000 $27,600 $29,700 Credits sales Total cash...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations: Current Assets as of December 31 (prior year):      Cash           $4,460      Accounts receivable, net $52,000      Inventory $15,400 Property, plant, and equipment, net $122,000 Accounts payable $44,000 Common stock $126,860 Retained earnings $23,000 Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT