Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Crane 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

Crane 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,525 2,732 2,908 2,254

Because of the time needed to create each table, Crane maintains an ending Finished Goods Inventory of 20% of the following quarters budgeted sales. Crane has been following this inventory policy for several years. The company ended 2017 with 505 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 $9/square 27
Direct labor 12 DLH $18/DLH 216
Variable overhead 12 DLH $55/DLH 660
Fixed overhead 12 DLH $9/DLH 108
$1,136

A. Prepare Cranes production budget for 2018. Assume that the desired ending inventory for 2018 is 598 tables. (Round answers to 0 decimal places, e.g. 5,275.)

B. Crane maintains inventory of American cherry wood equal to 10% of the following quarters production needs. On December 31, 2017, Cranes physical inventory count showed 5,569 board feet of American cherry. Due to an anticipated price increase in 2019, managers want to have 10,070 board feet of American cherry wood in inventory on December 31, 2018. Prepare Cranes 2018 direct materials purchases budget for American cherry wood. (Round answers to 0 decimal places, e.g. 5,275.)

C. Prepare Cranes direct labor budget for 2018. (Round answers to 0 decimal places, e.g. 5,275.)

D. Assume that because of the skill level required to make the tables, Crane 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 Cranes 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.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Sketch the graph of the function 1 4x x 2 .

Answered: 1 week ago