Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Regression Statistics Multiple R 0.988609498 R Square 0.97734874 Adjusted R Square 0.975289534 Standard Error 39.44999726 Observations 13 ANOVA df SS MS F Significance F Regression
Regression Statistics | ||||||||
Multiple R | 0.988609498 | |||||||
R Square | 0.97734874 | |||||||
Adjusted R Square | 0.975289534 | |||||||
Standard Error | 39.44999726 | |||||||
Observations | 13 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 738658.7226 | 738658.7226 | 474.6241975 | 2.13107E-10 | |||
Residual | 11 | 17119.32512 | 1556.302284 | |||||
Total | 12 | 755778.0477 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | -168.9983354 | 33.90225259 | -4.984870398 | 0.000412256 | -243.6166902 | -94.37998053 | -243.6166902 | -94.37998053 |
X Variable 1 | 0.039379719 | 0.001807581 | 21.78587151 | 2.13107E-10 | 0.035401261 | 0.043358177 | 0.035401261 | 0.043358177 |
Using the Solver function in Excel, assuming sales are $28,000 what reduction in variable costs per $1 of sales is required to enable the company to generate a net profit after tax equal to 5% of total costs? (Refer to the original data and profit and cost functions developed using regression analysis as well as a corporate tax rate of 30%) (4 decimal places). |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started