The data below have been taken from the cost records of the Halifax General Hospital. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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: 1. 2. 3. Month 4. May......... June Requirements: Using the high-low method, and based upon the data collected: (a) estimate the variable cost per admission. July............ August .......... September...... October............. November.......... December...... *********** Number of Patients Admitted 3,600 3,800 2,900 3,200 3,300 2,600 2,200 3,500 Admitting Department Costs $ 29,400 $ 28,700 $ 27,400 $ 28,000 $ 28,600 $ 26,200 $ 25,600 $ 29,300 (b) estimate the fixed costs for admission. (c) estimate the cost formula for admissions (cost formula is in the format of Y = a + bx). 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? 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.) Scrutinize the points on your scattergraph, and explain why the high-low method would or would not yield an accurate cost formula in this situation. 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: 1. 2. 3. Month 4. May......... June Requirements: Using the high-low method, and based upon the data collected: (a) estimate the variable cost per admission. July............ August .......... September...... October............. November.......... December...... *********** Number of Patients Admitted 3,600 3,800 2,900 3,200 3,300 2,600 2,200 3,500 Admitting Department Costs $ 29,400 $ 28,700 $ 27,400 $ 28,000 $ 28,600 $ 26,200 $ 25,600 $ 29,300 (b) estimate the fixed costs for admission. (c) estimate the cost formula for admissions (cost formula is in the format of Y = a + bx). 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? 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.) Scrutinize the points on your scattergraph, and explain why the high-low method would or would not yield an accurate cost formula in this situation.
Expert Answer:
Answer rating: 100% (QA)
1 a To Estimate the variable cost per admission and fixed costs using the highlow method we need to determine the highest and lowest number of patient... View the full answer
Related Book For
A Survey of Mathematics with Applications
ISBN: 978-0134112107
10th edition
Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde
Posted Date:
Students also viewed these accounting questions
-
On January 1, 20X1, Alpha Corporation acquired all of Bravo Companys assets and liabilities by issuing shares of its $3 par value stock to the owners of Bravo Company in a business combination. Alpha...
-
With a some calculation we can get formulas to determine whether or not a set of vectors is linearly independent. (a) Show that this subset of R2 is linearly independent if and only if ad - bc 6= 0....
-
If we assume that all boys have no sperm cells at age 11 (11.0 years) and all have sperm cells at age 18, then estimate the probability of first developing sperm cells at ages 12 (i.e., between 12.0...
-
A circular transistor of 10-mm diameter is cooled by impingement of an air jet exiting a 2-mm-diameter round nozzle with a velocity of 20 m/s and a temperature of 15C. The jet exit and the exposed...
-
The BOM for product A is shown next and data from the inventory records are shown in the table. In the master production schedule for product A, the MPS quantity row (showing completion dates) calls...
-
Describe the two types of illegal acts
-
Alpine Ski Shops Prepaid Rent balance is $4,500 on June 1. This prepaid rent rep resents six months rent. Journalize and post the adjusting entry on June 30 to record one months rent. Compute the...
-
China Express owns a number of stores that sell fast food. As part of its compensation packages, China Express provides employees with bonuses based on customer satisfaction surveys. Recent analysis...
-
Matthew, Inc., owns 3 0 percent of the outstanding stock of Lindman Company and has the ability to significantly influence the investee s operations and decision making. On January 1 , 2 0 2 1 , the...
-
1. How will you characterize Tupperwares distribution strategy in relation to the theoretical models? 2. What are the advantages and disadvantages of Tupperwares distribution model? 3. How do you...
-
If government tax policy requires Jasmin to pay $30,000 in taxes on annual income of $200,000 and Paul to pay $10,000 in tax on annual income of $100,000, then the tax policy is: -Proportional -...
-
IFRS is considered to be more: (a) principles-based and less rules-based than GAAP. (b) rules-based and less principles-based than GAAP. (c) detailed than GAAP. (d) None of the above.
-
Consider the CT signal \(x(t)=\delta(t+4)-\delta(t-4)\). Sketch \(\int x(t) d t\) and find the energy of the signal (Fig. 1.89). Energy \(E=8\). Figure 1.89 -4 [18(1+4)-8(1-4)]dt 0 4 +
-
Sketch the even and odd parts of the following signals shown in Fig. 1.88a and \(\mathrm{b}\). Figure 1.88 a and b (a) 2 0 x(t) 2 (b) 1 + x(t) 0 2 t
-
Harper Travel Agency purchased land for $85,000 cash on December 10, 2019. At December 31, 2019, the lands value has increased to $93,000. What amount should be reported for land on Harpers balance...
-
The following information relates to La Greca Co. for the year 2019. Instructions After analyzing the data, prepare an income statement and a retained earnings statement for the year ending December...
-
Joe lives in La Jolla on the main street which leads to all the restaurants and bars. He parked his car on the street last night. This morning he goes to get into his car and notices someone...
-
The Home Depot is the leading retailer in the home improvement industry and one of the 10largest retailers in the United States. The company included the following on its January 29, 2012, balance...
-
No jockeys weigh more than 200 pounds. Deb is not a jockey. Deb weighs more than 200 pounds. Use an Euler diagram to determine whether the syllogism is valid or invalid.
-
Write the first five terms of the geometric sequence with the first term, a 1 , and common ratio, r. a 1 = -3, r = -1
-
Graph the equation, using the x- and y-intercepts. 2x - y = 4
-
Derive Eqs. (E.7) and (E.8) of Example 8.10. Data From Example 8.10:- Equation E.7 and E.8:- Determine the effects of rotary inertia and shear deformation on the natural frequencies of a simply...
-
(a) Derive a general expression for the response of a uniform beam subjected to an arbitrary force. (b) Use the result of part (a) to find the response of a uniform simply supported beam under the...
-
Derive Eqs. (E.5) and (E.6) of Example 8.10. Data From Example 8.10:- Equation E.5 and E.6:- Determine the effects of rotary inertia and shear deformation on the natural frequencies of a simply...
Study smarter with the SolutionInn App