Acct434 Advanced Cost Management: 6-28 Sierra Furniture is an elite desk manufacturer

Reminder: Please REWORD/PARAPHRASE written or essay answers to ensure you do not get tagged for PLAGIARISM as we cannot guarantee other buyers have not submitted this tutorial verbatim.

Acct434 Advanced Cost Management
Homework ES Week 2

6-28 Budget schedules for a manufacturer
Sierra Furniture is an elite desk manufacturer. It makes two products:
Executive desks - 3' × 5' oak desks
Chairman desks - 6' × 4' red oak desks

The budgeted direct-cost inputs for each product in 2009 are:
Executive Line Chairman Line
Oak top 16 square feet -
Red oak top - 25 square feet
Oak legs 4.00 -
Red oak legs - 4.00
Direct manufacturing labor 3 hours 5 hours

Unit data pertaining to the direct materials for March 2009 are:
Actual Beginning Direct Materials Inventory (3/1/2009)
Executive Line Chairman Line
Oak top (square feet) 320 -
Red oak top (square feet) - 150
Oak legs 100 -
Red oak legs - 40

Target Ending Direct Materials Inventory (3/31/2009)
Executive Line Chairman Line
Oak top (square feet) 192.00 -
Red oak top (square feet) - 200.00
Oak legs 80.00 -
Red oak legs - 44.00

Unit cost data for direct-cost inputs pertaining to February 2009 and March 2009 are:
February 2009 (actual) March 2009 (budgeted)
Oak top (per square foot) 18.00 20.00
Red oak top (per square foot) 23.00 25.00
Oak legs (per leg) 11.00 12.00
Red oak legs (per leg) 17.00 18.00
Manufacturing labor cost per hour 30.00 30.00
Manufacturing overhead (both variable and fixed) is allocated to each desk on the basis of budgeted direct manufacturing labor-hours per desk. The budgeted variable manufacturing overhead rate for March 2009 is $35 per direct manufacturing labor-hour. The budgeted fixed manufacturing overhead for March 2009 is $42,500. Both variable and fixed manufacturing overhead costs are allocated to each unit of finished goods.
Data relating to finished goods inventory for March 2009 are:
Executive Line Chairman Line
Beginning inventory in units 20 5
Beginning inventory in dollars (cost) 10,480 4,850
Target ending inventory in units 30 15
Budgeted sales for March 2009 are 740 units of the executive line and 390 units of the chairman line. The budgeted selling prices per unit in March 2009 are $1,020 for the executive-line desk and $1,600 for the chairman-line desk. Assume the following in your answer:
Work-in-process inventories are negligible and ignored.
- Direct materials inventory and finished goods inventory are costed using the FIFO method.
- Unit costs of direct materials purchased and finished goods are constant in March 2009.

Required:
1. Prepare the following budgets for March 2009:
a. Revenues budget
b. Production budget in units
c. Direct material usage budget and direct material purchases budget
d. Direct manufacturing labor budget
e. Manufacturing overhead budget
f. Ending inventories budget (direct materials and finished goods)
g. Cost of goods sold budget
2. Suppose Sierra Furniture decides to incorporate continuous improvement into its budgeting process. Describe two areas where Sierra could incorporate continuous improvement into the budget schedules in requirement 1.
Powered by