Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 2019 is 580 tables. (Round answers to O decimal places, eg. S,275) 1st Quarter 2nd Quarter 3d Quarter 4th Quarter Annal Budgeted production Budgeted ending inventory Total units required Beginning inventory Budgeted Production 251 2931 1001 ! 3072 3291 237 585 2568| -2797| |-2705 |-201 |-100eei LINK TO TEXT LINK TO VIDEO hn maintains inventory a American c a wood equal to 10% of the follow ng quarter s production needs On December 31 2017 Vaughn's physical inventory count sho ed 5 588 board eat o Ame can che Due to an anticipated price increase in 2019, man want to have 10,020 board feet of American cherry wood in inventory on December 31, 2019. Prepare Voughn's 2018 direct materials purchoses budget for American cherry wood. (Round answers to 0 decimal places, e.g.5,275) Direct Materials Purchases Budget 1tQuarter 2nd Quarter ad Quarter 4thQuarter Annual Budgeted production Standard board fect Production needs Budgeted ending inventory Total DM required Beginning inventory Budgoted purchases 2018 6992 504 6993 1193 68 2670 0470257789 ssee-499,--6763||-5045-5500 | Standard price per board feet Budgeted purchases cost 328025 3484753295352771251261000 LINK TO TEXT
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