Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The budget director of Birding Homes & Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following
The budget director of Birding Homes & Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: a. Estimated sales for January: Bird house Bird feeder. 15,000 units at $25 per unit 40,000 units at $15 per unit b. Estimated inventories at January 1:1 Direct materials: Wood Plastic Finished products: Bird house Bird feeder 600 ft. 1,000 lbs. 1,000 units at $15 per unit) 2,500 units at $8 per unit c. Desired inventories at January 31: Direct materials: Wood Plastic Finished products: Bird house Bird feeder 500 ft. 1,250 lbs. 1,500 units at $15 per unit 3,000 units at $8 per unit d. Direct materials used in production: In manufacture of Bird House: Wood Plastic 0.80 ft. per unit of product 0.10 lb. per unit of product In manufacture of Bird Feeder: Wood 0.20 ft. per unit of product eBook d. Direct materials used in production: In manufacture of Bird House: Wood Plastic 0.80 ft. per unit of product 0.10 lb. per unit of product In manufacture of Bird Feeder: Wood 0.20 ft. per unit of product 1.00 lb. per unit of product Plastic e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood Plastic f. Direct labor requirements: $2.50 per ft. $0.80 per lb. Bird House: < Fabrication Department 0.40 hr. at $18 per hr. Assembly Department 0.20 hr. at $12 per hr. Bird Feeder: Fabrication Department 0.25 hr. at $18 per hr. Assembly Department 0.10 hr. at $12 per hr. g. Estimated factory overhead costs for January: Indirect factory wages $40,000 Depreciation of plant and equipment 20,000 Power and light 10,000 Insurance and property tax 5,000 h. Estimated operating expenses for January: Sales salaries expense Advertising expense $125,000 80,000 eBook h. Estimated operating expenses for January: Sales salaries expense $125,000 Advertising expense 80,000 Office salaries expense 40,000 Depreciation expense-office equipment 4,000 Travel expense-selling 25,000 Office supplies expense 2,500 Miscellaneous administrative expense 3,500 i. Estimated other revenue and expense for January: Interest revenue $4,540 Interest expense 3,000 j. Estimated tax rate: 25% Required: 1. Prepare a sales budget for January. Bird house Bird feeder Birding Homes & Feeders Inc. Sales Budget For the Month Ending January 31 Total revenue from sales Unit Sales Volume Unit Selling Total Sales Price S Total revenue from sales 2. Prepare a production budget for January. For those boxes in which you must enter subtracted or negative numbers use a Birding Homes & Feeders Inc. Production Budget For the Month Ending January 31 Units Bird House Bird Feeder 3. Prepare a direct materials purchases budget for January. For those boxes in which you must enter subtracted or negative 3. Prepare a direct materials purchases budget for January. For those boxes in which you must enter subtracted or negative numbers Birding Homes & Feeders Inc. Direct Materials Purchases Budget For the Month Ending January 31 Required units for production: Bird house K Bird feeder Desired units of inventory, January 31 Total units available Estimated units of inventory, January 1 Total units to be purchased Unit price Total direct materials to be purchased Wood x$ Plastic Total eBook 4. Prepare a direct labor cost budget for January. Birding Homes & Feeders Inc. Direct Labor Cost Budget For the Month Ending January 31 Hours required for production: Bird house Bird feeder Total Fabrication Department Assembly Department Total Hourly rate S x$ $ x$ Total direct labor cost $ $ 5. Prepare a factory overhead cost budget for January. Birding Homes & Feeders Inc. Factory Overhead Cost Budget For the Month Ending January 31 Total factory overhead cost 6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $9,000, and work in process at the end of January is estimated to be $10,500. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Birding Homes & Feeders Inc. Cost of Goods Sold Budget For the Month Ending January 31 Direct materials: Cost of direct materials available for use Cost of direct materials placed in production $s Total manufacturing costs Total work in process during period Cost of goods manufactured Cost of finished goods available for sale Cost of goods sold 7. Prepare a selling and administrative expenses budget for January. Birding Homes & Feeders Inc. Selling and Administrative Expenses Budget Selling expenses: For the Month Ending January 31 < Total selling expenses Administrative expenses: Total administrative expenses Total operating expenses $$ $$ 0111 S $$ $$ 8. Prepare a budgeted income statement for January. In the Other revenue and expense section, indicate expenses as negative amounts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started