create a powerpoint slide based on this data - basically how did i find this data and what does it mean

1 answer below »

View more »
Answered 1 days AfterJan 25, 2025

Answer To: create a powerpoint slide based on this data - basically how did i find this data and what does it...

Khushboo answered on Jan 25 2025
4 Votes
Under step 1, we have put all data in excel with their item number, Product Name, Item group, Quantity and confirmed ship date and we have calculated respective month for each shipped item.
Under step 2, we
made a pivot table based on item wise for each month and calculated quantity for each month in columnar format.
Post that we have calculated average and monthly maximum demand for each item by putting formula in excel.
We have also calculated Standard deviation for each month demand for each item by putting standard deviation formula in excel.
Under step 3, we have calculated lead time in days and months for each item. Basis monthly max demand time requirement the average lead time for average monthly demand has been reduced and we have calculated safety stock level.
Further, safety stock at level 2 has also been calculated by multiplying lead time * average monthly demand.
The analysis of sales demand per month and top 10 demanding items are as follows:
Steps to followed for safety stock requirement
Top 10 demanding items
Qty    
LABEL, "MADE IN U.S.A."    LABEL, "HP OUT"    LABEL, "HP IN"    LABEL, "LP IN"    LABEL, PX-Q300    LABEL, ERI LOGO, 65 SERIES    LABEL, "WARNING", 65 SERIES    LABEL, "LP OUT"    RING, LOCK, SEGMENT, 8"    SCREW, HEX-HEAD, 5/8"-11, X .5", NYLON    RING, SECURING, 65 SERIES, GRP    1000    1000    1000    1000    1000    1000    1000    1000    50    50    60    
Monthly Average Highest Demanding items
Monthly Average    SCREW, SOCKET-HEAD, 5/16"-18, X 1.0", 316    SCREW, HEX-HEAD, 5/8"-11, X .5", NYLON    LABEL, "HP OUT"    LABEL, "HP IN"    LABEL, "LP OUT"    LABEL, "LP IN"    LABEL, "MADE IN U.S.A."    LABEL, "WARNING", 65 SERIES    LABEL, ERI LOGO, 65 SERIES    LABEL, PX-Q300    PLATE, BEARING, 65 SERIES, ALU    RING, SECURING, 65 SERIES, GRP    RING, LOCK, SEGMENT, 8"    NUT, HEAVY HEX, 3/4"-10, PTFE COATED (2H)    2.5    4.166666666666667    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    2.0833333333333335    5    4.166666666666667    3    
    Item number    Product name    Quantity    Month bucket    AVG Monthly Demand    Max Monthly...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30