Reference no: EM131404686
Q1. Billie Johnson is the Chief Operating Officer at Union Hospital in Newark, New Jersey. She is analyzing the hospital's overhead costs but is not sure whether nursing hours or the number of patient days would be the best cost driver to use for predicting the hospital's overhead.
She has gathered the following information for the last six months of the most recent year:
Read the requirements:
1. Are the hospital's overhead costs fixed, variable, or mixed? Explain.
2. Graph the hospital's overhead costs against nursing hours.
3. Graph the hospital's overhead costs against the number of patient days.
4. Do the data appear to be sound or do you see any potential data problems? Explain.
5. Use the highlow method to determine the hospital's cost equation using nursing hours as the cost driver. Predict total overhead costs if 23,500 nursing hours are predicted for the month.
6. Ms. Johnson runs a regression analysis using nursing hours as the cost driver to predict total hospital overhead costs. The Excel output from the regression analysis is shown here
If 23,500 nursing hours are predicted for the month, what is the total predicted hospital overhead?
7. Ms. Johnson then ran the regression analysis using number of patient days as the cost driver. The Excel output from the regression is shown here:
If 3,800 patient days are predicted for the month, what is the total predicted hospital overhead?
8. Which regression analysis (using nursing hours or using number of patient days as the cost driver) produces the best cost equation? Explain your answer.
Q2. Carmichael Industries is in the process of analyzing its manufacturing overhead costs. Carmichael Industries is not sure if the number of units produced or the number of direct labor (DL) hours is the best cost driver to use for predicting manufacturing overhead (MOH) costs.
Requirements-
1. Are manufacturing overhead costs fixed, variable, or mixed? Explain.
2. Graph Carmichael Industries' manufacturing overhead costs against DL hours.
3. Graph Carmichael Industries' manufacturing overhead costs against units produced.
4. Do the data appear to be sound, or do you see any potential data problems? Explain.
5. Use the highlow method to determine Carmichael Industries' manufacturing overhead cost equation using DL hours as the cost driver. Assume that management believes that all data is accurate and wants to include all of it in the analysis.
6. Estimate manufacturing overhead costs if Carmichael Industries incurs 25,500 DL hours in January.
Attachment:- Assignment Files.rar
|
What are the primary assumptions each author makes
: There are very different views of what types of evidence are most credible in evaluating the effectiveness of psychological treatment research. In this discussion you will analyze basic applied psychological research as well as evaluate how resear..
|
|
Relationship between age and hours of television watching
: Using the given value, characterize the nature of the relationship between age and hours of television watching in 1996.
|
|
What are three controversies discussed in the halter article
: What are three controversies discussed in the Halter, Rolin-Kenny, & Dzurec (2013) article? Give your opinions about these controversies.From your point view, are these legitimate concerns? Why or why not?Briefly outline a research method that coul..
|
|
Develop a proposal for migrating your firm to ifrs from gaap
: "General Ledger and Reporting Systems" Please respond to the following: Develop a proposal for migrating your firm to IFRS from GAAP. Discuss how you will educate your users in IFRS.
|
|
Graph the hospital overhead costs against nursing hours
: Graph the hospital's overhead costs against nursing hours. Graph the hospital's overhead costs against the number of patient days
|
|
Which graph shows the weakest
: Assume that all four graphs have the same numerical scales for the two axes. Which graph shows the strongest relationship between the two variables? Which graph shows the weakest?
|
|
How company should approach implementation of your strategy
: Recommend a strategy that the company you indicated may use to prevent future business information failures. Indicate how the company should approach the implementation of your recommended strategy.
|
|
Write what you believe is the wisest, most ethical decision
: Computers fail for many reasons; most commonly, because of a hard drive crash. Computers may also be rendered unusable by fire, flood, mistreatment, sabotage, rust, viruses, overheating, static electric shock, and other mishaps. Even the savviest ..
|
|
What is the value of the correlation between them
: Suppose two variables have a deterministic linear relationship with a positive association. What is the value of the correlation between them?
|