Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 145
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need a template to figure out weekly food costs... Me1Me2 Excel Discussion (Misc queries) 2 September 20th 07 04:57 PM
how do i set up inventory for food? Amanda Excel Worksheet Functions 1 March 19th 07 08:02 PM
printer inventory template printer inventory template Excel Worksheet Functions 1 December 20th 06 04:08 AM
Inventory template Rao Ratan Singh New Users to Excel 2 June 28th 06 08:16 PM
template for taking customer food order mccheryl Excel Worksheet Functions 0 May 12th 06 12:25 PM


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"