Fill in all blanks on excel sheet using the information given above.

**please show all work and all equations used**

1st and 3rd 4th sth 6th 7th Month Month Month Month Month Month Month Gross Sales or Receipts Less: Cost of Goods Sold - Labor Less: Cost of Goods Sold - Materials Gross Profit Less Expenses Accounting & Legal Advertising Bad Debts Insurance Rent Repairs & Maintenance Salaries & Wages to others) Royalties Supplies Taxes & Licenses Other Expenses Total Expenses Net Profit | 9th 10th 1 11th 12th Total % of % of Total Year 1 Revenue Month Month Month Month Month Year 2 Revenue Please note, while these numbers and factors are based on an actual business, the data has been changed. The information is to be used for ACC202 exercise purposes only. Important Variables to consider: * 2019 Water jobs included a hurricane flooding * 2020 values include the impact driven by COVID shutdown * Contractually, Royalties should be 10% of Revenues * The franchise recomends that marketing spend be no less than ~3% of sales Average Sales for a multi-territory franchise are $600k, median sales $550k. -Top territory was $10M+ * A single terriotry is ~50,000 households. * Gross Margins for the industry are 65-70%, technicians perfoming the work are counted in the COGS #. Amazing Restoration Company 2019 Full year 2020 YTD (8 months) Income Duct Work $ 150,000 $ 78,000 Mold Work $ 387,000 $ 201,240 Water Jobs $ 75,000 $ 39,000 Total Income $ 612,000 $ 318,240 Cost of Goods Sold Direct Cost - Labor $ 2,558 $ 55,592 Direct Cost - Subcontractors $ 394,243 $ 37,547 $ 29,476 $ 19,379 Direct Cost - Supplies & Materials Total Cost of Goods Sold $ 426,277 $ 112,517 Gross Profit $ 185,723 $ 205,723 $ 5,889 7,199 $ $ $ 1,100 Expenses Advertising & Promotional Amortization Auto & truck expenses Fuel Repair & Maintenance $ 680 $ $ 9,078 $ $ $ 4,155 6,018 5,119 11,136 Total Auto & truck expenses $ 13,913 $ Bank Charges $ 241 $ 1,145 Repair & Maintenance $ 4,155 $ $ 5,119 11,136 $ 13,913 Total Auto & truck expenses Bank Charges $ 241 $ 1,145 $ 1,801 1,730 303 $ 581 $ $ $ $ $ 32 200 $ 17 $ 6,381 $ $ 2,853 $ $ 1,628 $ 262 4,309 3,810 1,628 7,915 3,490 5,152 1,128 4,079 $ $ $ $ Computer Software Continuing Education Disposal Fees Dues & Subscriptions Insurance Insurance - Liability Insurance-Auto & WIC Interest Expense Lab Fees Legal & Professional Fees Meals Merchant Account Fees QuickBooks Payments Fees Total Merchant Account Fees Miscellaneous Office Supplies Payroll Expenses Office Taxes $ 4,224 $ 8,191 $ 298 $ $ $ $ 4,472 3,192 3,784 $ 4,472 $ $ 326 $ 1,605 1,381 $ $ $ $ $ 6,375 3,953 $ $ $ $ 6,375 85,000 91,375 522 3,953 52,700 56,653 $ $ $ 9 $ 1,204 $ 745 2,871 29,278 $ 3,094 Office Taxes Offiice Payroll Total Payroll Expenses Payroll Processing Fee Purchases Rent Expense Royalty Payment Small Equipment Purchase Taxes & Licenses Technology Fee Telephone Travel Uncategorized Expense Total Expenses Net Operating Income $ 974 $ $ $ $ $ $ $ $ $ $ $ 635 $ 609 1,110 1,638 2,021 $ 1,967 $ 4,829 $ $ $ 163,584 $ 147,560 $ $ $ 22,139 58,162 1st and 3rd 4th sth 6th 7th Month Month Month Month Month Month Month Gross Sales or Receipts Less: Cost of Goods Sold - Labor Less: Cost of Goods Sold - Materials Gross Profit Less Expenses Accounting & Legal Advertising Bad Debts Insurance Rent Repairs & Maintenance Salaries & Wages to others) Royalties Supplies Taxes & Licenses Other Expenses Total Expenses Net Profit | 9th 10th 1 11th 12th Total % of % of Total Year 1 Revenue Month Month Month Month Month Year 2 Revenue Please note, while these numbers and factors are based on an actual business, the data has been changed. The information is to be used for ACC202 exercise purposes only. Important Variables to consider: * 2019 Water jobs included a hurricane flooding * 2020 values include the impact driven by COVID shutdown * Contractually, Royalties should be 10% of Revenues * The franchise recomends that marketing spend be no less than ~3% of sales Average Sales for a multi-territory franchise are $600k, median sales $550k. -Top territory was $10M+ * A single terriotry is ~50,000 households. * Gross Margins for the industry are 65-70%, technicians perfoming the work are counted in the COGS #. Amazing Restoration Company 2019 Full year 2020 YTD (8 months) Income Duct Work $ 150,000 $ 78,000 Mold Work $ 387,000 $ 201,240 Water Jobs $ 75,000 $ 39,000 Total Income $ 612,000 $ 318,240 Cost of Goods Sold Direct Cost - Labor $ 2,558 $ 55,592 Direct Cost - Subcontractors $ 394,243 $ 37,547 $ 29,476 $ 19,379 Direct Cost - Supplies & Materials Total Cost of Goods Sold $ 426,277 $ 112,517 Gross Profit $ 185,723 $ 205,723 $ 5,889 7,199 $ $ $ 1,100 Expenses Advertising & Promotional Amortization Auto & truck expenses Fuel Repair & Maintenance $ 680 $ $ 9,078 $ $ $ 4,155 6,018 5,119 11,136 Total Auto & truck expenses $ 13,913 $ Bank Charges $ 241 $ 1,145 Repair & Maintenance $ 4,155 $ $ 5,119 11,136 $ 13,913 Total Auto & truck expenses Bank Charges $ 241 $ 1,145 $ 1,801 1,730 303 $ 581 $ $ $ $ $ 32 200 $ 17 $ 6,381 $ $ 2,853 $ $ 1,628 $ 262 4,309 3,810 1,628 7,915 3,490 5,152 1,128 4,079 $ $ $ $ Computer Software Continuing Education Disposal Fees Dues & Subscriptions Insurance Insurance - Liability Insurance-Auto & WIC Interest Expense Lab Fees Legal & Professional Fees Meals Merchant Account Fees QuickBooks Payments Fees Total Merchant Account Fees Miscellaneous Office Supplies Payroll Expenses Office Taxes $ 4,224 $ 8,191 $ 298 $ $ $ $ 4,472 3,192 3,784 $ 4,472 $ $ 326 $ 1,605 1,381 $ $ $ $ $ 6,375 3,953 $ $ $ $ 6,375 85,000 91,375 522 3,953 52,700 56,653 $ $ $ 9 $ 1,204 $ 745 2,871 29,278 $ 3,094 Office Taxes Offiice Payroll Total Payroll Expenses Payroll Processing Fee Purchases Rent Expense Royalty Payment Small Equipment Purchase Taxes & Licenses Technology Fee Telephone Travel Uncategorized Expense Total Expenses Net Operating Income $ 974 $ $ $ $ $ $ $ $ $ $ $ 635 $ 609 1,110 1,638 2,021 $ 1,967 $ 4,829 $ $ $ 163,584 $ 147,560 $ $ $ 22,139 58,162