Answered step by step
Verified Expert Solution
Question
1 Approved Answer
questions 3-4 please thank you The data below have been taken from the cost records of the Halifax General Hospital. The data relate to the
questions 3-4 please thank you
The data below have been taken from the cost records of the Halifax General Hospital. The data relate to the costs of admitting patients at various levels of patient activity: Requirements: 1. Using the high-low method, and based upon the data collected: (a) estimate the variable cost per admission. (b) estimate the fixed costs for admission. (c) estimate the cost formula for admissions (cost formula is in the format of Y=a+bx ). 2. Using the cost formula you derived above, what admission costs would you expect to be incurred during a month in which there are 2,750 hospital admissions? 3. Prepare a scattergraph plot using the data. Plot cost on the vertical axis and activity on the horizontal axis. Add the visual best-fit "trendline" to fit a line through the points on your scattergraph. Also add the "high-low trendline" so that you can compare the two trendlines and the data set points in Requirement 4. (Hint: You can either use software, such as Microsoft Excel, or Google Sheets, or draw the scattergraph plot on your computer using a drawing program (Microsoft Paint, or similar) or you can draw and plot the points on a piece of paper by hand and take a picture and insert the picture into your document.) 4. Scrutinize the points on your scattergraph, and explain why the high-low method would or would not yield an accurate cost formula in this situationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started