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 bands travel expenses.

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

March
April
May