Template for Event Costing

I have been googling for a excel sheet, but just seem to find the right one. Then I found this great looking forum so I know someone here must beable to help me.

This is what I need:

I host an event twice a month I have cost that change every two weeks and would like a nice looking sheet that I can puch the numbers in to then it will tell me how much I need to charge each guest. I have cost that are always the same and other that are not. If this isnt clear here is an example...

Week1 week2 Month Year
Milk 2.50 2.50 5.00 130.00
Eggs .75 .75 1.50 39.00
Vodka 2.50 2.50 5.00 130.00
Lawn Darts 10.25 10.25 20.50 530.00


Host 75.00 75.00 150.00 3900.00
room 125.00 125.00 250.00 6500.00

total 216 216 432 11232.00

Number of guest week1 week 2 month year
25 30 55 55


cost of each guest 8.64 7.20


Yeah if any of this easy math is wrong please dont bust my balls So if you have a clue and I hope someone does. Anyone know where I can find what I am looking for?


THANK YOU