Please help verify that the answers are correct.

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 10.500.00 Advertising for helmet......... $11,000 11 000 00 Cash January 1.... Depresia lon on factory building................. $1.500 1,500.00 Depreciation on office equipment......... Seno 800.00 Insurance on factory building......................$1.200 1.200,00 Miscellaneous expenses-factory................. 5500 500.00 Office supplies expense... . . .$300 300.00 Professional fees......... ...SCOO 800.00 Property taxes on factory building..................$400 400.00 Raw Materials used in production, .$60.000 60.000,00 Renton production equipment.........................35,000 5.000.00 Research & Development..........................$10,000 10.000.00 Sales commissions (10% of sales)............ $32,000 32.000.00 Utility costs-factory................................ $900 900.00 Wages - Factory direct labor....................... $87500 87.500.00 Work in process. January 1............................. $0 Work in process, January 31...................... Raw materials inventory, January 1.............$0 Raw materials inventory, January 31.... .. 12.000 12.000.00 Raw materials purchases. ........372 000 72.000.00 Finished goods inventory, January 1.............50 Production and Sales Data Number of halmats produced Expected sales in units for January Expected sales in units for February Desired ending inventory Direct materials needed per 1 finished unit Direct materials cost Desired direct materials inventory Direct labor hours per unit Direct labor hourly rate 10.000 8.000 540 Unit sel price $40 Undset 10.000 20% of next month's sales 1 Kilogram $6 per klogram 20% of next months' production 0.35 hour $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: 36% Manufacturing overhead and selling and administratve costs are paid as incurred. Desired ending cash balance: 20,000 (financing is necessary if cash balance alls 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 AND 2 INFORMATION FILLED 1.500 S Part-1 Production Costs Direct Direct Manufacturing Item Material Labor Ovehead Period Cost Administartive salaries $ 10,500 Advertising for helmets $ 11,000 Depreciation on Factory Building Depreciation on Office Equipment $ 800 Insurance on Factory Building 1.200 Miscellanious expenses -factory 500 office supplies 300 Professional fees Property taxes on factory buiding 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 Total IS 60,000 S 87,500S 9,500S 65,400 $ 800 $ Part-2 Item Administartive salaries Advertising for helmets Depreciation on Factory Building Depreciation on Office Equipment Insurance on Factory Building Miscellanious expenses -factory office supplies Professional fees Property taxes on factory buiding Raw Material used in production Rent on Production equipment Research and Development Sales Commission Utility Cost-Factory Wages Factory Direct labor Total Variable Cost Fixed Cost Total Cost $ 10,500 $ 10,500 $ 11,000 $ 11,000 $ 1,500 $ 1,500 $ 800 $ 800 1.200 1,200 $ 500 $ 500 300 $ 300 $ 800 $ $ 400 $ 400 60,000 60,000 $ 5,000 5,000 $ 10,000 10,000 $ 32,000 32,000 $ 900 $ 900 $ 87,500 $ 87,500 $ 1,79,500 $ 42,900 $ 2.22,400 800 1$ $ UE EL HIJ Part 3 - Prepare a schedule of cost of goods manufactured for the month of January, 2020. (Don't forget the heading) 1 Concrete Helmet Company Cost of Goods Manufactured Schedule For the month Ended January, 2020 6 Work in process inventory, Febuary 1,2020 Direct materials: Raw materials inventory, February 1,2020 Raw materials purchase 72,000 Total Cost of Materials Available for Use 72,000 Ending raw materials S (12,000) Direct Materials Used $ 60,000 + Direct labor: $ 87,500 S + Manufacturing overhead: Depreciation on factory building Insurance on factory building Miscellaenous expenses-factory Property taxes on factory building Rent on production equipment Utility costs-factory Total manufacturing overhead Total manufacturing costs incurred during the period Total manufacturing costs in Work-in-process Less = Cost of Goods Manufactured 1,500 1,200 500 400 5,000 900 9,500 24 25 $ $ 157,000 157,000 27 157,000 Part 4 - Determine the cost of producing a helmet The cost of producing a helmet is $15.70 Cost of goods manufactured $157000 divide by the total units manufactured 10,000=$15.70 Part 5 - Identify the type of cost accounting system that Concrete Helmet Company is probably using at this time. Explain. The Concrete Helmet Company is using Absorption costing system. In Absorption costing cost per unit is based on total manufacturing cost (Variable + Fixed manufacturing cost). Product cost consists of Variable cost (Raw material + labor) and Fixed cost (Indirect manufacturing cost). Part 6 - Under what circumstances migt Concrete use a different cost accounting system? Explain. Variable costing system is castoff for numerous managerial decision-making purposes. Variable costing assistances management in cost volume profit analysis and break-even analysis. Variable costing also, supports in flexible budget preparation and profitability at various levels of output. It is also beneficial for valuation of new product promotions and pricing results. Part 7 - Compute the unit variable cost for a helmet. 2 The unit variable cost for a helmet is $18.75. 3. To obtain the unit variable cost is by adding the raw materials used, wages-factory and sales commission. Tt in 5 Part 8 - Compute the unit contribution margin AND the contribution margin ratio. - The unit contribution margin $21.25. I added the selling price and variable cost to get the unit contribution margin. 3 The contribution margin ratio 53.13% 1 Part 9 - Calculate the break-even point in sales dollars AND the break-even point in units Fixed cost $42,900+ Contribution margin % 53.13%=$80,753 Fixed Cost $42,900+Unit contribution margin $21.25=$2,019 (C) Part 10 (a through d) (a) Concrete Helmet Company Sales budget For the Month Ended January,2020 Expected sales in units 8,000 Unit Selling price 40.0 Total Sales 320,000 10,000 Concrete Helmet Company Direct Materials Budget For the Month Ended January, 2020 Units to be produced Direct materials needed per unit 1kg Total kilograms needed for production Desired direct materials inventory Total materials required Beginning direct materials Direct material purchases Direct material cost Total cost of direct materials purchases 10,000 2,000 12,000 (b) 12,000 6.00 72,000 Armstrong Helmet Company Production Budget For the month ended December 31, 2013 Expected sales in units 8,000 Desired ending inventory 2,000 Total Required units 10,000 Beginning finished goods Required production units 10,000 Concrete Helmet Company Direct Labor Budget For the Month Ended January, 2020 Units to be produced Direct labor time (per unit) Total required direct labor hours Direct labor cost (per hour) Total direct labor cost 10,000 0.35 3,500 25 87,500 Part 10(e) (e) $ 32,000 Concrete Helmet Company Selling & Administrative Budget For the Month Ended January, 2020 Variable Expenses: Sales commisions Fixed Expenses: Administrative salaries 10,500 Advertising for helmets 11,000 Depreciation on office equpment 800 Office supplies expense 300 Research and development 10,000 Professional fees 800 Total Fixed Expenses: Total Selling & Administrative Expenses: $ $ 33,400 65,400 O F G H 224,000 224,000 $ Concrete Helmet Company Cash Budget For the Month Ended January, 2020 Beginning cash balance Add: Receipts Collections from customers Total available cash Less: Disbursements Direct materials 45,000 Direct labor 87,500 Manufacturing overhead 9,500 Selling and administrative expenses 65,400 Total Disbursements Excess (deficiency) of available cash over disbursements Financing (if any): Ending cash balance Concrete Helmet Company Budgeted Income Statement For the Month Ended January, 2020 Sales 320,000 Cost of goods sold 125,600 Gross Profit 194,400 Selling and administative expenses 65,400 Income from operations 129,000 Income Tax Expense 45,150 Net Income 83,850 $ 207,400 9,900 10,100 20,000