Question

During the school year, the hometeam school band arranges concert dates in many communities. Because only part of the school's travel expenses are covered by the concert admission fees, the band raises money to help defray its operating expenses through events in the local community such as car washer. To estimate its expenses for the upcoming year, the bands manager has estimated the number of concert dates for each of the school months, September through May. For each concert, the manager estimates hotel costs of $900, food costs of $430, bus rental costs of $500, and other costs of $160. The following table presents the number of planned concerts during the upcoming year.

Hometeam School Band Scheduled Concerts
Month	Scheduled Concerts	Month	Scheduled Concerts
September	2	February	4
October	5	March	5
November	4	April	6
December	9	May	7
January	5

Requirement:

Prepare a monthly schedule estimating the band’s travel expenses.

Hometeam School Band Estimated Travel Expenses
Month	Hotel	Food	Bus	Other	Total
September
October
November
December
January
February

March
April
May

Answer 1

Monthly schedule estimating the band’s travel expenses.

Hometeam School Band Estimated Travel Expenses
Month	Hotel	Food	Bus	Other	Total
September	900*2=1800	430*2=860	500*2=1000	160*2=320	3980
October	900*5=4500	430*5=2150	500*5=2500	160*5=800	9950
November	900*4=3600	430*4=1720	500*4=2000	160*4=640	7960
December	900*9=8100	430*9=3870	500*9=4500	160*9=1440	17910
January	900*5=4500	430*5=2150	500*5=2500	160*5=800	9950
February	900*4=3600	430*4=1720	500*4=2000	160*4=640	7960

March	900*5=4500	430*5=2150	500*5=2500	160*5=800	9950
April	900*6=5400	430*6=2580	500*6=3000	160*6=960	11940
May	900*7=6300	430*7=3010	500*7=3500	160*7=1120	13930