\begin{tabular}{|l|l|} \hline Instructions \\ \hline 15 & ApplyaCustomnumberformattomaketheformulareferencedisplayasthedescriptivecolumnheadingPurchasePrice.BoldtheheadingsincellsJ4:M4. \\ \hline 16 & CreateascenarionamedBestCase,usingPurchasePriceandMonthsFinanced.Enterthesevaluesforthescenario:40000,and36. \\ \hline 17 & CreateasecondscenarionamedWorstCase,usingthesamechangingcells.Enterthesevaluesforthescenario:50000,and72. \\ \hline 18 & CreateathirdscenarionamedMostLikely,usingthesamechangingcells.Enterthesevaluesforthe-scenario:45000,and60. \\ \hline 19 & GenerateaScenarioSummaryreportbasedonMonthlyPayment.BesuretousebestpracticeinformattingthereportbydeletingColumnA:B,Row1,andtheCurrentValuescolumn. \\ \hline 20 & LoadtheSolveradd-inifitisnotalreadyloaded.SettheobjectivetocalculateaMonthlyPaymentof$500. \\ \hline 21 & Use Purchase Price and Months Financed as changing variable cells. \\ \hline 22 & SetconstraintstoensurethePurchasePriceislessthanorequalto$50,000,greaterthanorequalto$30,000,andawholenumber. \\ \hline 23 & Setconstraintstoensuremonthsfinancedarelessthanorequalto72,greaterthanorequalto24andawholenumber. \\ \hline 24 & Solvetheproblemandsavetheresults.GeneratetheAnswerReport.Ifyougetaninternalmemoryerrormessage,removeSolverasanadd-in,closetheworkbook,opentheworkbook,addSolverinagain,andfinishusingSolver. \end{tabular} \begin{tabular}{|l|l|} \hline Instructions \\ \hline 15 & ApplyaCustomnumberformattomaketheformulareferencedisplayasthedescriptivecolumnheadingPurchasePrice.BoldtheheadingsincellsJ4:M4. \\ \hline 16 & CreateascenarionamedBestCase,usingPurchasePriceandMonthsFinanced.Enterthesevaluesforthescenario:40000,and36. \\ \hline 17 & CreateasecondscenarionamedWorstCase,usingthesamechangingcells.Enterthesevaluesforthescenario:50000,and72. \\ \hline 18 & CreateathirdscenarionamedMostLikely,usingthesamechangingcells.Enterthesevaluesforthe-scenario:45000,and60. \\ \hline 19 & GenerateaScenarioSummaryreportbasedonMonthlyPayment.BesuretousebestpracticeinformattingthereportbydeletingColumnA:B,Row1,andtheCurrentValuescolumn. \\ \hline 20 & LoadtheSolveradd-inifitisnotalreadyloaded.SettheobjectivetocalculateaMonthlyPaymentof$500. \\ \hline 21 & Use Purchase Price and Months Financed as changing variable cells. \\ \hline 22 & SetconstraintstoensurethePurchasePriceislessthanorequalto$50,000,greaterthanorequalto$30,000,andawholenumber. \\ \hline 23 & Setconstraintstoensuremonthsfinancedarelessthanorequalto72,greaterthanorequalto24andawholenumber. \\ \hline 24 & Solvetheproblemandsavetheresults.GeneratetheAnswerReport.Ifyougetaninternalmemoryerrormessage,removeSolverasanadd-in,closetheworkbook,opentheworkbook,addSolverinagain,andfinishusingSolver. \end{tabular}