Question

1 Approved Answer

Posted on Sep 11, 2024

Regression Statistics 2 Multiple R 0.798889623 3 R Square 0.63822463 4 Adjusted R Square 0.602047093 5 Standard Error 1448.955289 6 Observations 12 7 df Significance

image text in transcribed

Regression Statistics 2 Multiple R 0.798889623 3 R Square 0.63822463 4 Adjusted R Square 0.602047093 5 Standard Error 1448.955289 6 Observations 12 7 df Significance F 0.001828192 8 ANOVA 9 10 Regression 11 Residual 12 Total 13 14 15 Intercept 16 DLH 1 10 11 SS MS F 37037744.61 37037744.61 17.64146159 20994714.31 2099471.431 58032458.92 Coefficients Standard Errort Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% ! 237.8355134 3401.764305 0.069915342 0.945639422 -7341.767701 7817.438727 -7341.767701 7817.438727 5.067605022 1.206522641 4.200173995 0.001828192 2.37930505 7.755904995 2.37930505 7.755904995 Manufacturing Expense Variable, Fixed, or Mixed Variable Amount Variable Fixed General Ledger Number DM $ $ $ 5100 Wax 5120 Scent 5130 Wicks 5140 Coloring 5192 Packaging Boxes 5150 Clips 5191 Cellophane 5323 Shipping Cost 5193 Information Sticker $3,000,000.00 Variable $ 480,000.00 Variable $ 300,000.00 Variable $ 120,000.00 Variable $ 18,750.00 Variable $ 15,000.00 Variable $ 15,000.00 Variable $ 180,000.00 Variable $ 45,000.00 Variable $ 4,173,750.00 82.76 13.24 8.28 3.31 0.52 0.41 0.41 4.97 1.24 $ $ $ $ 0.00 Total Dm DL 5230 CandleMaster Labor $ 112,500.00 Variable 5220 Candle Maker Labor $ 183,750.00 Variable 5210 Apprentice Labor $ 105,000.00 Variable $ 401,250.00 $ $ $ 3.10 5.07 2.90 Total DL Moh 5315 Indirect Salaries $ 474,000.00 Fixed 5313 Depreciation $ 360,000.00 Fixed 5321 Rent on Warehouse $ 72,000.00 Fixed 5325 Utilities $ 60,000.00 Mixed 5317 Insurance $ 12,000.00 Fixed 5319 Parts and Repairs $ 18,000.00 variable 5311 Cleaning Supplies $ 24,000.00 Variable $ 1,020,000.00 28.13793103 - - - - - 0.50 0.66 127.37 $ $ $ $ $ 13.08 9.93 1.99 - 0.33 $ $ $ $ 25.32 Total Cost(MOH) POHR quare values from your regression analysis, for which mixed Based on the R-square va sis DL the best predictor? For which is it the worst predictor? Explain. 0-8. Add up the fixed and variable components of your individual expense cos equations and create a total cost equation for: a. MOH only b. Total Production Costs Name: Making Point Predicti 0-9. How much shou year if they use 45. ich should Jordan estimate that Wedgewood will spend on MOH next Ethey use 45,000 DL hours (round to the nearest dollar)? 0-10. How much should Jordan estimate the company will spend on production next year using the 45,000 DL hour estimate (round to the nearest dollar)? Regression Statistics 2 Multiple R 0.798889623 3 R Square 0.63822463 4 Adjusted R Square 0.602047093 5 Standard Error 1448.955289 6 Observations 12 7 df Significance F 0.001828192 8 ANOVA 9 10 Regression 11 Residual 12 Total 13 14 15 Intercept 16 DLH 1 10 11 SS MS F 37037744.61 37037744.61 17.64146159 20994714.31 2099471.431 58032458.92 Coefficients Standard Errort Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% ! 237.8355134 3401.764305 0.069915342 0.945639422 -7341.767701 7817.438727 -7341.767701 7817.438727 5.067605022 1.206522641 4.200173995 0.001828192 2.37930505 7.755904995 2.37930505 7.755904995 Manufacturing Expense Variable, Fixed, or Mixed Variable Amount Variable Fixed General Ledger Number DM $ $ $ 5100 Wax 5120 Scent 5130 Wicks 5140 Coloring 5192 Packaging Boxes 5150 Clips 5191 Cellophane 5323 Shipping Cost 5193 Information Sticker $3,000,000.00 Variable $ 480,000.00 Variable $ 300,000.00 Variable $ 120,000.00 Variable $ 18,750.00 Variable $ 15,000.00 Variable $ 15,000.00 Variable $ 180,000.00 Variable $ 45,000.00 Variable $ 4,173,750.00 82.76 13.24 8.28 3.31 0.52 0.41 0.41 4.97 1.24 $ $ $ $ 0.00 Total Dm DL 5230 CandleMaster Labor $ 112,500.00 Variable 5220 Candle Maker Labor $ 183,750.00 Variable 5210 Apprentice Labor $ 105,000.00 Variable $ 401,250.00 $ $ $ 3.10 5.07 2.90 Total DL Moh 5315 Indirect Salaries $ 474,000.00 Fixed 5313 Depreciation $ 360,000.00 Fixed 5321 Rent on Warehouse $ 72,000.00 Fixed 5325 Utilities $ 60,000.00 Mixed 5317 Insurance $ 12,000.00 Fixed 5319 Parts and Repairs $ 18,000.00 variable 5311 Cleaning Supplies $ 24,000.00 Variable $ 1,020,000.00 28.13793103 - - - - - 0.50 0.66 127.37 $ $ $ $ $ 13.08 9.93 1.99 - 0.33 $ $ $ $ 25.32 Total Cost(MOH) POHR quare values from your regression analysis, for which mixed Based on the R-square va sis DL the best predictor? For which is it the worst predictor? Explain. 0-8. Add up the fixed and variable components of your individual expense cos equations and create a total cost equation for: a. MOH only b. Total Production Costs Name: Making Point Predicti 0-9. How much shou year if they use 45. ich should Jordan estimate that Wedgewood will spend on MOH next Ethey use 45,000 DL hours (round to the nearest dollar)? 0-10. How much should Jordan estimate the company will spend on production next year using the 45,000 DL hour estimate (round to the nearest dollar)