Newport, Incorporated, used Excel to run a least-squares regression analysis, which resulted in the following output...

Transcribed Image Text:

Newport, Incorporated, used Excel to run a least-squares regression analysis, which resulted in the following output Regression Statistics Multiple R R Square Observations 0.7225 0.8500 30 5 Intercept Production (X) Required: Coefficients 31,000 Standard Error 3,493 T Stat P-Value 2.86 0.021 5.87 0.4640 14.30 0.000 a. What is Newport's total fixed cost? b. What is Newport's variable cost per unit? Round your answer to 2 decimal places. c. What total cost would Newport predict for a month in which they sold 5,000 units? d. What proportion of variation in Newport's cost is explained by variation in production? Note: Round your intermediate calculations to 2 decimal places. a. Total Fixed Cost b. Variable Costs c. Total Costs d. Proportion of Variation per unit % Newport, Incorporated, used Excel to run a least-squares regression analysis, which resulted in the following output Regression Statistics Multiple R R Square Observations 0.7225 0.8500 30 5 Intercept Production (X) Required: Coefficients 31,000 Standard Error 3,493 T Stat P-Value 2.86 0.021 5.87 0.4640 14.30 0.000 a. What is Newport's total fixed cost? b. What is Newport's variable cost per unit? Round your answer to 2 decimal places. c. What total cost would Newport predict for a month in which they sold 5,000 units? d. What proportion of variation in Newport's cost is explained by variation in production? Note: Round your intermediate calculations to 2 decimal places. a. Total Fixed Cost b. Variable Costs c. Total Costs d. Proportion of Variation per unit %