Question

5.                                           

5.                                                         Master Budget                        Actual Results

Sales Volume in Unit                                     2,500                                     2,700

Sales Revenue                                     $          37,500                                     41,000

Variable Cost of Goods Sold                          20,000                                     21,200

Variable S&A                                                 5,000                                     5,500

Contribution Margin                                       12,500                                     14,300

Fixed Cost of Goods Sold                              4,000                                     4,200

Fixed S&A                                                      3,000                                     2,900

Operating Income                                           5,500                                     7,200

a. Make a flexible budget.

b. Compute a revenue/spending variance and indicate its favorability.

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

Solution a& b:

Particulars Actual results Revenue and spending variances Flexible Budget
Nos of units 2700 2700
Sales revenue $41,000.00 $500.00 F $40,500.00
Variable expenses:
Variable cost of goods sold $21,200.00 $400.00 F $21,600.00
Variable S&A $5,500.00 $100.00 U $5,400.00
Total Variable Expenses $26,700.00 $300.00 F $27,000.00
Contribution margin $14,300.00 $800.00 F $13,500.00
Fixed Expenses:
Fixed Cost of goods sold $4,200.00 $200.00 U $4,000.00
Fixed S&A $2,900.00 $100.00 F $3,000.00
Total Fixed Expenses $7,100.00 $100.00 U $7,000.00
Net Operating Income $7,200.00 $700.00 F $6,500.00
Add a comment
Know the answer?
Add Answer to:
5.                                           
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
  • Solomon Manufacturing Company established the following standard price and cost data. Sales price $ 8.50 per...

    Solomon Manufacturing Company established the following standard price and cost data. Sales price $ 8.50 per unit Variable manufacturing cost $ 3.80 per unit Fixed manufacturing cost $ 2,500 total Fixed selling and administrative cost $ 900 total Solomon planned to produce and sell 2,500 units. Actual production and sales amounted to 2,700 units. Required Prepare the pro forma income statement in contribution format that would appear in a master budget. Prepare the pro forma income statement in contribution format...

  • 10 Which of the following statements is true? activity is higher than expected total fixed costs...

    10 Which of the following statements is true? activity is higher than expected total fixed costs should be higher than expected. I civity is lower than expected, total fixed costs should be lower than expected Fixed costs should not be included in a flexible budget because they do not change when the level of activity changes. C A revenue variance is favorable if the actual revenue is greater than the revenue in the master (static planning) budget. A spending variance...

  • OIive Company makes slver belt buckles. The company's master budget appears In the first column of...

    OIive Company makes slver belt buckles. The company's master budget appears In the first column of the table Required: Complete the table by preparing Olve's flexible budget for 4,000, 6,000, and 7,000 units. (Round your Intermediate calculetions to 2 decimal places.) Master Budget Flexible Budget (5,000 Units) Flexible Budget (6,000 Units) Flexible Budget (7,000 Units) (4,000 Units) Direct materials 1,000 Direct labor 2,500 Variable manufacturing overhead 1,500 Fixed manufacturing overhead 17,900 Total manufacturing cost 22,900

  • Hanno had the following static budget for March, when it expected to sell 4,000 sandwiches: Sales...

    Hanno had the following static budget for March, when it expected to sell 4,000 sandwiches: Sales revenue $ 48,000 Variable costs $ 28,000 Fixed costs $ 5,000 Net income $15,000 Hanno actually sold 5,000 sandwiches during March at $12 each. Variable costs were $37,500 and fixed costs were $4,800. A. Prepare a flexible budget at for March that will help Hanno separate the volume variance from the flexible budget variance. Make your income statement match my format and compute net...

  • Olive Company makes silver belt buckles. The company’s master budget appears in the first column of...

    Olive Company makes silver belt buckles. The company’s master budget appears in the first column of the table. Required: Complete the table by preparing Olive’s flexible budget for 4,200, 6,200, and 7,200 units. (Round your intermediate calculations to 2 decimal places.) Master Budget Flexible Budget( 4200 Units) Flexible Budget (6200 Units) Flexibile Budget (7200 Budgets) Direct Materials 1,560 Direct Labor 2,600 Variable Manufacturing Overhead 2,080 Fixed Moh 18,000 Total: 24,240

  • Prepare a flexible budget using the following information: Sales Price $20 per unit Cost of goods...

    Prepare a flexible budget using the following information: Sales Price $20 per unit Cost of goods sold is 30% of Sales Price Variable Operating Cost are $2.50 per unit sold Fixed Operating Cost are $15,000 Sales levels 10,000, 12,500, 15,000

  • #3 only. 14-23 Flexible Budgets; Total Operating Income Variance; Breakdown of the Total Operating Income Variance;...

    #3 only. 14-23 Flexible Budgets; Total Operating Income Variance; Breakdown of the Total Operating Income Variance; Spreadsheet Application The following information is available for Brownstone Products Company for the month of July Units Sales revenue Variable manufacturing costs Fixed manufacturing costs Variable selling and administrative expenses Fixed selling and administrative expenses Actual Master Budget 3.800 4,000 $53,200 $60,000 19.000 16,000 16.000 15,000 7,700 8,000 10.000 9,000 Required 1. What was the total operating income variance for July, rounded to the...

  • Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2,000...

    Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2,000 U ? Sales revenue ? 13,000 F ? ? ? Less: Variable mfg. costs $ 87,750 $ 91,000 ? $ 105,000 Variable mktg/adm.costs ? $ 3,250 U ? $ 4,000 F 30,000 Contribution margin $ 52,000 ? ? $ 6,000 U ? What is the master budget sales revenue?

  • 3. ABC Company has the master/static budget and actual of operating result (2015) as shown beloW. ABC Company Operating Results For year 2015 Master Budget 20,000 1,000,000 500,000 Actual Varianc...

    3. ABC Company has the master/static budget and actual of operating result (2015) as shown beloW. ABC Company Operating Results For year 2015 Master Budget 20,000 1,000,000 500,000 Actual Variance Units sold Revenue Variable cost Variable production overhead 15,000 742,500 390,000 160,000500 32,500 F 225,000 5,000 U 257,500 U 110,000 F 115,000 U 5,000 F 110,000 U Contribution margin Fixed production overhead Operating income 340,000 150,000 190,000 45,000 80,000 3.1 Prepare a flexible budget for ABC Company for vear 2015...

  • Master Master Budget Variance Actual 60,500 Budget 57,000 Sales volume (number of cases sold) Sales revenue...

    Master Master Budget Variance Actual 60,500 Budget 57,000 Sales volume (number of cases sold) Sales revenue Less: Variable expenses Contribution margin Less: Fixed expenses $ 193,700 $ 71,200 176,700 62,700 $ 122,500 $ 73,200 114,000 72,000 $ 49,300 $ 42,000 Operating income The budgeted sales price per unit is $ 3.10 Requirement 2. What is the budgeted variable expense per unit? The budgeted variable expense per unit is $ 1.10. Requirement 3. What is the budgeted fixed cost for the...

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