Homework Answers
Please note you have selected F&U correctly, but few fields are incomplete.
So, please find below same details in tabular format: Looks like the highlighted ones in below table, are missing in the image posted as question. Once you update these numbers in the excel, answer will be complete.
First, please update figures as per Master Budget column. If "Sales activity variance" column didn't auto populate, please fill up as per below table:
| Sales Activity variance | ||||
| Flexible Budget | Sales Activity Variance | Master Budget | ||
| Sales in Units *** | 230000 | 5000 | F | 225000 |
| Selling Price per unit *** | $ 9 | $ 9 | ||
| Sales Revenue (Sales in units multiplied by selling price per unit) | 2,070,000 | 45,000 | F | 2,025,000 |
| Less: Variable Cost @ 3.75 per unit | 862,500 | (18,750) | U | 843,750 |
| Contribution Margin | 1,207,500 | 26,250 | F | 1,181,250 |
| Less: Fixed Cost | 225,000 | 225,000 | ||
| Operating Profit | 982,500 | 26,250 | F | 956,250 |
*** I have provided these fields in my table for your understanding and need not update in the answer field in excel.
Add Answer to:
The master budget at Western Company last period called for sales of 225,000 units at $9 each. The costs were estim...
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 profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
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 $910 per unit. Variable costs were $4.50 per unit. Actual fixed costs were $225,000. Required: Prepare a profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
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 flexible budget for Western. Answer is not complete. WESTERN COMPANY Flexible Budget Sales revenue Variable costs Contribution margin...
The master budget at Western Company last period called for sales of 225,800 units at $9.8...
The master budget at Western Company last period called for sales of 225,800 units at $9.8 each. The costs were estimated to be $3.83 variable per unit and $225,800 fixed. During the period, actual production and actual sales were 230,800 unit. The selling price was $9.90 per unit. Variable costs were $5.30 per unit. Actual fixed costs were $225,800. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting “F” for favorable, or “U” for...
The master budget at Western Company last period called for sales of 225,800 units at $9.8...
The master budget at Western Company last period called for sales of 225,800 units at $9.8 each. The costs were estimated to be $3.83 variable per unit and $225,800 fixed. During the period, actual production and actual sales were 230,800 units. The selling price was $9.90 per unit. Variable costs were $5.30 per unit. Actual fixed costs were $225,800. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for...
The master budget at Western Company last period called for sales of 225,400 units at $9.4...
The master budget at Western Company last period called for sales of 225,400 units at $9.4 each. The costs were estimated to be $3.79 variable per unit and $225,400 fixed. During the period, actual production and actual sales were 230,400 units. The selling price was $9.50 per unit. Variable costs were $4.90 per unit. Actual fixed costs were $225,400. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for...
The master budget at Western Company last period called for sales of 225,700 units at $9.70...
The master budget at Western Company last period called for sales of 225,700 units at $9.70 each. The costs were estimated to be $3.82 variable per unit and $225,700 fixed. During the period, actual production and actual sales were 230,700 units. The selling price was $9.80 per unit. Variable costs were $5.20 per unit. Actual fixed costs were $225,700. Required: Prepare a profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
The master budget at Western Company last period called for sales of 226,000 units at $10.00...
The master budget at Western Company last period called for sales of 226,000 units at $10.00 each. The costs were estimated to be $3.85 variable per unit and $226,000 fixed. During the period, actual production and actual sales were 231,000 units. The selling price was $10.10 per unit. Variable costs were $5.50 per unit. Actual fixed costs were $226,000. Required: Prepare a profit variance analysis. (Indicate the effect of each variance by selecting “F” for favorable, or “U” for unfavorable....
The master budget at Western Company last period called for sales of 225,900 units at $9.90...
The master budget at Western Company last period called for sales of 225,900 units at $9.90 each. The costs were estimated to be $3.84 variable per unit and $225,900 fixed. During the period, actual production and actual sales were 230,900 units. The selling price was $10.00 per unit. Variable costs were $5.40 per unit. Actual fixed costs were $225,900. Required: Prepare a profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
The master budget at Western Company last period called for sales of 226,800 units at $10.80...
The master budget at Western Company last period called for sales of 226,800 units at $10.80 each. The costs were estimated to be $3.93 variable per unit and $226,800 fixed. During the period, actual production and actual sales were 231,800 units. The selling price was $10.90 per unit. Variable costs were $6.30 per unit. Actual fixed costs were $226,800. Required: Prepare a profit variance analysis. (Indicate the effect of each varlance by selecting "F" for favorable, or "U" for unfavorable....
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 profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
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 $910 per unit. Variable costs were $4.50 per unit. Actual fixed costs were $225,000. Required: Prepare a profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
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 flexible budget for Western. Answer is not complete. WESTERN COMPANY Flexible Budget Sales revenue Variable costs Contribution margin...
The master budget at Western Company last period called for sales of 225,800 units at $9.8 each. The costs were estimated to be $3.83 variable per unit and $225,800 fixed. During the period, actual production and actual sales were 230,800 units. The selling price was $9.90 per unit. Variable costs were $5.30 per unit. Actual fixed costs were $225,800. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for...
The master budget at Western Company last period called for sales of 225,400 units at $9.4 each. The costs were estimated to be $3.79 variable per unit and $225,400 fixed. During the period, actual production and actual sales were 230,400 units. The selling price was $9.50 per unit. Variable costs were $4.90 per unit. Actual fixed costs were $225,400. Required: Prepare a sales activity variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for...
The master budget at Western Company last period called for sales of 225,700 units at $9.70 each. The costs were estimated to be $3.82 variable per unit and $225,700 fixed. During the period, actual production and actual sales were 230,700 units. The selling price was $9.80 per unit. Variable costs were $5.20 per unit. Actual fixed costs were $225,700. Required: Prepare a profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
The master budget at Western Company last period called for sales of 225,900 units at $9.90 each. The costs were estimated to be $3.84 variable per unit and $225,900 fixed. During the period, actual production and actual sales were 230,900 units. The selling price was $10.00 per unit. Variable costs were $5.40 per unit. Actual fixed costs were $225,900. Required: Prepare a profit variance analysis. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable....
The master budget at Western Company last period called for sales of 226,800 units at $10.80 each. The costs were estimated to be $3.93 variable per unit and $226,800 fixed. During the period, actual production and actual sales were 231,800 units. The selling price was $10.90 per unit. Variable costs were $6.30 per unit. Actual fixed costs were $226,800. Required: Prepare a profit variance analysis. (Indicate the effect of each varlance by selecting "F" for favorable, or "U" for unfavorable....
Most questions answered within 3 hours.
-
A rock band plays at a 67 dB sound level. How many times greater
is the...
asked 4 minutes ago -
What is the acceleration due to gravity when measured in
furlongs per fortnight-squared ? (1furlong is...
asked 11 minutes ago -
Read the t statistic from the t distribution
table and choose the correct answer. For a...
asked 30 minutes ago -
A copper wire of cross-sectional area of 8.2x10^-7 m^2 has a
resistance of 1.11 Ω.
a)....
asked 35 minutes ago -
Here is a sample data set (n=48) that is nearly normal (as can
be seen in...
asked 37 minutes ago -
Consider a binomial experiment with n = 9 trials where the
probability of success on a...
asked 55 minutes ago -
Find the percentage of the total work lost to friction if 20.8 J
of work is...
asked 58 minutes ago -
1.why should every employee should know his rights in the
workplace?
2.why the industrial officer union...
asked 55 minutes ago -
6. Given the following equations:
(i) 3 A2+ + 2 D → 3 A + 2...
asked 58 minutes ago -
Consider the oscillator position x=2 cos(2π t), where time t is
measured in seconds. What is...
asked 58 minutes ago -
A firm has beginning inventory of 340 units at a cost of $9
each. Production during...
asked 1 hour ago -
Find the standard deviation of the following 6 price values of
the S & P 500...
asked 1 hour ago