1) In terms of the first group (Instructions),there must be only one (1)worksheet. Your 'internal memorandum' must be copied and pasted into the 'Instructions' worksheet. In the 'Instructions' worksheet, you must include the following information:
? Your name and the name of the company.
? Explain the purpose of the dashboard that you created and why you chose those 4 panels that you included in your dashboard.
? Indicate the location (cells and worksheet) of: a) the Sales Growth (quantity) ratio (obtained using calculated fields - see below) (for example, worksheet YYY, cells ZZZ), b) your second ratio (you must include the ratio formula and also explain why you chose that ratio), c) the budget sales revenue variance (see part 4 below), d) at least two (2) Pivot Tables used (see part 4 below).
? Internal Memorandum - You MUST include an internal memorandum that will be sent to the CEO Ana Pizarro :
? In your internal memo, you MUST include two (2) interesting findings that you discovered when analysing the data
? Additionally, you MUST include two (2) recommendations to Management based on your analysis of the data. As suggested above, you could prepare the internal memorandum using Word and then copy and paste the image into Excel. ? Finally, you MUST include one (1) recommendation to Management in relation to the way the data was organised and stored.
Staff ID Name Employment Type Monthly Sales Target Monthly Hours Shop 078 Yilun Zhong Part Time $70,000 76 Melbourne CBD 051 Maria Perez Full Time $150,000 152 Melbourne CBD 045 Indah Vasistha Full Time $150,000 152 Melbourne CBD 079 Joshua Taylor Full Time $150,000 152 Frankston 036 Kevin Sugianto Full Time $150,000 152 Frankston 068 Luis Gomez Part Time $70,000 76 FrankstonProduct ID Product Name Product Type Unit cost Sales Price 12567 Iphone 12 256 GB iphone $927 $1,426 12798 Iphone 12 128 GB iphone $748 $1,151 12421 Iphone 12 Pro 128 GB iphone $1,034 $1,591 12579 Iphone 11 64 GB iphone $605 $931 11378 Apple MacBook Pro 16-inch 512 GB Macbook $2,693 $3,848 11256 Apple MacBook 13-inch 512 GB Macbook $1,692 $2,418 11651 Apple MacBook Air 13-inch 256 GB Macbook $1,463 $2,088 14297 Apple iMac 21.5-inch 2.3 GHz 256 GB desktop $1,406 $1,758 14672 Apple iMac with retina 5K display 27-inch desktop $2,638 $3,298 13656 Apple ipad 32 GB ipad $381 $635 13682 Apple ipad Air 256 GB ipad $744 $1,241 13695 Apple ipad Pro 12.9-inch 128 GB ipad $889 $1,483 15728 Watch SE 40mm watch $253 $504 15456 Watch Series 6 44mm watch $273 $548Category Shop Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Budgeted Sales Revenue Melbourne CBD $350,000 $350,000 $400,000 $400,000 $400,000 $450,000 Budgeted Sales Revenue Frankston $500,000 $500,000 $430,000 $430,000 $450,000 $450,000\fApple MacBook Air 13-inch 256 GB Yilun Zhong 9 10 Apple MacBook Air 13-inch 256 GB Luis Gomez 4 Apple iMac 21.5-inch 2.3 GHz 256 GB Maria Perez 12 Apple iMac 21.5-inch 2.3 GHz 256 GB Kevin Sugianto 13 Apple iMac 21.5-inch 2.3 GHz 256 GB Joshua Taylor 15 Apple iMac 21.5-inch 2.3 GHz 256 GB Indah Vasistha 4 Apple iMac 21.5-inch 2.3 GHz 256 GB Yilun Zhong Apple iMac 21.5-inch 2.3 GHz 256 GB Luis Gomez F U ON A O UI N O O H D UT O V U V Apple iMac with retina 5K display 27-inch Joshua Taylor 10 6 6 V W W N UT DO O A DO O O UI N Apple iMac with retina 5K display 27-inch Kevin Sugianto 3 Apple iMac with retina 5K display 27-inch Indah Vasistha 6 Apple iMac with retina 5K display 27-inch Luis Gomez 1 Apple iPad 32 GB Maria Perez 17 n U N A UI N H UI DO A W O O O N DO D O W UT H O O UT H OO Apple iPad 32 GB Joshua Taylor 18 Apple iPad 32 GB Kevin Sugianto 15 Apple ipad 32 GB Luis Gomez 12 Apple ipad 32 GB Indah Vasistha 13 5 6 6 1 00 1 W H OO OO UT O A OO N O O O ON OO D H N A A OO N W G N UT H N F Apple iPad 32 GB Yilun Zhong 7 Apple iPad Air 256 GB Kevin Sugianto 8 J W N W O N D UT O W N A V A W O V D UI A O V OO 00 00 UT H O OO N N A U H G O ON A Apple ipad Air 256 GB Maria Perez Apple ipad Air 256 GB Joshua Taylor 10 Apple iPad Air 256 GB Indah Vasistha Apple ipad Air 256 GB Yilun Zhong Apple ipad Air 256 GB Luis Gomez Apple ipad Pro 12.9-inch 128 GB Luis Gomez Apple ipad Pro 12.9-inch 128 GB Joshua Taylor 16 O O N O U U A V N A O D DO W N UT O OO V O AO Apple ipad Pro 12.9-inch 128 GB Kevin Sugianto Apple ipad Pro 12.9-inch 128 GB Maria Perez 9 Apple ipad Pro 12.9-inch 128 GB Indah Vasistha 13 Apple ipad Pro 12.9-inch 128 GB Yilun Zhong 5 Watch SE 40mm Joshua Taylor 5 Watch SE 40mm Maria Perez Watch SE 40mm Kevin Sugianto 11 Watch SE 40mm Indah Vasistha 19 Watch SE 40mm Yilun Zhong 4 Watch SE 40mm Luis Gomez 6 W D UI P Watch Series 6 44mm Luis Gomez 13 Watch Series 6 44mm Maria Perez 13 10 24
