1) Use the data given below to answer the following question. Following is the order database of XYZ restaurant in Sydney between April and June 2020. You can download the order Database from Week 2 page on Canvas. Item Region Supplier Unit Cost Units Steel Fork North Peter 5.44 98 Ceramic Plate South Kane 23.44 53 Steel Fork South Jones 8.44 39 Silver Spoon South Gerry 23.44 30 Steel Fork West Sarah 6.44 59 Ceramic Plate North Peter 8.44 63 Steel Fork South Audrey 5.44 78 Steel Fork South Jones 8.44 93 Steel Fork West Thomas 5.44 35 Ceramic Plate North Peter 12.44 63 Steel Fork South Mary 8.44 93 Ceramic Plate North Henry 5.44 32 Ceramic Plate North Philip 23.44 84 Steel Fork North Peter 8.44 38 Glass Bottle South Simson 128.45 5 Ceramic Bowl North Peter 19.44 19 Ceramic Plate South Mary 12.44 31 Silver Spoon North Peter 12.44 67 Silver Spoon North Philip 23.44 18 Ceramic Bowl South Kane 8.44 99 Steel Fork South Simson 4.74 70 Ceramic Bowl North Philip 19.44 77 Ceramic Plate South Gerry 12.44 49 Ceramic Plate South Simson 18.45 90 Ceramic Plate North Peter 8.44 7 Ceramic Plate West Sarah 23.44 10 Ceramic Bowl South Jones 8.44 53 Steel Fork South Audrey 5.44 69 Silver Spoon North Henry 8.44 99 Steel Fork South Gerry 4.74 56 Ceramic Plate South Gerry 12.44 83 Glass Bottle South Kane 128.45 8 Ceramic Bowl North Peter 8.44 65 Ceramic Bowl South Mary 15.94 58 Ceramic Bowl South Kane 27.4 45 Glass Bottle West Sarah 278.45 6 Steel Fork South Gerry 4.74 10 Silver Spoon West Sarah 5.44 79 Ceramic Plate West Thomas 23.44 60 Steel Fork South Audrey 4.74 17 Ceramic Plate South Jones 8.44 14 Ceramic Plate South Jones 23.44 97 Ceramic Plate South Audrey 8.44 31

a- Using MS Excel calculate inventory value and then sort the data by inventory value.

b- Using MS Excel calculate percentage and the cumulative percentage of total inventory value to help the restaurateur conduct a Pareto analysis.