In this project, you will examine a soig liter functions to model ve cost and protit functions as certain satiables de changed. For your grade, you will turn in a written uport doe in Moodle by Sunday, February 28) with the following 1. Complete solutions to all problem parts. Your solutions are to be typed Beatly and in complete te 2. Exceel graphs of the relevant cost and ease functions (os specified in the question). Grades will be based on the following components Solutions are written in complete settes . Game is correct Mathematical Content Solutions are correct Reports contain complete solutions to all questions Scale(s) cheon Excel graples male sense in context Project Questions Southwest Hospital hures an operating to sed only for eve surgery. The cost of rent heat, and electricity for the operating room and its $360,000, and the man salaries of the staff for this room total to $500.000. Each surgery performed requires the of $760 worth of medical supplies and drugs. To promote goodwill every patient receives a botiquet of Homes the day after surgery. In addition, one quarter of patients retire dark slus, which the hospital provides free of charge. It costs the hospital $30 for each bosquet of flowers and $10 for each pair of glasses. The hospital receives a payment of $2000 for each eye operation performed 1. Identify the revente perse and the anal fixed and variable conts for running the operating room. Use these values to construct cost and function, with representing the number of operations performed per year. Us Excel to graph these functions over an appropriate range of valux 2. How many we operation test the hospital perform each year in ceder to break even? 3. Southwest Hospital currently averages 70 eye operation per month One of the muses w jest barned about a machine that would reduce by $100 per patient the amount of medical supplies needed. It can be used for $100.000 antally keeping in mind the financial cost and benefits, advise the hospital on whether it should we this machine Use Escelto grape the cost and revente functivities in this ajusted to 4. An advertising ency has propued to the hospital's president that she spend $20.000 per month on television and to advertising to persuade people that Southwest Hop tal is the best place to use any surgery performed. Advertising account cutives estimate that such publicity would increase business by 40 operations per month they are correct and if this increase is not large cough to affect fixed costs, what impact would this advertising hunve on the hospitale pirofits? Use Excel to staple the cost and revenue functions in this scenario 5 In case the advertising agency is being overly optimistic, how many extra operations per month are needed to cover the cont of the proposed ads? 6. If the campaign is approved and subsequently meets its projection should the hospital review ita decision about the machine damed in Question 3? In this project, you will examine a soig liter functions to model ve cost and protit functions as certain satiables de changed. For your grade, you will turn in a written uport doe in Moodle by Sunday, February 28) with the following 1. Complete solutions to all problem parts. Your solutions are to be typed Beatly and in complete te 2. Exceel graphs of the relevant cost and ease functions (os specified in the question). Grades will be based on the following components Solutions are written in complete settes . Game is correct Mathematical Content Solutions are correct Reports contain complete solutions to all questions Scale(s) cheon Excel graples male sense in context Project Questions Southwest Hospital hures an operating to sed only for eve surgery. The cost of rent heat, and electricity for the operating room and its $360,000, and the man salaries of the staff for this room total to $500.000. Each surgery performed requires the of $760 worth of medical supplies and drugs. To promote goodwill every patient receives a botiquet of Homes the day after surgery. In addition, one quarter of patients retire dark slus, which the hospital provides free of charge. It costs the hospital $30 for each bosquet of flowers and $10 for each pair of glasses. The hospital receives a payment of $2000 for each eye operation performed 1. Identify the revente perse and the anal fixed and variable conts for running the operating room. Use these values to construct cost and function, with representing the number of operations performed per year. Us Excel to graph these functions over an appropriate range of valux 2. How many we operation test the hospital perform each year in ceder to break even? 3. Southwest Hospital currently averages 70 eye operation per month One of the muses w jest barned about a machine that would reduce by $100 per patient the amount of medical supplies needed. It can be used for $100.000 antally keeping in mind the financial cost and benefits, advise the hospital on whether it should we this machine Use Escelto grape the cost and revente functivities in this ajusted to 4. An advertising ency has propued to the hospital's president that she spend $20.000 per month on television and to advertising to persuade people that Southwest Hop tal is the best place to use any surgery performed. Advertising account cutives estimate that such publicity would increase business by 40 operations per month they are correct and if this increase is not large cough to affect fixed costs, what impact would this advertising hunve on the hospitale pirofits? Use Excel to staple the cost and revenue functions in this scenario 5 In case the advertising agency is being overly optimistic, how many extra operations per month are needed to cover the cont of the proposed ads? 6. If the campaign is approved and subsequently meets its projection should the hospital review ita decision about the machine damed in Question 3