Documentation
Shelly Cashman Excel 2016 | Module 1: SAM Project 1a
Blooming Everywhere Delivery
CREATING A WORKSHEET AND A CHART
Author: Hamad Alrasheed
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
Company Analysis
Area FY 2018 FY 2019 FY 2020 FY 2021
North Miami $ 2,000.00 $ 2,850.00 $ 3,140.00
South Miami $ 3,500.00 $ 4,200.00 $ 4,500.00
East Miami $ 2,400.00 $ 2,650.00 $ 3,500.00
West Miami Total Revenue
Total $ 7,900.00 $ 7,900.00
Expenses
Area FY 2018 FY 2019 FY 2020
North Miami 250 280 310
South Miami 375 420 470
East Miami 300 340 400
West Miami 320 350 635 Total Expenses
Total 1245 1390 1815
Profit
Year FY 2018 FY 2019 FY 2020 Total Profit
Net Profit $ - 0
Blooming Everywhere Delivery
2018 – 2020 Revenue
FY 2018 North Miami South Miami East Miami West Miami 2000 3500 2400 FY 2019 North Miami South Miami East Miami West Miami 2850 4200 2650 FY 2020 North Miami South Miami East Miami West Miami 3140 4500 3500