I need help with Part 10. I have finished everything before and provided the information below.

Concrete Helmet Company "Adapted from Armstrong Helmet Company Case developed by Dick Wasson, Southwestern College and revised as appropriate per course **This project is worth 60 points. You must upload your assignment submission as an Excel file - no other formats will be accepted. An Excel workbook file is provided for you to complete this case project. You do not need to add or remove any rows or columns in the Excel file. The Business Situation Concrete Helmet Company is a newly formed company that manufactures bicycle helmets. The company began operations January 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, and budgets based on the information. The information provided to each candidate is as follows: Cost Items and Account Balances Administrative salaries........$ 10,500.00 Advertising for helmets........ $ 11,000.00 Cash, January 1....... Depreciation on factory buildi$ 1,500.00 Depreciation on office equipn $ 800.00 Insurance on factory building S 1,200.00 Miscellaneous expenses - fa $ 500.00 Office supplies expense....... S 300.00 Professional fees............... S 800.00 Property taxes on factory bui $ 400.00 Raw Materials used in produ$ 60,000.00 Rent on production equipmer$ 5,000.00 Research & Development.... $ 10,000.00 Sales commissions (10% of $ 32,000.00 Utility costs - factory........... S 900.00 Wages - Factory direct labor $ 87,500.00 Work in process, January 1.. $ Work in process, January 31 $ Raw materials inventory, Jan S Raw materials inventory, Jan $ 12,000.00 Raw materials purchases..... S 72,000.00 Finished goods inventory, Ja $ Production and Sales Data Number of helmets produced 10,000 Expected sales in units for JE 8,000 $40 Unit sell price Expected sales in units for Fe 10,000 Desired ending inventory 20% of next month's sales Direct materials needed per 1 Kilogram Direct materials cost $6 per kilogram Desired direct materials inver 20% of next months' production Direct labor hours per unit 0.35 hour Direct labor hourly rate $25 per hour Cash Flow Data Cash collection from customers: 70% in month of sale and 30% the following month. Cash payments to suppliers: 75% in month of purchase and 25% the following month. Income tax rate: 35% Manufacturing overhead and selling and administrative costs are paid as incurred. Desired ending cash balance $ 20,000 (financing is necessary if cash balance falls below the $20,000 minimum). Instructions Using the data presented above, complete the following 10 parts using this Excel workbook. 1. Classify the costs as either product costs or period costs using the five-column table in the Excel workbook for part 1. Enter the dollar amount of each cost in the appropriate column and total each classification. 2. Classify the costs as either variable or fixed costs. Assume there are no mixed costs. Enter the dollar amount of each cost in the appropriate column and total each classification. Assume Misc. expense-factory and Utility costs-factory are fixed costs 3. Prepare a schedule of cost of goods manufactured for the month of January. Don't forget the proper heading. 4. Determine the cost of producing a helmet (production cost per unit). 5. Identify the type of cost accounting system that Concrete Helmet Company is probably using at this time. EXPLAIN. 6. Under what circumstances might Concrete Helmet Company use a different cost accounting system? Explain. 7. Compute the unit variable cost per helmet. 8. Compute the unit contribution margin AND the contribution margin ratio (%). 9. Calculate the break-even point in sales dollars AND the break-even point in units. 10. Prepare the following budgets for the month of January. a) Sales b) Production c) Direct materials d) Direct labor e) Selling & Administrative expenses f) Cash g) Budgeted income statement PROJECT CHECK FIGURES: Total costs = $222,400 Total Period costs = $65,400 Cost of Goods Manufactured = $157,000 Total cash disbursements = $214,100 Net Income = $83,850 Part 1 - Classify the COSTS as either product costs or period costs using the below 5 column table. Enter the dollar amount of each cost in the appropriate column and total each classification. Product Costs Item Direct Materials Direct Labor Manufacturing Overhead Period Costs Administrative salaries 10,500 Advertising for helmets $ 11,000 Depreciation on Factory Building $ 1,500 Depreciation on Office Equipment $ 800 Insurance on Factory Building $ 1,200 Miscellanious expenses - factory $ 500 office supplies 300 Professional fees $ 800 Property taxes on factory building $ 400 Raw Material used in production $ 60,000 Rent on production equipment 5,000 Research and Development $ 10,000 Sales Commission $ 32,000 Utility Cost -Factory $ 900 Wages Factory Direct labor $ 87,500 Totals $ 60,000 $ 87,500 $ 9,500 $ 65,400 Item Concrete Helmet Company - Caselproject Part 2 - Classify the COSTS as either variable or fixed costs. Assume there are no mixed costs. Enter the dollar amount of each cost in the appropriate column and total each classification. **Assume the Misc. expense-factory and Utilitiy costs-factory are a fixed cost. Variable Costs Fixed Costs Total Costs Administrative salaries 10,500 $ 10,500 Advertising for helmets 11.000 $ 11,000 Depreciation on Factory Building 1,500 $ 1,500 Depreciation on Office Equipment 800 $ 800 Insurance on Factory Building 1,200 $ 1,200 Miscellanious expenses - factory 500 $ 500 office supplies 300 $ 300 Professional fees 800 $ 800 Property taxes on factory building 400 $ 400 Raw Material used in production $ 60,000 60,000 Rent on production equipment 5,000 $ 5,000 Research and Development 1,000 $ 10,000 Sales Commission 32,000 32,000 Utility Cost -Factory 900 $ 900 Wages Factory Direct labor $ 87,500 87,500 Totals 179,500 $ 42,900 $ 222,400 Part 4 - Determine the cost of producing a helmet Total manufacturing costs for helmets = $157,000 Divide this by the number of helmets produced (10,000) The cost to manufacture a single helmet is $15.70 Part 5 - Identify the type of cost accounting system that Concrete Helmet Company is probably using at this time. Explain. Concrete Helmet Company is using absorption costing system because they are using all of the costs that go into manufacturing a helmet. This includes labor, raw materials, and manufacturing overhead. Part 6 - Under what circumstances migt Concrete use a different cost accounting system? Explain. 1. If multiple cost dirvers are found 2. When cost accounting is based on decision making Part 7 - Compute the unit variable cost for a helmet. H I E F G Part 7 - Compute the unit variable cost for a helmet. Direct Materials (1 kg at $6 per kg) $6.00 Direct Labor (0.35 hrs at $25 per hr) $8.75 Sales Comissions $4.00 Unit Variable costs for helmet $18.75 Part 8 - Compute the unit contribution margin AND the contribution margin ratio. Selling Price - $40.00 Variable cost - $18.75 Unit contribution margin is $21.25 The contribution margin ratio is 53.13% Part 9 - Calculate the break-even point in sales dollars AND the break-even point in units Break even point in sales Fixed Cost $42,900 Contribution margin % 53.13% $80,753 Break even point in units Fixed Cost $42,900 Unit contribution marg $21.25 $2,019 B Part 10 La through d) (c) Sales budget Direct Materials Budget Total Sales Total kilograms needed for production Total materials required (b) Armstrong Helmet Company Production Budget For the month ended December 31, 2013 Total cost of direct materials purchases Total Required units (d) Direct Labor Budget Required production units Total required direct labor hours Total direct labor cost G H Part 10e) (e) Selling & Administrative Budget Variable Expenses: Fixed Expenses: Total Fixed Expenses: Total Selling & Administrative Expenses: F G H Part 10 (f-9) (g) Cash Budget Budgeted Income Statement Beginning cash balance Add: Receipts Gross Profit Total available cash Less: Disbursements Income Tax Expense Net Income Total Disbursements Excess (deficiency) of available cash over disbursements Financing (if any): Ending cash balance