PR 21-3A Budgeted income statement and supporting budgets Obj. 4 l direct labor The budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, n Fabrication production manager, and sales manager, has gathered the following data for use in developing ept., $29,216 the budgeted income statement for December: A. Estimated sales for December: Bird house .. 3,200 units at $50 per unit EXCEL TEMPLATE Bird feeder.. 3,000 units at $70 per unit B. Estimated inventories at December 1: Direct materials: Finished products: Wood . .. . .. . . 200 ft. Bird house .. . .. .. 320 units at $27 per unit Plastic. .. . .... 240 lbs. Bird feeder. . . .... 270 units at $40 per unit C. Desired inventories at December 31: Direct materials: Finished products: Wood 220 ft. Bird house . .. .. .. 290 units at $27 per unit Plastic. ..... 200 lbs. Bird feeder. . ... .. 250 units at $41 per unit D. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood . . .. . . .... 0.80 ft. per unit of product Wood ........... 1.20 ft. per unit of product Plastic. ... .. 0.50 lb. per unit of product Plastic . .. 0.75 lb. per unit of product E. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood ... $7.00 per ft. Plastic ..... .... $1.00 per lb. F. Direct labor requirements: Bird House: Fabrication Department . 0.20 hr. at $16 per hr. Assembly Department... 0.30 hr. at $12 per hr. Bird Feeder: Fabrication Department . 0.40 hr. at $16 per hr. Assembly Department. .. 0.35 hr. at $12 per hr. G. Estimated factory overhead costs for December: Indirect factory wages $75,000 Power and light $6,000 Depreciation of plant and equipment 23,000 Insurance and property tax 5,000 H. Estimated operating expenses for December: Sales salaries expense $70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expense-office equipment 600 Telephone expense-selling 550 Telephone expense-administrative 250 Travel expense-selling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400