Use Excel to prepare the following budgets for March 2020:

1. Sales budget
2. Production budget
3. Direct materials purchases budget
4. Direct labor cost budget
5. Factory overhead cost budget
6. Costs of goods sold budget. Work in process at the beginning of March is estimated to be $11,000, and work in process at the ending of March is desired to be $12,500.
7. Selling and administrative expenses budget
8. Budgeted income statement

The excel (or google sheet) document should have a different tab for each budget (8 total). Do not use excel as a typewriter. You must use formulas and links between spreadsheet tabs. Formatting should include appropriate headings.

Information for Budgeted Income Statement and Supporting Budgets: The budget director of Athletic Supplies 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 March: a. Estimated sales for March: Batting helmet 1,100 units at $42 per unit Football helmet 6,400 units at $146 per unit b. Estimated inventories at March 1: Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet c. Desired inventories at March 31: Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet 55lbs. 65lbs. 75 units at $28 per unit 220 units at $75 per unit 70lbs. 74 lbs. 50 units at $27 per unit 225 units at $72 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.5lbs. per unit of product Foam lining 0.75lb. per unit of product In manufacture of football helmet: Plastic 3.5lbs. per unit of product Foam lining 1.75 Ibs. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic $5.4 per lb. Foam lining $3.6 per lb. g. Estimated factory overhead costs for March: Indirect factory wages Depreciation of plant and equipment Power and light Insurance and property tax h. Estimated operating expenses for March: Sales salaries expense Advertising expense Office salaries expense Depreciation expense-office equipment Telephone expense-selling Telephone expense-administrative Travel expense-selling Office supplies expense Miscellaneous administrative expense $75,00014,0003,0003,700 3,700 $186,200 88,200 33,500 5,000 3,900 1,500 10,000 1,500 2,200 i. Estimated other income and expense for March: Interest revenue 800 Interest expense 875 j. Estimated tax rate: 30% Information for Budgeted Income Statement and Supporting Budgets: The budget director of Athletic Supplies 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 March: a. Estimated sales for March: Batting helmet 1,100 units at $42 per unit Football helmet 6,400 units at $146 per unit b. Estimated inventories at March 1: Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet c. Desired inventories at March 31: Direct materials: Plastic Foam lining Finished products: Batting helmet Football helmet 55lbs. 65lbs. 75 units at $28 per unit 220 units at $75 per unit 70lbs. 74 lbs. 50 units at $27 per unit 225 units at $72 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.5lbs. per unit of product Foam lining 0.75lb. per unit of product In manufacture of football helmet: Plastic 3.5lbs. per unit of product Foam lining 1.75 Ibs. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic $5.4 per lb. Foam lining $3.6 per lb. g. Estimated factory overhead costs for March: Indirect factory wages Depreciation of plant and equipment Power and light Insurance and property tax h. Estimated operating expenses for March: Sales salaries expense Advertising expense Office salaries expense Depreciation expense-office equipment Telephone expense-selling Telephone expense-administrative Travel expense-selling Office supplies expense Miscellaneous administrative expense $75,00014,0003,0003,700 3,700 $186,200 88,200 33,500 5,000 3,900 1,500 10,000 1,500 2,200 i. Estimated other income and expense for March: Interest revenue 800 Interest expense 875 j. Estimated tax rate: 30%