Reference no: EM132004443
Question - As the volunteer business manager for the New City Band (City Band), you are responsible for preparing the operating budget for the organization's upcoming summer concert season. Each year, City Band presents up to 20 weekend performances, depending on weather conditions. The concerts are free to the public, but the band hangs a pot from the bandstand and people leave small donations in it. On average, City Band gets $100 in donations at each of its performances. In addition to donations, New City pays the band $3,000 per season plus $125 for each performance.
City Band also has a small endowment of $100,000 on which it expects to earn 3.5 percent in the coming fiscal year. City Band's trustees have decided to use that money to pay for operating expenses if they need to.
City Band pays its conductor $3,000 for the summer season and has an insurance policy to protect it against any loss of equipment or damage to the bandstand. That policy costs the band $500 for the summer plus $25 per performance.
New music costs the band $200 per year. Following Generally Accepted Accounting Principles, the band recognizes music acquisitions as expenses in the year the music is acquired. In addition, City Band pays music publishers an average of $40 per concert for the rights to perform certain pieces in its repertoire. The band has an average of 60 musicians at each of its performances. Each musician is paid $5 per performance.
Question 1. Prepare an operating budget for City Band for the coming fiscal year assuming the band performs on each of its 20 scheduled concert dates.
Question 2. Prepare a flexible budget showing what would happen if the band could only perform on 80 percent of its scheduled concert dates.
Question 3. Calculate City Band's total contribution margin per concert.
Lately, some of City Band's older musicians have been having difficulty climbing the stairs to get up to the bandstand. In addition, there are two disabled musicians who play at all of the band's rehearsals but are reluctant to play at the concerts because of the difficulty they have accessing the bandstand.
City Band's trustees would like to accommodate both groups of musicians. They have gotten an estimate of $10,000 to make the bandstand accessible. You have lined up a 10-year, 500$ per year grant from the State Office of Disabilities and a five-year, 750$ per year grant from the Federal Office of the Ageing to help pay for the modifications to the bandstand. In addition, the local chapter of the Knights of Columbus has offered to donate $1,500 toward the project.
Question 4. If City Band's cost of capital is 6 percent, should it invest in the bandstand modifications based solely on the Knight's donation and the proceeds from the grants? Support your answer with the appropriate time value of money calculations.
City Band expected to hold 20 concerts during its last summer concert season and pay an average of 60 musicians $5 per concert for their performances. At the end of the summer, the band had only been able to perform 16 times. The other four performances were rained out. Because of the shortened concert season, the trustees decided to pay the musicians who came to the concerts $6 per performance. On average, 55 musicians were at each performance.
Question 5: Calculate City Band's total musician's stipend expense variance for the season. Indicate whether that variance was favorable or unfavorable. Calculate the portion of that variance that was due to volume. Indicate whether that variance was favorable or unfavorable. Calculate the portion of that variance that was due to quantity. Indicate whether that variance was favorable or unfavorable. Calculate the portion of that variance that was due to rate paid to the musicians. Indicate whether that variance was favorable or unfavorable.