Question
Prepare Concords production budget for 2018. Assume that the desired ending inventory for 2018 is 596 tables. (Round answers to 0 decimal places) Concord Furniture
Prepare Concords production budget for 2018. Assume that the desired ending inventory for 2018 is 596 tables. (Round answers to 0 decimal places)
Concord Furniture builds high-end hand-made dining tables. Attacus Simmons, the companys owner, has developed the following sales forecast for 2018.
1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |||||
Forecasted sales (tables) | 2,549 | 2,752 | 2,958 | 2,084 |
Because of the time needed to create each table, Concord maintains an ending Finished Goods Inventory of 20% of the following quarters budgeted sales. Concord has been following this inventory policy for several years. The company ended 2017 with 510 tables on hand. The standard cost card for a table is as follows:
Standard Quantity | Standard Price | Total Standard Cost | |||||||
American cherry wood | 25 board feet |
| $4/board foot |
|
| $100 |
| ||
American cherry turning square (legs) | 4 squares | $9/square | 36 | ||||||
Direct labor | 12 DLH | $16/DLH | 192 | ||||||
Variable overhead | 12 DLH | $50/DLH | 600 | ||||||
Fixed overhead | 12 DLH | $8/DLH | 96 | ||||||
$1,024 |
|
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