Question: A . Demand Forecasting ( 3 - Month Moving Average ) : Using the 3 - month moving average method, forecast the demand for July.

A. Demand Forecasting (3-Month Moving Average):
Using the 3-month moving average method, forecast the demand for July. Use the following formula:
Forecast =(D_(t-1)+D_(t-2)+D_(t-3))/(3)
Use April, May, and June for the forecast. Round your final answer to the nearest whole number.
B. Safety Stock Calculation:
If the lead time is one month, compute the safety stock using:
Safety Stock =Z\times \sigma \times \sqrt(L)ead Time Fraction
Where Lead Time Fraction =1.0(one month). Round your final answer to the nearest whole number. A. Demand Forecasting (3-Month Moving Average):
Using the 3-month moving average method, forecast the demand for July. Use the following formula:
Forecast =(D_(t-1)+D_(t-2)+D_(t-3))/(3)
Use April, May, and June values. Round your final answer to the nearest whole number.
B. Safety Stock Calculation:
Assuming a lead time of one month, calculate the safety stock using:
Safety Stock =Z\times \sigma \times \sqrt(L)ead Time Fraction
Where Lead Time Fraction =1.0. Round your answer to the nearest whole number. A distribution center supplies home appliances to retail outlets and plans inventory based on monthly
demand projections. The operations team uses a 4-month weighted moving average method for
forecasting, assigning weights of 0.1,0.2,0.3, and 0.4 from oldest to most recent month. The actual
demand for the past seven months is given below. The center also wants to determine the safety stock
level for its target service level. The standard deviation of monthly demand is 60 units, and the service
level goal is 97.5%, corresponding to a Z-value of 1.96.
A. Demand Forecasting (4-Month Weighted Moving Average):
Using the 4-month weighted moving average method, forecast demand for June. Use the formula:
Forecast =(D_(t-4)\times 0.1)+(D_(t-3)\times 0.2)+(D_(t-2)\times 0.3)+(D_(t-1)\times 0.4)
Use February to May values. Round your answer to the nearest whole number.
B. Safety Stock Calculation:
Assuming a lead time of two weeks, calculate the safety stock using:
Safety Stock =Z\times \sigma \times \sqrt(L)ead Time Fraction
Lead Time Fraction =0.5. Round your final answer to the nearest whole number. A. Demand Forecasting (Exponential Smoothing):
Using exponential smoothing, forecast demand for April. Use the recursive formula:
F_(t)=\alpha D_(t-1)+(1-\alpha )F_(t-1)
Start from October and calculate up to March. Round the April forecast to the nearest whole number.
B. Safety Stock Calculation:
If the lead time is three weeks, calculate the safety stock using:
Safety Stock =Z\times \sigma \times \sqrt(L)ead Time Fraction
Lead Time Fraction =0.75. Round the final result to the nearest whole number.Inventory Review and Replenishment Process
A regional distribution center follows a routine inventory review process for
multiple electronic products. The team uses a fixed reorder point (R2P) policy
and checks inventory levels at regular intervals. The process begins by
reviewin
( NOTE : DO NOT UPLOAD IMAGE OF 5TH QUESTION MUST DRAW THE FLOWCHART)
A . Demand Forecasting ( 3 - Month Moving Average

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!