Question
Swifty Furniture builds high-end hand-made dining tables. Attacus Simmons, the companys owner, has developed the following sales forecast for 2022. 1st Quarter 2nd Quarter 3rd
Swifty Furniture builds high-end hand-made dining tables. Attacus Simmons, the companys owner, has developed the following sales forecast for 2022.
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |||||
---|---|---|---|---|---|---|---|---|
Forecasted sales (tables) | 2,600 | 3,100 | 2,900 | 1,800 |
Because of the time needed to create each table, Swifty maintains an ending Finished Goods Inventory of 20% of the following quarters budgeted sales. Swifty has been following this inventory policy for several years. The company ended 2021 with 425 tables on hand. The standard cost card for a table is as follows:
Standard Quantity | Standard Price | Total Standard Cost | |||||||
---|---|---|---|---|---|---|---|---|---|
American cherry wood | 20 board feet |
| $4/board foot |
|
| $80 |
| ||
American cherry turning square (legs) | 4 squares | $8/square | 32 | ||||||
Direct labor | 8 DLH | $15/DLH | 120 | ||||||
Variable overhead | 8 DLH | $45/DLH | 360 | ||||||
Fixed overhead | 8 DLH | $12/DLH | 96 | ||||||
$688 |
(a)
Partially correct answer iconYour answer is partially correct.
Prepare Swiftys production budget for 2022. Assume that the desired ending inventory for 2022 is 500 tables.
Production Budget | |||||
---|---|---|---|---|---|
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Annual | |
select an opening production budget item Budgeted productionBudgeted unit salesTotal units requiredBudgeted ending inventoryBeginning inventory | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units |
select a production budget item Budgeted productionBudgeted ending inventoryBeginning inventoryBudgeted unit salesTotal units required | enter a number of units | 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 ending inventoryBudgeted unit salesTotal units requiredBudgeted ProductionBeginning inventory | 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 | enter a total number of units for the first part |
select a production budget item Budgeted productionBeginning inventoryTotal units requiredBudgeted unit salesBudgeted ending inventory | enter a number of units | enter a number of units | enter a number of units | enter a number of units | enter a number of units |
select a closing production budget item Budgeted unit salesBeginning inventoryBudgeted ending inventoryBudgeted ProductionTotal units required | enter a total number of units | enter a total number of units | enter a total number of units | enter a total number of units | enter a total number of units |
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