This assignment will be submitted to Turnitin®.
Instructions
Instructions: Upon completing the Tulsa Memorial Hospital Case Study found in the Pink and Song text, complete the Assignment #3 Excel spreadsheet linked below. Responses to the “Question Set” (located on the bottom left tab of the spreadsheet) should be in Times New Roman, 12-point font, and answered using the text-wrap feature in the same cell as the question. Remember to use the spreadsheet labeled “Model” (located on the bottom left tab of the spreadsheet) to assist with your calculations. Your completed file should be named using the First initial of your first name_Your last name_Module 3 Homework (i.e., J_Smith_Module 3 Homework).
Questions: (Found on the Question Set tab of Assignment #3 Excel spreadsheet)
What are the projected revenues, expenses, and profits or losses of the urgent-care center if volume continues at the current level? That is, construct a pro forma operating statement using the historical data provided to project into the future. Then project that into the future in 2023; that is, what would this pro forma look like if costs increased at 2 percent and revenues 5 percent per year (that is, five years from now)? [Note: To compound inflation, raise your inflation factor to the exponent 5].
How many visits per day are required for breakeven operations without a new marketing program? How does this relate to the current volume?
Now, assume the incremental costs are added to increase volume. Use the data from the incremental monthly cost section. Use the spreadsheet model to estimate how it changes the additional visits-per-day necessary.
What happens to breakeven with the new marketing program? Use the spreadsheet to assist you in your analysis.
For the live session, prepare a list of the areas that cause you concern. What is uncertain?
Submission Instructions:
Before submitting your homework assignment, be sure to review the Case Study Assignment Grading Rubric.
When you have completed work on the “Model” tab and responded to all items in the “Question Set” tab of Assignment #3, please upload your work below as an Excel spreadsheet. All assignments should be completed and uploaded prior to the live session.
When your assignment has been graded, the system will notify you that a grade has been ‘returned.’ This means your instructor has graded the assignment, not that it is being rejected.
Module 3 Homework.xlsx
