Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Analysis And Decision Making

Authors: David E. Vance

1st Edition

0071406654, 9780071406659

More Books

Students also viewed these Accounting questions

Question

Personal role: This consists of service to family and friends.

Answered: 1 week ago

Question

The role of life: It consists of your own service to yourself.

Answered: 1 week ago