c. Desired inventories at February 28: Direct materials: Fabric 390 sq. yds. Wood 650 linear ft. Filler 300 cu. ft. Springs 540 units Finished products: King 80 units Prince 35 units d. Direct materials used in production: In manufacture of King: Fabric 6.0 sq. yds. per unit of product Wood 38 linear ft. per unit of product Filler 4.2 cu. ft. per unit of product Springs 16 units per unit of product In manufacture of Prince: Fabric 4.0 sq. yds. per unit of product Wood 26 linear ft. per unit of product Filler 3.4 cu. ft. per unit of product Springs 12 units per unit of product e. Anticipated purchase price for direct materials: Fabric $12.00 per sq. yd. Wood 7.00 per linear ft. Filler $3.00 per cu. ft. Springs 4.50 per unitf. Direct labor requirements: King: Framing Department 1.2 hrs. at $12 per hr. Cutting Department 0.5 hr. at $14 per hr. Upholstery Department 0.8 hr. at $15 per hr. Prince: Framing Department 1.0 hr. at $12 per hr. Cutting Department 0.4 hr. at $14 per hr. Upholstery Department 0.6 hr. at $15 per hr.a. Estimated sales of King and Prince chairs for Februanrr by sales territory: Northern Domestic: King 610 unite at $?'Ei per unit Prince FEE! unite at $5551 per unit Southern Domestic: King 340 unite at $?'Ei per unit Prince 44E! unite at $5551 per unit International: King 360 unite at $855 per unit Prince 29E! unite at $6M! per unit b. Estimated inventories at Fetiruar}r 1: Direct materials: Fabric 420 so. vds. Wood 580 linear it. Filler 250 cu. ft. Springs 660 unite Finished products: King 90 unite Prince 25 units 2. Prepare a production budget for February. For those boxes in which you must enter subtracted or negative numbers use a minus sign Royal Furniture Company Production Budget For the Month Ending February 28 Units King Prince Expected units to be sold 1,310 1,480 Desired inventory, February 28 80 35 Total units available 1,390 1,515 Estimated inventory, February 1 Total units to be produced 1,300 1,4903. Prepare a direct materials purchases budget for February. For those boxes in which you must enter subtracted or negative numbers use a minus sig Royal Furniture Company Direct Materials Purchases Budget For the Month Ending February 28 Direct Materials Fabric Wood Filler Springs Total (sq. yds.) (linear ft.) (cu. ft.) (units) Required units for production: King 7,800 49,400 5,460 20,800 Prince 5,960 38,740 5,066 17,880 Desired inventory, February 28 390 650 300 540 Total 14,150 88,790 10,826 39,220 Estimated inventory, February 1 X Total units to be purchased 13,730 88,210 38,560 Unit price 12 7 3 4.50 Total direct materials to be purchased 164,760 +A 617,470 173,520Feedbank T Check My Work Remember to take into account expected units to be sold, desired units in ending inventory and estimated units in beginning inventory when calculating total units to be produced. Once sales quantities are estimated, the expected sales revenue can be determined. Remember to take into account materials required for production, desired ending materials inventory and estimated beginning materials inventory when calculating direct materials to be purchased. For the Month Ending February 28 Units King Prince Expected units to be sold V 1,310 1,480 Desired inventory, February 28 V 35 Total units available 1,390 1,515 Estimated inventory, February 1 90 X 25 X Total units to be produced 1,300 V 1,490 3. Prepare a direct materials purchases budget for February. For those boxes in which you must enter subtracted or negative numbers use a minus si Royal Furniture Company Direct Materials Purchases Budget For the Month Ending February 28 Direct Materials Fabric Wood Filler Springs Total (sq. yds.) (linear ft.) (cu. ft.) (units) Required units for production: King 7,800 49,400 V 5,460 20,800 V Prince 5,960 V 38,740 V 5,066 17,880 V Desired inventory, February 28 390 650 300 540 V Total 14,150 88,790 10,826 39,220 V Estimated inventory, February 1 420 X 580 X 250 X 560 X Total units to be purchased 13,730 88,210 10,576 38,560 V Unit price 12 3 1.50 V Total direct materials to be purchased $ 164,760 $ 617,470 $ 31,728 173,520 V $ 987,478 V
