Item Name Purveyor Case Size Case Price Count Cost per Unit
Grains
Rice purveyor3 5 500 6 100
quinoa purveyor4 5 500 6 100
barley purveyor5 5 500 6 100
oats purveyor6 5 500 6 100
Pulses
Lentils purveyor8 5 500 6 100
Chickpeas purveyor9 5 500 6 100
Beans purveyor10 5 500 6 100
Flour
Wheat flour purveyor12 5 500 6 100
Cornflour purveyor13 5 500 6 100
Rice flour purveyor14 5 500 6 100
Sugar
Granulated Sugar purveyor17 5 500 6 100
Brown Sugar purveyor18 5 500 6 100
Powdered Suga purveyor19 5 500 6 100
Canned Goods
Vegetables purveyor21 5 500 6 100
Fruits purveyor22 5 500 6 100
Soups purveyor23 5 500 6 100
Spices purveyor24 5 500 6 100
Salt
Pepper purveyor26 5 500 6 100
Turmeric purveyor27 5 500 6 100
Cumin purveyor28 5 500 6 100
Oil
Olive Oil purveyor30 5 500 6 100
Vegetable Oil purveyor31 5 500 6 100
Coconut Oil purveyor32 5 500 6 100
Condiments
Ketchup purveyor34 5 500 6 100
Mustard purveyor35 5 500 6 100
Mayonnaise purveyor36 5 500 6 100
Baking Ingredients
Baking Powder purveyor38 5 500 6 100
Baking Soda purveyor39 5 500 6 100
Yeast purveyor40 5 500 6 100
Total Cost Total Value on Hand
87000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
Item Name Purveyor Case Size Case Price Count Cost per Unit
Dairy
Milk purveyor3 5 500 6 100
Cheese purveyor4 5 500 6 100
Butter purveyor5 5 500 6 100
Yogurt purveyor6 5 500 6 100
Meats
Chicken purveyor8 5 500 6 100
Beef purveyor9 5 500 6 100
Pork purveyor10 5 500 6 100
Deli slices purveyor11 5 500 6 100
Fresh Produce
Lettuce purveyor12 5 500 6 100
Tomatoes purveyor13 5 500 6 100
Cucumbers purveyor14 5 500 6 100
Apples purveyor15 5 500 6 100
Beverages
Juice purveyor17 5 500 6 100
Soda purveyor18 5 500 6 100
Water bottles purveyor19 5 500 6 100
Prepared meals
Leftovers purveyor21 5 500 6 100
Salads purveyor22 5 500 6 100
Sandwiches purveyor23 5 500 6 100
Baking goods
Eggs purveyor26 5 500 6 100
Cream purveyor27 5 500 6 100
Baking soda purveyor28 5 500 6 100
Snacks
Pudding cups purveyor30 5 500 6 100
Cheese sticks purveyor31 5 500 6 100
Fruit snacks purveyor32 5 500 6 100
Miscellaneous
Whipped cream purveyor34 5 500 6 100
Butter purveyor35 5 500 6 100
Ice packs purveyor36 5 500 6 100
Total Cost Total Value on Hand
81000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
Item Name Purveyor Case Size Case Price Count Cost per Unit Total Cost
Writing Implements
Pens purveyor3 5 500 6 100 3000
Pencils purveyor4 5 500 6 100 3000
Highlighters purveyor5 5 500 6 100 3000
Markers purveyor6 5 500 6 100 3000
Paper products
Copy paper purveyor8 5 500 6 100 3000
Notebooks purveyor9 5 500 6 100 3000
Notepads purveyor10 5 500 6 100 3000
Post-it notes purveyor11 5 500 6 100 3000
Desktop Items
Staplers purveyor12 5 500 6 100 3000
Paper clips purveyor13 5 500 6 100 3000
Tape dispensers purveyor14 5 500 6 100 3000
Rubber bands purveyor15 5 500 6 100 3000
Filling suppliers
Folders purveyor17 5 500 6 100 3000
Binders purveyor18 5 500 6 100 3000
Labels purveyor19 5 500 6 100 3000
Dividers purveyor20 5 500 6 100 3000
Mailroom suppliers
Envelops purveyor21 5 500 6 100 3000
Pizza purveyor22 5 500 6 100 3000
Stamps purveyor23 5 500 6 100 3000
Paacking tape purveyor24 5 500 6 100 3000
Shipping labels purveyor25 5 500 6 100 3000
Cleaning Suppliers
Paper towels purveyor26 5 500 6 100 3000
Tissues purveyor27 5 500 6 100 3000
Toilet paper purveyor28 5 500 6 100 3000
Disinfecting wipespurveyor30 5 500 6 100 3000
Total Value on Hand
75000
Item Name Purveyor Case Size Case Price Count Cost per Unit Total Cost
Whiskey
Scotch purveyor3 5 500 6 100 3000
Bourbon purveyor4 5 500 6 100 3000
Rye purveyor5 5 500 6 100 3000
Irish purveyor6 5 500 6 100 3000
Rum
White purveyor17 5 500 6 100 3000
Dark purveyor18 5 500 6 100 3000
Spiced purveyor19 5 500 6 100 3000
Tequila
Blanco purveyor21 5 500 6 100 3000
Reposado purveyor22 5 500 6 100 3000
Añejo purveyor23 5 500 6 100 3000
Gin
London Dry purveyor26 5 500 6 100 3000
Old Tom purveyor27 5 500 6 100 3000
New American purveyor28 5 500 6 100 3000
Brandy
Cognac purveyor26 5 500 6 100 3000
Armagnac purveyor27 5 500 6 100 3000
Fruit Brandy purveyor28 5 500 6 100 3000
Liqueurs
Amaretto purveyor26 5 500 6 100 3000
Baileys purveyor27 5 500 6 100 3000
Cointreau purveyor28 5 500 6 100 3000
Vodka
Plain purveyor26 5 500 6 100 3000
Flavoured purveyor27 5 500 6 100 3000
Total Value on Hand
63000
Item Name Purveyor Case SizeCase Price Count Cost per Unit Total Cost
Ale
Pale Ale purveyor3 5 500 6 100 3000
Brown Ale purveyor4 5 500 6 100 3000
Belgian Ale purveyor5 5 500 6 100 3000
Porter purveyor6 5 500 6 100 3000
Stout purveyor7 5 500 6 100 3000
Lager
Pilsner purveyor8 5 500 6 100 3000
Helles purveyor9 5 500 6 100 3000
Dunkel purveyor10 5 500 6 100 3000
Bock purveyor11 5 500 6 100 3000
Specialty Beers
Wheat Beer purveyor12 5 500 6 100 3000
Saison purveyor13 5 500 6 100 3000
Sour Ale purveyor14 5 500 6 100 3000
Craft Beers
IPA purveyor17 5 500 6 100 3000
Double IPA purveyor18 5 500 6 100 3000
Session IPA purveyor19 5 500 6 100 3000
Imported Beers
Belgian purveyor21 5 500 6 100 3000
German purveyor22 5 500 6 100 3000
British purveyor23 5 500 6 100 3000
Domestic Beers
Mainstream Brands
purveyor26 5 500 6 100 3000
Local Breweiespurveyor27 5 500 6 100 3000
Non-Alcoholic Beers
Alcohol-free purveyor26 5 500 6 100 3000
Low-alcohol purveyor27 5 500 6 100 3000
Total Value on Hand
66000
Item Name Purveyor Case Size Case Price Count Cost per UnitTotal Cost
Red Wines
Cabernet Sauvignon
purveyor3 5 500 6 100 3000
Merlot purveyor4 5 500 6 100 3000
Pinot Noir purveyor5 5 500 6 100 3000
Syrah purveyor6 5 500 6 100 3000
Whitw Wines
Chardonnay purveyor12 5 500 6 100 3000
Sauvignon Blancpurveyor13 5 500 6 100 3000
Pinot Grigio purveyor14 5 500 6 100 3000
Riesling purveyor15 5 500 6 100 3000
Rosé Wines
Still Rosé purveyor17 5 500 6 100 3000
Sparkling Rosé purveyor18 5 500 6 100 3000
Sparkling Wines
Champagne purveyor21 5 500 6 100 3000
Prosecco purveyor22 5 500 6 100 3000
Cava purveyor23 5 500 6 100 3000
Dessert Wines
Port purveyor26 5 500 6 100 3000
Sherry purveyor27 5 500 6 100 3000
Late Harvest purveyor28 5 500 6 100 3000
Fortified Wines
Madeira purveyor26 5 500 6 100 3000
Marslala purveyor27 5 500 6 100 3000
Total Value on Hand
54000
Item Name Purveyor Case Size Case Price Count Cost per Unit
Meat & Poultry
Chicken breasts purveyor3 5 500 6 100
Ground beef purveyor4 5 500 6 100
Pork Chops purveyor5 5 500 6 100
Seafood
Shrimp purveyor8 5 500 6 100
Selmon fillets purveyor9 5 500 6 100
Fish sticks purveyor10 5 500 6 100
Vegetables
Peas purveyor12 5 500 6 100
Corn purveyor13 5 500 6 100
Mixed vegetables purveyor14 5 500 6 100
Fruits
Berries purveyor17 5 500 6 100
Sliced Peaches purveyor18 5 500 6 100
Fruit mixes purveyor19 5 500 6 100
Prepared meals
Lasagna purveyor21 5 500 6 100
Pizza purveyor22 5 500 6 100
Soups purveyor23 5 500 6 100
Casseroles purveyor24 5 500 6 100
Breads & Doughs
Bread Loaves purveyor26 5 500 6 100
Rolls purveyor27 5 500 6 100
Pizza Dough purveyor28 5 500 6 100
Desserts & Sweets
Ice Cream purveyor30 5 500 6 100
Frozen yogurt purveyor31 5 500 6 100
Pies purveyor32 5 500 6 100
Miscellaneous
Whipped cream purveyor34 5 500 6 100
Ice packs purveyor36 5 500 6 100
Total Cost Total Value on Hand
72000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
3000
For adding new categories, simply add in the respective
sheet(s) using insert row feature and paste the formula in the
unit price cell from any existing unit price cell of an existing
category. Please modify the Purveyor columns according to your
suppliers, then you just have to imput count, case size & total
price. The sheet will automatically give you unit price and Total
Value on hand. Please dont forget to give a 5 star if you are
satsified with the work.
