Using the data provided in E6-29A, the laboratory manager performed a regression analysis to predict total laboratory
Question:
Requirements
1. Determine the lab's cost equation (use the output from the Excel regression).
2. Determine the R-square (use the output from the Excel regression).
3. Predict the total laboratory overhead for the month if 3,100 tests are performed.
Transcribed Image Text:
SUMMARY OUTPUT Regression Statistics Multiple R 4 R Square 5 Adjusted R Square Standard Error Observations ANOVA 0.878214 0.77126 0.725512 3156.338706 df SS 1 167956201.28 167956201.28 Significance F MS 10 Regression Residual Total 16.858885 0.009301 5 49812370.15 9962474.03 11 6 217768571.43 12 13 Lower 95% -9901.898 2.558 Standard Error Upper 14 t Stat 0.626 4.106 Coefficients 3187.94 P-value 15 95% 16 Intercept 17 X Variable 1 0.559 0.009 16277.778 5092.169 6.84 1.666 11.123 18 Number of Lab Tests Total Laboratory Overhead Costs Month January. February. March April. May . Performed 3,000 2,850 3,400 3,700 3,900 1,900 2,050 $21,900 $20,600 $28,900 $31,000 $28,000 June $20,200 July.. $14,000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 88% (9 reviews)
Req 1 y 684x 318794 Req 2 The Rsquare is 077126 This indicates that t...View the full answer
Answered By
Fahmin Arakkal
Tutoring and Contributing expert question and answers to teachers and students.
Primarily oversees the Heat and Mass Transfer contents presented on websites and blogs.
Responsible for Creating, Editing, Updating all contents related Chemical Engineering in
latex language
4.40+
8+ Reviews
22+ Question Solved
Related Book For
Question Posted:
Students also viewed these Financial Accounting questions
-
Using the data provided in E6-31A, the laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as follows: Requirements 1....
-
Using the data provided in E6-57B, the laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as follows: Requirements 1....
-
Using the data provided in E6-50B, the laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as follows: Requirements 1....
-
The following selected financial information was obtained from the 2012 financial reports of Robotranics, Inc. and Technology, Limited: Assume that total assets, total liabilities, and total...
-
Consider as shown below, and suppose that authors could also appear as top level elements. What change would have to be done to the relational schema? similar PCDATA declarations for year,...
-
What is the difference between DP and PDP addressing modes in the C55x?
-
Figure P5.94 shows the mixing of two streams. The shear stress between each fluid and its adjacent walls is negligible. Why can't Bernoulli's equation be applied between points in stream 1 and the...
-
Assume that on February 1, Procter & Gamble (P&G) paid $720,000 in advance for 2 years insurance coverage. Prepare P&Gs February 1 journal entry and the annual adjusting entry on June 30.
-
Matthew wants to take out a loan to buy a car. He calculates that he can make repayments of $4000 per year. If he can get a five-year loan with an annual interest rate of 4%, what is the maximum...
-
A thick steel sheet of area 400 cm2 is exposed to air near the ocean. After a one-year period it was found to experience a weight loss of 375 g due to corrosion. To what rate of corrosion, in both...
-
Refer to the laboratory overhead cost and activity data for Elmhurst Health Center in E6-29A. Use the high-low method to determine the laboratory's cost equation for total laboratory overhead. Use...
-
The manager of the main laboratory facility at Elmhurst Health Center (from E6-29A) collects seven additional months of data after obtaining the regression results in E6-31A. The number of tests...
-
Serene Brakes manufactures brake pads and other automotive components. The firms CEO is very pleased that aggressive cost cutting appears to be paying off as the firms cost per unit has decreased...
-
Consider the role technology plays in both of this chapters caselets. How do you think advances in technology (e.g. mobile communications, cloud computing, social media) will influence the service...
-
Describe the key features of, and benefits from participating in, hub-and-spoke transport networks.
-
Why do you think the Netherlands is the worlds most globally connected country?
-
Construct point estimates for the following situations: (a) A labor union randomly samples 75 of its members and finds that 40 favor the new contract. Estimate the proportion of all workers who favor...
-
A prospective clients current standard of living is $100,000 per year. This person plans to retire in 15 years. What will the clients future standard of living be if the average annual inflation rate...
-
On April 30, 2018, Dawson Co. borrowed $6,000 on a one-year, 9 percent note payable. What amounts would Dawson Co. report for the note payable and the related interest payable on its balance sheet at...
-
Grace is training to be an airplane pilot and must complete five days of flying training in October with at least one day of rest between trainings. How many ways can Grace schedule her flying...
-
Bell Simpson manufactures a specialty precision scale. For January, the company expects to sell 800 scales at an average price of $ 2,350 per unit. The average manufacturing cost of each unit sold is...
-
Emerald Service anticipates the following sales revenue over a five- month period: The company's sales are 20% cash and 80% credit. Its collection history indicates that credit sales are collected as...
-
Stately Corporation is preparing its cash payments budget for next month. The following information pertains to the cash payments: a. Stately Corporation pays for 55% of its direct materials...
-
State the dividend irrelevance proposition. What are the assumptions behind this proposition? Explain why this proposition does not hold in the real world. (20 marks)
-
How many monthly withdrawals of $1,400 will an investment of $75,000 sustain if the first withdrawal is made 12 months from now and the money earns 8.4% compounded monthly
-
1. You buy a bond with 3 years left to maturity and a yield to maturity of 6% for $920. After 1 year you receive a coupon payment of $30 and sell the bond for $940. What was your rate of return on...
Study smarter with the SolutionInn App