10-53 Financial budgets: expense budget During the school year, the Happy Valley 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, January through September. For each concert, the manager estimates hotel costs of $1,000, food costs of $500, bus rental costs of $600, and other costs of $300. The following table presents the number of planned concerts during the upcoming year: HAPPY VALLEY SCHOOL BAND SCHEDULED CONCERTS MONTH January February March April May SCHEDULED CONCERTS MONTH SCHEDULED CONCERTS 4 6 5 2 3 June July August September 8 6 4 5 Required Prepare a monthly schedule estimating the band's travel expenses.