Reconsider the example of choosing the advertising budget for the VRX2000 that is presented in Section 14 There it was determined that the optimal level of adventising spending was $135,392 leading to a profit of $77,425 Now suppose that the component prices for the VRX2000 have been fluctuating The variable cost for producing the VRX2000 has now increased from $205 to $315 Due to the competitive marketplace. VRX feels they cannot pass these costs on to the consumer, so the company plans to keep the selling price of the VRX2000 at \$405. Click here for the Excel Data File Re-5olve the optimization model for the VRX2000 considering the new variable cost. 0. What impact did the increased variable cost have (if any) on the best level of advertising? Suppose instead that the variable cost for the V/PY 2000 decreases to $275 Re-solve the optimization model b. What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the increased variable cost have (if any) on the best level of advertising? Whate: Do not round intermediate calculations and round up the final answers to the next whe VRX2000 Optimization Model What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the decreased variable cost have (if any) on the best level of advertising? Note: Do not round intermediate calculations and round up the final answers to the next whole number: VRX2000 Optimization Model Reconsider the example of choosing the advertising budget for the VRX2000 that is presented in Section 1.4. There it was determined that the optimal level of advertising spending was $135,392 leading to a profit of $77,425. Now suppose that the component prices for the VRX2000 have been fluctuating. The variable cost for producing the VRX2000 has now increased from $295 to $315. Due to the competitive marketplace, VRX feels they cannot pass these costs on to the consumer, so the company plans to keep the selling price of the VRX2000 at $405. Click here for the Excel Data File Re-solve the optimization model for the VRX2000 considering the new variable cost. a. What impact did the increased variable cost have (if any) on the best level of advertising? Suppose instead that the variable cost for the VRX2000 decreases to $275. Re-solve the optimization model. b. What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the increased variable cost have (if any) on the best level of advertising? Note: Do not round intermediate calculations and round up the final answers to the next whole number. Reconsider the example of choosing the advertising budget for the VRX2000 that is presented in Section 1.4. There it was determined that the optimal level of advertising spending was $135,392 leading to a profit of $77,425. Now suppose that the component prices for the VRX2000 have been fluctuating. The variable cost for producing the VRX2000 has now increased from $295 to $315. Due to the competitive marketplace, VRX feels they cannot pass these costs on to the consumer, so the company plans to keep the selling price of the VRX2000 at $405. Click here for the Excel Data File Re-solve the optimization model for the VRX2000 considering the new variable cost. a. What impact did the increased variable cost have (if any) on the best level of advertising? Suppose instead that the variable cost for the VRX2000 decreases to $275. Re-solve the optimization model. b. What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the decreased variable cost have (if any) on the best level of advertising? Note: Do not round intermediate calculations and round up the final answers to the next whole number. \begin{tabular}{|c|c|c|c|c|} \hline 4 & B & C & D & E \\ \hline 1 & VRX2000 Optin & ization M & del & \\ \hline 2 & & & & Required B \\ \hline 3 & Parameters: & & & \\ \hline 4 & Unit Variable Cost & $275 & & \\ \hline 5 & Unit Revenue & $405 & & \\ \hline 6 & Fixed Cost & $100,000 & & \\ \hline 7 & & & & \\ \hline 8 & Decision Variable: & & & \\ \hline 9 & Advertising Budget & $207,540 & & \\ \hline 10 & & & & \\ \hline 11 & Prediction Formul & ales ax+b & & \\ \hline 12 & a & 7.01 & & \\ \hline 13 & b & 400 & & \\ \hline 14 & & & & \\ \hline 15 & Expected Units Sold & 3,593 & & \\ \hline 16 & & & & \\ \hline 17 & Total Revenue & $1,455,259 & & \\ \hline 18 & Total Variable Cost & $988,139 & & \\ \hline 19 & Fixed Cost & $100,000 & & \\ \hline 20 & Advertising Cost & $207,540 & & \\ \hline 21 & & & & \\ \hline 22 & Total Profit & $159,580 & & \\ \hline \end{tabular} Reconsider the example of choosing the advertising budget for the VRX2000 that is presented in Section 14 There it was determined that the optimal level of adventising spending was $135,392 leading to a profit of $77,425 Now suppose that the component prices for the VRX2000 have been fluctuating The variable cost for producing the VRX2000 has now increased from $205 to $315 Due to the competitive marketplace. VRX feels they cannot pass these costs on to the consumer, so the company plans to keep the selling price of the VRX2000 at \$405. Click here for the Excel Data File Re-5olve the optimization model for the VRX2000 considering the new variable cost. 0. What impact did the increased variable cost have (if any) on the best level of advertising? Suppose instead that the variable cost for the V/PY 2000 decreases to $275 Re-solve the optimization model b. What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the increased variable cost have (if any) on the best level of advertising? Whate: Do not round intermediate calculations and round up the final answers to the next whe VRX2000 Optimization Model What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the decreased variable cost have (if any) on the best level of advertising? Note: Do not round intermediate calculations and round up the final answers to the next whole number: VRX2000 Optimization Model Reconsider the example of choosing the advertising budget for the VRX2000 that is presented in Section 1.4. There it was determined that the optimal level of advertising spending was $135,392 leading to a profit of $77,425. Now suppose that the component prices for the VRX2000 have been fluctuating. The variable cost for producing the VRX2000 has now increased from $295 to $315. Due to the competitive marketplace, VRX feels they cannot pass these costs on to the consumer, so the company plans to keep the selling price of the VRX2000 at $405. Click here for the Excel Data File Re-solve the optimization model for the VRX2000 considering the new variable cost. a. What impact did the increased variable cost have (if any) on the best level of advertising? Suppose instead that the variable cost for the VRX2000 decreases to $275. Re-solve the optimization model. b. What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the increased variable cost have (if any) on the best level of advertising? Note: Do not round intermediate calculations and round up the final answers to the next whole number. Reconsider the example of choosing the advertising budget for the VRX2000 that is presented in Section 1.4. There it was determined that the optimal level of advertising spending was $135,392 leading to a profit of $77,425. Now suppose that the component prices for the VRX2000 have been fluctuating. The variable cost for producing the VRX2000 has now increased from $295 to $315. Due to the competitive marketplace, VRX feels they cannot pass these costs on to the consumer, so the company plans to keep the selling price of the VRX2000 at $405. Click here for the Excel Data File Re-solve the optimization model for the VRX2000 considering the new variable cost. a. What impact did the increased variable cost have (if any) on the best level of advertising? Suppose instead that the variable cost for the VRX2000 decreases to $275. Re-solve the optimization model. b. What impact did the decreased variable cost have (if any) on the best level of advertising? Complete this question by entering your answers in the tabs below. What impact did the decreased variable cost have (if any) on the best level of advertising? Note: Do not round intermediate calculations and round up the final answers to the next whole number. \begin{tabular}{|c|c|c|c|c|} \hline 4 & B & C & D & E \\ \hline 1 & VRX2000 Optin & ization M & del & \\ \hline 2 & & & & Required B \\ \hline 3 & Parameters: & & & \\ \hline 4 & Unit Variable Cost & $275 & & \\ \hline 5 & Unit Revenue & $405 & & \\ \hline 6 & Fixed Cost & $100,000 & & \\ \hline 7 & & & & \\ \hline 8 & Decision Variable: & & & \\ \hline 9 & Advertising Budget & $207,540 & & \\ \hline 10 & & & & \\ \hline 11 & Prediction Formul & ales ax+b & & \\ \hline 12 & a & 7.01 & & \\ \hline 13 & b & 400 & & \\ \hline 14 & & & & \\ \hline 15 & Expected Units Sold & 3,593 & & \\ \hline 16 & & & & \\ \hline 17 & Total Revenue & $1,455,259 & & \\ \hline 18 & Total Variable Cost & $988,139 & & \\ \hline 19 & Fixed Cost & $100,000 & & \\ \hline 20 & Advertising Cost & $207,540 & & \\ \hline 21 & & & & \\ \hline 22 & Total Profit & $159,580 & & \\ \hline \end{tabular}