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 reorderplease 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

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 Accounting Questions!

Q:

\f