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 washes. To estimate its expenses for the upcoming year, the band's 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 $390, bus rental costs of $800, and other costs of $200.

Hometeam School Band Scheduled Concerts

Month

Scheduled Concerts

Month

Scheduled Concerts

September

2

February

5

October

3

March

4

November

5

April

6

December

8

May

7

January

3

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