Question: please help me write a VLOOKUP formula to find the reorder quantity for the basketball OWN 1 Sporting Goods Inventory List Item Name Preferred Supplier
please help me write a VLOOKUP formula to find the reorder quantity for the basketball OWN 1 Sporting Goods Inventory List Item Name Preferred Supplier Quantity on Hand Reorder Point Reorder Quantity Cost per Unit Sales Price per Unit Tenacket Sport Spiesne 100 150 S6000 SIKO0 Golf club (driver) GA Sports Distribution 250 150 150 $80.00 $200.00 5 Can of tennis balls GA Sports Distribution 400 250 250 $2.00 $4.00 Basketball Sports Supplies, Inc. 150 100 200 $11.25 $25.00 Football GA Sports Distribution 600 400 300 $12.00 $10.00 Baseball bat IGA Sports Distribution 300 2001 200 $35.00 $100.00 Baseball We Sell Sports 475 300 300 $6.00 $15.00 Soccer ball We Sell Sports | 100 $15.00 $1000 11 Baseball dove We Sell Sports 1000 600 $2000 $50.00 Sports Supplies, Inc Hockey stick 300 275 275 $40.00 $90.00 Total Item S1200000 $20,000.00 $800.00 $1.687.50 $7.200.00 S10.500.00 52,850.00 $1.500.00 $20.000.00 $20.000.00 306 17.50 80 600
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
