Question

XYZ Company's budgeted and actual results for last year are as follows: Master budget Actual results...

XYZ Company's budgeted and actual results for last year are as follows:

Master budget Actual results
Price $600 $700
Sales volume (units) 7,000 5,000
Unit VC $200 $200
Fixed costs $200,000 $200,000


Required:

(a) Compute budgeted and actual revenue, costs and profits:

Master budget Actual
Sales volume (units)
Revenue $ $
Variable costs $ $
Contribution margin $ $
Fixed costs $ $
Profit $ $



In (b)-(d) below, enter favorable and unfavorable variances as positive and negative numbers, without F or U.

(b) How much is the total profit variance?
(enter negative numbers with a minus, i.e. enter negative $100 as -100 not ($100) ) $

(c) How much is the activity variance(=sales volume variance)?
(enter negative numbers with a minus) $

(d) How much is the revenue variance (=sales price variance)?
(enter negative numbers with a minus) $

Homework Answers

Know the answer?
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
Similar Questions
Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2000U...
Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 13,000 ? 2000U ? Sales revenue ? 13,000F ? ? ? Less: <Variable mfg. Costs> $87,750 $91,000 ? $105,000 <Variable mktg/adm.costs> ? $3,250U ? $4,000F 30,000 Contribution margin $52,000 ? ? $6,000U ? What is the master budget contribution margin? Select one: A. $52,000. B. $45,000. C. $47,500. D. $39,000.
Below is data for Jewelry by Jessica for the month of October. Master Budget Flexible Budget...
Below is data for Jewelry by Jessica for the month of October. Master Budget Flexible Budget Actual Results Revenue $60,000 $64,000 $76,800 Variable costs $24,000 $38,400 $44,800 Contribution margin $36,000 $25,600 $32,000 Fixed costs $5,000 $5,000 $7,500 Profit before taxes $31,000 $20,600 $24,500 What statement below is true? Group of answer choices Fixed costs spending variance is $2,500 U and the sales price variance is $10,400 F Sales volume variance is $10,400 U and the variable cost spending variance is...
Hyson Inc. manufactures and sells produces. The master budget and the actual results for July are...
Hyson Inc. manufactures and sells produces. The master budget and the actual results for July are as follows: Actual July Sales Master Budget Un it sales 12,000 10,000 Sales $132,000 $100,000 Variable costs $70,800 $60,000 Contribution margin $61,200 $40,000 Fixed costs $30,000 $25,000 Operating income $31,200 $15,000 If flexible budgeting is used, how much is contribution margin per unit based on actual sales of 12,000 units? (A) $4.00 (B) $5.10 (C) $4.55 (D) None of the above How much is...
The master budget at Western Company last period called for sales of 225,000 units at $9...
The master budget at Western Company last period called for sales of 225,000 units at $9 each. The costs were estimated to be $3.75 variable per unit and $225,000 fixed. During the period, actual production and actual sales were 230,000 units. The selling price was $9.10 per unit. Variable costs were $4.50 per unit. Actual fixed costs were $225,000.    Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U"...
Ram bikes manufactures a single product. Budgeted results and actual results for June are as follows:...
Ram bikes manufactures a single product. Budgeted results and actual results for June are as follows: Fixed Budget Actual Results Variance Production & Sales (units) 5,000 4,850                                                        $ $ $ Sales Revenue    750,000      751,750                     1,750 (F) Direct Materials 350,000 363,750 13,750 (A) Direct Labour 150,000 145,500 4,500 (F) Variable Overhead 50,000 58,200 8,200 (A) Rent & Rates 25,000 26,000 1,000 (A) Other Costs       4,000                           4,600                          600 (A) Total Costs   579,000   598,050                     19,050 (A) Profit/Loss   171,000    153,700    17,300 (A) -------------- ------------ ----------------...
For CVS Brand Products 2017 year end, the following budgeted and actual results are available for...
For CVS Brand Products 2017 year end, the following budgeted and actual results are available for the bagged popcorn department: Budget Actual Bags of popcorn sold 10,000 13,000 Selling price $5 $4.75 Variable costs per bag $2 $1.75 Fixed costs $8,000 $6,500 Prepare the Static, Flexible, and Actual budgets for the popcorn department for 2017. Determine the static budget variance, the flexible budget variance, the total sales volume variance, indicating (F) favorable or (U) unfavorable for each line item in...
ames Manufacturing had the following information available for July: Actual Results Flexible Budget Variance Flexible Budget...
ames Manufacturing had the following information available for July: Actual Results Flexible Budget Variance Flexible Budget Sales Activity Variance Master Budget Units 12,000 ? 3,000 U ? Sales revenue ? $ 16,800 F ? ? ? Less: Variable manufacturing costs $ 88,500 $ 92,000 ? $ 111,000 Variable marketing and administrative ? $ 5,500 U ? $ 6,200 F $ 33,000 Contribution margin $ 52,000 ? ? $ 6,300 U ? What was James’s master budget contribution margin?
The results for July for Brahms & Sons follow:   Actual (based on actual sales of 76,000...
The results for July for Brahms & Sons follow:   Actual (based on actual sales of 76,000 units) Master Budget (based on budgeted sales 74,000 units) Sales revenue $ 560,000 $ 629,000 Less Variable costs Direct material 76,000 62,900 Direct labor 87,000 111,000 Variable overhead 94,000 111,000 Marketing 17,800 18,500 Administrative 14,700 18,500 Total variable costs $ 289,500 $ 321,900 Contribution margin $ 270,500 $ 307,100 Less Fixed costs Manufacturing 121,500 116,000 Marketing 26,600 18,500 Administrative 90,000 88,000 Total fixed costs...
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 $ 930,000 Direct labor 210,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($30,000 is variable) 180,000 Plant management salaries 200,000 1,865,000 Gross profit 1,285,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 $ 960,000 Direct labor 240,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($45,000 is variable) 210,000 Plant management salaries 200,000 1,955,000 Gross profit 1,195,000 Selling expenses Packaging 75,000 Shipping 105,000 Sales salary (fixed...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT