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 17,700 units plus 10% of the next months sales. The finished goods inventory on March 31 is budgeted to be 25,200 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,200 components.
The company maintains no work in process inventories.
A sales budget for the All Weather speaker is as follows:
Required: 1. Prepare a production budget for the All Weather for April, May, June and July.
2. Prepare a direct materials purchases budget showing the quantity of XL 12 components to be purchased for April, May and June and for the quarter in total.
AprilMayJuneJulyAugustBudgetedSalesinUnits117,000155,000212,000102,00060,900 \begin{tabular}{|l|l|l|l|l|} \hline & \multicolumn{1}{c|}{ April } & May & June & July \\ \hline Budgeted sales (units) & & & & \\ \hline & & & & \\ \hline Total needs & & & & \\ \hline & & & & \\ \hline Required production & & & & \\ \hline \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline & \multicolumn{1}{|c|}{ April } & May & June & SecondQuarter \\ \hline Required production (units) & & & & \\ \hline XL 12 components needed per unit & & & & \\ \hline Production needs & & & & \\ \hline & & & & \\ \hline Total XL 12 needs & & & & \\ \hline & & & & \\ \hline Material XL 12 purchases & & & & \\ \hline \end{tabular}
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