Sales, Production, Direct Materials Purchases, and Direct Labor Cost The budget director of Royal British Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for March is summarized as follows: a. Estimated sales of William and Kate chairs for March by sales territory: Eastern Domestic: William 7,500 units at $800 per unit Kate 6,000 units at $650 per unit Western Domestic: William 6,000 units at $700 per unit Kate 5,000 units at $550 per unit International: William 2,500 units at $600 per unit Kate 1,000 units at $350 per unit b. Estimated inventories at March 1: Direct materials: Finished products: Fabric 5,500 sq. yds. William 1,500 units Wood 13,700 lineal ft. Kate 300 units Filler 3,800 cu. ft. Springs 3,500 units c. Desired inventories at March 31: Direct materials: Finished products: Fabric 9,000 sq. yds. William 2,000 units Wood 20,000 lineal ft. Kate 900 units Filler 5,000 cu. ft. Springs 7,500 units d. Direct materials used in production: In manufacture of William: Fabric 4.0 sq. yds. per unit of product Wood 16 lineal ft. per unit of product Filler 3.8 cu. ft. per unit of product Springs 14 units per unit of product In manufacture of Kate: Fabric 2.5 sq. yds. per unit of product Wood 12 lineal ft. per unit of product Filler 3.2 cu. ft. per unit of product Springs 10 units per unit of product e. Anticipated purchase price for direct materials: Fabric $9.00 per sq. yd. Filler $1.50 per cu. ft. Wood 5.00 per lineal ft. Springs 2.00 per unit f. Direct labor requirements: William: Framing Department 2.5 hrs. at $15 per hr. Cutting Department 1.0 hr. at $12 per hr. Upholstery Department 3.0 hrs. at $16 per hr. Kate: Framing Department 1.5 hrs. at $15 per hr. Cutting Department 0.5 hr. at $12 per hr. Upholstery Department 2.0 hrs. at $16 per hr. Required: 1. Prepare a sales budget for March. Royal British Furniture Company Sales Budget For the Month Ending March 31 Product and Area Unit Sales Volume Unit Selling Price Total Sales William: Eastern Domestic fill in the blank ceff4d07e061fb2_1 $fill in the blank ceff4d07e061fb2_2 $fill in the blank ceff4d07e061fb2_3 Western Domestic fill in the blank ceff4d07e061fb2_4 fill in the blank ceff4d07e061fb2_5 fill in the blank ceff4d07e061fb2_6 International fill in the blank ceff4d07e061fb2_7 fill in the blank ceff4d07e061fb2_8 fill in the blank ceff4d07e061fb2_9 Total fill in the blank ceff4d07e061fb2_10 $fill in the blank ceff4d07e061fb2_11 Kate: Eastern Domestic fill in the blank ceff4d07e061fb2_12 $fill in the blank ceff4d07e061fb2_13 $fill in the blank ceff4d07e061fb2_14 Western Domestic fill in the blank ceff4d07e061fb2_15 fill in the blank ceff4d07e061fb2_16 fill in the blank ceff4d07e061fb2_17 International fill in the blank ceff4d07e061fb2_18 fill in the blank ceff4d07e061fb2_19 fill in the blank ceff4d07e061fb2_20 Total fill in the blank ceff4d07e061fb2_21 $fill in the blank ceff4d07e061fb2_22 Total revenue from sales $fill in the blank ceff4d07e061fb2_23 2. Prepare a production budget for March. Royal British Furniture Company Production Budget For the Month Ending March 31 William Units Kate Units Expected units to be sold fill in the blank 08964805cfbd050_1 fill in the blank 08964805cfbd050_2 fill in the blank 08964805cfbd050_4 fill in the blank 08964805cfbd050_5 Total fill in the blank 08964805cfbd050_6 fill in the blank 08964805cfbd050_7 fill in the blank 08964805cfbd050_9 fill in the blank 08964805cfbd050_10 Total units to be produced fill in the blank 08964805cfbd050_11 fill in the blank 08964805cfbd050_12 3. Prepare a direct materials purchases budget for March. Royal British Furniture Company Direct Materials Purchases Budget For the Month Ending March 31 Direct Materials: Fabric (sq. yds.) Wood (lineal ft.) Filler (cu. ft.) Springs (units) Total Required units for production: William fill in the blank 605a3f028047fe4_1 fill in the blank 605a3f028047fe4_2 fill in the blank 605a3f028047fe4_3 fill in the blank 605a3f028047fe4_4 Kate fill in the blank 605a3f028047fe4_5 fill in the blank 605a3f028047fe4_6 fill in the blank 605a3f028047fe4_7 fill in the blank 605a3f028047fe4_8 fill in the blank 605a3f028047fe4_10 fill in the blank 605a3f028047fe4_11 fill in the blank 605a3f028047fe4_12 fill in the blank 605a3f028047fe4_13 Total fill in the blank 605a3f028047fe4_14 fill in the blank 605a3f028047fe4_15 fill in the blank 605a3f028047fe4_16 fill in the blank 605a3f028047fe4_17 fill in the blank 605a3f028047fe4_19 fill in the blank 605a3f028047fe4_20 fill in the blank 605a3f028047fe4_21 fill in the blank 605a3f028047fe4_22 Total units to be purchased fill in the blank 605a3f028047fe4_23 fill in the blank 605a3f028047fe4_24 fill in the blank 605a3f028047fe4_25 fill in the blank 605a3f028047fe4_26 Unit price $fill in the blank 605a3f028047fe4_27 $fill in the blank 605a3f028047fe4_28 $fill in the blank 605a3f028047fe4_29 $fill in the blank 605a3f028047fe4_30 Total direct materials to be purchased $fill in the blank 605a3f028047fe4_31 $fill in the blank 605a3f028047fe4_32 $fill in the blank 605a3f028047fe4_33 $fill in the blank 605a3f028047fe4_34 $fill in the blank 605a3f028047fe4_35 4. Prepare a direct labor cost budget for March. Royal British Furniture Company Direct Labor Cost Budget For the Month Ending March 31 Framing Department Cutting Department Upholstery Department Total Hours required for production: William fill in the blank 40f8cff5507505f_1 fill in the blank 40f8cff5507505f_2 fill in the blank 40f8cff5507505f_3 Kate fill in the blank 40f8cff5507505f_4 fill in the blank 40f8cff5507505f_5 fill in the blank 40f8cff5507505f_6 Total fill in the blank 40f8cff5507505f_7 fill in the blank 40f8cff5507505f_8 fill in the blank 40f8cff5507505f_9 Hourly rate $fill in the blank 40f8cff5507505f_10 $fill in the blank 40f8cff5507505f_11 $fill in the blank 40f8cff5507505f_12 Total direct labor cost $fill in the blank 40f8cff5507505f_13 $fill in the blank 40f8cff5507505f_14 $fill in the blank 40f8cff5507505f_15 $fill in the blank 40f8cff5507505f_16