Osage, Inc., manufactures and sells lamps. The company produces only when it receives orders and, therefore, has no inventories. The following information is available for the current month: Actual (based on actual orders for 450,000 units) Master Budget (based on budgeted orders for 480,000 units) Sales revenue $ 4,490,000 $ 4,320,000 Less Variable costs Materials 1,536,000 1,536,000 Direct labor 243,000 312,000 Variable overhead 627,600 576,000 Variable marketing and administrative 397,500 408,000 Total variable costs $ 2,804,100 $ 2,832,000 Contribution margin $ 1,685,900 $ 1,488,000 Less Fixed costs Manufacturing overhead 628,800 600,000 Marketing 190,000 190,000 Administrative 133,500 112,500 Total fixed costs $ 952,300 $ 902,500 Operating profits $ 733,600 $ 585,500 Required: Prepare a sales activity variance analysis for Osage, Inc. (Do not round intermediate calculations. 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.)
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.
Osage, Inc., manufactures and sells lamps. The company produces only when it receives orders and, therefore, has no inventories. The following information is available for the current month:
Actual (based on actual orders for 450,000 units) | |||||||||||
Sales revenue | $ | 4,490,000 | $ | 4,320,000 | |||||||
Less | |||||||||||
Variable costs | |||||||||||
Materials | 1,536,000 | 1,536,000 | |||||||||
Direct labor | 243,000 | 312,000 | |||||||||
Variable |
627,600 | 576,000 | |||||||||
Variable marketing and administrative | 397,500 | 408,000 | |||||||||
Total variable costs | $ | 2,804,100 | $ | 2,832,000 | |||||||
Contribution margin | $ | 1,685,900 | $ | 1,488,000 | |||||||
Less | |||||||||||
Fixed costs | |||||||||||
Manufacturing overhead | 628,800 | 600,000 | |||||||||
Marketing | 190,000 | 190,000 | |||||||||
Administrative | 133,500 | 112,500 | |||||||||
Total fixed costs | $ | 952,300 | $ | 902,500 | |||||||
Operating profits | $ | 733,600 | $ | 585,500 | |||||||
Required:
Prepare a sales activity
![The following information is available for the current month:
Actual (based on
actual orders for
450,000 units)
$4,490,000
Master Budget (based
on budgeted orders
for 480,000 units)
$4,320,000
Sales revenue
Less
Variable costs
1,536,000
312,000
Materials
1,536,000
243,000
627,600
Direct labor
Variable overhead
Variable marketing and administrative
Total variable costs
576,000
408,000
$2,832,000
397,500
$2,804,100
Contribution margin
$1,685,900
$1,488,000
Less
Fixed costs
Manufacturing overhead
Marketing
Administrative
628,800
190,000
133,500
600,000
190,000
112,500
Total fixed costs
952,300
$ 902,500
Operating profits
$ 733,600
585,500](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F84e2d71b-8feb-4f2e-a183-7e33daac2690%2Ff03ae796-60e5-4ada-98ae-a6bac17b3c06%2Fvj0uzap_processed.jpeg&w=3840&q=75)
![Required:
Prepare a sales activity variance analysis for Osage, Inc. (Do not round intermediate calculations. 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.)
OSAGE, INC.
Sales Activity Variance
Flexible
Budget
Sales Activity
Variance
Master Budget
Sales revenue
Variable costs:
Materials
Direct labor
Variable overhead
Variable marketing and administrative
Total variable costs
Contribution margin
Fixed costs:
Manufacturing overhead
Marketing
Administrative
Total fixed costs
Operating profits](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F84e2d71b-8feb-4f2e-a183-7e33daac2690%2Ff03ae796-60e5-4ada-98ae-a6bac17b3c06%2F28v0o4w_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 2 steps
![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)