Answered step by step
Verified Expert Solution
Question
1 Approved Answer
identify the ABC classification, purchase plan ( qty ) , and ending inventory by march SALES PRICE/PK 23.58 ZEE 387.60 WHY 148.16 WHY 11 12
identify the ABC classification, purchase plan qty and ending inventory by march
SALES PRICE/PK 23.58 ZEE 387.60 WHY 148.16 WHY 11 12 13 14 15 94.98 WHY 16 17 18 21 22 23 24 25 26 27 28 item AIOOOOI A100002 A100013 A100004 A100105 A100106 A100007 A100008 A100009 B200001 B200002 B200003 B200004 B200005 B200006 B200007 B200008 B200009 B200010 coooool coooo coooo coooo c000005 c000006 COST/PK 10.25 25.98 98.00 135.00 204.00 98.77 830.00 34.78 33.78 56.90 40.87 35.09 45.23 46.79 12.45 15.34 49.78 30.78 34.80 33.50 25.98 26.90 34.87 30.12 0.28 Su ZEE EXE EXE WHY MMM QUE MMM EXE WHY WHY MMM QUE ZEE EXE EXE WHY WHY MMM MMM ZEE ZEE lier LEADTIME DAYS 20 20 45 45 40 40 40 30 35 30 45 40 40 40 30 35 50 45 45 40 40 30 30 50 15 py AVE MONTHLY SALES 70,000 40,000 1 ,800 2 ooo 2 ooo 16,000 500 45,300 44 800 23,400 4,000 20,000 33 400 32 900 97,000 97,500 39,800 24 ooo 24,300 34,100 35,000 135 ooo 43 200 74,000 400,000 ON HAND INVENTORY 61 ,ooo 7,000 800 1 ooo 1 ooo 11,700 900 67,500 76 ooo 40,000 7,500 40,000 60 ooo 74 000 120,000 130,000 42,600 14 000 26,667 45,333 28,000 100 ooo 90 ooo 80,000 290,000 IN TRANSIT INVENTORY 70,000 20,000 4 000 2 ooo 50,000 70,000 70 ooo 40,000 15,000 50,000 50 ooo 40 ooo 160,000 200,000 90,000 35 ooo 30,000 50,000 120,000 350 ooo 50 ooo 140,000 ABC CLASSIFICATIO ETA FEB JAN 60,000 10,ooo 1 ,ooo 1 ooo 10,ooo 500 45,000 40 ooo 30,000 5,000 30,000 50 ooo 35 ooo 1 oo,ooo 1 oo,ooo 40,000 15 ooo 20,000 40,000 35,000 120 ooo 60 ooo 75,000 400,000 FEB 75,000 10,000 2 ooo 1 500 12,000 300 38,000 60 ooo 25,000 5,000 28,000 30 ooo 30 ooo 140,000 90,000 40,000 20 ooo 22,000 35,000 30,000 130 ooo 35 ooo 76,000 400,000 MAR 66,000 10,000 3 ooo 1 200 20,000 300 40,000 66 ooo 23,000 5,000 20,000 40 ooo 45 ooo 90,000 120,000 40,000 20 ooo 18,000 38,000 38,000 180 ooo 50 ooo 90,000 350,000 APR 120,000 10,000 1,000 1 400 25,000 700 70,000 40 ooo 45,000 5,000 20,000 30 ooo 35 ooo 1 oo,ooo 150,000 40,000 30 ooo 26,000 39,000 42,000 130 ooo 45 ooo 72,000 500,000 MAY 65,000 10,ooo 2 ooo 1 300 18,000 400 48,000 50 ooo 23,000 5,000 20,000 45 ooo 40 ooo 90,000 1 oo,ooo 40,000 25 ooo 25,000 40,000 30,000 140 ooo 40 ooo 75,000 500,000 ETA MAR QUANTITY AMOUNT 49.36 186.20 283.50 1 ,477.40 66.08 57.43 101.28 85.83 73.69 74.86 31.13 30.68 79.65 64.64 73.08 70.35 49.36 37.66 73.23 60.24 0.87 MOQ 10,000 5,000 50,000 500,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started