Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Aaron 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
Aaron 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,500 | 2,700 | 2,900 | 2,200 |
Because of the time needed to create each table, Aaron maintains an ending Finished Goods Inventory of 20% of the following quarters budgeted sales. Aaron has been following this inventory policy for several years. The company ended 2017 with 500 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 |
| $5/board foot |
|
| $125 |
| ||
American cherry turning square (legs) | 4 squares | $10/square | 40 | ||||||
Direct labor | 12 DLH | $18/DLH | 216 | ||||||
Variable overhead | 12 DLH | $60/DLH | 720 | ||||||
Fixed overhead | 12 DLH | $10/DLH | 120 | ||||||
$1,221 |
PLEASE fill in everything ill give you a thumbs up if done right
CALCULATOR PRINTER VERSION BACK NEXT Prepare Aaron's production budget for 2018. Assume that the desired ending inventory for 2018 is 600 tables. (Round answers to 0 decimal places, e.g. 5,275.) Production Budget Ist Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual 2500 27 2900 10300 600 600 3040 3280 3340 2800 10900 500 580 440 500 2540 2740 2760 2360 10400 Aaron maintains inventory of American cherry wood equal to 10% of the following quarter's production needs. On December 31, 2017, Aaron's physical inventory count showed 5,500 board feet of American cherry. Due to an anticipated price increase in 2019, managers want to have 10,000 board feet of American cherry wood in inventory on December 31, 2018. Prepare Aaron's 2018 direct materials purchases budget for American cherry wood. (Round answers to 0 decimal places, e.g. 5,275.) Direct Materials Purchases Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual 63500 685 69000 59 260000 6850 69 5900 10000 74900 6900 27000 70350 75 Aaron maintains inventory of American cherry wood equal to 10% of the following quarter's production needs. On December 31, 2017, Aaron's physical inventory count showed 5,500 board feet of American cherry. Due to an anticipated price increase in 2019, managers want to have 10,000 board feet of American cherry wood in inventory on December 31 2018. Prepare Aaron's 2018 direct materials purchases budget for American cherry wood. (Round answers to 0 decimal places, e.g. 5,275.) Direct Materials Purchases Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual 63500 68500 69000 59000 26 6850 6900 5900 10000 70350 75400 74900 69000 270 5500 6850 6900 5900 64850 68550 68000 63100 2645 Direct Labor Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Total DLH required Standard DLH per unit Budgeted DL cost Standard wage rate 2540 2740 2760 2360 10400 12 12 12 12 12 30480 32880 33120 28320 124800 18 18 18 18 18 591840 509760 s Budgeted production $486640 596160 2246400 CALCULATOR PRINTER VERSION Assume that because of the skill level required to make the tables, Aaron cannot easily hire additional workers to handle peaks in demand. Consequently, the company maintains a steady workforce of 60 employees and guarantees each worker 500 hours per quarter. For any additional time required to complete the scheduled production, these same workers earn 1.5 times their normal hourly rate. Prepare Aaron's direct labor budget for 2018. (Round overtime rate to 1 decimal place, e.g. 52.7 and all other answers to 0 decimal places, e.g. 5,275.) Direct Labor Budget Ist Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual 2540 2740 2760 23 12 12 30480 32880 33120 28320 124800 30000 30000 30000 30000 30000 480 2880 3120 94800 12960 77760 84240 0 174960 552960 617760 s 624240 509760 2304720 Click if you would like to show Work for this question: Open Show WorkStep 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