Question 9 5 points Save Ans Open Excel follows these instructions The executive director of Mutt Rescue (MR) animal shelter has asked you to prepare an annual line-item budget for the coming fiscal year as well as a flexible budget based on a 7 percent increase in the number of dogs taken into MR's shelter during the year. Besides the line items, be sure to provide total revenues, total expenses, and profit (or loss) information, When finished, save the spreadsheet as lastname.firstname.shelter and upload it to this question. She has given you the following information: Number of dogs rescued and placed is 800 e Average length of stay at the shelter per dog is 14 days . Daily cost of feeding one dog is $1.15 e Average number of veterinary visits per dog is 1.3 visits . Cost per veterinary visit is $45 Cost of spayeuter and transportation is $75 per dog rescued. Every dog is spayed or neutered Cost of the kennel and related equipment is $400,000 with a useful life of 20 years with no salvage value. The organization uses straight-line depreciation There are three full-time employees: an executive director who earns $40,000, a trainer who earns $30,000, and a kennel manager who earns $25,000. Fringe benefits are equal to 25 percent of each employees annual salary In addition, the shelter expects to place all of the dogs that it takes into the program by the last day of the fiscal year. It charges an adoption fee of $250 per dog. Experience shows that 15 percent of the people who adopt a dog give an extra $100 at the time of adoption. Finally, the shelter actively fundraises and expects to raise an additional $45,000 in donations during the iscal year Attach File Browse My Computer Browse Content Collection Browse Dropbox Moving to the next question prevents changes to this answer Question 9 of 33 MacBook Air F1O F12 7 8 0