Question
Coronado 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
Coronado 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,000 | 2,800 | 1,900 |
Because of the time needed to create each table, Coronado maintains an ending Finished Goods Inventory of 20% of the following quarters budgeted sales. Coronado has been following this inventory policy for several years. The company ended 2021 with 450 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)
New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is partially correct.
Prepare Coronados 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 unit salesBeginning inventoryBudgeted productionTotal units requiredBudgeted 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 production budget item Beginning inventoryTotal units requiredBudgeted ending inventoryBudgeted productionBudgeted unit sales | 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 ProductionBeginning inventoryBudgeted ending inventoryTotal units requiredBudgeted 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 | enter a total number of units for the first part |
select a production budget item Budgeted productionBeginning inventoryTotal units requiredBudgeted ending inventoryBudgeted unit sales | 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 salesTotal units requiredBudgeted ProductionBudgeted ending inventoryBeginning inventory | 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