Read the Clean Clothes Company's Background Story, found in the Course Syllabus. The Clean Clothes Company currently has two different locations. Mr. Pantin began with Location 1, which he purchased from his aunt and uncle, and he opened Location 2 in 2013. The company generates revenue from dry-cleaning services and has several expenses.

The CCC Locations Data Excel Spreadsheet (below are images) contains data about the revenue and expenses for each location for the year 2018.

Create a third sheet within the CCC Locations Data Excel Spreadsheet called Summary. The purpose of the summary worksheet is to consolidate and summarize the data from the services provided during the 2018 year.

In order to enhance the workbook's appearance, include appropriate headers and format the worksheet, column, and row headers as needed.

Answer the following questions:

1. For each location calculate the totals and averages for revenue (Hint: Revenue is derived from "Dry Cleaning Services") and each expense.
2. On the summary sheet calculate the total revenue for each location.
3. On the summary sheet calculate the total revenue for both locations.
4. On the summary sheet calculate the total expenses for each location.
5. On the summary sheet calculate the total expenses for both locations.
6. On the summary sheet calculate the total income for each location. (Note: Income=Revenue-Expenses).
7. On the summary sheet calculate the total income for both locations.
8. On the summary calculate the greatest expense for each location. (Note: Use the maximum function for this task).
9. Write a note to the owners explaining your recommendations for increasing revenue.
10. Write a note to the owners explaining your recommendations for reducing costs.

Clean Clothes Company - 2018 Location: Dry Cleaning Services Expenses: Electricity Water Gas Cable Insurance Wages Cleaning Supplies Maintenance Mortgage 2 Q1-2018 Q2-2018 50108 5000 2000 1275 200 1200 33750 2000 0 2500 Q3-2018 42000 4500 1750 1180 200 1200 33750 2000 1575 2500 Q4-2018 45000 55090 4805 1500 1077 200 1200 33750 2000 1020 2500 Clean Clothes Company - 2018 Location: Dry Cleaning Services Expenses: Electricity Water Gas Cable Insurance Wages Cleaning Supplies Maintenance Mortgage 2 Q1-2018 Q2-2018 50108 5000 2000 1275 200 1200 33750 2000 0 2500 Q3-2018 42000 4500 1750 1180 200 1200 33750 2000 1575 2500 Q4-2018 45000 55090 4805 1500 1077 200 1200 33750 2000 1020 2500