Question

Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units.

The companys business conditions are improving. One possible result is a sales volume of approximately 18,000 units. The company president is confident that this volume is within the relevant range of existing capacity. How much would operating income increase over the 2015 budgeted amount of $220,000 if this level is reached without increasing capacity? PHOENIX COMPANY Forecasted Contribution Margin Income Statement For Year Ended December 31, 2015 15,000 18,000 Sales (in units) Contribution margin (per unit) Contribution margin Fixed costs Expected increase in operating income

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

1

PHOENIX COMPANY

Flexible Budget Report

For Year Ended December 31, 2015

Flexible Budget

Flexible Budget

Variable
Amount per unit

Total
Fixed cost

Units sales
14000

Units sales
16000

  Sales

200

2800000

3200000

  Cost of goods sold

0

0

     Direct materials

63

882000

1008000

     Direct labor

14

196000

224000

Machinery repairs

4

56000

64000

Utilities

3

42000

48000

Packaging

6

84000

96000

Shipping:

7

98000

112000

Total variable cost

97

1358000

1552000

Contribution margin

103

1442000

1648000

Less: Fixed cost

Depreciation

300,000

300,000

300,000

Utilities

135000

135,000

135,000

Plant management salaries

220,000

220,000

220,000

Sales Salary

235000

235,000

235,000

     Advertising expense

125000

125,000

125,000

     Salaries

230,000

230,000

230,000

     Entertainment expense

80,000

80,000

80,000

Total Fixed cost

1,325,000

1,325,000

1,325,000

  Income from operations

117,000

323,000

2

PHOENIX COMPANY

Forecasted Contribution margin income statement

For the year ended Dec-31-2015

  Possible sales (units)

15000

18000

  Contribution margin per unit

× 103

× 103

  Total contribution margin

1545000

1854000

  Less: Fixed costs

1,325,000

1,325,000

operating income

220000

529000

309000

Operating income increase

3

PHOENIX COMPANY

Forecasted Contribution margin income statement

For the year ended Dec-31-2015

  Possible sales (units)

15000

12000

  Contribution margin per unit

× 103

× 103

  Total contribution margin

1545000

1236000

  Less: Fixed costs

1,325,000

1,325,000

operating income (loss)

220000

-89000

-309000

Operating income decrease

Working notes for the above answer is as udner


PHOENIX COMPANY Flexible Budget Report For Year Ended December 31, 2015 10 Flexible Budget Flexible Budget Variable Total Fixed cost Units sales Units sales 16000 14000 +E13 14000 +E14 14000 +E15 14000 -E 1 6*14000 +E17 14000 -E18*1 4000 +E19*14000 -E20*1 4000 +E2114000 +E2214000 Amount per unit 12 13 Sales 14 Cost of goods sold 15 Direct materials 16 Direct labor 17 Machinery repairs 18 Utilities 19 Packagin 20 Shipping 21 Total variable cost 22 Contribution margin 23 Les5: Fixed cost 24 Depreciation 25 Utilities 26 Plant management salaries 27 Sales Sala 28 Advertising expense 29 Salaries 30 Entertainment expense 31 Total Fixed cost 32 Income from operations 3000000/15000 945000/15000 210000/15000 60000/15000 45000/15000 90000/15000 105000/15000 SUM(E15:E20 +E13-E21 +E13 16000 +E1416000 =-E15*16000 =-E 16,16000 +E17 16000 +E18 16000 +E19 16000 +E20 16000 +E21 16000 +E22 16000 +G24 +G25 300000 #1 80000-45000 220000 235000 125000 230000 80000 -SUM(F24:F30) +F24 +F25 +F26 +F27 +F28 +F29 +F30 +F31 =+G22-G31 +G28 +G30 +G31 +H22-H31

Add a comment
Know the answer?
Add Answer to:
Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an...

    Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2015 Sales: $3,000,000 Cost of goods sold                  Direct materials: $975,000              Direct labor: $240,000              Machinery repairs (variable cost): $45,000              Depreciation—plant equipment (straight-line): $315,000              Utilities ($60,000 is...

  • Phoenix Company's 2015 master budget included the following fixed budget report. It is based on an...

    Phoenix Company's 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. $ 3,150,000 unt PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2015 Sales Cost of goods sold Direct materials $ 945,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation-plant equipment (straight-line) 330,000 Utilities ($60,000 is variable) 180,000 Plant management salaries 190,000 Gross profit Selling expenses Packaging 75,000 Shipping 105,000 Sales salary fixed annual...

  • Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...

    Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. Required information Problem 21-1A Preparation and analysis of a flexible budget LO P1 (The following information applies to the questions displayed below.) Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. $3,300,000 PHOENIX COMPANY Fixed Budget Report For Year Ended December...

  • Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an...

    Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 $3,150,000 Sales Cost of goods sold Direct materials $960,000 225,000 45,000 300,000 195,000 180,000 Direct labor Machinery repairs (variable cost) Depreciation-Plant equipment (straight-line) Utilities ($45,000 is variable) Plant management salaries Gross profit Selling expenses Packaging Shipping Sales salary (fixed annual amount) General and administrative expenses...

  • Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an...

    Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. $3,300,000 PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales Cost of goods sold Direct materials $915,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation-Plant equipment (straight-line) 330,000 Utilities ($45,000 is variable) 195,000 Plant management salaries 210,000 Gross profit Selling expenses Packaging 90,000 Shipping 90,000 Sales salary (fixed annual amount) 235,000 General...

  • [The following information applies to the questions displayed below.] Phoenix Company’s 2015 master budget included the...

    [The following information applies to the questions displayed below.] Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2015   Sales $ 3,000,000   Cost of goods sold      Direct materials $ 915,000      Direct labor 225,000      Machinery repairs (variable cost) 60,000      Depreciation—plant equipment (straight-line) 315,000      Utilities ($45,000 is variable) 180,000      Plant management salaries 220,000 1,915,000      Gross profit...

  • Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected produc...

    Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales Cost of goods sold Direct materials Direct labor $3, 150, 000 $975, 000 225, 000 45, 000 315, 000 210,000 200, 000 Machinery repairs (variable cost) Depreciation-Plant equipment (straight line) Utilities ($60, 000 is variable) Plant management salaries Gross profit Selling expenses Packaging Shipping...

  • Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...

    Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,000,000 Cost of goods sold Direct materials $ 945,000 Direct labor 240,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($30,000 is variable) 195,000 Plant management salaries 220,000 1,975,000 Gross profit 1,025,000 Selling expenses Packaging 90,000 Shipping 105,000 Sales salary (fixed...

  • Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...

    Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,150,000 Cost of goods sold Direct materials $ 900,000 Direct labor 210,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($45,000 is variable) 195,000 Plant management salaries 190,000 1,855,000 Gross profit 1,295,000 Selling expenses Packaging 75,000 Shipping 90,000 Sales salary (fixed...

  • Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...

    Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,000,000 Cost of goods sold Direct materials $ 945,000 Direct labor 240,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($30,000 is variable) 195,000 Plant management salaries 220,000 1,975,000 Gross profit 1,025,000 Selling expenses Packaging 90,000 Shipping 105,000 Sales salary (fixed...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT