Answer to Question 1
F
Answer to Question 2
1.
Direct Material Usage Budget in Quantity and Dollars
Material
Wool Dye Total
Physical Units Budget
Direct materials required for
Blue Rugs (200,000 rugs 36 skeins and 0.8 gal.) 7,200,000 skeins 160,000 gal.
Cost Budget
Available from beginning direct materials inventory: (a)
Wool: 458,000 skeins 961,800
Dye: 4,000 gallons 23,680
To be purchased this period: (b)
Wool: (7,200,000 458,000) skeins 2 per skein 13,484,000
Dye: (160,000 4,000) gal. 6 per gal. 936,000
Direct materials to be used this period: (a) + (b) 14,445,800 959,680 15,405,480
2.
= = 2.55 per DMLH
= = 12 per MH
3.
Budgeted Unit Cost of Blue Rug
Cost per
Unit of Input Input per
Unit of
Output
Total
Wool 2 36 skeins 72.00
Dye 6 0.8 gal. 4.80
Direct manufacturing labor 13 62 hrs. 806.00
Dyeing overhead 12 7.21 mach-hrs. 86.40
Weaving overhead 2.55 62 DMLH 158.10
Total 1,127.30
10.2 machine hour per skein 36 skeins per rug = 7.2 machine-hrs. per rug.
4.
Revenue Budget
Units Selling Price Total Revenues
Blue Rugs 200,000 2,000 400,000,000
Blue Rugs 185,000 2,000 370,000,000
5a.
Sales = 200,000 rugs
Cost of Goods Sold Budget
From Schedule Total
Beginning finished goods inventory 0
Direct materials used 15,405,480
Direct manufacturing labor (806 200,000) 161,200,000
Dyeing overhead (86.40 200,000) 17,280,000
Weaving overhead (158.10 200,000) 31,620,000 225,505,480
Cost of goods available for sale 225,505,480
Deduct ending finished goods inventory 0
Cost of goods sold 225,505,480
5b.
Sales = 185,000 rugs
Cost of Goods Sold Budget
From Schedule Total
Beginning finished goods inventory 0
Direct materials used 15,405,480
Direct manufacturing labor (806 200,000) 161,200,000
Dyeing overhead (86.40 200,000) 17,280,000
Weaving overhead (158.10 200,000) 31,620,000 225,505,480
Cost of goods available for sale 225,505,480
Deduct ending finished goods inventory
(1,127.30 15,000) 16,909,500
Cost of goods sold 208,595,980
6.
200,000 rugs sold 185,000 rugs sold
Revenue 400,000,000 370,000,000
Less: Cost of goods sold 225,505,480 208,595,980
Gross margin 174,494,520 161,404,020
7. If sales drop to 185,000 blue rugs, Xander should look to reduce fixed costs and produce less to reduce variable costs and inventory costs.
8. Top management can look for ways to increase (stretch) sales and improve quality, efficiency, and input prices to reduce costs in each cost category such as direct materials, direct manufacturing labor, and overhead costs. Top management can also use the budget to coordinate and communicate across different parts of the organization, create a framework for judging performance and facilitating learning, and motivate managers and employees to achieve stretch targets of higher revenues and lower costs.