The daated information concerning sales and production for March is summarized a

Question

The daated information concerning sales and production for March is summarized as follows a. Estimated sales of william and Kate chairs for 1 Sales, production, direct materials purchases, and direct labor cost budget director of Royal British Furniture Company requests estimates of sales, pro- ion, and other operating data from the various administrative units every month. se Obj.2 March by sales territory: v3. Total direct materials purchases, 53,894,830 Eastern Domestic: 7,500 units at $800 per unit 6,000 units at $650 per unit Kate Western Domestic William Kate 6,000 units at $700 per unit 5,000 units at $550 per unit International William Kate 2,500 units at $600 per unit 1,000 units at $350 per unit b. Estimated inventories at March 1 Direct materials: Finished products: Fabric Wood Filler Springs 5,500 sq. yds. 13,700 lineal ft 3,800 cu. ft 3,500 units William 1,500 units 300 units c. Desired inventories at March 31: Direct materials: Finished products: William Kate 2.000 units 900 units Fabric Wood Filler Springs 9,000 sq. yds 20,000 lineal ft. 5,000 cu. ft. 7,500 units d. Direct materials used in production: In manufacture of William: Fabric Wood Filler Springs 4.0 sq. yds. per unit of product 16 lineal ft. per unit of product 3.8 cu. ft. per unit of product 14 units per unit of product In manufacture of Kate: 2.5 sq. yds. per unit of product Fabric Woo 12 lineal ft. per unit of product 3.2 cu. ft. per unit of product 10 units per unit of product Springs e. Anticipated purchase price for direct materials: Springs $1.50 per cu. ft. 2.00 per unit Filler $9.00 per sq.yd. Fabric Wood 5.00 per lineal ft.

Explanation / Answer

Req 1: Sales Budget for the Month of March WILLIAM KATE Eastern Domestic Expected Sales in Units 7500 6000 Expected Selling price per unit 800 650 Budgeted Sales in $ for Territory 6000000 3900000 Western Domestic Expected Sales in Units 6000 5000 Expected Selling price per unit 700 550 Budgeted Sales in $ for Territory 4200000 2750000 International Expected Sales in Units 2500 1000 Expected Selling price per unit 600 350 Budgeted Sales in $ for Territory 1500000 350000 Budgeted Sales for Company Total Budgeted Sales units 16000 12000 Budgeted Sales in $ 11700000 7000000 Req 2: Production Budget for March WILLIAM KATE Budgeted Sales units 16000 12000 Add: Desired Ending Inventory-Given 2000 900 Less: Desired Opening Inventory-Given 1500 300 Budgeted Production units 16500 12600 Req 3: Direct Material Purchase budget for March WILLIAM KATE TOTAL Budgeted Production units 16500 12600 Fabric: Fabric Requirement per unit in Sq. yards 4 2.5 Total Requirement in Sq. yards 66000 31500 97500 Add: Desired Ending Inventory-Given 9000 Less: Desired Opening Inventory-Given 5500 Fabric Purchase Budget in Sq. yards 101000 Purchase price per sq. yards $9.00 Fabric Purchase Budget in $ $909,000.00 Wood: Wood Requirement per unit in Lineal Ft. 16 12 Total Requirement in Lineal Ft. 264000 151200 415200 Add: Desired Ending Inventory-Given 20,000 Less: Desired Opening Inventory-Given 13700 Wood Purchase Budget in Lineal Ft. 421,500 Purchase price per Lineal Ft. $5.00 Wood Purchase Budget in $ $2,107,500.00 Filler: Filler Requirement per unit in cubic Ft. 3.8 3.2 Total Requirement in cubic Ft. 62700 40320 103020 Add: Desired Ending Inventory-Given 5,000 Less: Desired Opening Inventory-Given 3800 Filler Purchase Budget in Cubic Ft. 104,220 Purchase price per Cubic Ft. $1.50 Filler Purchase Budget in $ $156,330.00 Springs: Springs Requirement per unit in Units 14 10 Total Requirement in Units 231000 126000 357000 Add: Desired Ending Inventory-Given 7,500 Less: Desired Opening Inventory-Given 3500 Springs Purchase Budget in units 361,000 Purchase price per Unit $2.00 Spring Purchase Budget in $ $722,000.00 Req 4: Direct labour cost Budget for March WILLIAM KATE TOTAL Budgeted Production units 16500 12600 Framing Department: Labour hours required per unit 2.5 1.5 Labour cost per hour 15 15 Budgeted labour hours 41250 18900 60150 Budgeted labour cost in $ 618750 283500 902250 Cutting Department: Labour hours required per unit 1 0.5 Labour cost per hour 12 12 Budgeted labour hours 16500 6300 22800 Budgeted labour cost in $ 198000 75600 273600 Upholstery Department: Labour hours required per unit 3 2 Labour cost per hour 16 16 Budgeted labour hours 49500 25200 74700 Budgeted labour cost in $ 792000 403200 1195200 Total Budgeted labour cost in $ 1608750 762300 2371050

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.