Question:
The budget director of Monarch 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 November 2012 is summarized as follows:
1. Prepare a sales budget for November.
2. Prepare a production budget for November.
3. Prepare a direct materials purchases budget for November.
4. Prepare a direct labor cost budget for November.
Transcribed Image Text:
a. Estimated sales of King and Prince chairs for November by sales territory: Northern Domestic: King.. 5,800 units at $750 per unit 7,200 units at $570 per unit Prince Southern Domestic: 3,600 units at $690 per unit 4,100 units at $580 per unit King... Prince International: 1,750 units at $780 per unit 1,100 units at $610 per unit King... Prince . b. Estimated inventories at November 1: Direct materials: Finished products: Fabric . 4,500 sq. yds. 6,000 linear ft. 2,800 cu. ft. 950 units King... Wood 280 units Prince.. Filler Springs. 6,700 units c. Desired inventories at November 30: Direct materials: Finished products: 4,100 sq. yds. 6,200 linear ft. 3,100 cu. ft. Fabric ... 900 units King... Prince . Wood 400 units Filler Springs.. 7,200 units d. Direct materials used in production: In manufacture of King: Fabric 6.0 sq. yds. per unit of product 38 linear ft. per unit of product 4.2 cu. ft. per unit of product 16 units per unit of product Wood Filler Springs... In manufacture of Prince: Fabric . 4.0 sq. yds. per unit of product 26 linear ft. per unit of product 3.4 cu. ft. per unit of product 12 units per unit of product Wood Filler Springs.. e. Anticipated purchase price for direct materials: Fabric $14.00 per sq. yd. 8.00 per linear ft. Springs. Filler $3.50 per cu. ft. Wood 4.00 per unit f. Direct labor requirements: King: Framing Department.. Cutting Department.. Upholstery Department.. 2.6 hrs. at $12 per hr. 1.4 hrs. at $11 per hr. 22 hrs. at $15 per hr. Prince: Framing Department.. Cutting Department. .. Upholstery Department.. 2.0 hrs. at $12 per hr. 0.5 hr. at $11 per hr. 1.8 hrs. at $15 per hr.