please answer question 3-24 only using this table thank you!!
TO2 PART II Planning The department will also pay $100 to clean the hall after each concert and $50 per concert for student hers. It will also spend $200 on promotion for each concert and $75 per concert for insurance Ticket and program costs will reage $0.75 per attendee Finally, the department needs to buy a tuba at a cost of $4,000, a baritone saxophone for $2.500, and a full set of percussion instruments at a cost of 57 soo. It figures that the instruments will last only s years and will not be able to be sold for anything after 5 years. The department will also need to buy 30 sets of band music pages at an average cost of Sigeperst. The music pages often get lost, so the department wants to treat the sets as an expense in the year they are acquired *3-as, kefer to Problem 2-29 in Chapter 2. Assuming that the mix of visitors does not change provide a budget assuming admissions are 10 percent lower and 10 percent higher than expected. MR uses straight-line depreciation Salvage value of the kennel and related equipment: $0 MR has three full-time employees an executive director who earns $40.000 per year, an evaluator/ trainer who earns $30,000 per year, anda kennel manager who earns $25.000. Fringe benefits are equal to 25 percent of each employees annual salary MR expects to place all the dogs that it takes into the program by the last day of the fiscal year. It charges an adoption fee of $225 per dag. Experience has shown that is percent of the people elect to make an additional donation to MR at the time of adoption Historically, these extra donations have averaged $175. In addition, MR has an active fundraising program and expects to raise $40,000 in donations during the fiscal year *3-24 Stratton County Community College is adding a band program that will be open to college students and also to the community. The music department chair has asked you to prepare a special purpose badget for the program for the next two semesters. Prepare the budget for the full academic year using an accrual basis using the following information: The band will derive revenge from the sources Students enrolled in and classes will pay $425 per semester. The college has two semesters each year. Community members will pay $50 per semester to play in the band but will not receive course credit. The only other revenue will come from the sale of tickets to the six concerts that the band intends to give each academic year. The faculty expects to have 35 students enrolled in band dasses each semester and also expects another 20 people from the community to play in the band each semester. Based on discussions with other universities, Stratton expects its concerts to attract 300 people on average and expects to charge $2.50 per ticket To run the band program, Stratton will have to hire a graduate assistant at a cost of $15.000 per academic year (two semesters). It will also have to rent an average of 10 brass and 15 woodwind instruments per semester. Brass instrument rentals will average S90 per semester per instrument and woodwinds will cost $50 per instrument per semester. The band will rent rehearsal space from the local high school at a cost of $250 per night. The band will meet one night each week for 15 weeks in each semester 3-26. The Free Health Care Center (FH) charges each patient $550 (not quite free after all, but pretty dose). Due to rising costs, the center has been forced to consider raising this charge to $6.00 or $6.50. If the price goes up, fewer people will come to the center for care. At a price of $6.00 only 18,000 patients are expected, and at a price of $6.50 there will likely be only 16,000 patients. Prepare a flexible budget for the FH at prices of $5-50, $6.00, and $6.50. The variable cost per patient is $4, and the fraud costs of operating the center are $32,000. The Fil currently expects to have about 20,000 patient visits. What do you recommend the clinic do? Why? 3-27. The Georgeville city government provides a wide variety of services to the community. Among them is the protection provided by the police force. In order to provide that force, it spends $3 million on salaries, $200,000 n vehicle costs, and $300,000 on supplies The police force expects to have 7.000 measurable actions, consisting of 1,000 arrests, 4,000 traffic citations, and 2,000 responses to emergency calls. It has noted that the average cost for each one of these actions is $429 if you simply divide the $3 million department cost by the 7,000 specific individual actions. Some have argued that it is not cost-effective to give out traffic tickets since the $429 cost per ticket exceeds the fine collected. The Georgeville Police Department is considering adopting a performance budget. The performance areas would be arrests, citations, and emergency responses 49 Inputs 50 Student tuition (per semester) 51 Semesters per year 52 Student enrollment per semester 53 Community members fees 54 Community members in band 55 Concerts per year 56 Average concert attendance 57 Concert ticket price 58 Ticket & program costs (per attendee) 59 Concert Cleaning (per concert) 60 Student Ushers (per concert) 61 Concert Promotion (per concert) 62 Concert Insurance (per concert) 63 Graduate Assistant (per year) 64 Instrument Purchases 65 Useful life Number Unit Cost $ 56 57 Brass rental (per semester) 58 Woodwind rental (per semester) 59 Rehearsal Space (per semester) 20 Music (per year) 71 Stratton County Community 72 College Band 73 Revenue 74 Tuition 35 Community Musicians 76 Concert Revenues 77 Total Revenue 78 79 Expenses 80 Salaries 81 Instrument Rental 82 Instrument Depreciation 83 Music 84 Rehearsal Space Rental 85 Variable Concert Costs 86 Fixed Concert Costs 87 88 Total Expenses 89 90 Suplus/(Deficit) 91 Sheet1 $ $ Ready TO2 PART II Planning The department will also pay $100 to clean the hall after each concert and $50 per concert for student hers. It will also spend $200 on promotion for each concert and $75 per concert for insurance Ticket and program costs will reage $0.75 per attendee Finally, the department needs to buy a tuba at a cost of $4,000, a baritone saxophone for $2.500, and a full set of percussion instruments at a cost of 57 soo. It figures that the instruments will last only s years and will not be able to be sold for anything after 5 years. The department will also need to buy 30 sets of band music pages at an average cost of Sigeperst. The music pages often get lost, so the department wants to treat the sets as an expense in the year they are acquired *3-as, kefer to Problem 2-29 in Chapter 2. Assuming that the mix of visitors does not change provide a budget assuming admissions are 10 percent lower and 10 percent higher than expected. MR uses straight-line depreciation Salvage value of the kennel and related equipment: $0 MR has three full-time employees an executive director who earns $40.000 per year, an evaluator/ trainer who earns $30,000 per year, anda kennel manager who earns $25.000. Fringe benefits are equal to 25 percent of each employees annual salary MR expects to place all the dogs that it takes into the program by the last day of the fiscal year. It charges an adoption fee of $225 per dag. Experience has shown that is percent of the people elect to make an additional donation to MR at the time of adoption Historically, these extra donations have averaged $175. In addition, MR has an active fundraising program and expects to raise $40,000 in donations during the fiscal year *3-24 Stratton County Community College is adding a band program that will be open to college students and also to the community. The music department chair has asked you to prepare a special purpose badget for the program for the next two semesters. Prepare the budget for the full academic year using an accrual basis using the following information: The band will derive revenge from the sources Students enrolled in and classes will pay $425 per semester. The college has two semesters each year. Community members will pay $50 per semester to play in the band but will not receive course credit. The only other revenue will come from the sale of tickets to the six concerts that the band intends to give each academic year. The faculty expects to have 35 students enrolled in band dasses each semester and also expects another 20 people from the community to play in the band each semester. Based on discussions with other universities, Stratton expects its concerts to attract 300 people on average and expects to charge $2.50 per ticket To run the band program, Stratton will have to hire a graduate assistant at a cost of $15.000 per academic year (two semesters). It will also have to rent an average of 10 brass and 15 woodwind instruments per semester. Brass instrument rentals will average S90 per semester per instrument and woodwinds will cost $50 per instrument per semester. The band will rent rehearsal space from the local high school at a cost of $250 per night. The band will meet one night each week for 15 weeks in each semester 3-26. The Free Health Care Center (FH) charges each patient $550 (not quite free after all, but pretty dose). Due to rising costs, the center has been forced to consider raising this charge to $6.00 or $6.50. If the price goes up, fewer people will come to the center for care. At a price of $6.00 only 18,000 patients are expected, and at a price of $6.50 there will likely be only 16,000 patients. Prepare a flexible budget for the FH at prices of $5-50, $6.00, and $6.50. The variable cost per patient is $4, and the fraud costs of operating the center are $32,000. The Fil currently expects to have about 20,000 patient visits. What do you recommend the clinic do? Why? 3-27. The Georgeville city government provides a wide variety of services to the community. Among them is the protection provided by the police force. In order to provide that force, it spends $3 million on salaries, $200,000 n vehicle costs, and $300,000 on supplies The police force expects to have 7.000 measurable actions, consisting of 1,000 arrests, 4,000 traffic citations, and 2,000 responses to emergency calls. It has noted that the average cost for each one of these actions is $429 if you simply divide the $3 million department cost by the 7,000 specific individual actions. Some have argued that it is not cost-effective to give out traffic tickets since the $429 cost per ticket exceeds the fine collected. The Georgeville Police Department is considering adopting a performance budget. The performance areas would be arrests, citations, and emergency responses 49 Inputs 50 Student tuition (per semester) 51 Semesters per year 52 Student enrollment per semester 53 Community members fees 54 Community members in band 55 Concerts per year 56 Average concert attendance 57 Concert ticket price 58 Ticket & program costs (per attendee) 59 Concert Cleaning (per concert) 60 Student Ushers (per concert) 61 Concert Promotion (per concert) 62 Concert Insurance (per concert) 63 Graduate Assistant (per year) 64 Instrument Purchases 65 Useful life Number Unit Cost $ 56 57 Brass rental (per semester) 58 Woodwind rental (per semester) 59 Rehearsal Space (per semester) 20 Music (per year) 71 Stratton County Community 72 College Band 73 Revenue 74 Tuition 35 Community Musicians 76 Concert Revenues 77 Total Revenue 78 79 Expenses 80 Salaries 81 Instrument Rental 82 Instrument Depreciation 83 Music 84 Rehearsal Space Rental 85 Variable Concert Costs 86 Fixed Concert Costs 87 88 Total Expenses 89 90 Suplus/(Deficit) 91 Sheet1 $ $ Ready
