During the school year, the Hilton 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 $ 925, food costs of $ 400, bus rental costs of $ 500, and other costs of $ 250. The following table presents the number of planned concerts during the upcoming year:

Month Scheduled Concerts month scheduled concerts

September 4 February 3

October 2 March 4

November 7 April 6

December 8 May 7

January 4

Requirement:

Prepaire a monthly schedule estimating the bands travel expenses

Month	hotel	food	bus	other	total
September
October
November
December
January
February
March
April
May