Last year, the retailer's weekly variance of demand was 100 units. The variance of orders was 250, 300, 400, and 600 units for the retailer, wholesalers, distributing and manufacturer. respectively (note that the variance of orders equals the variance of demand for that firm's supplier) 

A. calculate the bullwhip measures for the retailer, wholesales, distributor and manufacturer?

B. what is the bullwhip effect for the entire supply chain?

C. provide actionable guidelines (with anticipated bullwhip measures of each point on how to reduce bullwhip measures to 2 in the supply chain?

All your calculations has to be done on paper and has to be done on excel sheets. Each question you must show the formula used to calculate the answer in excel sheet in order to use excel in exam.