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

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.

In this activity, you created a dashboard that can help you share your findings. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:How did you arrange the sheets onto the dashboard to effectively present the data? What are some other ways in which you might use dashboards?Is there a dashboard that you would like to create? If so, what kinds of data might it feature?

Which business document summarizes a company’s financial performance over a specific period?Group of answer choicesBusiness PlanMeeting MinutesBalance SheetFinancial Statement

Examine your completed data visualization. In the space provided below, write 2-3 sentences (40-60 words) in response to each of the following questions:How does the line chart help you visualize the sales data? Based on your analysis, when will your company need to increase staff and inventory?

You should try and add as much information and as many visualizations as possible into your dashboard so that it conveys the most amount of information possible. 1 pointTrueFalse