Part A Furniture Specialties is a company that make two types of dining tables:
ID: 2535979 • Letter: P
Question
Part A
Furniture Specialties is a company that make two types of dining tables: Simple and Futuristic. There are two types of direct materials: Pine and Mahogany woods. Direct manufacturing labour workers are hired on an hourly basis; no overtime is worked. In terms of manufacturing overhead costs, there are two manufacturing overhead cost pools and two cost drivers. The two manufacturing overhead cost pools are manufacturing operations overhead and machine setup overhead. The cost drivers for manufacturing overhead are: direct manufacturing labour-hours for manufacturing operations overhead cost and setup labour-hours for machine setup overhead cost. Nonmanufacturing costs consist of product design, marketing, and distribution costs.
The following data are available for the 2018 budget:
Direct Materials Rate
Pine
$ 9 per meter square (m2)
Mahogany
$13 per meter square (m2)
Direct Manufacturing labour rate
$25 per hour
Quantity of Material for Each Product
Simple Table
Futuristic Table
Pine
14 m2
14 m2
Mahogany
8 m2
10 m2
Direct Material Labour
6 hours
8 hours
Products
Simple Table
Futuristic Table
Expected Sales for 2018 (in units)
55,000
15,000
Selling Price
$ 750
$ 950
Target ending inventory in units
12,000
500
Beginning inventory in units
1,000
500
Beginning inventory in dollars
$ 400,000
$ 275,000
Direct materials inventory
Pine
Mahogany
Beginning inventory
85,000 m2
65,000 m2
Target ending inventory
90,000 m2
25,000 m2
Data on Manufacturing Overhead Cost
Manufacturing Operations Overhead cost (in capacity of 350,000 direct manufacturing labour-hours)
Variable manufacturing operation overhead costs (per direct manufacturing labour-hours)
Supplies
Indirect manufacturing labour
Power (support department costs)
Maintenance (support department costs)
Total variable manufacturing operation overhead cost
$ 4.50
6.50
7.00
3.50
$ 21.50
Fixed manufacturing operation overhead cost
Depreciation
Supervision
Power (support department costs)
Maintenance (support department costs)
Total fixed manufacturing operation overhead cost
$ 1,400,000
420,000
725,000
430,000
$ 2,975,000
Machine Setup Overhead Costs (in capacity of 15,150 setup labour-hours)
Variable machine setup overhead cost (per setup labour-hours)
Supplies
Indirect manufacturing labour
Power (support department)
Total variable machine setup overhead cost
$ 25
55
10
$ 90
Fixed machine setup overhead cost
Depreciation
Supervision
Power (Support department cost)
Total fixed machine setup overhead cost
$ 605,000
1,040,000
21,500
$ 1,666,500
0.2 hour of setup labour-hour is allocated to make one unit of simple table and 0.3 hour of setup labour-hour is allocated for futuristic table
Non-manufacturing Cost
Product Design Cost (fixed)
$ 1,100,000
Marketing Cost
Fixed marketing cost
Variable marketing cost is equals the 7.5% of revenues
$ 1,350,000
Distribution Cost
Fixed distribution cost
Variable distribution cost is $2 per cubic feet of table sold and shipped
Simple table 20 cubic feet per table sold and shipped
Futuristic table 25 cubic feet per table sold and shipped
$ 1,700,000
Required:
Based on the above information provided by the various department managers, prepare the following budgets:
C. Direct Material Usage Budget in quantity and dollars (6 points)
Direct Materials Rate
Pine
$ 9 per meter square (m2)
Mahogany
$13 per meter square (m2)
Direct Manufacturing labour rate
$25 per hour
Explanation / Answer
C.
Working:
Pine Mahagony Direct material usage - Sq.mtr 1134000 678000 Direct material usage - Dollars 10206000 8814000