The third group (Calculations) must include four (4) worksheets:• one (1) worksheet to calculate each ratio (2 ratios in total: Calculation 1 and Calculation 2);• one (1) worksheet to calculate revenue budget variance (labelled as ‘Calculation 3’); and• one (1) worksheet labelled ‘Additional Calculations’ in which you include any other calculations(e.g. calculations used in the 4th dashboard panel).Do not forget to appropriately use cell referencing in your calculations.One of the ratios should be ‘sales growth’ regarding quantity. You must obtain the sales growth ratiousing Pivot Tables and CALCULATED FIELDS. In terms of the second ratio, there is no prescription, soyou need to decide which ratio to use. However, you must use Excel formulas to calculate the value(s).In the ‘Calculation 3’ worksheet, you must calculate budget (sales revenue) variance for each shop.Information on budgeted sales revenues is provided in the ‘Actual & Budget’ worksheet. Additionally,you must include a chart and/or table about Actual and Budgeted data in the dashboard report. Becreative!You must use at least two (2) Pivot Tables in your calculations.

Prepare ONE (1) Instruction worksheet. Aim for approximately 900 words (+/- 10%) in total (includingInternal Memorandum). Your “Internal Memorandum” must be copied and pasted in the Instructionworksheet. Your Instruction worksheet must include the following information:● Your name and name of the company● Explain the purpose of the dashboard that you created and why you chose the 4 panels thatyou included in your dashboard report.● Indicate the location (cells and worksheet) of: a) the Sales Growth (quantity) ratio (obtainedusing calculated fields – see Calculations below) (for example, worksheet YYY, cells ZZZ), b)your second ratio (you must include the ratio formula and also explain why you chose thatratio), c) the budget sales revenue variance (see Calculations below), d) at least two (2) PivotTables that you used (see Calculations below).● You must include an internal memorandum that will be sent to Finance Manager, ClaudiaFlores (aim for approximately 600-700 words). As a suggestion, please prepare the internalmemorandum using Word and then copy and paste the image into Excel:o In your internal memo, you should include a general overview of your data analysis.o Additionally, you should include two (2) interesting findings discovered when analysingthe data [HINT: Please mention the specific location of your finding; for example, seePanel XX dashboard OR Cells XX:XX Worksheet ‘aaaa’, etc).o Finally, you should include two (2) recommendations to Management based on youranalysis of the data. Do not forget to justify your recommendations.ChatGPT

Open a workbook on Excel and Create the type of the spreadsheet save it as ‘2024 Budget Statistics.”Jan Feb March April May June July Aug Sep Oct Nov DecSales 20000Cost of salesGross IncomeProfit /LossExpenditureSalary 8000Rent 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500Water &ElectricityFibre InternetTotal Expenses3.1.1 Merge and center “Expenditure”Using formulas calculate the following.a. Sales increase monthly by 15%b. Cost of Sale is 5.5% of Sales.c. Calculate Gross income.d. Salary will increase on the 10th Month by 6%e. Water and Electricity 5% of the salary will decrease by 2.5% in June.f. Fiber Internet 5% of the salary will increase in July by 4% and will decrease by September by 2%.g. Calculate the Total Expensesh. Calculate the profit /the loss.

Using the financial statements below, calculate the current ratio for the current year. Please calculate to 2 decimal places.Profit and loss statement Current year Prior yearRevenue 14,800 18,500Less Cost of sales 6,000 7,500Gross profit 8,800 11,000Less expenses Wages Expense 5,500 6,500Interest Expense 2,200 2,000Depreciation Expense 1,000 1,200Advertising Expense 900 800Net profit (800) 500BALANCE SHEET Current year Prior yearCurrent assets Cash 14,250 16,700Accounts Receivable 14,000 3,500Inventory 6,000 2,500Prepaid Expenses 650 1,500Non-current assetsProperty Plant Equipment 192,500 193,500Land 210,000 210,000Total assets 437,400 427,700Current liabilitiesAccounts Payable 11,700 4,200Unearned Revenue 3,500 2,000Wages Payable 3,500 2,500Non-current liabilitiesBank Loan 118,000 122,500Total liabilities 136,700 131,200NET ASSETS 300,700 296,500Equity Share Capital 255,000 250,000Retained Earnings 45,700 46,500TOTAL EQUITY 300,700 296,500

You've been provided with the following information about a businessComplete a horizontal analysis for the "Revenue" account. Round the percentage change to one decimal place (1 mark).Note: Do not enter the "%" symbol when entering your answer. For example if your answer is "5.1%", only enter "5.1". Profit and loss statement Current year Prior yearRevenue 15000 10000Less Cost of sales 6500 3000Gross profit 8500 7000Less expenses Marketing Expense 2000 1800Rent Expense 1500 1500Wages Expense 800 1000Utilities Expense 1500 1500Net profit 2700 1200

Purchases Rs. 7,20,000; Office expenses Rs. 30,000; Selling expenses Rs. 90,000; Opening inventory Rs. 1,40,000; Closing inventory Rs. 80,000; Revenue from operations Rs. 12,00,000. Calculate Operating Ratio