Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE HELP WITH SECTION I LEFT BLANK Vaughn Furniture builds high-end hand-made dining tables. Attacus Simmons, the companys owner, has developed the following sales forecast
PLEASE HELP WITH SECTION I LEFT BLANK
Vaughn 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,519 | 2,764 | 2,931 | 1,798 |
Because of the time needed to create each table, Vaughn maintains an ending Finished Goods Inventory of 20% of the following quarters budgeted sales. Vaughn has been following this inventory policy for several years. The company ended 2017 with 504 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) | 3 squares | $8/square | 24 | ||||||
Direct labor | 12 DLH | $14/DLH | 168 | ||||||
Variable overhead | 12 DLH | $57/DLH | 684 | ||||||
Fixed overhead | 12 DLH | $9/DLH | 108 | ||||||
$1,109 |
Prepare Vaughn's production budget for 2018. Assume that the desired ending inventory for 2018 is 580 tables. (Round answers to O decimal places, e.g. 5,275.) Production Budget 1St Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual 1798 Budgeted production Budgeted ending inventory Total units required Beginning inventory Budgeted Production 2519 2764 2931 10012 553 586 360 580 580 3072 3350 3291 2378 10592 504 553 586 360 504 2568 2797 2705 2018 10088 LINK TO TEXT LINK TO VIDEO Vaughn maintains inventory of American cherry wood equal to 10% of the following quarter's production needs. On December 31, 2017, Vaughn's physical inventory count showed 5,588 board feet of American cherry. Due to an anticipated price increase in 2019, managers want to have 10,020 board feet of American cherry wood in inventory on December 31, 2018. Prepare Vaughn's 2018 direct materials purchases budget for American cherry wood. (Round answers to O decimal places, e.g. 5,275.) Direct Materials Purchases Budget 1St Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Budgeted production 2568 2797 2705 2018 10088 Standard board feet 25 25 25 25 25 64200 Production needs Budgeted ending inventory Total DM required Beginning inventory Budgeted purchases Standard price per board feet> Budgeted purchases cost 69925 67625 50450 252200 6993 6763 5045 10020 10020 71193 76688 72670 6763 65907 60470 262220 5588 6993 5045 5588 65605 69695 55425 252200 5 5 5 328025 348475 329535 277125 1283160 LINK TO TEXT LINK TO VIDEO
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