Good Aftenoon, I wanted to know how much would it be for the homework below? Thank you Answer the requirements of the following…

Good Aftenoon, I wanted to know how much would it be for the homework below? Thank you Answer the requirements of the following document and upload your answer to this drop box. Use Excel with all the relevant formulas to cross reference the data in this question. You have until the 13th of Dec. 2012 at 11:55 P.M. to submit your work. no exceptions. COMPREHENSIVE BUDGET PROBLEM The budget director of Hi Performance Athletic Co., with the assistance of the controller, treasurer, production amanger, and sales manager, has gathered the following data for use in developing the budgeted income statement for January 2012. a. Estimated sales for Jnauary Batting helmets 305 unites @$70 per unit Football helmet 630 units @$135 per unit b. Estimated inventories at January Direct materials: Finished products: Plastic 80-lbs Batting helmet 35 units @$40 per unit Foam lining 60-lbs Fopotball helmet 40 units @$60 per unit c. Desired Inventorties at January 31: Direct materials: Finished products: Plastic 90-lbs Batting helmet 30 units @40 per unit Foam lining 55-lbs Football helmet 50 units @$58 per unit d. Direct materials used in production: In manufacturing of batting helmet: Plastic 1.20-lbs. per unit of product Foam lining 0.50-lb. per unit of product In manufacturing of football helmet Plastic 2.80-lbs. per unit of product Foam lining 1.40-lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct material: Plastic $5.50 per lb. Foam lining $4.00 per lb. f. Direct labor requirements: Batting helmet: Molding department 0.20 hr. @$15 per hr. Assembly department 0.50 hr. @$13 per hr. Football helmet Molding department 0.30 hr. @$15 per hr. Assembly department 0.65 hr. @$13 per hr. g. Estimated factyory overhaed costs for January: Indirect factory wages $14,500; Power and light $2,000 Depreciation of plant & equipment $4,200 Insurance &property tax $1,700 h. Estimated operating expenses for January: Sales salary expense $15,400 Advertising expense $8,500 Office salaries expense $11,500 Depreciation expense – offise equipment $3,200 Telephone expense – selling $950 Telephone expense – administrative $600 Travel expense – selling $2,300 Office supplies expense $550 Miscellaneous administrative expense $00 i. Estimated other income and expense fro Jnauary: Interest revenue $140 Interest expense $172 j. Estimated tax rate: 30% Instructions: uisng Excel with the appropriate formulas do the following using one sheet for each. 1 Prepare a sales budget for Jnauary 2 Prepare a production budget for January 3 Prepare a direct materials purchases budget fro January 4 Prepare a direct labor cost budget for January 5 Prepare a factory overhead cost budgety for January 6 Prepare a cost of goods sold budget for Jnauary. Work-in process at the beginning of January is estimated at $12,500, and work in process at the end of January is desired to be $13,500. 7 Prepare a selling and adminstartive expense budget for Jnauary 8 Prepare a budgeted income statement for Jnauary My email address is
[email protected] Thank you, Rebeca Furniss