Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Budgeted income statement and supporting budgetsThe budget director of Birding Homes & Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales

Budgeted income statement and supporting budgetsThe 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 15,000 units at $25 per unit Bird feeder 40,000 units at $15 per unitb. Estimated inventories at January 1:Direct materials: Wood 600 ft. Plastic 1,000 lbs.Finished products: Bird house 1,000 units at $15 per unit Bird feeder 2,500 units at $8 per unitc. Desired inventories at January 31:Direct materials: Wood 500 ft. Plastic 1,250 lbs.Finished products: Bird house 1,500 units at $15 per unit Bird feeder 3,000 units at $8 per unitd. Direct materials used in production:In manufacture of Bird House: Wood 0.80 ft. per unit of product Plastic 0.10 lb. per unit of productIn manufacture of Bird Feeder: Wood 0.20 ft. per unit of product Plastic 1.00 lb. per unit of producte. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood $2.50 per ft. Plastic $0.80 per lb.f. Direct labor requirements: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:Line Item DescriptionAmountIndirect factory wages$40,000Depreciation of plant and equipment20,000Power and light10,000Insurance and property tax5,000h. Estimated operating expenses for January:Line Item DescriptionAmountSales salaries expense$125,000Advertising expense80,000Office salaries expense40,000Depreciation expenseoffice equipment4,000Travel expenseselling25,000Office supplies expense2,500Miscellaneous administrative expense3,500i. Estimated other revenue and expense for January:Line Item DescriptionAmountInterest revenue$4,540Interest expense3,000j. Estimated tax rate: 25%Required:1. Prepare a sales budget for January.Birding Homes & Feeders Inc.Sales BudgetFor the Month Ending January 31Line Item DescriptionUnit SalesVolumeUnit SellingPriceTotal SalesBird housefill in the blank 1$fill in the blank 2$fill in the blank 3Bird feederfill in the blank 4fill in the blank 5fill in the blank 6Total revenue from sales $fill in the blank 72. Prepare a production budget for January. For those boxes in which you must enter subtracted or negative numbers use a minus sign.Birding Homes & Feeders Inc.Production BudgetFor the Month Ending January 31Line Item DescriptionUnitsBird HouseUnitsBird Feederfill in the blank 9fill in the blank 10fill in the blank 12fill in the blank 13fill in the blank 15fill in the blank 16fill in the blank 18fill in the blank 19fill in the blank 21fill in the blank 223. Prepare a direct materials purchases budget for January. For those boxes in which you must enter subtracted or negative numbers use a minus sign.Birding Homes & Feeders Inc.Direct Materials Purchases BudgetFor the Month Ending January 31Line Item DescriptionWoodPlasticTotalRequired units for production: Bird housefill in the blank 23fill in the blank 24 Bird feederfill in the blank 25fill in the blank 26 Desired units of inventory, January 31fill in the blank 27fill in the blank 28 Total units availablefill in the blank 29fill in the blank 30 Estimated units of inventory, January 1fill in the blank 31fill in the blank 32 Total units to be purchasedfill in the blank 33fill in the blank 34 Unit price$fill in the blank 35$fill in the blank 36 Total direct materials to be purchased$fill in the blank 37$fill in the blank 38$fill in the blank 394. Prepare a direct labor cost budget for January.Birding Homes & Feeders Inc.Direct Labor Cost BudgetFor the Month Ending January 31Line Item DescriptionFabricationDepartmentAssemblyDepartmentTotalHours required for production: Bird housefill in the blank 40fill in the blank 41 Bird feederfill in the blank 42fill in the blank 43 Totalfill in the blank 44fill in the blank 45 Hourly rate$fill in the blank 46$fill in the blank 47 Total direct labor cost$fill in the blank 48$fill in the blank 49$fill in the blank 505. Prepare a factory overhead cost budget for January.Birding Homes & Feeders Inc.Factory Overhead Cost BudgetFor the Month Ending January 31Line Item DescriptionAmount$fill in the blank 52fill in the blank 54fill in the blank 56fill in the blank 58Total factory overhead cost$fill in the blank 596. 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 BudgetFor the Month Ending January 31Line Item DescriptionAmount $fill in the blank 61 $fill in the blank 63 Direct materials: $fill in the blank 65 fill in the blank 67 Cost of direct materials available for use$fill in the blank 68 fill in the blank 70 Cost of direct materials placed in production$fill in the blank 71 fill in the blank 73 fill in the blank 75 Total manufacturing costs fill in the blank 76 Total work in process during period $fill in the blank 77 fill in the blank 79 Cost of goods manufactured fill in the blank 80Cost of finished goods available for sale $fill in the blank 81 fill in the blank 83Cost of goods sold $fill in the blank 847. Prepare a selling and administrative expenses budget for January.Birding Homes & Feeders Inc.Selling and Administrative Expenses BudgetFor the Month Ending January 31Line Item DescriptionAmountSelling expenses: $fill in the blank 86 fill in the blank 88 fill in the blank 90 Total selling expenses $fill in the blank 91Administrative expenses: $fill in the blank 93 fill in the blank 95 fill in the blank 97 fill in the blank 99 Total administrative expenses fill in the blank 100Total operating expenses $fill in the blank 1018. Prepare a budgeted income statement for January. In the Other revenue and expense section, indicate expenses as negative amounts.Birding Homes & Feeders Inc.Budgeted Income StatementFor the Month Ending January 31Line Item DescriptionAmount $fill in the blank 103 fill in the blank 105 $fill in the blank 107Operating expenses: $fill in the blank 109 fill in the blank 111 Total operating expenses fill in the blank 112Operating income $fill in the blank 113Other revenue and expense: $fill in the blank 115 fill in the blank 117fill in the blank 118Income before income tax $fill in the blank 119 fill in the blank 121Net income $fill in the blank 122

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ronald W Hilton

7th Edition

0073022853, 978-0073022857

Students also viewed these Accounting questions

Question

How is vacation and sick time accrued?

Answered: 1 week ago