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. If there is no effect, do not select either option.) Sales revenue Less: Variable costs Contribution margin Less: Fixed costs Operating profits Actual Budget $ $ 0 0 WESTERN COMPANY Profit Variance Analysis Manufacturing Variances Sales Price Variance Flexible Budget $ $ $ Sales Activity Variance 2,070,000 $ 45,000 862,500 1,207,500 18,750 U $26,250 F 225,000 0 982,500 $26,250 F Master Budget $ 2,025,000 843,750 $ 1,181,250 $ 225,000 956,250
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Vikram
![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. If there
is no effect, do not select either option.)
Sales revenue
Less:
Variable costs
Contribution margin
Less:
Fixed costs
Operating profits
Actual Budget
$
$
0
0
WESTERN COMPANY
Profit Variance Analysis
Manufacturing
Variances
Sales Price Variance
Flexible Budget
2,070,000
$
$
$
862,500
1,207,500
225,000
982,500
$
Sales Activity
Variance
45,000
18,750 U
26,250 F
0
26,250 F
Master Budget
$ 2,025,000
$
$
843,750
1,181,250
225,000
956,250](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fab8887f0-a61a-48e3-bdf1-cd8861d2c123%2F559cf145-c528-4b44-a02d-75f757af3bf2%2Fr28953n_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)