Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hi, I wanna know formulas for overstocked, reorder Y/N,reorder qty and No. Items on Backorder , No. Items >1000 Overstocked , Place Order (>3 items

hi, I wanna know formulas for overstocked, reorder Y/N,reorder qty and No. Items on Backorder , No. Items >1000 Overstocked , Place Order (>3 items to Re-Order) .

image text in transcribed
A B C D E F G H J K Re-Order Quantities: Inventory Code Description Cost each In Stock On Back-Order | Overstocked Re-Order Y/N Re-Order Qty C1019 Item Cost Connector Pack $81.20 Re-Order Qty 35 M1021 MGX 8025 Chip Set $0.00 $138.60 50 29 M1022 MGX 8066 Chip Set $300.00 $167.00 25 25 $1,000.00 R1001 Robot Motor Kit $1,445.40 10 42 R1002 Robot Kit 33A $2,545.20 37 R1003 Robot Kit 38A $2,850.40 35 R1004 Robot Kit 38G Value of Current Stock $3,202.40 $762,766.30 7 R1005 Robot Kit SP3 Max Stock Level $2,928.00 35 4 R1006 Robot Kit 448 $3,091.90 Min Stock Level 6 46 R1007 Robot Kit 555 $2,640.60 No. Items on Backorder 32 R1023 Relays - Small Pack $198.40 No. Items >1000 Overstocked 7 R1024 Relays - Medium Pack $251.20 Place Order (>3 items to Re-Order 19 R1025 Relays - Large Pack $358.60 52 S1008 Servo Motors A21 (4 pack) $790.10 26 $1009 Servo Motors B21 (4 pack) $1,010.40 0 Yes $1010 Servo Motors A21 (8 pack) $1,767.50 48 S1011 Servo Motors B21 (8 pack) $1,840.00 23 $1012 SMC Pneumatic Part 3-44 $783.60 55 S1013 SMC Pneumatic Part X-22 $711.10 29 $1014 SMC Pneumatic Part X-33 $740.70 44 $1015 SMC Pneumatic Part 3-47 $634.20 7

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

Bank Performance, Risk And Firm Financing

Authors: P. Molyneux

1st Edition

0230313353, 9780230313354

More Books

Students also viewed these Accounting questions

Question

Are your goals SMART?

Answered: 1 week ago