Hotel Name:
Retail sales tax number:
Hotel location address:
Electricity supplier:
Water supplier:
# of guestrooms:
Are you open all year round (Yes or No)?
Instructions:
1. Fill in your Hotel's business name in Cell B2
2. Fill in your Hotel's retail sales tax number (8 digit number beginning with "1") in B4
3. Fill in your Hotel's business address in B6
4. Fill in your Hotel's electricity supplier in B8
5. Fill in your Hotel's water supplier in B10
6. Fill in your Hotel's # of guest rooms in B12
7. Answer the question "yes" or "no" in B14. If you answered "No" do not use this file to calculate your refund. Contact Jane G
the Mo Dept of Revenue at 417-895-6477 or at Jane.Gardner@dor.mo.gov for the file "Hotel resold electricity & water work
8. GO TO worksheet tab "resold electricity calculation" -- Instructions
your refund. Contact Jane Gardner at
sold electricity & water worksheets--little or no winter operations"
Hrs of Use kWh per Guest resold
per Rental Rental Rooms electricity your sales your tax
Room Appliance & Lighting Wattage Day Day Period Rented resold kWh $s tax rate refund
color television 200 4 0.80 199901 - $0.00 $0.00
clock-radio 5 24 0.12 199902 - $0.00 $0.00
bedside lamp 4.5 - 199903 - $0.00 $0.00
bedside lamp 4.5 - 199904 - $0.00 $0.00
floor lamp 3 - 199905 - $0.00 $0.00
desk lamp 2 - 199906 - $0.00 $0.00
room entry light 0.5 - 199907 - $0.00 $0.00
bathroom light 8 - 199908 - $0.00 $0.00
bathroom vent 1 - 199909 - $0.00 $0.00
bathroom heat lamp 1 - 199910 - $0.00 $0.00
hair dryer 1000 0.167 ie 10min 0.17 199911 - $0.00 $0.00
coffee maker 900 0.167 ie 10min 0.15 199912 - $0.00 $0.00
microwave 1000 0.167 ie 10min 0.17 Total - - $0.00 $0.00
iron 1000 0.167 ie 10min 0.17
Room Heating & Cooling Appliance 200001 - $0.00 $0.00
200002 - $0.00 $0.00
200003 - $0.00 $0.00
200004 - $0.00 $0.00
resold kwh per room rented per day 1.58 200005 - $0.00 $0.00
200006 - $0.00 $0.00
your cost per kWh (1999) 200007 - $0.00 $0.00
your cost per kWh (2000) 200008 - $0.00 $0.00
your cost per kWh (2001) 200009 - $0.00 $0.00
your cost per kWh (2002) 200010 - $0.00 $0.00
your cost per kWh (2003) 200011 - $0.00 $0.00
your cost per kWh (2004) 200012 - $0.00 $0.00
your cost per kWh (2005) Total - - $0.00 $0.00
Instructions your cost per kWh (2006)
1. Fill in the lamp wattage for each of the lamps listed above on lines 4 thru 9 200101 - $0.00 $0.00
if the lamp is applicable to your typical guestroom in cells B4 -B9. If you are using 200102 - $0.00 $0.00
compact fluorescent lighting--a 32watt CFL is the equivalent of a 100watt incandescent. 200103 - $0.00 $0.00
2. If the bathroom has a vent that is turned on/off by the guest, enter a 200104 - $0.00 $0.00
wattage rating of 88 in cell B10 200105 - $0.00 $0.00
3. If the bathroom has a heat lamp, enter a wattage rating of 250 in cell B11. 200106 - $0.00 $0.00
4. If your typical guestroom does not have a coffee maker, microwave, or 200107 - $0.00 $0.00
iron, delete the wattage ratings in the applicable cell -- B12 thru B15. 200108 - $0.00 $0.00
5. Is there any appliances in your typical guestroom that are not named 200109 - $0.00 $0.00
above? If so, contact Jane Gardner, Mo Dept of Revenue, at 200110 - $0.00 $0.00
417-895-6477, to help add that appliance to your calculation. 200111 - $0.00 $0.00
6. Determine the type of heating and cooling appliance that is in your 200112 - $0.00 $0.00
typical guestroom. Do you use a 1) ptac that has a/c and full electric Total - - $0.00 $0.00
heat; 2) a ptac that has a/c and heatpump; 3) a fan coil unit that has a
full electric heat (e.g. centralized a/c, room heat); or 4) a fan coil unit 200201 - $0.00 $0.00
with no heater (e.g. centralized a/c and heat)? If you are using an 200202 - $0.00 $0.00
hvac appliance that is not listed in 1) thru 4), contact Jane Gardner 200203 - $0.00 $0.00
for assistance. 200204 - $0.00 $0.00
7. Now go to the worksheet that is included in the file entitled "room hvac 200205 - $0.00 $0.00
options". You will find all the above options on this worksheet, as well as the 200206 - $0.00 $0.00
various "sizes" in which these hvac appliances are available. Follow 200207 - $0.00 $0.00
the instructions on the "room hvac options" worksheet to COPY the 200208 - $0.00 $0.00
correct hvac appliance and enter in cells A17 & A18 above. 200209 - $0.00 $0.00
8. Your total kWh per room rented is in cell E20. 200210 - $0.00 $0.00
9. Go to Column H and enter the number of guest rooms rented for each 200211 - $0.00 $0.00
period listed. Column I contains a formula that multiplies your total 200212 - $0.00 $0.00
kWh per room rented times your number of guest rooms rented. Total - - $0.00 $0.00
10. Determine your average cost per kWh per calendar year -- take a couple of electric
bills from each calendar year, divide the electricity charges 200301 - $0.00 $0.00
by the kWh purchased. Enter this cost per kWh in cell E22 through E28 -- the cost 200302 - $0.00 $0.00
per kWh will likely range from $.04 to $.07. Filling in these cells will calculate your resold electricity $s 200303 - $0.00 $0.00
in column J. 200304 - $0.00 $0.00
11. Go to column K and fill in your hotel's sales tax rate for each period. Fill in as a decimal (.07225, for example) 200305 - $0.00 $0.00
Filling in this column will calculate your sales tax refund on your resold 200306 - $0.00 $0.00
electricity. 200307 - $0.00 $0.00
12. PROVIDE copies of electric bills for each month of the refund claim period 200308 - $0.00 $0.00
unless the utility is able to provide this information for you. 200309 - $0.00 $0.00
13. GO TO worksheet tab "resold water calculation" -- Instructions section 200310 - $0.00 $0.00
200311 - $0.00 $0.00
200312 - $0.00 $0.00
Total - - $0.00 $0.00
200401 - $0.00 $0.00
200402 - $0.00 $0.00
200403 - $0.00 $0.00
200404 - $0.00 $0.00
200405 - $0.00 $0.00
200406 - $0.00 $0.00
200407 - $0.00 $0.00
200408 - $0.00 $0.00
200409 - $0.00 $0.00
200410 - $0.00 $0.00
200411 - $0.00 $0.00
200412 - $0.00 $0.00
Total - - $0.00 $0.00
200501 - $0.00 $0.00
200502 - $0.00 $0.00
200503 - $0.00 $0.00
200504 - $0.00 $0.00
200505 - $0.00 $0.00
200506 - $0.00 $0.00
200507 - $0.00 $0.00
200508 - $0.00 $0.00
200509 - $0.00 $0.00
200510 - $0.00 $0.00
200511 - $0.00 $0.00
200512 - $0.00 $0.00
Total - - $0.00 $0.00
200601 - $0.00 $0.00
200602 - $0.00 $0.00
200603 - $0.00 $0.00
200604 - $0.00 $0.00
200605 - $0.00 $0.00
Total - - $0.00 $0.00
Gr Total - - $0.00 $0.00
Room HVAC Options
OPTION #1: If your guestroom has a ptac with a/c and electric heater (NO heat pump) -- choose the "box" directly below with
the size of unit that is in your typical guest room and copy the WHOLE box (both lines in the box and from B thru
electricity calculation" in cell A17. hint: it is very unlikely that MO has any hotels with 12,000 or 15,000 btuh units
units; some may have 9,000 btuh units.
ptac -- btuh 7000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 7000 heat/cool unit -- annual estimated kwh for heating
ptac -- btuh 9000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 9000 heat/cool unit -- annual estimated kwh for heating
ptac -- btuh 12000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 12000 heat/cool unit -- annual estimated kwh for heating
ptac -- btuh 15000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 15000 heat/cool unit -- annual estimated kwh for heating
OPTION #2: If your guestroom has a ptac with a/c and electric heater w/ heat pump -- choose the "box" directly below with
the size of unit that is in your typical guest room and copy the WHOLE box (both lines in the box and from B thru
electricity calculation" in cell A17. hint: it is very unlikely that MO has any hotels with 12,000 or 15,000 btuh units
units, some may have 9,000 btuh units.
ptac -- btuh 7000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 7000 heat pump/cool unit -- annual estimated kwh for heating
ptac -- btuh 9000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 9000 heat pump/cool unit -- annual estimated kwh for heating
ptac -- btuh 12000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 12000 heat pump/cool unit -- annual estimated kwh for heating
ptac -- btuh 15000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 15000 heat pump/cool unit -- annual estimated kwh for heating
OPTION #3: If your guestroom has a fan coil unit with an electric heater, first find correct "style" (vertical, low vertical, horizonta
each style has a different color. THEN find the correct blower fan size (by cfm) of the unit. Then copy the WHO
from B thru F) and paste it on worksheet "resold electricity calculation" in cell A17.
vertical fancoil unit (blower fan 200cfm) -- room size less than 250sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (800cfm) -- room size 550+ sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (200cfm) -- room size less than 250sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (200cfm) -- room size less than 250sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (300cfm) -- room size 250-350sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (800cfm) -- room size 550+ sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (800cfm) -- room size 550+ sqft
with heater size 2kw (including blower fan)
OPTION #4: If your guestroom has a fan coil unit with fans only (centralized heat and cooling), first find correct "style" (vertical
w/ high static motor) -- each style has a different color. THEN find the correct blower fan size (by cfm) of the unit
lines in the box and from B thru F) and paste it on worksheet "resold electricity calculation" in cell A17.
vertical fancoil unit (blower fan 200cfm) -- room size less than 250sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (800cfm) -- room size 550+ sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (200cfm) -- room size less than 250sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (200cfm) -- room size less than 250sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (300cfm) -- room size 250-350sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (800cfm) -- room size 550+ sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (800cfm) -- room size 550+ sqft
with no heater (just blower fan)
SEASONAL HOTEL (CLOSED JANUARY AND FEBRUARY)
OPTION #1: If your guestroom has a ptac with a/c and electric heater (NO heat pump) -- choose the "box" directly below with
the size of unit that is in your typical guest room and copy the WHOLE box (both lines in the box and from B thru
electricity calculation" in cell A17. hint: it is very unlikely that MO has any hotels with 12,000 or 15,000 btuh units
units; some may have 9,000 btuh units.
ptac -- btuh 7000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 7000 heat/cool unit -- annual estimated kwh for heating
ptac -- btuh 9000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 9000 heat/cool unit -- annual estimated kwh for heating
ptac -- btuh 12000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 12000 heat/cool unit -- annual estimated kwh for heating
ptac -- btuh 15000 heat/cool unit -- annual estimated kwh for cooling
ptac -- btuh 15000 heat/cool unit -- annual estimated kwh for heating
OPTION #2: If your guestroom has a ptac with a/c and electric heater w/ heat pump -- choose the "box" directly below with
the size of unit that is in your typical guest room and copy the WHOLE box (both lines in the box and from B thru
electricity calculation" in cell A17. hint: it is very unlikely that MO has any hotels with 12,000 or 15,000 btuh units
units, some may have 9,000 btuh units.
ptac -- btuh 7000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 7000 heat pump/cool unit -- annual estimated kwh for heating
ptac -- btuh 9000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 9000 heat pump/cool unit -- annual estimated kwh for heating
ptac -- btuh 12000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 12000 heat pump/cool unit -- annual estimated kwh for heating
ptac -- btuh 15000 heat pump/cool unit -- annual estimated kwh for cooling
ptac -- btuh 15000 heat pump/cool unit -- annual estimated kwh for heating
OPTION #3: If your guestroom has a fan coil unit with an electric heater, first find correct "style" (vertical, low vertical, horizonta
each style has a different color. THEN find the correct blower fan size (by cfm) of the unit. Then copy the WHO
from B thru F) and paste it on worksheet "resold electricity calculation" in cell A17.
vertical fancoil unit (blower fan 200cfm) -- room size less than 250sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
vertical fan coil unit blower fan (800cfm) -- room size 550+ sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (200cfm) -- room size less than 250sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
low vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (200cfm) -- room size less than 250sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (300cfm) -- room size 250-350sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan (800cfm) -- room size 550+ sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (400cfm) -- room size 350-450sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (600cfm) -- room size 450-550sqft
with heater size 2kw (including blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (800cfm) -- room size 550+ sqft
with heater size 2kw (including blower fan)
OPTION #4: If your guestroom has a fan coil unit with fans only (centralized heat and cooling), first find correct "style" (vertical
w/ high static motor) -- each style has a different color. THEN find the correct blower fan size (by cfm) of the unit
lines in the box and from B thru F) and paste it on worksheet "resold electricity calculation" in cell A17.
vertical fancoil unit (blower fan 200cfm) -- room size less than 250sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
vertical fan coil unit blower fan (800cfm) -- room size 550+ sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (200cfm) -- room size less than 250sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (300cfm) -- room size 250-350sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
low vertical fan coil unit blower fan (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (200cfm) -- room size less than 250sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (300cfm) -- room size 250-350sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan (800cfm) -- room size 550+ sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (400cfm) -- room size 350-450sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (600cfm) -- room size 450-550sqft
with no heater (just blower fan)
horizontal (ceiling) fan coil unit blower fan HIGH STATIC (800cfm) -- room size 550+ sqft
with no heater (just blower fan)
e "box" directly below with
in the box and from B thru F) and paste it on worksheet "resold
12,000 or 15,000 btuh units; most rooms should have 7,000 btuh
kWh consumed per year kWh per Rental Day
628 1.93
3442 8.28
837 2.58
4425 10.64
1183 3.64
5958 14.33
1535 4.72
7265 17.47
box" directly below with
in the box and from B thru F) and paste it on worksheet "resold
12,000 or 15,000 btuh units; most rooms should have 7,000 btuh
kWh consumed per year kWh per Rental Day
628 1.93
2504 6.02
837 2.58
3220 7.74
1183 3.64
4353 10.47
1535 4.72
5331 12.82
rtical, low vertical, horizontal, or horizontal w/high static motor) --
e unit. Then copy the WHOLE box (both lines in the box and
kWh consumed per year kWh per Rental Day
55 0.17
3383 8.13
88 0.27
3432 8.25
143 0.44
3515 8.45
198 0.61
3597 8.65
231 0.71
3647 8.77
75 0.23
3412 8.20
149 0.46
3523 8.47
165 0.51
3548 8.53
286 0.88
3729 8.97
55 0.17
3383 8.13
94 0.29
3440 8.27
182 0.56
3572 8.59
182 0.56
3572 8.59
259 0.80
3688 8.87
165 0.51
3548 8.53
198 0.61
3597 8.65
248 0.76
3671 8.83
find correct "style" (vertical, low vertical, horizontal, or horizontal
an size (by cfm) of the unit. Then copy the WHOLE box (both
tion" in cell A17.
kWh consumed per year kWh per Rental Day
55 0.17
83 0.20
88 0.27
132 0.32
143 0.44
215 0.52
198 0.61
297 0.71
231 0.71
347 0.83
75 0.23
112 0.27
149 0.46
223 0.54
165 0.51
248 0.60
286 0.88
429 1.03
55 0.17
83 0.20
94 0.29
140 0.34
182 0.56
272 0.65
182 0.56
272 0.65
259 0.80
388 0.93
165 0.51
248 0.60
198 0.61
297 0.71
248 0.76
371 0.89
e "box" directly below with
in the box and from B thru F) and paste it on worksheet "resold
12,000 or 15,000 btuh units; most rooms should have 7,000 btuh
kWh consumed per year kWh per Rental Day
628 2.42
3442 5.64
837 3.22
4425 7.25
1183 4.55
5958 9.77
1535 5.90
7265 11.91
box" directly below with
in the box and from B thru F) and paste it on worksheet "resold
12,000 or 15,000 btuh units; most rooms should have 7,000 btuh
kWh consumed per year kWh per Rental Day
628 2.42
2504 4.10
837 3.22
3220 5.28
1183 4.55
4353 7.14
1535 5.90
5331 8.74
rtical, low vertical, horizontal, or horizontal w/high static motor) --
e unit. Then copy the WHOLE box (both lines in the box and
kWh consumed per year kWh per Rental Day
55 0.21
3383 5.55
88 0.34
3432 5.63
143 0.55
3515 5.76
198 0.76
3597 5.90
231 0.89
3647 5.98
75 0.29
3412 5.59
149 0.57
3523 5.78
165 0.63
3548 5.82
286 1.10
3729 6.11
55 0.21
3383 5.55
94 0.36
3440 5.64
182 0.70
3572 5.86
182 0.70
3572 5.86
259 1.00
3688 6.05
165 0.63
3548 5.82
198 0.76
3597 5.90
248 0.95
3671 6.02
find correct "style" (vertical, low vertical, horizontal, or horizontal
an size (by cfm) of the unit. Then copy the WHOLE box (both
tion" in cell A17.
kWh consumed per year kWh per Rental Day
55 0.21
83 0.14
88 0.34
132 0.22
143 0.55
215 0.35
198 0.76
297 0.49
231 0.89
347 0.57
75 0.29
112 0.18
149 0.57
223 0.37
165 0.63
248 0.41
286 1.10
429 0.70
55 0.21
83 0.14
94 0.36
140 0.23
182 0.70
272 0.45
182 0.70
272 0.45
259 1.00
388 0.64
165 0.63
248 0.41
198 0.76
297 0.49
248 0.95
371 0.61
Conference Rooms
Lighting 2.4 watts per sq ft (per building code)
hvac 3 watts per sq ft (30btus of cooling per sq ft/10seer=3watts)
5.4 watts per sq ft
average sq ft per conference room
0 wattage per conference room
0 kwh per rented conference room (presumes avg conference
room rented an average of 4 hours per day)
Instructions
1. If your conference rooms do not have their own hvac appliances, delete the 3 watts in cell B4.
2. Determine your average conference room sq footage. For example, if you have 3 conference
rooms, one is 1,000 sq ft and one is 750 sq ft and one is 600 sq ft, your average conference
room's sq footage is 783. Enter your average conference room sq footage in cell B8.
Completing this cell will give you the average resold kWh per rented conference room
3. Fill in the number of conference rooms rented each month in column K. Completing
this column will compute your resold electricity for the conference rooms, as follows:
column L contains a formula that multiplies the number of conference rooms rented by the
resold kWh per rented conference room in cell B12; Column M contains a formula that
multiplies the resold kWh in column L times the cost per kWh (which you entered on
worksheet "resold electricity calculation" in cell E22-28; Column N brings over your sales tax
rate that you've already entered on "resold electricity calculation" worksheet; and Column O
calculates the tax refund on the resold electricity $s in Column M.
4. You are done.
200206
200207
200208
200209
200210
200211
200212
Total
200301
200302
200303
200304
200305
200306
200307
200308
200309
200310
200311
200312
Total
200401
200402
200403
200404
200405
200406
200407
200408
200409
200410
200411
200412
Total
200501
200502
200503
200504
200505
200506
200507
200508
200509
200510
200511
200512
Total
200601
200602
200603
200604
200605
Total
Gr Total
Conference resold
Rooms resold electricity your sales your tax
Period Rented kWh $s tax rate refund
199901 - $0.00 0.000% $0.00
199902 - $0.00 0.000% $0.00
199903 - $0.00 0.000% $0.00
199904 - $0.00 0.000% $0.00
199905 - $0.00 0.000% $0.00
199906 - $0.00 0.000% $0.00
199907 - $0.00 0.000% $0.00
199908 - $0.00 0.000% $0.00
199909 - $0.00 0.000% $0.00
199910 - $0.00 0.000% $0.00
199911 - $0.00 0.000% $0.00
199912 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200001 - $0.00 0.000% $0.00
200002 - $0.00 0.000% $0.00
200003 - $0.00 0.000% $0.00
200004 - $0.00 0.000% $0.00
200005 - $0.00 0.000% $0.00
200006 - $0.00 0.000% $0.00
200007 - $0.00 0.000% $0.00
200008 - $0.00 0.000% $0.00
200009 - $0.00 0.000% $0.00
200010 - $0.00 0.000% $0.00
200011 - $0.00 0.000% $0.00
200012 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200101 - $0.00 0.000% $0.00
200102 - $0.00 0.000% $0.00
200103 - $0.00 0.000% $0.00
200104 - $0.00 0.000% $0.00
200105 - $0.00 0.000% $0.00
200106 - $0.00 0.000% $0.00
200107 - $0.00 0.000% $0.00
200108 - $0.00 0.000% $0.00
200109 - $0.00 0.000% $0.00
200110 - $0.00 0.000% $0.00
200111 - $0.00 0.000% $0.00
200112 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200201 - $0.00 0.000% $0.00
200202 - $0.00 0.000% $0.00
200203 - $0.00 0.000% $0.00
200204 - $0.00 0.000% $0.00
200205 - $0.00 0.000% $0.00
200206 - $0.00 0.000% $0.00
200207 - $0.00 0.000% $0.00
200208 - $0.00 0.000% $0.00
200209 - $0.00 0.000% $0.00
200210 - $0.00 0.000% $0.00
200211 - $0.00 0.000% $0.00
200212 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200301 - $0.00 0.000% $0.00
200302 - $0.00 0.000% $0.00
200303 - $0.00 0.000% $0.00
200304 - $0.00 0.000% $0.00
200305 - $0.00 0.000% $0.00
200306 - $0.00 0.000% $0.00
200307 - $0.00 0.000% $0.00
200308 - $0.00 0.000% $0.00
200309 - $0.00 0.000% $0.00
200310 - $0.00 0.000% $0.00
200311 - $0.00 0.000% $0.00
200312 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200401 - $0.00 0.000% $0.00
200402 - $0.00 0.000% $0.00
200403 - $0.00 0.000% $0.00
200404 - $0.00 0.000% $0.00
200405 - $0.00 0.000% $0.00
200406 - $0.00 0.000% $0.00
200407 - $0.00 0.000% $0.00
200408 - $0.00 0.000% $0.00
200409 - $0.00 0.000% $0.00
200410 - $0.00 0.000% $0.00
200411 - $0.00 0.000% $0.00
200412 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200501 - $0.00 0.000% $0.00
200502 - $0.00 0.000% $0.00
200503 - $0.00 0.000% $0.00
200504 - $0.00 0.000% $0.00
200505 - $0.00 0.000% $0.00
200506 - $0.00 0.000% $0.00
200507 - $0.00 0.000% $0.00
200508 - $0.00 0.000% $0.00
200509 - $0.00 0.000% $0.00
200510 - $0.00 0.000% $0.00
200511 - $0.00 0.000% $0.00
200512 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200601 - $0.00 0.000% $0.00
200602 - $0.00 0.000% $0.00
200603 - $0.00 0.000% $0.00
200604 - $0.00 0.000% $0.00
200605 - $0.00 0.000% $0.00
Total - - $0.00 $0.00
Gr Total - - $0.00 $0.00
Conference Total Gross
Period Guest Rooms Rooms Tax Refund
199901 $0.00 $0.00 $0.00 0
199902 $0.00 $0.00 $0.00 0
199903 $0.00 $0.00 $0.00 0
199904 $0.00 $0.00 $0.00
199905 $0.00 $0.00 $0.00
199906 $0.00 $0.00 $0.00
199907 $0.00 $0.00 $0.00
199908 $0.00 $0.00 $0.00
199909 $0.00 $0.00 $0.00
199910 $0.00 $0.00 $0.00
199911 $0.00 $0.00 $0.00
199912 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
200001 $0.00 $0.00 $0.00
200002 $0.00 $0.00 $0.00
200003 $0.00 $0.00 $0.00
200004 $0.00 $0.00 $0.00
200005 $0.00 $0.00 $0.00
200006 $0.00 $0.00 $0.00
200007 $0.00 $0.00 $0.00
200008 $0.00 $0.00 $0.00
200009 $0.00 $0.00 $0.00
200010 $0.00 $0.00 $0.00
200011 $0.00 $0.00 $0.00
200012 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
200101 $0.00 $0.00 $0.00
200102 $0.00 $0.00 $0.00
200103 $0.00 $0.00 $0.00
200104 $0.00 $0.00 $0.00
200105 $0.00 $0.00 $0.00
200106 $0.00 $0.00 $0.00
200107 $0.00 $0.00 $0.00
200108 $0.00 $0.00 $0.00
200109 $0.00 $0.00 $0.00
200110 $0.00 $0.00 $0.00
200111 $0.00 $0.00 $0.00
200112 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
200201 $0.00 $0.00 $0.00
200202 $0.00 $0.00 $0.00
200203 $0.00 $0.00 $0.00
200204 $0.00 $0.00 $0.00
200205 $0.00 $0.00 $0.00
200206 $0.00 $0.00 $0.00
200207 $0.00 $0.00 $0.00
200208 $0.00 $0.00 $0.00
200209 $0.00 $0.00 $0.00
200210 $0.00 $0.00 $0.00
200211 $0.00 $0.00 $0.00
200212 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
200301 $0.00 $0.00 $0.00
200302 $0.00 $0.00 $0.00
200303 $0.00 $0.00 $0.00
200304 $0.00 $0.00 $0.00
200305 $0.00 $0.00 $0.00
200306 $0.00 $0.00 $0.00
200307 $0.00 $0.00 $0.00
200308 $0.00 $0.00 $0.00
200309 $0.00 $0.00 $0.00
200310 $0.00 $0.00 $0.00
200311 $0.00 $0.00 $0.00
200312 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
200401 $0.00 $0.00 $0.00
200402 $0.00 $0.00 $0.00
200403 $0.00 $0.00 $0.00
200404 $0.00 $0.00 $0.00
200405 $0.00 $0.00 $0.00
200406 $0.00 $0.00 $0.00
200407 $0.00 $0.00 $0.00
200408 $0.00 $0.00 $0.00
200409 $0.00 $0.00 $0.00
200410 $0.00 $0.00 $0.00
200411 $0.00 $0.00 $0.00
200412 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
200501 $0.00 $0.00 $0.00
200502 $0.00 $0.00 $0.00
200503 $0.00 $0.00 $0.00
200504 $0.00 $0.00 $0.00
200505 $0.00 $0.00 $0.00
200506 $0.00 $0.00 $0.00
200507 $0.00 $0.00 $0.00
200508 $0.00 $0.00 $0.00
200509 $0.00 $0.00 $0.00
200510 $0.00 $0.00 $0.00
200511 $0.00 $0.00 $0.00
200512 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
200601 $0.00 $0.00 $0.00
200602 $0.00 $0.00 $0.00
200603 $0.00 $0.00 $0.00
200604 $0.00 $0.00 $0.00
200605 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00
Gr Total $0.00 $0.00 $0.00
Water Sold in Guest Rooms
Minutes of Use (A) Flow rate of fixture (B) Usage per Guest
Bathroom sink 1 2 2
Minutes of Use (C) Flow rate of fixture (D) Usage per Guest
Shower 9 1.5 14
# of Uses (C) Gallons per Flush (E) Usage per Guest
Toilet 3 1.6 5
Total Resold Gallons of Water per Guest per day 21
gallons divided by 748 = resold ccfs per guest per day 0.028075
your cost per ccf/gallon (1999)
(A) 4 times @ 15 seconds -- from EPA hotel water usage study your cost per ccf/gallon (2000)
(B) typically ranges from 2 - 5 gallons per minute (gpm) your cost per ccf/gallon (2001)
(C) each person takes 1.2 showers per day for 8 minutes each your cost per ccf/gallon (2002)
or 9 minutes total & flushes 3 times -- from EPA hotel your cost per ccf/gallon (2003)
water usage study your cost per ccf/gallon (2004)
(D) typically ranges from 1.5 - 6 gallons per minute (gpm) your cost per ccf/gallon (2005)
(E) typically ranges from 1.6 - 5 gallons per flush (gpf)) your cost per ccf/gallon (2006)
Instructions
1. If your hotel was built after 1994, your guestroom should have low
flow fixtures. These low flow rates have already been posted
above in cells D3, D6, and D9. If your hotel was built before
1994, enter your fixture flow rates in cells D3, D6, and D9.
2. If your typical guestroom has a whirlpool or jacuzzi, please contact
Jane Gardner at the MO Dept of Revenue at 417-895-6477 to add
this appliance.
3. Cell F13 shows your total resold gallons per guest per day; Cell F15
converts the resold gallons per guest per day to CCFs per guest per day.
4. Resold water usage is per GUEST. If you have the number of Guests per
month, you may replace the heading in Column J with "# of Guests"
and provide that information per period. If not, the water refund
schedule brings over the number of Guest Rooms Rented that was
entered on the "resold electricity calculation" worksheet and we will
use the number of guest rooms rented as the number of guests.
5. Examine your water bills to determine if your water utility bills
your usage in GALLONS of CCFs. The refund worksheet presumes
that your water utility bills your usage in CCFs. If not and water is
billed in GALLONs, change the formula in column K to read "$F$13"
instead of "$F$15".
6. Determine your average cost per ccf (or gallon) per calendar year -- take a couple of
water bills in each calendar year, divide the water usage charge
(do NOT include sewer charges) by the ccfs (or gallons) purchased.
Enter this cost in cells F17 - F23. Filling in these cells will complete your
tax refund schedule on your resold water.
7. PROVIDE copies of water bills for each month of the refund claim period
unless the utility is able to provide this information for you.
8. GO TO worksheet tab "conference room calc" if you have conference
rooms. If you do not, you are done.
this ccf factor will be multiplied by the number of hotel paying guests each month to get
the total ccfs of water resold; then the total ccfs of resold water will be multiplied by the
$ charged per ccf by the water company to get the total water $s resold, then times the
sales tax rate of the hotel to get the refund
20041
20041
20041
Total
20050
20050
20050
20050
20050
20050
20050
20050
20050
20051
20051
20051
Total
20060
20060
20060
20060
20060
Total
Gr Total
Guest Resold
Rooms Gals or Resold your sales your tax
Period Rented CCFs Water $s tax rate refund
199901 - - $0.00 0.000% $0.00 0
199902 - - $0.00 0.000% $0.00 0
199903 - - $0.00 0.000% $0.00 0
199904 - - $0.00 0.000% $0.00
199905 - - $0.00 0.000% $0.00
199906 - - $0.00 0.000% $0.00
199907 - - $0.00 0.000% $0.00
199908 - - $0.00 0.000% $0.00
199909 - - $0.00 0.000% $0.00
199910 - - $0.00 0.000% $0.00
199911 - - $0.00 0.000% $0.00
199912 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200001 - - $0.00 0.000% $0.00
200002 - - $0.00 0.000% $0.00
200003 - - $0.00 0.000% $0.00
200004 - - $0.00 0.000% $0.00
200005 - - $0.00 0.000% $0.00
200006 - - $0.00 0.000% $0.00
200007 - - $0.00 0.000% $0.00
200008 - - $0.00 0.000% $0.00
200009 - - $0.00 0.000% $0.00
200010 - - $0.00 0.000% $0.00
200011 - - $0.00 0.000% $0.00
200012 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200101 - - $0.00 0.000% $0.00
200102 - - $0.00 0.000% $0.00
200103 - - $0.00 0.000% $0.00
200104 - - $0.00 0.000% $0.00
200105 - - $0.00 0.000% $0.00
200106 - - $0.00 0.000% $0.00
200107 - - $0.00 0.000% $0.00
200108 - - $0.00 0.000% $0.00
200109 - - $0.00 0.000% $0.00
200110 - - $0.00 0.000% $0.00
200111 - - $0.00 0.000% $0.00
200112 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200201 - - $0.00 0.000% $0.00
200202 - - $0.00 0.000% $0.00
200203 - - $0.00 0.000% $0.00
200204 - - $0.00 0.000% $0.00
200205 - - $0.00 0.000% $0.00
200206 - - $0.00 0.000% $0.00
200207 - - $0.00 0.000% $0.00
200208 - - $0.00 0.000% $0.00
200209 - - $0.00 0.000% $0.00
200210 - - $0.00 0.000% $0.00
200211 - - $0.00 0.000% $0.00
200212 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200301 - - $0.00 0.000% $0.00
200302 - - $0.00 0.000% $0.00
200303 - - $0.00 0.000% $0.00
200304 - - $0.00 0.000% $0.00
200305 - - $0.00 0.000% $0.00
200306 - - $0.00 0.000% $0.00
200307 - - $0.00 0.000% $0.00
200308 - - $0.00 0.000% $0.00
200309 - - $0.00 0.000% $0.00
200310 - - $0.00 0.000% $0.00
200311 - - $0.00 0.000% $0.00
200312 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200401 - - $0.00 0.000% $0.00
200402 - - $0.00 0.000% $0.00
200403 - - $0.00 0.000% $0.00
200404 - - $0.00 0.000% $0.00
200405 - - $0.00 0.000% $0.00
200406 - - $0.00 0.000% $0.00
200407 - - $0.00 0.000% $0.00
200408 - - $0.00 0.000% $0.00
200409 - - $0.00 0.000% $0.00
200410 - - $0.00 0.000% $0.00
200411 - - $0.00 0.000% $0.00
200412 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200501 - - $0.00 0.000% $0.00
200502 - - $0.00 0.000% $0.00
200503 - - $0.00 0.000% $0.00
200504 - - $0.00 0.000% $0.00
200505 - - $0.00 0.000% $0.00
200506 - - $0.00 0.000% $0.00
200507 - - $0.00 0.000% $0.00
200508 - - $0.00 0.000% $0.00
200509 - - $0.00 0.000% $0.00
200510 - - $0.00 0.000% $0.00
200511 - - $0.00 0.000% $0.00
200512 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
200601 - - $0.00 0.000% $0.00
200602 - - $0.00 0.000% $0.00
200603 - - $0.00 0.000% $0.00
200604 - - $0.00 0.000% $0.00
200605 - - $0.00 0.000% $0.00
Total - - $0.00 $0.00
Gr Total - - $0.00 $0.00