Went over with the owner all the different ways we order beef - a "current" price, a sheet with "specials" for this week and a market fresh sheet which has to be ordered 4 weeks in advance. What I need to make is an excel sheet that I can plug in everything I order every week and keep track of past orders easily. I know I can do all this in a filing drawer with my printouts, which I intend to do.. but in the end I would prefer to make it all digital.
Anyone have any excel spreadsheets that would give me a good template or nudge in the right direction for what I want to do? I'd love to be able to press a button and come up with last fourth of July's numbers ya know?
I use to staple a form to the weeks flyer with the feature items-quantitied ordered, quantity sold, and quantity carried- make notes- snowstorm?
id also include the profit merchandising, of what sold- if bnls pork chops were on sale- write down how many stuffed ones sold, marinated chops , etc. record sales, and costs too
Sounds rather simple, or maybe I am just over simplifying. Create an excell spreadsheet with the items you order in one column, quantity on hand in the next, and quantity to be ordered in the next. Once you place the order you save that sheet and name it for the date or supplier etc. When the next week comes along make a copy of the previous weeks sheet, delete the qty on hand and qty ordered, fill in the new qtys then save that sheet with the new week date or whatever system you elect to use. This way you have a sheet for each week, or each supplier. If its a weekly sheet, then you have 52 in your workbook. Save each workbook for the whole year. I have done this with cutting tests etc. I even have workbooks where I list the items I bought by the quarter.
Cowboy posted my cutting tests on the front page, I will work on a format for you saving purchases for the quarter, I record the price I paid too and any notes about special buys etc..
__________________
I'm not a vegetarian, but have eaten many animals that were.
