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
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...
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.
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...
How many of the following variances are unfavorable? Item Budget Actual Sales price $350 $380 Sales...
How many of the following variances are unfavorable? Item Budget Actual Sales price $350 $380 Sales revenue $15,000 $12,500 Cost of goods sold $10,000 $9,000 Selling and administrative expenses $3,200 $3,500 Labor costs $1,800 $1,680 Production volume 1,300 units 1,260 units Group of answer choices 4 1 0 2 5 3 6 Favors Publishing has the following budgeted and actual amounts Budgeted Actual Sales price / book $90.00 $87.00 Book sales 30,000 books 32,000 books Calculate Favor's Publishing's sales volume...
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...
The master budget at Western Company last period called for sales of 226,300 units at $10.3...
The master budget at Western Company last period called for sales of 226,300 units at $10.3 each. The costs were estimated to be $3.88 variable per unit and $226,300 fixed. During the period, actual production and actual sales were 231,300 units. The selling price was $10.40 per unit. Variable costs were $5.80 per unit. Actual fixed costs were $226,300. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for...
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...
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?