The financial director of Belleville Furniture Company requests estimates of sales, production, and other operating data...

 
   

Transcribed Image Text:

The financial director of Belleville 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: Estimated sales of Grace and Albert chairs for March by sales territory: Eastern Domestic: Grace 7,500 units at $800/unit Albert 6,000 units at $650/unit Western Domestic: Grace 6,000 units at $720/unit Albert 5,000 units at $575/unit International: Grace Albert 3,500 units at $650/unit 1,500 units at $340/unit . Estimated inventories at March 1: Direct Materials: Fabric Wood Filler 5,500 sq. yds. 13,700 lineal ft. 3,800 cu. ft. Springs 3,500 units Finished Products: Grace 1,500 units Albert 300 units Desired inventories at March 31: Direct Materials: Fabric Wood Filler Springs Finished Products: 9,000 sq. yds. 20,000 lineal ft. 5,000 cu. ft. 7,500 units Grace Albert Direct materials used in production: In manufacture of Grace: Fabric Wood Filler Springs 2,000 units 875 units 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 Albert: Fabric Wood Filler Springs Direct labor requirements: Grace: Framing Dept. 3.0 sq. yds. per unit of product 12 lineal ft. per unit of product 3.0 cu. ft. per unit of product 12 units per unit of product 2.5hrs. at $15/hr. 1.0 hrs. at $12/hr. Cutting Dept. Upholstery Dept. 3.0 hrs. at $16/hr. Albert: Framing dept. Cutting dept. 1.5 hrs. at $15/hr. 0.75 hr. at $12/hr. 2.0 hr. at $16/hr. Upholstery dept. Anticipated purchase price for direct materials: Fabric Wood Filler Springs $9.00 per sq. yd. $6.00 per lineal ft. $15 per cu. ft. $2.00 per unit Requirements: 1. Prepare a sales budget for March. 2. Prepare a production budget for March. The financial director of Belleville 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: Estimated sales of Grace and Albert chairs for March by sales territory: Eastern Domestic: Grace 7,500 units at $800/unit Albert 6,000 units at $650/unit Western Domestic: Grace 6,000 units at $720/unit Albert 5,000 units at $575/unit International: Grace Albert 3,500 units at $650/unit 1,500 units at $340/unit . Estimated inventories at March 1: Direct Materials: Fabric Wood Filler 5,500 sq. yds. 13,700 lineal ft. 3,800 cu. ft. Springs 3,500 units Finished Products: Grace 1,500 units Albert 300 units Desired inventories at March 31: Direct Materials: Fabric Wood Filler Springs Finished Products: 9,000 sq. yds. 20,000 lineal ft. 5,000 cu. ft. 7,500 units Grace Albert Direct materials used in production: In manufacture of Grace: Fabric Wood Filler Springs 2,000 units 875 units 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 Albert: Fabric Wood Filler Springs Direct labor requirements: Grace: Framing Dept. 3.0 sq. yds. per unit of product 12 lineal ft. per unit of product 3.0 cu. ft. per unit of product 12 units per unit of product 2.5hrs. at $15/hr. 1.0 hrs. at $12/hr. Cutting Dept. Upholstery Dept. 3.0 hrs. at $16/hr. Albert: Framing dept. Cutting dept. 1.5 hrs. at $15/hr. 0.75 hr. at $12/hr. 2.0 hr. at $16/hr. Upholstery dept. Anticipated purchase price for direct materials: Fabric Wood Filler Springs $9.00 per sq. yd. $6.00 per lineal ft. $15 per cu. ft. $2.00 per unit Requirements: 1. Prepare a sales budget for March. 2. Prepare a production budget for March.