Sierra Furniture is an elite desk manufacturer. It manufactures two products:

—† Executive desks: 0.91 m × 1.5 m oak desks = 1.365 m2

—† Chairperson desks: 1.8 m × 1.2 m red oak desks = 2.16 m2

The budgeted direct cost inputs for each product in 2013 are as follows:

Unit data pertaining to the direct materials for March 2013 are as follows:

Unit cost data for direct cost inputs pertaining to February 2013 and March 2013 are:

Manufacturing overhead (both variable and fixed) is allocated to each desk based on budgeted direct manufacturing labour-hours per desk. The budgeted variable manufacturing overhead rate for March 2013 is $42 per direct manufacturing labour-hour. The budgeted fixed manufacturing overhead for March 2013 is $51,000. Both variable and fixed manufacturing overhead costs are allocated to each unit of finished goods. Data relating to finished goods inventory for March 2013 are:

Budgeted sales for March 2013 are 740 units of the Executive Line and 390 units of the Chairperson Line. The budgeted selling prices per unit in March 2013 are $1,224 for an Executive Line desk and $1,920 for a Chairperson Line desk.
Assume the following in your answer:
a. Work-in-process inventories are negligible and ignored.
b. Direct materials inventory and finished goods inventory are costed using the FIFO method.
c. Unit costs of direct materials purchased and finished goods are constant in March 2013.
REQUIRED
Prepare the following budgets for March 2013:
1. Revenue budget.
2. Production budget in units.
3. Direct materials usage budget and direct materials purchases budget.
4. Direct manufacturing labour budget.
5. Manufacturing overhead budget.
6. Ending inventory budget.
7. Cost of goods sold budget and gross margin calculation.

Transcribed Image Text:

Executive Line Chairperson Line Direct materials Oak top Red oak top Oak legs Red oak legs 1.5 square metres 4 legs 3 hours 2.3 square metres 4 legs 5 hours Direct manufacturing labour Actual Beginning Direct Materials Inventory (March 1, 2013) Product Chairperson Line Oak top Red oak top Oak legs Red oak legs Executive Line 29.8 square metres 100 legs 13.9 square metres 40 legs Target Ending Direct Materials Inventory (March 31, 2013) Product Chairperson Line Oak top Red oak top Oak legs Red oak legs Executive Line 17.9 square metres 80 legs 18.6 square metres 44 legs February 2013 (Actual) Oak top (per square metre) Red oak top (per square metre) Oak legs (per leg) Red oak legs (per leg) Manufacturing lal S21.60 27.60 13.20 20.40 36.00 March 2013 (Budgeted) S24.00 30.00 14.40 21.60 36.00 our cost per hour Chairperson Line Beginning inventory Beginning inventory in dollars (cost) Budgeted ending inventory Executive Line 20 units $12,576 5 units $5,820 15 units 30 units