placing a po peter dods - owner. ask the right people the right questions historical turns - pos...
DESCRIPTION
Island Mentality – Accessories How is it in stock? Quality of Product? Space!!! Merchandising and Stock rooms New Products?TRANSCRIPT
Placing a PO Peter Dods - Owner
• Ask the right people the right questions
• Historical Turns - POS system???• Calculate GMROI on all lines• MI SalesTrak – Great tool
• Island Mentality – Accessories• How is it in stock?• Quality of Product?• Space!!! Merchandising and Stock rooms • New Products?
• Special Orders • Fool me once…shame on you…• Ask Again??? The cons• Let the Vendor Know!!!! • Don’t get in the way of the
customer’s needs!
A Typical Order Sheet….
NONAMECO - Order SheetStock
IdealStock
PO Total 695.00Earphones MSRP Sale Price NET Line Total
2 4 2 HG-44 Sound Isolating Earphones 124.00 99.00 50.00 100.002 3 1 FH-65 In Ear Monitors 186.00 149.00 75.00 75.006 20 14 TJ-S Professional Quality Heaphone 75.00 59.99 30.00 420.006 4 "Check" JT-45 Professional Studio Headphone 125.00 99.99 50.00 0.001 2 1 FH-N7 Professional Monitoring Headphones 250.00 199.99 100.00 100.00
This looks nice in theory, but Easy Music Center has twoLocations. It is a lot trickier than this. Email me:
[email protected] if you would like the template
Check Formula….explain
Special Orders = Don’t drop the ball!!!Specail Order Sheet
Needs to be ordered Sales ProposalVendor Sku Description Q Person Name Date For Tel MSRP Price NET Notes PO#XYZco 456 Ac Adaptor 1 Kaimi Brede 5/28/2010 Jack Buick 808-594-6544 20.00 16.00 11.20 Needs 2 day Air 19999XYZco 3456 Picks 1 Hiroshi Park 5/27/2010 Mr. Clause 808-223-3288 1.00 0.80 0.56 Ground is okay 19997XYZco 8234 Strings 1 Jericho Sombrio 5/26/2010 Mr. Clause 808-223-3288 5.00 4.00 2.80 Next Stocking 19995XYZco 34324 Headphones 3 Peter Dods 5/25/2010 Joe Blow 808-448-5966 100.00 80.00 60.00 Next Stocking 19993ABCco 2345 Speaker 1 Jericho Sombrio 5/24/2010 Adam F 808-589-8888 300.00 210.00 157.50 1st day priority 19991OrderedNO NEW ORDERS BELOW THIS LINE
2 ABCco 56 Microphone 2 Hiroshi Park 5/23/2010 Adam F 808-589-8888 90.00 63.00 47.25 199891 ABCco 76568 Software 2 Jericho Sombrio 5/22/2010 Adam F 808-589-8888 200.00 140.00 91.00 199873 NAYco 1234 Drums 2 Hiroshi Park 5/21/2010 Jake Shapiro 808-569-1111 600.00 420.00 273.00 ETA 8/25/09 Call!!! 199852 NAYco 246 Sticks 4 Jericho Sombrio 5/20/2010 Ham Ford 510-646-1234 5.00 3.50 2.28 199831 NAYco 234 Heads 1 Hiroshi Park 5/19/2010 Ham Ford 510-646-1234 20.00 18.00 11.70 199811 NAYco 457 Kick pedal 1 Jericho Sombrio 5/18/2010 Ham Ford 510-646-1234 40.00 36.00 23.40 19979
1 Ordered2 In the store; call customer3 Problem, backorder, etc. Call Customer!4 Called waiting to come in
We do it in a google doc spreadsheet so all employees can Access it and edit at the same time!!! Works great…
\Share Your Resources!!!
Left Side of Screen…
Further Columns Down….
Order Email Phone # Fax # Order # Excel [email protected] 714-225-6500 714-225-6644 714-225-6450 \\ABCco\Order Form.xls \\ABCco\Order [email protected] 615-550-5600 615-550-5878 615-550-5899 \\NAYco\Order Form.xls \\NAYco\Order Form.pdf
5/28/2010 Last Order/ Days Since FORMULA!Company How it Works Checked Last Order Check It? Order Rep Name Rep EmailABCco Free Fedex Ground 5/25/2010 4 30 JP Kerouac [email protected] $3500 Free freight to West Coast 4/25/2010 34 30 order John Great [email protected]
A Tritech PO:
We cut and paste from the Excel Order sheets….