Question: Swifty, Inc., sells drum sets. John Johnson, controller, is responsible for preparing the master budget. The sales manager has given Johnthe following sales forecast for
Swifty, Inc., sells drum sets. John Johnson, controller, is responsible for preparing the master budget. The sales manager has given Johnthe following sales forecast for the coming months.
| April | May | June | July | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Forecasted unit sales | 14,000 | 17,000 | 12,000 | 13,000 |
Swifty expects to have 7,000 drum sets in ending inventory on March 31. The company purchases the drum sets from its supplier for $150 each and maintains 20% of the following month's projected sales in ending inventory. Prepare Swifty's inventory purchases budget for the second quarter.
| April | May | June | Quarter | ||||||
|---|---|---|---|---|---|---|---|---|---|
| select an opening name for this budget Budgeted ending inventoryBudgeted purchases, unitsTotal units requiredBudgeted purchasesBudgeted unit costBeginning inventoryBudgeted unit sales | enter a number of units | enter a number of units | enter a number of units | enter a number of units | |||||
| select an item Total units requiredBudgeted unit salesBudgeted unit costBudgeted purchasesBudgeted purchases, unitsBudgeted ending inventoryBeginning inventory | 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 costBudgeted ending inventoryBudgeted purchasesBeginning inventoryTotal units requiredBudgeted purchases, unitsBudgeted unit sales | 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 purchases, unitsTotal units requiredBeginning inventoryBudgeted ending inventoryBudgeted unit salesBudgeted purchasesBudgeted unit cost | 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 Beginning inventoryBudgeted unit costBudgeted ending inventoryTotal units requiredBudgeted purchasesBudgeted purchases, unitsBudgeted unit sales | 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 salesBudgeted purchases, unitsBudgeted purchasesBudgeted unit costBeginning inventoryBudgeted ending inventoryTotal units required | $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 costBudgeted purchasesBeginning inventoryBudgeted unit salesBudgeted ending inventoryTotal units requiredBudgeted purchases, units | $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
