![Film-Tech Cinema Systems](http://www.film-tech.com/images/masthead.jpg) |
|
Home
Products
Store
Forum
Warehouse
Contact Us
|
|
|
|
Author
|
Topic: Excel Spreadsheet for Weekly Concessions
|
|
Randy Stankey
Film God
![](/ubbmembers/64b.jpg)
Posts: 6539
From: Erie, Pennsylvania
Registered: Jun 99
|
posted 10-13-2012 09:44 PM
It shouldn't be that hard if all you want to do is count up items sold and total everything up.
Each row would be a week. Each column would be an item. Sum the columns and put the result at the bottom. Sum across the bottom to get your grand totals.
It gets a bit more complicated if you want to track revenue. In that case, you'd need to put in a section with item prices and multiply item counts by the price. Again, not too hard. Just more stuff.
If you want inventory tracking, that's another thing.
If you want to keep track of par stock, that's something else. (e.g. If you want to automatically order when stock on a certain item goes below a set number.)
How many items do you sell? (If you track inventory by the cup or bag as most places do, you'll have to include each size.)
None of this is really hard to do, per se but these are things you need to know BEFORE you go designing a spreadsheet.
My old boss was famous for giving vague assignments like "Make a spreadsheet for inventory" but he never told you what he really wanted. After you worked several days, making a spreadsheet, counting inventory and making sure everything was right, he would look at your report and complain that it wasn't right.
Since then, I have learned to be specific about what you ask for.
| IP: Logged
|
|
|
|
All times are Central (GMT -6:00)
|
|
Powered by Infopop Corporation
UBB.classicTM
6.3.1.2
The Film-Tech Forums are designed for various members related to the cinema industry to express their opinions, viewpoints and testimonials on various products, services and events based upon speculation, personal knowledge and factual information through use, therefore all views represented here allow no liability upon the publishers of this web site and the owners of said views assume no liability for any ill will resulting from these postings. The posts made here are for educational as well as entertainment purposes and as such anyone viewing this portion of the website must accept these views as statements of the author of that opinion
and agrees to release the authors from any and all liability.
|
|
|
|