Question: Please show detail steps of solution and formula with calculation. A B D Q1 and Q2 below. Table 4 begin{tabular}{|l|r|r|r|} hline & Localsalesofimportcars(inmillion) & LocalpayrollCarPlussyearly(inbillion)

Please show detail steps of solution and formula with calculation.
A B D Q1 and Q2 below. Table 4 \begin{tabular}{|l|r|r|r|} \hline & Localsalesofimportcars(inmillion) & LocalpayrollCarPlussyearly(inbillion) \\ sales (in thousand) \end{tabular} Q1: Given the estimated local sales of import cars, \$18 million, and estimated local payroll, \$3.8 billion, next year, what is the forecasted sales for Car Plus for next year? You have to show your anaylsis to earn points. Sales next year (in thousand) Table 5 Year 1 Interest rate (\%) Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 1 Year 8 32 Year 9 33 Year 10 \begin{tabular}{|r|r|} \hline 3.0 & \\ \hline 4.2 & \\ \hline 6.0 & \\ \hline 3.0 & \\ \hline 5.0 & \\ \hline 4.8 & \\ \hline 3.0 & \\ \hline 6.0 & \\ \hline 4.0 & \\ \hline 2.0 & \\ \hline \end{tabular} Q2: The manager, Alan, suggested the annual average interest rate (Table 5) be taken into consideration along with local payroll and local sales of import cars for the year, when forecasting Car Plus's yearly sales. Along with the information indicated in Q1, Alan predicted the average interest rate next year is 5.6%. Should the interest rate be included to forecast Car Plus's next year's sales? Provide the quantitative/statistical reasoning behind your answer (no personal perception please). Yes or No, and your reasoning
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
