Use This Sheet To Set-Up The Month

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 19

Use This Sheet to Set-up the Month.

Very Important First Thing = Select File, Save As and name File As Month (Ex. May 2011.xls)
Location =
Year =
Month =

Enter Store Location


Enter the Year
Enter the Month

Sales Adjustment =

Enter Sales Trend As .#### (Ex. .9734)

Food Cost % Budget =

Enter Food Cost % As .#### (Ex. .3376)

Labor Cost % Budget =

Enter Labor Cost % As .#### (Ex. .3185)

Hourly Rate =
Month Starts On This Day =

Enter Hourly Rate As ##.## (Ex. 9.87)


Enter the First Day Month (Ex. Tuesday)

To Unprotect Sheet: Go to Tools, Select Unprotect Sheet, Enter Password = Sweet Tea.

(Ex. May 2011.xls)

ea.

BUDGET WORKSHEET
Budget 2011

April

May

June

Total

Sales $

$0.00

Food %

#DIV/0!

Labor %

#DIV/0!

Net %

#DIV/0!

Net $

#DIV/0!

Actual 2011

April

May

June

Total

Sales $

$0.00

Food %

#DIV/0!

Labor %

#DIV/0!

Net %

#DIV/0!

Net $

$0.00

Daily Tracking

Use Net Sales Here

Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
TOTAL
MONTH

D
a
GUEST CHECK
t COUNTS AVG.
e
###
###
###
###
###
###
###
#DIV/0!
###
###
###
###
###
###
###
#DIV/0!
###
###
###
###
###
###
###
#DIV/0!
###
###
###
###
###
###
###
#DIV/0!
###
###
###
###
###
###
###
#DIV/0!
###
###
#DIV/0!
0

#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!

BREAKFAST

2:00 PM

5:00 PM

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!
#DIV/0!

#DIV/0!
#DIV/0!

#DIV/0!
#DIV/0!

CLOSE

OVER /
SHORT

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Gift
Cards
Sold

Gift
Cards
Red.

NET SALES

SALES +
TAX

Non-Cash
Payments

$0.00

ACTUAL
DEPOSIT

CASH +
CREDIT

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

102359684.xls.ms_office

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

0
LABOR
HOURS

Week-End
$0.00

0.00

Daily Avg.
#DIV/0!

0.00

Daily Avg.
#DIV/0!

0.00

Daily Avg.
#DIV/0!

0.00

Daily Avg.
#DIV/0!

0.00

Daily Avg.
#DIV/0!

Week-End
$0.00

Week-End
$0.00

Week-End
$0.00

Week-End
$0.00

Daily Avg.
0.00
#DIV/0!
0.00
#DIV/0!
#DIV/0! Monthly Avg

Purchase Log

Day

Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
TOTAL
MONTH

D
a
t
e

Labatt

Bimbo

Brookshires

Petty
Cash

Other
Food

Total

###
###
###
###
###
###
###
$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

$0.00
$0.00

###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###

102359684.xls.ms_office

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Snap Shot

Sales Adjustment

Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
TOTAL
MONTH

D
a
t
e

Last Year Net


Sales

###
###
###
###
###
###
###
$0.00
###
###
###
###
###
###
###
$0.00
###
###
###
###
###
###
###
$0.00
###
###
###
###
###
###
###
$0.00
###
###
###
###
###
###
###
$0.00
###
###
$0.00
$0.00

0.00%

Food Cost %

0.00%

Sales Goal

Actual Sales

Variance +/Sales Dollars

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Labor Cost %

0.00%

Food
Purchase
Budget
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Food
Purchase
Actual
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Hourly Rate

$0.00

Variance +/Spent

Labor Hours
Goal

Labor Hours
Actual

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

102359684.xls.ms_office

Variance +/- Labor Dollars Labor Dollars Variance +/Hours Used


Budget
Actual
Dollars Spent
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

0 Man Hour Breakdown


0

BACK OF HOUSE

Day

D
A
T
E

SALES

Monday

###

Tuesday

SALES PER
MANHOUR

F.O.H.
HOURS

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Wednesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Thursday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Friday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Saturday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Sunday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

$0.00

TOTAL

B.O.H.
HOURS

FRONT OF HOUSE

0.00

SALES PER
Total Hrs.
MANHOUR

Monday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Tuesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Wednesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Thursday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Friday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Saturday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Sunday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

$0.00

TOTAL

0.00

Monday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Tuesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Wednesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Thursday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Friday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Saturday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Sunday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

$0.00

TOTAL

0.00

Monday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Tuesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Wednesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Thursday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Friday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Saturday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Sunday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

$0.00

TOTAL

0.00

Monday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Tuesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Wednesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Thursday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Friday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Saturday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Sunday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

#DIV/0!

0.00

$0.00

TOTAL

0.00

Monday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

Tuesday

####

$0.00

#DIV/0!

0.00

#DIV/0!

0.00

0.00

#DIV/0!

0.00

TOTAL

$0.00

0.00
#DIV/0!
102359684.xls.ms_office

Petty Cash
0
Date

From

Items

Reciept
Total

Balance Should Always Equal =

$200.00

Cash On
Hand

Balance

Variance

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

$0.00

$0.00

$200.00

All Total

TOM OWES THE STORE

Open / Close
Mgr. Initials

$0.00

Week 1
Raw Cost Mon Tus Wed Thur Fri Sat Sun Total WTD Total Mon Tus
Gal
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each
each

Icecream mix
mini Blizz
Buster Bar
Dill
Orange Venilla
Dilly Heath
Dilly NSA
SM blizz
M Blizz
L Blizz
Sm shake
Med shake
Lg shake
Sm Sundae
Med Sundae
Lg Sundae
Sm Artic Rush
Med Artic Rush
Lg Artic Rush
Sm Cone
Med Cone
Lg Cone
Waffle Bowl
Waffle Cone
Sm Mollate
Med Moolate
Lg Moolate
Pbutter Bash
Oreo Earthquake
Small Dipped

$5.28
$0.28
$0.76
$0.37
$0.43
$0.37
$0.28
$0.64
$1.01
$1.43
$0.72
$0.80
$0.94
$0.22
$0.31
$0.41
$0.33
$0.54
$0.69
$0.27
$0.32
$0.45
$0.37
$0.37
$0.54
$0.64
$0.76
$0.63
$0.67
$0.22

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Week 2
Week 3
Wed Thur Fri Sat Sun Total WTD Total Mon Tus Wed Thur Fri Sat Sun Total WTD Total
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Week 4
Week 5
Mon Tus Wed Thur Fri Sat Sun Total WTD Total Mon Tus Wed Thur Fri Sat Sun Total
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

WTD Total MTD Total


$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Week 1
Raw Cost Mon Tus Wed Thur Fri Sat Sun Total WTD Total Mon Tus
each
each
each
each
each
each
each
lb.
each
each
each
each
order
order
each
can
order
lb
lb
lb
lb
lb
order
each
lb
each
order
each
each
each
each
each
each
each
order
order
order
order
order

4-1 patty
6-1 patty
Dude
Crispy Chicken
Grilled Chicken
Steak Finger
Hot Dog
Popcorn Chix
Small Bun
LG Bun
Hot dog bun
Tx Toast
Onion ring
Fry
Gravy Cup
Nacho Cheese
Nacho chips
Lettuce
Salad Mix
Onions
Taco Meat
Chili
Tater Tots
Sliced cheese
Shred Cheese
Jal. Cheese
jalitos
bacon
Hunger Buster
Belt Buster
Jalitos Ranch
Triple Buster
Grilled Chicken
Crispy Chicken
4p chic
6p chic
4p steak
6p steak
nachos

$0.51
$0.33
$0.58
$0.84
$0.79
$0.24
$0.26
$1.93
$0.13
$0.14
$0.35
$0.19
$0.67
$0.25
$0.15
$6.69
$0.19
$0.68
$0.80
$1.78
$1.92
$1.20
$0.27
$0.08
$2.53
$0.12
$0.99
$0.13
$0.87
$1.39
$1.11
$2.15
$1.49
$1.69
$1.38
$1.90
$1.38
$1.89
$0.64

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Week 2
Week 3
Wed Thur Fri Sat Sun Total WTD Total Mon Tus Wed Thur Fri Sat Sun Total WTD Total
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Week 4
Week 5
Mon Tus Wed Thur Fri Sat Sun Total WTD Total Mon Tus Wed Thur Fri Sat Sun Total
3

7
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$3.57
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$3.57

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

WTD Total MTD Total


$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

$3.57
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$3.57

Date

Dilly Bar

Buster Bar

Ice Cream

Gal

StarKiss

8in

10in

Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
0

Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
Monday
Tuesday
TOTAL
MONTH

D
a
t
e
###
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####
#####

Actual
Usage

Guest
Checks

Daily
Variance
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

You might also like