Question
Symphony Electronics produces wireless speakers for outdoor use on patios, decks, etc. Their most popular model is the All Weather and requires four separate XL12
Symphony Electronics produces wireless speakers for outdoor use on patios, decks, etc. Their most popular model is the All Weather and requires four separate XL12 components per unit. The company is now planning raw material needs for the second quarter. Sales of the All Weather are the highest in the second quarter of each year as customers prepare for the summer season. The company has the following inventory requirements:
- The finished goods inventory on hand at the end of each month must be equal to 16,000 units plus 10% of the next months sales. The finished goods inventory on March 31 is budgeted to be 28,000 units.
- The raw materials inventory on hand at the end of each month must be equal to 20% of the following months production needs for raw materials. The raw materials inventory on March 31 for XL 12 is budgeted to be 98,400 components.
- The company maintains no work in process inventories.
A sales budget for the All Weather speaker is as follows:
Budgeted Sales in Units | |||
April | 120,000 | ||
May | 150,000 | ||
June | 210,000 | ||
July | 106,000 | ||
August | 60,000 |
Required: 1. Prepare a production budget for the All Weather for April, May, June and July.
April | May | June | July | |
Budgeted sales (units) | ||||
Add: Desired ending inventory | ||||
Total needs | ||||
Less: Beginning inventory | ||||
Required Production |
2. Prepare a direct material purchases budget showing the quantity of XL 12 components to be purchased for April, May and June and for the quarter in total.
April | May | June | Second Quarter | |
Required production (units) | ||||
XL 12 components needed per unit | ||||
Production needs | ||||
Add: Desired ending inventory | ||||
Total XL 12 needs | ||||
Less: Beginning inventory | ||||
Material XL 12 purchases |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started