Jodido

OVERVIEW- (see below for specific help instructions) - This form automatically calculates what your bar costs should be and calculates a bottle per bottle variance.
Column A is where all ofthe item Column B Column C Column D FORMULA PRICES FORMULA Enter in FORMULA
descriptions are typed in. is LAST Purchases is the THIS Column are taken What U spent your POS VARIANCE
WEEK's takenfrom WEEK'S (B+C-D) from per item.(E*F) report shows
count INVOICES counts ; USAGE invoices (UsageXPrice) COUNT a problem
Description - scroll up + down Inventory Week of 02/05/01 Purchases frominvoices Inventory Week of 02/12/01 Total Weekly Usage X Price Each Equals Total Weekly Cost Usage per POS report Variance
Beers
Amstel 0 240 161 79 $0,92 $72,68 68 11
Bud Light 46240 234 52 $0,56 $29,12 54 -2
Budweiser 58 240 226 72 $0,56 $40,32 108 -36
Coors Light 74 168 196 46 $0,56 $25,76 33 13
Corona 29 240 114 155 $0,73 $113,15 133 22
Heineken (1.04 because storepurchase) 47 240 113 174 $0,91 $158,34 149 25
Heineken Dark (recommend 86/replace) 75 0 71 4 $0,92 $3,68 3 1
Miller Lite Beer 19 240 201 58 $0,55 $31,90 47 11
Miller Genuine Draft 19 240 215 44 $0,55$24,20 30 14
O'Douls 111 0 104 7 $0,46 $3,22 4 3
Sam Adams 103 120 165 58 $0,77 $44,66 38 20
Sharps 86 0 80 6 $0,49 $2,94 3 3
Total Weekly Beer Expenditures $549,97 85
Total Weekly BeerSales (from POS) $2.961,96
Ideal Weekly % Beer Cost 18,57%
HELP ITEMS
Deleting an item/row 1. Click on the cell or row you'd like deleted
2. Click the right mouse buttonand choose 'Delete'
Inserting a new item/row 1. Click on the cell or row where you'd like the new row inserted
2. Choose 'Insert' from the gray bar above, then choose 'Row(s)'. Chooseeither insert above or below.
Formulas - copying/repairing erased 1. Click the cell next door (above or below) that contains the formula you want to copy
2.Hover over the bottom...