Please help completing this excel assignment. For Q9, 10 I need to write recommendations.... not sure about the ratios I put so any changes are appreciated!
Tasks The CCC Locations Data Excel Spreadsheet 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 questions below, and then upload and submit a single Excel Workbook. Instructions 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: Total revenue Average quarterly revenue Q1-2018 Q2-2018 Q3-2018 81788 Q4-2018 80750 Dry Cleaning Services 90000 94325 $ 346,863.00 $ 86.715.75 6200 Expenses: Electricity Water Gas Cable Insurance Wages Cleaning Supplies Maintenance Mortgage Total expense 7077 2200 1500 200 1585 45000 2280 300 3500 63642 6000 1800 1460 200 1585 45000 2200 1943 1475 200 1585 48768 2280 450 3500 66401 7300 26577 2492 8435 1530 5965 200 800 1585 6340 42101 180869 2280 9040 750 3500 Total expense 60988 $ 252,776.00 3500 61745 Average quarterly expense $ 63,194.00 Clean Clothes Company - 2018 Location: Total revenue Average quarterly revenue Q1-2018 Q2-2018 50108 Q3-2018 42000 Q4-2018 45000 Dry Cleaning Services 55090 $ 192,198.00 $ 48,049.50 Expenses: Electricity Water Gas Cable Insurance Wages Cleaning Supplies Maintenance Mortgage Total expense 5000 2000 1275 200 1200 33750 2000 4500 1750 1180 200 1200 33750 2000 1575 2500 48655 4805 1500 1077 200 1200 33750 2000 1020 2500 48052 5400 19705 2180 7430 1310 4842 200 800 1200 4800 40950 142200 2100 8100 500 3095 2500 Total expense Average quarterly expense 56340 $ 200,972.00 $ 50.243.00 2500 47925 Total Revenue Location 1 Location 2 $ $ 346,863 192,198 Net Profit margin Location 1 Location 2 27% -5% Total Revenue for both location $ 539,061 Expense Ratio Location 1 Location 2 73% 105% Total Expense Location 1 Location 2 $ $ 252,776 200,972 Total Expense for both location $ 453,748 Total Income Location 1 Location 2 $ $ 94,087 (8,774) Total Income for both location $ 85,313 Greatest Expense Location 1 Location 2 $ $ 180,869 142,200 Q9, write a note to the owners explainning your recommendations for inreasing revenue Note: 010, write a note to the owners explaining your recommendations for reducing costs
