How do I start by setting this up?

Excel File Edit View Insert Format Tools AutoSave Data Window Help 0 323 Fri 11:50 AM GR Book 1 Home Insert Draw Page Layout Q Formulas Data Review View Tell me X Share Comments 12 - A A Calibr (Body BIU 23 General w Paste Av S Delete 2 O $% Conditional Format Cal Formatting as Table Styles Format Sort Fier Find & Ideas Al Xfx G H 1 1 L M 0 5 2 7 8 9 10 11 12 1 14 15 16 17 18 19 20 22 24 23 26 27 24 Colugbus Lancaster Cincinnati Dayton + Rech HINT BEFORE BEGINNING: FOR THIS ASSIGNMENT, IT IS IMPERATIVE THAT EACH SALE/EXPENSE/CAPTION APPEAR IN THE SAME ROW/CELL ON EACH WORKSHEET. IT IS THE ONLY WAY THIS WILL WORK 1. Set up a different sheet within the same workbook for each location. Use grouping to set up identical formats for each location. Rename each sheet (Columbus, Lancaster, Dayton, and Cincinnati). Use the following format: Heading Quarter 2 Quarter 1 Quarter 3 Quarter Total 4 Sales Variable Expenses List each variable expense Total Variable Expenses Contribution Margin Fixed Expenses List each fixed expense Total Fixed Expenses Projected Income *Use single and double underlines where applicable. The first and last row of numbers should be formatted for currency, no decimals and the remainder with a comma and no decimals. *Center the heading over the worksheet (center across selection). Use a bolder, larger font for the heading *Use formulas where applicable. *Make the following assumptions: Columbus: Sales $55,000 per month (sales for all locations increase 10% per quarter) Food 25% of sales - variable Paper 10% of sales - variable Condiments 5% of sales - variable Rent $2,000 per month plus 5% of sales - Variable and fixed portions Advertising $2,000 per month - fixed Utilities $2,500 per month - fixed Depreciation $4,000 per month - fixed Payroll 15% of sales - variable Variable Expenses List each variable expense Total Variable Expenses Contribution Margin Fixed Expenses List each fixed expense Total Fixed Expenses Projected Income *Use single and double underlines where applicable. The first and last row of numbers should be formatted for currency, no decimals and the remainder with a comma and no decimals "Center the heading over the worksheet (center across selection). Use a bolder, larger font for the heading. *Use formulas where applicable. *Make the following assumptions: Columbus: Sales $55,000 per month (sales for all locations increase 10% per quarter) Food 25% of sales - variable Paper 10% of sales - Variable Condiments 5% of sales - variable Rent $2,000 per month plus 5% of sales - Variable and fixed portions Advertising $2,000 per month - fixed Utilities $2,500 per month fixed Depreciation $4,000 per month - fixed Payroll 15% of sales - variable Lancaster sales are 15% lower than Columbus sales. Use a formula to set up Lancaster sales (cell reference Columbus sales in the formula - same applies to remaining locations) Expense assumptions are the same except rent which is $1,500 per month plus 5% of sales Dayton sales are 10% lower than Columbus sales. Expense assumptions are the same except rent that is $3,000 per month Cincinnati sales are 5% higher than Columbus sales Additionally, Cincinnati must pay an additional advertising fee that is 8% of sales. Insert a new row for this and call it Nat'l advertising