Question: identify the ABC classification, purchase plan ( qty ) , and ending inventory by march FORECAST PURCHASE PLAN ( QTY ) ENDING INVENTORY MAR item

identify the ABC classification, purchase plan (qty), and ending inventory by march FORECAST PURCHASE PLAN (QTY) ENDING INVENTORY MAR
item COST/PK SALES PRICE/PK Supplier MOQ LEADTIME (DAYS) PY AVE MONTHLY SALES ON HAND INVENTORY (PK) IN TRANSIT INVENTORY (PK) JAN FEB MAR APR MAY ABC CLASSIFICATION ETA FEB ETA MAR QUANTITY (PK) AMOUNT
A10000110.2523.58 ZEE 10,0002070,00061,00070,00060,00075,00066,000120,00065,000 B
A10000225.9849.36 ZEE 2040,0007,00020,00010,00010,00010,00010,00010,000 A
A10001398.00186.20 EXE 451,800800-1,0001,000 B
A100004135.00283.50 EXE 452,0001,0004,0002,0003,0002,000 C
A100105204.00387.60 WHY 402,0001,0002,0001,0001,5001,2001,4001,300 A
A10010698.77148.16 WHY 4016,00011,70050,00010,00012,00020,00025,00018,000 B
A100007830.001,477.40 WHY 5,00040500900-500300300700400 C
A10000834.7866.08 MMM 3045,30067,50070,00045,00038,00040,00070,00048,000 C
A10000933.7857.43 QUE 3544,80076,00070,00040,00060,00066,00040,00050,000 C
B20000156.90101.28 MMM 3023,40040,00040,00030,00025,00023,00045,00023,000 B
B20000240.8785.83 EXE 454,0007,50015,0005,0005,0005,0005,0005,000 C
B20000335.0973.69 WHY 4020,00040,00050,00030,00028,00020,00020,00020,000 C
B20000445.2394.98 WHY 4033,40060,00050,00050,00030,00040,00030,00045,000 C
B20000546.7974.86 WHY 4032,90074,00040,00035,00030,00045,00035,00040,000 C
B20000612.4531.13 MMM 50,0003097,000120,000160,000100,000140,00090,000100,00090,000 B
B20000715.3430.68 QUE 3597,500130,000200,000100,00090,000120,000150,000100,000 C
B20000849.7879.65 ZEE 5039,80042,60090,00040,00040,00040,00040,00040,000 C
B20000930.7864.64 EXE 4524,000

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!