Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Using the table below to create the schedule During the school year, the Hometea

ID: 2334392 • Letter: U

Question

Using the table below to create the schedule

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 rating expenses through events in the local community such as car washes. To estimate its expenses for the 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 September October November December anuary Scheduled Concerts Month Scheduled Concerts February March April May 3 8 Requirement Prepare a monthly schedule estimating the band's travel expenses

Explanation / Answer

HOME TEAM SCHOOL BAND ESTIMATED TRAVEL EXPENSES MONTH HOTEL FOOD BUS OTHER TOTAL SEPTEMBER 1800 780 1600 400 4580 OCTOBER 2700 1170 2400 600 6870 NOVEMBER 4500 1950 4000 1000 11450 DECEMBER 7200 3120 6400 1600 18320 JANUARY 2700 1170 2400 600 6870 FEBUARY 4500 1950 4000 1000 11450 MARCH 3600 1560 3200 800 9160 APRIL 5400 2340 4800 1200 13740 MAY 6300 2730 5600 1400 16030