Question

Sandoval Furniture builds high-end hand-made dining tables. Mackenzie Sandoval, the company's owner, has developed the following sales forecast for 2015.

Because of the time needed to create each table, Sandoval maintains an ending Finished Goods Inventory of 20 percent of the following quarter's budgeted sales. Sandoval has been following this inventory policy for several years. The company ended 2014 with 500 tables on hand.The standard cost card for a table is as follows:

Requireda. Prepare Sandoval's production budget for 2015. Assume that the desired ending inventory for 2015 is 600 tables.b. Sandoval maintains inventory of American cherry wood equal to 10 percent of the following quarter's production needs. On December 31, 2014, Sandoval's physical inventory count showed 5,500 board feet of American cherry. Due to an anticipated price increase in 2016, managers want to have 10,000 board feet of American cherry wood in inventory on December 31, 2015. Prepare Sandoval's 2015 direct materials purchases budget for American cherry wood.c. Prepare Sandoval's direct labor budget for 2015.d. Assume that because of the skill level required to make the tables, Sandoval 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 Sandoval's direct labor budget for2015.