Please see attachment

Intro
    Project 2    Please use this template provided to solve project 2 that contains 2 parts. Save your file using your first initial, last name, and project 2.
    Name: TYPE in your name here    Upload your solution to the project 2 link. Make sure you type your name in cell A2
        You should always verify that your project file has been uploaded co
ectly. Remember it is your
        responsibility to take the time to verify that your file has uploaded co
ectly.  If there are problems, please contact me immediately.
        You will be graded on the accuracy of your answer and the usage of excel.
        The project solution is worth a total of 30 pts.
        Remember to review the eLectures and guided examples in MBC. Also, there is support material on cost-profit-volume analysis in the Module 16 folder and relevant cost analysis in Module 17 folder.
        Keep in mind that even though this project focuses on material from Modules 16 and 17, but it is building on the concepts learned in Module 15 on cost behavior.
    Project 2 Objectives:
    1. Develop Contribution Income statement.
    2. Develop unit contribution margin.
    3. Perform Breakeven Analysis.
    4. Calculate and analyze operating leverage.
    5. Evaluate and recommend how to plan for increase in patient demand
    6. Evaluating relevant costs for decision making purposes
    Grading Ru
ic:    Points
    Part 1:
    #1    3.5
    #2    2
    #3    2
    #4    3
    #5    2
    #6    2
    #7    3.5
    #8    2
    #9    4
    Part 2:
    #1    2
    #2    2
    #3    2
    Total points    30
Project 1 Part 1
    Project 2 -Part 1
    Helping Hospital operates a general hospital but rents space to separately owned entities rendering specialized services such as pediatrics and psychiatry.
    Helping Hospital charges each separate entity for patients’ services (Meals and laundry) and for administrative services (billings and collections). Space and bed rentals are fixed charges for the year, based on bed capacity rented to each entity.
        Helping Hospital charged the following costs to Pediatrics for the year ended June 30, 2019.
            Patient Services    Bed Capacity
            (Variable cost)    (Fixed Cost)
        Dietary    $560,000
        Janitorial        $70,000
        Laundry    300,000
        Laboratory    410,000
        Pharmacy    300,000
        Repairs and maintenance        30,000
        General and administrative        1,300,000
        Rent        1,500,000
        Billings and collections    250,000
        Total    $1,820,000    $2,900,000
        In addition to these charges from Helping Hospital, Pediatrics incu
ed the following personnel costs.
            Annual Salaries—these salaries are fixed
        Supervising nurses    $100,000
        Nurses    420,000
        Assistants    180,000
        Total    $700,000
    During the year ended June 30, 2019, Pediatrics charged the following and had the following relevant days:
        $500    daily charge to patient for services
        $6,500,000    Total Revenues
        36    Relevant Range of daily beds
     Required: Prepare your solution on the Part 1 Solution Worksheet. You must provide cell references to this worksheet to earn credit.
        1. Prepare a contribution income statement for Pediatrics for the year ended June 30, 2019.
        2. Calculate the number of patient-days that Pediatrics generated in revenue for the year ended June 30, 2019.
        3. Compute the contribution margin per patient days generated for the year ended June 30, 2019.
        4. Calculate the minimum number of patient-days required for Pediatrics to
eak even for the upcoming year June 30, 2020. Assume that revenue per patient-day, cost per patient-day,
        cost per bed and salary rates for this upcoming year June 30, 2020, remain the same as for the year ended June...