Question: help pleade no excel i want to learn 3. A cooking oil distributor distributes oil to major supermarkets in the region. Though a person's daily

help pleade
no excel
i want to learn
help pleade no excel i want to learn 3. A cooking
help pleade no excel i want to learn 3. A cooking
3. A cooking oil distributor distributes oil to major supermarkets in the region. Though a person's daily consumption of oil seems to be almost the same, the distributor's demand for oil fluctuates every month. The distributor consolidates the order from all supermarkets and initiates his ordering and delivery processes. An accurate forecast is essential to reduce the variability of demand and supply of oil supply chain. The following table provides the distributor's overall sales made during the last 10 months (sales in gallons of oil). Month Sales 12,137 14,729 15,146 16,559 18,992 21,192 24,560 26,883 28,926 32,592 10 a. Compute an exponentially smoothed forecast, using an a value of 0.35. b. Compute an adjusted exponentially smoothed forecast (with a -0.35 and 3-0.40). c. Compare the two forecasts using MAD and indicate which seems to be more accurate. Based on the accurate method, what is the forecast for the 11th month? 1234567899 3. A cooking oil distributor distributes oil to major supermarkets in the region. Though a person's daily consumption of oil seems to be almost the same, the distributor's demand for oil fluctuates every month. The distributor consolidates the order from all supermarkets and initiates his ordering and delivery processes. An accurate forecast is essential to reduce the variability of demand and supply of oil supply chain. The following table provides the distributor's overall sales made during the last 10 months (sales in gallons of oil). Month Sales 1 12,137 14,729 15,146 16,559 18,992 21,192 24,560 26,883 9 28,926 32,592 10 a. Compute an exponentially smoothed forecast, using an a value of 0.35. b. Compute an adjusted exponentially smoothed forecast (with a=0.35 and 3-0.40). c. Compare the two forecasts using MAD and indicate which seems to be more accurate. Based on the accurate method, what is the forecast for the 11th month? .3 4 5 6 7 8

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!