help me to solve part b

only if u know the right answer

thanks

Consider a three-fimm supply chain consisting of a reale, manufacturer and supplier. The retailer's demand over an 8-week period was 90 units each of the first 2 weeks, 210 units each of the second 2 weeks. 200 units each of the third 2 weeks, and 400 units each of the fourth 2 weeks. The folowing table presents the orders placed by each firm in the supply chain Notice as is often the case in supply chains due to economies of scale, that total units are the same in each case, but firms further up the supply chain (away from the retain place to get less frequent, orders mick the icon to view the orders placed by each firm in the supply chain Click the icon to view the ways of calculating the variance a) What is the bullwhip measure for the retailer? The bulwhip measure for the retailer is 1. Enter your response rounded to two decimal places) b) What is the bullwhip measure for the manufacturer? More info The bulwhip measure for the manufacturer is Enter your response rounded to two decimal places) Recal that the sample variance of a dataset can be found by using the VARS function in Excel or by plugging each value of the data set into the formula More info - Variance in-1) where in the mean of the data setsed sie the number of values in the set Week Retailer Manufacturer Supplier 1 90 100 100 2 90 3 210 420 Print Done 4 210 5 290 580 1,360 200 7 400 300 400