Question: Sunland, Inc., sells drum sets. Anthony Walker, controller, is responsible for preparing the master budget. The sales manager has given Anthony the following sales forecast
Sunland, Inc., sells drum sets. Anthony Walker, controller, is responsible for preparing the master budget. The sales manager has given Anthony the following sales forecast for the coming months.
| April | May | June | July | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Forecasted unit sales | 17,000 | 20,000 | 15,000 | 16,000 |
Sunland expects to have 8,500 drum sets in ending inventory on March 31. The company purchases the drum sets from its supplier for $150 each and maintains 35% of the following month's projected sales in ending inventory. Prepare Sunland's inventory purchases budget for the second quarter.
| April | May | June | Quarter | ||||||
|---|---|---|---|---|---|---|---|---|---|
| select an opening name for this budget Budgeted unit cost , Total units required , Beginning inventory Budgeted , ending inventory, Budgeted purchases, Budgeted unit sales, Budgeted purchases | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||
| select an item Budgeted unit cost , Total units required , Beginning inventory Budgeted , ending inventory, Budgeted purchases, Budgeted unit sales, Budgeted purchases | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||
| select a summarizing line for the first part Budgeted unit cost , Total units required , Beginning inventory Budgeted , ending inventory, Budgeted purchases, Budgeted unit sales, Budgeted purchases | enter a total number of units for the first part | enter a total number of units for the first part | enter a total number of units for the first part | enter a total number of units for the first part | |||||
| select an item Budgeted unit cost , Total units required , Beginning inventory Budgeted , ending inventory, Budgeted purchases, Budgeted unit sales, Budgeted purchases | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||
| select a summarizing line for the second part Budgeted unit cost , Total units required , Beginning inventory Budgeted , ending inventory, Budgeted purchases, Budgeted unit sales, Budgeted purchases | enter a total number of units for the second part | enter a total number of units for the second part | enter a total number of units for the second part | enter a total number of units for the second part | |||||
| select an item Budgeted unit cost , Total units required , Beginning inventory Budgeted , ending inventory, Budgeted purchases, Budgeted unit sales, Budgeted purchases | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | |||||
| select a closing name for this budget Budgeted unit cost , Total units required , Beginning inventory Budgeted , ending inventory, Budgeted purchases, Budgeted unit sales, Budgeted purchases | $enter a total dollar amount | $enter a total dollar amount | $enter a total dollar amount | $enter a total dollar amount |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
