For the Module 5 Project, you will create consolidated expenses for M&S Provisions. When you complete the assignment, you will submit the Module 5 Project workbooks. HINT: The finished Module 5 Project should include 5 workbooks (Consolidated Expenses, Harry Haddock Projected Expenses, Lady Lobster Projected Expenses, Sharon Shrimp Projected Expenses, and 2020 Projected Expenses).

How do I make the 2020 Projected Expenses in MS Excel?

I have been trying but I can't figure out how to do it.

2020 Consolidated Expenses \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4 & A & & B & C & D & E & F & G \\ \hline 1 & \multicolumn{8}{|c|}{ Mes Provisions } \\ \hline 2 & \multicolumn{8}{|c|}{ Consolidated Expenses Worksheet } \\ \hline 3 & & & & & & & & 26-Oct- 2023 \\ \hline 4 & Expense Category & & 2020 & \begin{tabular}{c} 2021 \\ Projected \\ % Change \end{tabular} & 2021 & \begin{tabular}{c} 2022 \\ Projected \\ % Change \end{tabular} & 2022 & \begin{tabular}{c} Average \\ % Changed \end{tabular} \\ \hline 5 & Payroll & $ & 220,789.88 & 3.00% & $227,413.58 & 4.00% & $236,510.12 & 3.50% \\ \hline 6 & Benefits & $ & 46,352.06 & 6.10% & 49,179.54 & 6.00% & 52,130.31 & 6.05% \\ \hline 7 & Fuel & $ & 57,500.00 & 9.20% & 62,790.00 & 8.00% & 67,813.20 & 8.60% \\ \hline 8 & Storage & $ & 40,176.00 & 12.30% & 45,117.65 & 10.00% & 49,629.42 & 11.15% \\ \hline 9 & Event Fees & $ & 18,700.00 & 15.40% & 21,579.80 & 12.00% & 24,169.38 & 13.70% \\ \hline 10 & Maintenance & $ & 13,057.40 & 18.50% & 15,473.02 & 14.00% & 17,639.24 & 16.25% \\ \hline 11 & Advertising & $ & 10,942.91 & 21.60% & 13,306.58 & 16.00% & 15,435.63 & 18.80% \\ \hline 12 & Administrative & $ & 7,500.00 & 24.70% & 9,352.50 & 18.00% & 11,035.95 & 21.35% \\ \hline 13 & & $ & 415,018.25 & & $444,212.67 & & $474,363.25 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 4 & A & B & C & D & E & F & G \\ \hline 1 & \multicolumn{7}{|c|}{ M\&S Provisions } \\ \hline 2 & \multicolumn{7}{|c|}{ Sharon Shrimp Expenses Worksheet } \\ \hline 3 & & & & & & & 26-Oct-2023 \\ \hline 4 & Expense Category & 2020 & \begin{tabular}{c} 2021 \\ Projected \\ % Change \end{tabular} & 2021 & \begin{tabular}{c} 2022 \\ Projected \\ % Change \end{tabular} & 2022 & \begin{tabular}{l} Average \\ % Changed \end{tabular} \\ \hline 5 & Payroll & 68,712.06 & 2.50% & $70,429.86 & 2.50% & $72,190.61 & 2.50% \\ \hline 6 & Benefits & 17,077.07 & 2.00% & 17,418.61 & 3.00% & 17,94 & 2.50% \\ \hline 7 & Fuel & 18,500.00 & 2.00% & 18,870.00 & 3.00% & 19,436.10 & 2.50% \\ \hline 8 & Storage & 12,528.00 & 1.00% & 12,653.28 & 1.00% & 12,779.81 & 1.00% \\ \hline 9 & Event Fees & 5,000.00 & 1.00% & 5,050.00 & 1.00% & 5,100.50 & 1.00% \\ \hline 10 & Maintenance & 4,810.62 & 1.00% & 4,858.73 & 2.00% & 4,955.90 & 1.50% \\ \hline 11 & Advertising & 4,031.60 & (1.00%) & 3,991.28 & (1.00%) & 3,951.37 & (1.00%) \\ \hline 12 & Administrative & 2,500.00 & (2.00%) & 2,450.00 & (2.25%) & 2,394.88 & (2.13%) \\ \hline 13 & & $133,159.35 & & 135721.8 & & 138750.34 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 4 & A & B & C & D & E & F & G \\ \hline 1 & \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{c} M\&S Provisions \\ Harry Haddock Expenses Worksheet \end{tabular}}} \\ \hline 2 & & & & & & & \\ \hline 3 & & & & & & & 26-Oct- 2023 \\ \hline 4 & Expense Category & 2020 & \begin{tabular}{c} 2021 \\ Projected \\ % Change \end{tabular} & 2021 & \begin{tabular}{c} 2022 \\ Projected \\ \% Change \end{tabular} & 2022 & \begin{tabular}{c} Average \\ % Changed \end{tabular} \\ \hline 5 & Payroll & $72,870.62 & 2.50% & $74,692.39 & 2.50% & $76,559.70 & 2.50% \\ \hline 6 & Benefits & 14,027.60 & 2.00% & 14,308.15 & 3.00% & 14,737.39 & 2.50% \\ \hline 7 & Fuel & 19,000.00 & 2.00% & 19,380.00 & 3.00% & 19,961.40 & 2.50% \\ \hline 8 & Storage & 13,248.00 & 1.00% & 13,380.48 & 1.00% & 13,514.28 & 1.00 \\ \hline 9 & Event Fees & 7,500.00 & 1.00% & 7,575.00 & 1.00% & 7,650.75 & 1.00 \\ \hline 10 & Maintenance & 3,951.58 & 1.00% & 3,991.10 & 2.00% & 4,070.92 & 1.50% \\ \hline 11 & Advertising & 3,311.67 & (1.00%) & 3,278.55 & (1.00%) & 3,245.76 & (1.00%) \\ \hline 12 & Administrative & 2,500.00 & (2.00%) & 2,450.00 & (2.25%) & 2,394.88 & (2.13%) \\ \hline 13 & & 136409.47 & & 139055.67 & & 142135.08 & \\ \hline \end{tabular}