CA Caf Scenario Update: Email #3 You have received the following email from your Manager Send From: Manager CA Caf Sales Data - Essendon CA Caf Style Guide (Style Guide for External Documents) Video message from Manager Subject: Request for spreadsheet with charts I need the attached sales data set up in a spreadsheet with charts for an upcoming meeting we have with the bank to get a new loan. Can you please develop the spreadsheet with charts and call it 'Bank Loan Data'? It needs to meet the following requirements: Include monthly figures for each of the following: o Food expenses o Beverage expenses o Caf total revenue o Caf total expenses Include the total year figures for each of the following: o Food sales o Beverage sales o Food expenses o Beverage expenses o Caf total revenue o Caf total expenses Include a cell/formula that checks that you have included 12 months of revenue Include a cell/formula that checks that you have included 12 months of expenses Calculate the average revenue per quarter Calculate the average expenses per quarter Calculate the Caf's yearly profit or loss Include