You are the manager of a 325 room hotel which has an 83% average occupancy rate

You are the manager of a 325 room hotel which has an 83% average occupancy rate and an ADR of $139.80. Twenty-two percent (22%) of your occupied rooms are occupied rooms are occupied by 2 registered guest. Seven percent (7%) of your rooms are occupied by 3 guests. Your hotel has a restaurant that seats 350 guest and you do 3.2 turns in the restaurant each day. The hotel has a small banquet room that seats 50 people. You have 3 banquets plan for the month of June, the first is for 27 guests, the second is for 12 guest, and the third is for 31 guest. In each banquet each guest will be served a meal. On average 13% of your occupied rooms order 1.2 meals through room service in your hotel each day. The A/C blower motor which serves you public areas is a 20 horse power motor. The A/C blower motor that supplies your restaurant and banquet room is a 15 horse power motor. You have 100,000 cubic feet of public space and the restaurant and banquet room have 40,000 cubic feet of space. You keep the inside temperature of the hotel set at 75 degrees. Each person staying in your hotel soils 5 ½ pound of linen per day and each cover served results in ¾ pound of soiled linen. The average outside temperature for the month June is 82 degrees and June has 30 days.
 
Factors: 0.125/mcf/cdd
                                    0.75/Hp/cdd
Given that you pay the following cost information for electricity and water:
Electricity: $0.076/kWh
Water Rate: First 75 ccf @ $0.30 per ccf
                                    Next 270 ccf @ $0.37 per ccf
                                    All over 345 ccf @ $0.44 per ccf
Water Surcharge: A surcharge of 5.5% will be added to all water bills.
Sewer Rate: Commercial Sewer Rate: 255.5% of water bill (combined cost of water and water surcharge)
Sewer Surcharge: A surcharge of 5.5% will be added to all sewer bills
Given the following usage rates:
USAGE PER WATER ELECTRICITY
occupied room 225 gal 14 kWh
cover served 10 gal 1 kWh
pound soiled lined 4 gal 0.1 kWh
 
Answer the follow:
What is your forecasted electrical consumption (kWh and $) in the public areas and the restaurant for air conditioning for June using A/C horsepower to forecasted electrical consumption? __________ kWh $__________What is your forecasted electrical consumption (kWh and $) in the public areas and the restaurant for air conditioning for June using square footage to forecasted electrical consumption? __________ kWh $__________What is your foretasted electrical consumption (kWh and $) based on the number of occupied rooms, covers sold, and pounds of soiled linen?     __________ kWh $__________
What is your forecasted water consumption for the operation in hundreds of cubic feet and dollars? __________ ccf $__________What is your forecasted sewer cost for the operation in dollars? $__________What is your forecasted water and sewer cost for the operation in dollars? $__________