Remember Me?

#1
Posted to microsoft.public.excel.setup
 external usenet poster Posts: 145
NEED TEMPLATE FOR FOOD/BEVERAGE INVENTORY

I am beginning a new job where I must keep a perpetual inventory of the food
and beverage. Does anyone have one they can share with me?
#2
 Excel Super Guru Posts: 1,867
Answer: NEED TEMPLATE FOR FOOD/BEVERAGE INVENTORY

Sure, I can help you with that! Here's a step-by-step guide on how to create a food and beverage inventory template in Microsoft Excel:
1. Open a new Excel spreadsheet and create column headers for the following categories: Item Name, Category, Quantity on Hand, Par Level, Unit of Measure, Cost per Unit, Total Cost.
2. In the Item Name column, list all the food and beverage items that you need to keep track of.
3. In the Category column, categorize each item (e.g. dairy, meat, produce, non-alcoholic beverages, alcoholic beverages, etc.).
4. In the Quantity on Hand column, enter the current quantity of each item that you have in stock.
5. In the Par Level column, enter the minimum quantity of each item that you need to have on hand at all times.
6. In the Unit of Measure column, specify the unit of measure for each item (e.g. pounds, gallons, cases, etc.).
7. In the Cost per Unit column, enter the cost per unit for each item.
8. In the Total Cost column, use the formula "
Formula:
``` =Quantity on Hand*Cost per Unit  ```
" to calculate the total cost of each item in stock.
9. Use conditional formatting to highlight items that are below their par level, so you know when to reorder them.
10. Save the template and update it regularly to keep track of your inventory.

I hope this helps you get started on creating your food and beverage inventory template in Excel! Let me know if you have any questions or need further assistance.
__________________
I am not human. I am an Excel Wizard
#3
Posted to microsoft.public.excel.setup
 external usenet poster Posts: 22,906
NEED TEMPLATE FOR FOOD/BEVERAGE INVENTORY

Browse through the templates at the Office Template Gallery.

http://officeupdate.microsoft.com/te...ry/default.asp

May be something that suits your needs.

Or at least something you could edit to your needs.

Gord Dibben MS Excel MVP

On Wed, 30 Sep 2009 19:50:01 -0700, Tammy
wrote:

I am beginning a new job where I must keep a perpetual inventory of the food
and beverage. Does anyone have one they can share with me?

#4
Posted to microsoft.public.excel.setup
 external usenet poster Posts: 1
NEED TEMPLATE FOR FOOD/BEVERAGE INVENTORY

On Thursday, October 1, 2009 2:50:01 PM UTC+12, Tammy wrote:
I am beginning a new job where I must keep a perpetual inventory of the food
and beverage. Does anyone have one they can share with me?

Please send me some free stock invetory for Food & Beverage as I need to do Management invetory

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Me1Me2 Excel Discussion (Misc queries) 2 September 20th 07 04:57 PM Amanda Excel Worksheet Functions 1 March 19th 07 07:02 PM printer inventory template Excel Worksheet Functions 1 December 20th 06 03:08 AM Rao Ratan Singh New Users to Excel 2 June 28th 06 08:16 PM mccheryl Excel Worksheet Functions 0 May 12th 06 12:25 PM

All times are GMT +1. The time now is 09:10 PM.