Question

In: Accounting

I need a step by step explanation to the following problem in order to make me...

I need a step by step explanation to the following problem in order to make me understand the solution:

14-23 Flexible Budgets and Operating-Income Variance Analysis: Spreadsheet Application

The following information is available for Brownstone Products Company for the month of July:

Actual

Master Budget

Units

                      3,800

                        4,000

Sales Revenue

                    53,200

                     60,000

Variable manufacturing costs

                    19,000

16,000

Fixed manufacturing costs

                    16,000

                     15,000

Variable selling and administrative expenses

                      7,700

                        8,000

Fixed selling and administrative expenses

                    10,000

                        9,000

Set up a spreadsheet to compute the July sales volume variance and the flexible-budget variance for the month in terms of both contribution margin and operating income.

Discuss implications of these variances on strategic cost management of Brownstone.

Configure your spreadsheet so that it will allow the firm to prepare pro forma budgets for activities within its relevant range of operations. Use your spreadsheet to prepare a flexible budget for each of the following two output levels:

3,750 units

4,150 units

Solutions

Expert Solution

1)

Actual

Flexible Budget Variance

Flexible Budget

Sales Volume Variance

Master Budget

Units

3,800

0

3,800

200         U

4,000

Sales

$53,200

$ 3,800 U

$ 57,000

$3,000   U

$60,000

Variable costs:

    Manufacturing

$19,000

$3,800    U

$ 15,200

$800       F

$16,000

    Selling & admin.

$7,700

$100        U

$   7,600

$400       F

$8,000

Total variable costs

$26,700

$3,900     U

$22,800

$1,200    F

$24,000

Contribution margin

$26,500

$7,700     U

$34,200

$1,800    U

$36,000

Fixed costs:

    Manufacturing

$16,000

$1,000      U

$15,000

$15,000

    Selling & admin.

$10,000

$1,000      U

$9,000

$9,000

Total fixed costs

$26,000

$2,000      U

$24,000

$0          

$24,000

Operating Income

$500

$9,700      U

$10,200

$1,800    U

$12,000

Sales volume variance:

        Contribution margin variance = $ 36,000 - $ 34,200 = $ 1,800 U

          Operating income variance = $ 12,000 - $ 10,200 = $ 1,800 U

Explanation:

Budgeted manufacturing variable cost per unit = $ 16,000/4,000 = $ 4

Budgeted manufacturing variable cost for 3,800 units = $ 4 x 3,800 = $ 15,200

Budgeted Selling & admin variable cost per unit = $ 8,000/4,000 = $ 2

Budgeted Selling & admin variable cost for 3,800 units = $ 2 x 3,800 = $ 7,600

Total budgeted variable cost for 3,800 units = $ 15,200 + $ 7,600 = $ 22,800

Contribution margin = Sales – variable cost

Actual contribution margin for 3,800 units = $ 53,200 - $ 26,700 = $ 26,500

Budgeted contribution margin for 3,800 units = $ 57,000 - $ 22,800 = $ 34,200

Budgeted contribution margin for 4,000 units = $ 60,000 - $ 24,000 = $ 36,000

Operating income = Contribution margin – fixed cost

Budgeted operating income for 3,800 units = $ 34,200 - $ 24,000 = $ 10,200

Actual operating income for 3,800 units = $ 26,500 - $ 26,000 = $ 500

Budgeted operating income for 4,000 units = $ 36,000 - $ 24,000 = $ 12,000

2)

As a part of competitive strategy the company has bring down the price to $ 14 from $ 15. But the company does not have actual control on its operating cost which results in to such unfavorable variances for manufacturing and selling & administrative expenses. This surplus cost reduces the flexible-budget operating income of the period by 95 %. In order to compete successfully as low-cost producer the company should get control over the excess expenses.

Again the company has unfavorable selling-price and sale-volume variance. Budgeted sales volume is not achieved. Competitive reduced sales price strategy was unable to accomplish expected sales level.

3)

Flexible Budget

Flexible Budget

Master Budget

Units

3,750

4,150

4,000

Sales

$ 56,250

$ 62,250

$60,000

Variable costs:

    Manufacturing

$ 15,000

$ 16,600

$16,000

    Selling & admin.

$ 7,500

$ 8,300

$8,000

Total variable costs

$ 22,500

$ 24,900

$24,000

Contribution margin

$ 33,750

$ 37,350

$36,000

Fixed costs:

    Manufacturing

$15,000

$15,000

$15,000

    Selling & admin.

$9,000

$9,000

$9,000

Total fixed costs

$24,000

$24,000

$24,000

Operating Income

$9,750

$13,350

$12,000


Related Solutions

I need a step by step explanation to problem 14-26 in order to make me understand...
I need a step by step explanation to problem 14-26 in order to make me understand the solution: 14-26 Direct Materials and Direct Labor Variance Schmidt Machinery Company used 3,450 pounds of aluminum in June to manufacture 920 units. The company paid $28.50 per pound during the month to purchase aluminum. On June 1, the company had 50 pounds of aluminum on hand. At the end of June, the company had only 30 pounds of aluminum in its warehouse. Schmidt...
Note: I need a step by step answer to the question with an explanation of your...
Note: I need a step by step answer to the question with an explanation of your answer so that I can understand how to reproduce the steps. Marsha Inc. has the following budgeted data for 2016: Cash balance, beginning $15,000 Collections from customers 145,000 Direct materials purchases 25,000 Expenses: Operating expenses 50,000 Payroll 75,000 Income taxes 6,000 Other: Machinery purchases 30,000 Operating expenses include $20,000 depreciation for buildings and equipment. All purchases of materials are paid for in the period...
Note: I need a step by step answer to the question with an explanation of your...
Note: I need a step by step answer to the question with an explanation of your answers: White Corporation’s budget calls for the following sales for next year: Quarter 1 90,000 Quarter 3 68,000 Quarter 2 76,000 Quarter 4 96,000 Each unit of the product requires 3 pounds of direct materials. The company’s policy is to begin each quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirements and an inventory of direct materials equal...
can someone make me a shopping cart for me ? i need to make a shopping...
can someone make me a shopping cart for me ? i need to make a shopping cart ,but i have no idea about how to do this i have made 3 line of items , this is one of the pruduct line line 1 ------------------------------------- <!DOCTYPE html> <html lang="en"> <head> <style> .div1 { border: 2px outset red; background-color: lightblue; text-align: center; } </style> </head> <!-- body --> <body style="background-color:silver; "class="main-layout position_head"> <!-- loader --> </li> </ul> </section> </nav> </section> </header>...
If anyone can give a detailed, step by step analysis of the following problem I need...
If anyone can give a detailed, step by step analysis of the following problem I need to be able to do a problem LIKE this for a test Dec. 5, 2019. Thanks! Example Problem – 40 points. Use the printout to answer the following questions. 1. Suppose we want to develop a model to predict assessed value based on heating area. A sample of 15 single-family houses is selected in a particular community. The assessed value (in thousands of $...
Note: I need a step by step answer to the following problem to better understand how...
Note: I need a step by step answer to the following problem to better understand how this works. Hot Coffee Manufacturing produces and sells oak tables. The budgeted   manufacturing costs per table are as follows: Direct costs                 Oak top                48 square feet at $10 per sq. ft.                 Table legs                 4 legs at $5 per leg Direct labor is 3 hours and 24 minutes per table at $15 per hour. The variable overhead rate is $6 per...
Can you explain step by step for me? "Dumb it down"? I need a lot of...
Can you explain step by step for me? "Dumb it down"? I need a lot of help with this question. Thank you so much! This is the sample set. The s ample mean is 100 and the SD is 10 and the s ample size is 400. Construct the 95% confidence interval?
Please I need a clear explanation and clear handwriting with explanaing this for me because I...
Please I need a clear explanation and clear handwriting with explanaing this for me because I am realy confused and need help. Thanks in advance My lab was about  Magnets and Magnetic fields. This is the question I need to answer for! R3: Explain how a speaker works by explaining why each part is required. after that Summarize R3’s answer by explaining why the proffesor homemade earbud is so much superior to the one that you made.
I need a step by step answer to the following accounting problem. ACC 512 Multiproduct CVP...
I need a step by step answer to the following accounting problem. ACC 512 Multiproduct CVP Analysis with income taxes Case Jan Green is preparing a business plan to present to her local bank. She provides with the following selected information from her business Hightway 37 Stores: Products A B C D Selling price per unit $20.00 $50.00 $28.00 $10.00 Units sold 1,000 500 1,500 2,000 Variable cost per unit $10.00 $25.00 $14.00 $5.00 Total fixed costs $1,605.00 Combined federal...
May you please walk me through this problem step by step? I got the answers, but...
May you please walk me through this problem step by step? I got the answers, but I would like to know why. I am having a hard time comprehending where the numbers are coming from. A firm produces output according to a production function: Q = F(K,L) = min {5K,5L}. a. How much output is produced when K = 2 and L = 3? b. If the wage rate is $60 per hour and the rental rate on capital is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT