← All products 3 lines
17 rows
Price lists →
Open →
Cups and lids · A06-3 · CUP-PT-12
PET smoothie cup, 12oz
1,000 cups per case. Customers write it as "clear cups". From Asterley Imports, 28 days to arrive. Healthy
On the shelf, day by day
Every goods-in and every load since the count on Thu 24 Sep, then today's sales speed run forward.
Reorder point 3778
Counted 24 Sep80
++ Goods in201 delivery
−− Sent out2215 loads
±± Count0written off
== On the shelf now78cases
On hand78£2,964 at cost
Allocated5kept for 3 open orders
Available73to sell now
Back-ordered0none waiting
On order0nothing on order
Cover69 daysat 1.05 a day
Reorder point371.05 x (28 + 7 days)
Open orders for it
5 cases kept across 3 orders, oldest first
| Order | Customer | For | Wants | Sending | Status |
|---|---|---|---|---|---|
| SO-48390 today 09:35 | Lark Coffee Co Gedling | Fri 16 Oct City | 1 | 1 | Checked |
| SO-48356 14 Oct 11:21 | The Silver Fleece Basford | Mon 19 Oct City | 2 | 2 | Checked |
| SO-48368 14 Oct 14:30 | Hazelnut Bakehouse Sutton-in-Ashfield | Wed 21 Oct Mansfield | 2 | 2 | Checked |
Stock history
Newest first. Every row moves the balance; the top balance is the shelf today.
| When | What | Ref | In | Out | Balance |
|---|---|---|---|---|---|
| Thu 15 Oct 07:00 | Loaded for Hearth Café, Van 2 | SO-48158 | 1 | 78 | |
| Wed 14 Oct 07:00 | Loaded for Bramble Coffee House, Van 4 | SO-48314 | 1 | 79 | |
| Tue 13 Oct 07:00 | Loaded for Market Bakehouse, Truck 1 (7.5t) | SO-48250 | 1 | 80 | |
| Mon 12 Oct 07:00 | Loaded for Window Café, Truck 1 (7.5t) | SO-48187 | 1 | 81 | |
| Fri 9 Oct 07:00 | Loaded for Lark Coffee Co, Truck 1 (7.5t) | SO-48144 | 2 | 82 | |
| Wed 7 Oct 07:00 | Loaded for Lark Coffee Co, Truck 1 (7.5t) | SO-48072 | 2 | 84 | |
| Wed 7 Oct 07:00 | Loaded for Jam Jar Café, Truck 1 (7.5t) | SO-48052 | 1 | 86 | |
| Mon 5 Oct 07:00 | Loaded for Window Café, Truck 1 (7.5t) | SO-47951 | 2 | 87 | |
| Fri 2 Oct 07:00 | Loaded for Lark Coffee Co, Truck 1 (7.5t) | SO-47892 | 1 | 89 | |
| Thu 1 Oct 13:36 | Goods in from Asterley Imports | PO-2229 | +20 | 90 | |
| Thu 1 Oct 07:00 | Loaded for Hearth Café, Van 2 | SO-47882 | 2 | 70 | |
| Wed 30 Sep 07:00 | Loaded for Daisy Bakehouse, Truck 1 (7.5t) | SO-47800 | 2 | 72 | |
| Wed 30 Sep 07:00 | Loaded for Hazelnut Bakehouse, Van 3 | SO-47793 | 2 | 74 | |
| Wed 30 Sep 07:00 | Loaded for Lark Coffee Co, Truck 1 (7.5t) | SO-47659 | 1 | 76 | |
| Wed 30 Sep 07:00 | Loaded for Jam Jar Café, Truck 1 (7.5t) | SO-47646 | 1 | 77 | |
| Fri 25 Sep 07:00 | Loaded for Lark Coffee Co, Truck 1 (7.5t) | SO-47684 | 2 | 78 | |
| Thu 24 Sep 18:00 | Counted at close: the opening balance | Stock count | 80 | 80 |
Prices and margin
Per case, ex VAT. Every order prices itself from these.
Cost from Asterley Imports£38.00
Lowest price allowed (cost plus 12% margin)£43.19
| Price | Per case | Margin |
|---|---|---|
| Band A18% off list | £48.30 | 21.3% |
| Band B12% off list | £51.83 | 26.7% |
| Band C6% off list | £55.37 | 31.4% |
| List pricenew and one-off accounts | £58.90 | 35.5% |
Contract prices0 accounts
No account has a contract price on this line; each pays its band.
Sold in the last 3 weeks
Reports →22cases
£1,186ex VAT
29.5%margin made
Who buys it
Lark Coffee Co8 casesHearth Café3 casesWindow Café3 casesJam Jar Café2 casesHazelnut Bakehouse2 casesand 3 more accounts
Supplier · importer
Asterley Imports
Felixstowe. Jenny Marsh, 30 days
Lead time28 days
On time88%
Minimum order£2,000
Purchase orders with this line