SCEX5ConsolidateExpenses

.xlsx
School
Nova Scotia Community College **We aren't endorsed by this school
Course
BUSI 500
Subject
Business
Date
Oct 22, 2023
Pages
6
Uploaded by ConstableRiverGoat28 on coursehero.com
Shelly Cashman Expense Worksheet 10/22/2023 Consolidated Page 1 M&S Provisions 2020 Expenses 22-Oct-2023 Expense Category 2020 2021 2022 Payroll $147,919.26 2.50% $151,617.24 2.50% $155,407.67 2.50% Benefits 32324.46 2.00 96,973.38 3.00% 99,882.58 101.50% Fuel 38500 2.00 115,500.00 3.00% 118,965.00 101.50% Storage 26928 1.00 53,856.00 1.00% 54,394.56 50.50% Event Fees 11200 1.00 22,400.00 1.00% 22,624.00 50.50% Maintenance 9105.82 1.00 18,211.64 2.00% 18,575.87 51.00% Advertising 7631.24 (1.00) - (1.00%) - (50.50%) Administrative 5000 (2.00) (5,000.00) (2.25%) (4,887.50) (101.13%) $278,608.78 $453,558.26 $464,962.18 2021Projected % Change 2022 Projected % Change Average % Changed Payroll; 53.1% Benefits; 11.6% Fuel; 13.8% Storage; 9.7% Event Fees; 4.0% Maintenance; 3.3% Advertising; 2.7% Administrative; 1.8% 2020 Consolidated Expenses
Shelly Cashman Expense Worksheet 10/22/2023 Consolidated Page 2 Payroll Benefits Fuel Storage
Shelly Cashman Expense Worksheet 10/22/2023 Sharon Shrimp Page 3 M&S Provisions Sharon Shrimp Expenses 22-Oct-2023 Expense Category 2020 2021 2022 Payroll $68,712.06 2.50% $70,429.86 2.50% $72,190.61 2.50% Benefits 17077.07 2.00 51,231.21 3.00% 52,768.15 101.50% Fuel 18500.00 2.00 55,500.00 3.00% 57,165.00 101.50% Storage 12528.00 1.00 25,056.00 1.00% 25,306.56 50.50% Event Fees 5000.00 1.00 10,000.00 1.00% 10,100.00 50.50% Maintenance 4810.62 1.00 9,621.24 2.00% 9,813.66 51.00% Advertising 4031.60 (1.00) - (1.00%) - (50.50%) Administrative 2500.00 (2.00) (2,500.00) (2.25%) (2,443.75) (101.13%) $133,159.35 $219,338.31 $224,900.23 2021Proj ected % Change 2022 Projected % Change Average % Changed
Page1of 6
Uploaded by ConstableRiverGoat28 on coursehero.com