PLEASE HELP

Concrete Helmet Case Workbook for students QuSearch Sheet Data Review View Share Comments AutoSave OFF A svo Home Insert Draw Page Layout Formulas Mv Arial 11 A A BI U D A H264 x fx = = Az av alle Wrap Text SE Merge & Center O General $ % Insert 2X Delete D P D Conditional Format Formatting as Table Paste od -20 Cell Styles Ideas Format Sort & Filter Sensitivity X Find & Select V G H I J K L M N O P Q R S T U V W X Concrete Helmet Company *Adapted from Armstrong Helmet Company Case developed by Dick Wasson, Southwestern College and revised as appropriate per course 4 **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. 7 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 9 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. 10 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. 11 The information provided to each candidate is as follows: 12 Cost Items and Account Balances 13 Administrative salaries. ....$10,500 $ 10,500.00 14 Advertising for helmets.. .......................$11,000 $ 11,000.00 15 Cash, January 1. .................$0 16 Depreciation on factory building....................$1,500 $ 1,500.00 17 Depreciation on office equipment..................$800 $ 800.00 18 Insurance on factory building. ....................$1,200 $ 1,200.00 19 Miscellaneous expenses - factory.................$500 $ 500.00 20 Office supplies expense......... 21 Professional fees.......... ...............$800 $ 800.00 22 Property taxes on factory building... $ 400.00 23 Raw Materials used in production.... $ 60,000.00 24 Rent on production equipment..... 25 Research & Development....... 26 Sales commissions (10% of sales)... $ 32,000.00 27 Utility costs - factory........... ............$900 $ 900.00 28 Wages - Factory direct labor. .................. $87,500 $ 87,500.00 29 Work in process, January 1... 30 Work in process, January 31.......................$0 31 Raw materials inventory, January 1............... 32 Raw materials inventory, January 31..............$12,000 $ 12,000.00 33 Raw materials purchases............ 34 Finished goods inventory, January 1.............$0 A A A 36 Production and Sales Data 37 Number of helmets produced 38 Expected sales in units for January 39 Expected sales in units for February o Decirani andinn inventar Concrete HelmetCase Instructions 10,000 8,000 $40 Unit sell price 10,000 2007 nov month'e calce part 1 - 5pt part 2 - 5pt part 3 - 6pt parts 4-6 -6pt parts 7-9 - 10pt part 10 (a-d) - 6pt part 10 (e) - 3pt part 10 (-9) - 9pt + Ready 6 - - - + 100% AutoSave OFF svo Concrete Helmet Case Workbook for students QuSearch Sheet Home Insert Draw Page Layout Formulas Data Review View Comments Share [ 12 = = = DO Wrap Text EAY-O A A A Arial B I U General $ % 3 Insert 2X Delete E P Conditional Format Formatting as Table Paste 3 Merge & Center v .29 Cell Styles Sort & Filter Ideas Format Find & Select Sensitivity X | F20 x fox C D Cost of Goods Manufactured Schedule E F G H I J K L M N O P Q R S T U Work in process inventory, Direct materials: OPENING STOCK ADD PURCHASES Total Cost of Materials Available for Use LESS CLOSING STOCK OF MATERIALS Direct Materials Used $72,000 $72,000 ($12,000) $60,000 + Direct labor: $87,500 + Manufacturing overhead: DEPRECIATION ON FACTORY BUILDING INSURANCE OF FACTORY BUILDING MISC EXPENSES - FACTORY PROPERTY TAXES ON FACTORY BUILDING RENT ON PRODUCTION EQUIPMENT UTILITY COST - 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 Concrete Helmet Case Instructions part 1 - 5pt part 2 - 5pt part 3 - 6pt parts 4-6 -6pt parts 7-9 - 10pt part 10 (a-d) - 6pt part 10 (e) - 3pt + part 10 (f-g) - 9pt $ 0 Ready - - - + 100% AutoSave OFF A svo Concrete Helmet Case Workbook for students QuSearch Sheet Home Insert Draw Page Layout Formulas Data Review View Comments Share [ = = DO Wrap Text P = E EAY-O General $ % E Conditional Format Formatting as Table 3 Insert 2X Delete Paste 3 Merge & Center od -20 Cell Styles Sort & Filter Ideas Format Find & Select Sensitivity X Arial 12 A A BIU A | 417 x fx AB D 1 Part 7 - Compute the unit variable cost for a helmet. E F G H I J K L M N O P Q R S T U V W Part 8 - Compute the unit contribution margin AND the contribution margin ratio. Part 9 - Calculate the break-even point in sales dollars AND the break-even point in units Concrete HelmetCase Instructions part 1 - 5pt part 2 - 5pt part 3 - 6pt parts 4-6 -6pt parts 7-9 - 10pt part 10 (a-d) - 6pt part 10 (e) - 3pt + part 10 (-9) - 9pt $ 0 Ready - - - + 100% AutoSave OFF A svo Concrete Helmet Case Workbook for students QuSearch Sheet Home Insert Draw Page Layout Formulas Data Review View Comments Share 5 = = = Wrap Text E Az O DO SE Insert 2X Delete Arial 12 A A BI U DA fox General $ % PZD Conditional Format Cell Formatting as Table Styles Paste 3 Merge & Center od -20 Ideas Format Sort & Filter Sensitivity X Find & Select V | 119 x G H I J K L M N O P Q R S T U 1 Part 10 (e) (e) Selling & Administrative Budget Variable Expenses: Fixed Expenses: Total Fixed Expenses: Total Selling & Administrative Expenses: Concrete HelmetCase Instructions part 1 - 5pt part 2 - 5pt part 3 - 6pt parts 4-6 -6pt parts 7-9 - 10pt part 10 (a-d) - 6pt part 10 (e) - 3pt + part 10 (f-9) - 9pt 6 ] Ready - - + 100% AutoSave OFF A svo Concrete Helmet Case Workbook for students QuSearch Sheet Home Insert Draw Page Layout Formulas Data Review View Comments Share 5 Arial 12 = = = Wrap Text E A7 O AA A DO E General $ % , P Conditional Format Formatting as Table 2 insert 2X Delete Format Paste B I U E 3 Merge & Center .29 Cell Styles Sort & Filter Find & Select Ideas X Sensitivity A1 x fx Part 10 (f-g) L M N O P Q R 1 Part 10 (- 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 Concrete HelmetCase Instructions part 1 - 5pt part 2 - 5pt part 3 - 6pt parts 4-6 -6pt parts 7-9 - 10pt part 10 (a-d) - 6pt part 10 (e) - 3pt part 10 (-9) - 9pt + BO J - - Ready - + 100%