ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Your company wants to have a holiday party for its employees, and you were chosen to
2
create a very simple budget for the party. Use the information below to build a spreadsheet that shows
3
three prices for the party: a high budget (lots of fun), best guess, and tight budget (no fun).
4
5
Budgets are tricky to calculate sometimes. For example, you don't always know how
6
much people are going to eat and drink.
7
Do your best to come up with some reasonable assumptions.
8
9
There will be 20 people attending the party.
10
There are two options for appetizers -- bruschetta ($26) and cheese spread ($20)
11
There are three options for meals -- a steak ($25), chicken ($18), and fish ($20) per person
12
There are many options for desserts but they all cost $7 per person
13
The wine is $8 per glass.
14
The restaurant charges a gratuity fee of 20% (on the subtotal).
15
The restaurant also charges you the state sales tax of 6%.
16
17
High budget:
18
Best guess:
19
Tight budget:
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100