Inventory
- 40 items
- 3 locations
- Every number here is added up from its item's ledger
- Value on hand, everywhere
- $17,844.85at lot cost
- Commissary
- $16,235.2135 items
- Mill Street
- $1,002.2124 items
- Harbor Road
- $605.5524 items
- In transit
- $1.881 transfer unresolved
Needs a person 7
- Dark chocolate, 60% is down to 380 lb, about 15 days of baking. Valmont takes three weeks, so its reorder point is 600. Purchase suggested: 30 cases from Valmont, and 7 from Harlow to cover the gap.
- Pizza box, large, printed is at 1,550, under its reorder point of 2,000. 5,000 are on order from Keystone, due Tue Oct 27.
- Lemon Bar at Harbor Road is at −2. The register sold two that the count said were not there. Flagged for a count tonight.
- Chocolate Chip Cookie: the 1:31 pm van left with 24 and Mill Street received 22. 2 are still in transit until a manager says what happened to them.
- Cream cheese frosting: all 18 lb expire tomorrow, Wed Oct 7.
- Cream cheese: 60 of 210 lb expire Thu Oct 8.
- Gluten-free crust, 10 inch at Harbor Road is down to 3. Its reorder point there is 6. Transfer suggested from the commissary, which has 48.
Today so far
- Received
- Harlow Foodservice, 9:40 am. 14 lines, 1 short.
- Transfers
- 5 shipped. 4 received in full, 1 short by 2.
- Waste, at cost
- $68.35Commissary 22.10 · Mill Street 31.40 · Harbor Road 14.85
On hand, by item and place
| Item | Unit | Commissary | Mill Street | Harbor Road | In transit | Total | Value | Replenished by | Note |
|---|---|---|---|---|---|---|---|---|---|
| Finished goods | 1,521.63 | ||||||||
| Chocolate Chip Cookie | each | 96 | 42 | 17 | 2 | 157 | 146.84 | Daily par | 2 in transit since 1:52 pm, unresolved |
| Oatmeal Raisin Cookie | each | 48 | 31 | 14 | 0 | 93 | 82.77 | Daily par | |
| Double Chocolate Cookie | each | 0 | 27 | 12 | 0 | 39 | 37.83 | Daily par | |
| Fudge Brownie | each | 24 | 22 | 11 | 0 | 57 | 63.84 | Daily par | |
| Lemon Bar | each | 24 | 16 | −2 | 0 | 38 | 39.90 | Daily par | Harbor Road is below zero. Count flagged |
| Cupcake | each | 0 | 34 | 20 | 0 | 54 | 52.92 | Daily par | |
| Chocolate Layer Cake, 8 inch | each | 6 | 4 | 2 | 0 | 12 | 160.80 | Daily par | |
| Carrot Cake, 8 inch | each | 4 | 3 | 2 | 0 | 9 | 126.90 | Daily par | |
| New York Cheesecake, 10 inch | each | 38 | 3 | 2 | 0 | 43 | 548.25 | Daily par | 32 at the commissary are frozen |
| Apple Pie, 9 inch | each | 8 | 6 | 4 | 0 | 18 | 111.60 | Daily par | |
| Pumpkin Pie, 9 inch | each | 6 | 5 | 3 | 0 | 14 | 74.90 | Daily par | |
| Blueberry Muffin | each | 0 | 18 | 9 | 0 | 27 | 22.68 | Daily par | |
| Butter Croissant, baked | each | 0 | 14 | 6 | 0 | 20 | 20.40 | Daily par | |
| Dinner Rolls | dozen | 10 | 6 | 4 | 0 | 20 | 32.00 | Daily par | |
| Components, made in-house | 2,851.08 | ||||||||
| Croissant, shaped and frozen | each | 1,420 | 192 | 144 | 0 | 1,756 | 1,246.76 | Reorder point | |
| Cookie dough, chocolate chip | lb | 58 | 0 | 0 | 0 | 58 | 203.00 | Production plan | |
| Cake layer, chocolate, 8 inch | each | 84 | 0 | 0 | 0 | 84 | 264.60 | Reorder point | |
| Buttercream, vanilla | lb | 41 | 0 | 0 | 0 | 41 | 139.40 | Production plan | |
| Cream cheese frosting | lb | 18 | 0 | 0 | 0 | 18 | 54.90 | Production plan | All 18 lb expire tomorrow, Wed Oct 7 |
| Pie dough disc | each | 310 | 0 | 0 | 0 | 310 | 192.20 | Reorder point | |
| Pizza dough ball, large | each | 120 | 96 | 58 | 0 | 274 | 158.92 | Daily par | The commissary's 120 are not ready until Wed 2:30 pm |
| Pizza sauce | qt | 40 | 22 | 14 | 0 | 76 | 102.60 | Daily par | |
| Cheese blend | lb | 80 | 34 | 21 | 0 | 135 | 488.70 | Daily par | |
| Raw materials | 11,918.57 | ||||||||
| Cake flour | lb | 2,350 | 0 | 0 | 0 | 2,350 | 1,081.00 | Reorder point 1,000 | |
| All-purpose flour | lb | 1,800 | 0 | 0 | 0 | 1,800 | 828.00 | Reorder point 800 | |
| Bread flour | lb | 3,100 | 0 | 0 | 0 | 3,100 | 1,271.00 | Reorder point 1,200 | |
| Sugar, granulated | lb | 1,150 | 0 | 0 | 0 | 1,150 | 713.00 | Reorder point 500 | |
| Butter, unsalted | lb | 612 | 0 | 0 | 0 | 612 | 1,946.16 | Standing order | |
| Cream cheese | lb | 210 | 0 | 0 | 0 | 210 | 575.40 | Standing order | 60 lb expire Thu Oct 8 |
| Eggs, large | each | 2,880 | 0 | 0 | 0 | 2,880 | 691.20 | Reorder point 1,080 | |
| Mozzarella, block | lb | 364.8 | 0 | 0 | 0 | 364.8 | 1,076.16 | Reorder point 150 | |
| Pepperoni | lb | 98.5 | 0 | 0 | 0 | 98.5 | 403.85 | Reorder point 50 | |
| Crushed tomatoes, #10 can | can | 132 | 0 | 0 | 0 | 132 | 772.20 | Reorder point 48 | |
| Dark chocolate, 60% | lb | 380 | 0 | 0 | 0 | 380 | 2,432.00 | Reorder point 600 | Below reorder point. Valmont takes 3 weeks |
| Basil, fresh | oz | 22 | 6 | 4 | 0 | 32 | 17.60 | Ordered daily | |
| Gluten-free crust, 10 inch | each | 48 | 9 | 3 | 0 | 60 | 111.00 | Reorder point 6, per store | Harbor Road is below its reorder point |
| Packaging | 1,504.90 | ||||||||
| Pizza box, large, printed | each | 1,150 | 240 | 160 | 0 | 1,550 | 744.00 | Reorder point 2,000 | Below reorder point. 5,000 on order, due Tue Oct 27 |
| Cake box, 8 inch | each | 640 | 85 | 60 | 0 | 785 | 565.20 | Reorder point 300 | |
| Cookie box, one dozen | each | 400 | 70 | 45 | 0 | 515 | 195.70 | Reorder point 200 | |
| Bought to resell | 48.67 | ||||||||
| Bottled water | each | 0 | 96 | 61 | 0 | 157 | 48.67 | Reorder point 48, per store | |