SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA 0.782425862...

Transcribed Image Text:

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA 0.782425862 0.61219023 0.604434034 950.2950652 52 df SS Regression 1 71277851.51 Residual 50 45153035.54 Total 51 116430887.1 Intercept X Variable 1 MS F 71277851.51 78.9291912 903060.7109 Significance F 7.36486E-12 Coefficients Standard Error 1938.987565 1.137630836 797.165996 0.128050869 t Stat 2.432351072 8.884210218 P-value 0.018623144 7.36486E-12 Lower 95% 337.8325398 0.880433097 Upper 95% 3540.14259 1.394828576 In addition to the above information, use this information to answer Questions 1-6: Selling price per unit: After tax profit goal $2.85 $14,000 Tax Rate 40% Actual Unit Sales 12,000 Actual Production (units) 12,000 Lower 95.0% 337.8325398 0.880433097 Upper 95.0% 3540.14259 1.394828576 Given the information above, how many units do you need to sell to achieve your profit goal? (Round the variable cost to the nearest penny and round the # of units UP to the nearest whole number). SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA 0.782425862 0.61219023 0.604434034 950.2950652 52 df SS Regression 1 71277851.51 Residual 50 45153035.54 Total 51 116430887.1 Intercept X Variable 1 MS F 71277851.51 78.9291912 903060.7109 Significance F 7.36486E-12 Coefficients Standard Error 1938.987565 1.137630836 797.165996 0.128050869 t Stat 2.432351072 8.884210218 P-value 0.018623144 7.36486E-12 Lower 95% 337.8325398 0.880433097 Upper 95% 3540.14259 1.394828576 In addition to the above information, use this information to answer Questions 1-6: Selling price per unit: After tax profit goal $2.85 $14,000 Tax Rate 40% Actual Unit Sales 12,000 Actual Production (units) 12,000 Lower 95.0% 337.8325398 0.880433097 Upper 95.0% 3540.14259 1.394828576 Given the information above, how many units do you need to sell to achieve your profit goal? (Round the variable cost to the nearest penny and round the # of units UP to the nearest whole number).