Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 2. The following excel printout provides information to estimate overhead costs using linear regression: Coefficients Standard Error t Stat P-value Lower 95% Upper

image text in transcribed

Problem 2. The following excel printout provides information to estimate overhead costs using linear regression: Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 6035.987027 1411.05464 4.277642 0.002696 2782.0871 9289.88697 DLH 4.558482698 1.609683731 2.831912 0.022085 0.846543 8.27042244 # setups 771.1028938 54.93418317 14.03685 # moves 29.9411124 2.874675342 10.41548 6.44E-07 6.26E-06 644.42436 897.781429 23.312095 36.5701299 Regression Statistics Multiple R 0.996584412 R Square 0.99318049 Adjusted R Square 0.990623174 347.9563597 12 Standard Error Observations Required: (a). Write the complete cost function (round to nearest cent) using the appropriate variables. What's the estimated fixed cost? What's the estimated variable cost per unit? (b). What is the overhead estimate if the department has 1,205 DLH, 55 setups and 125 moves? (4 points) (c). Calculate a 99 percent confidence internal for the prediction made in requirement (b). (4 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Accounting questions