Based on the informations provided. How would I figure out #6 and what would be the answers using the excel template calculations. Please show steps and calculations. Thank you.

Consider the following changes in the Cambridge Software Corporation case study: 1- The willingness to pay of the large multidivisional corporations for the commercial version of the Modeler has risen to $1,500 and for the industrial version of the Modeler has risen to $2,800 2- The willingness to pay of the corporate R\&D and University Labs for the commercial version of the Modeler has risen to $1,200 3- The willingness to pay of the consultants and commercial companies for the commercial version of the Modeler has risen to $400 4- The willingness to pay of the small businesses for the commercial version of the Modeler has risen to $250 5- The willingness to pay of students for the commercial version of the Modeler has risen to $70 6- The bookstore has agreed to reduce its commission of selling Modeler to 30%, netting CSC 70% of the selling price Given the above-mentioned changes answer the following questions: a- If CSC only offers one version of the Modeler which version it should offer and at what price? b- If CSC only offers two versions of the Modeler which versions it should offer and at what prices? c- Should CSC offer all three versions? If yes, at what prices? If no, why not? \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ A } & B & C & E & F \\ \hline \multicolumn{2}{|c|}{ Product Version } & "Student" & "Commerical" & "Industrial" \\ \hline \multicolumn{2}{|c|}{ Development Cost } & $100,000 & $200,000 & $500,000 \\ \hline \multicolumn{2}{|c|}{ Variable Cost per Unit } & $15 & $25 & $35 \\ \hline MarketSegment(Customers) & Size & SegmentDevelopmentCost & Willingness to Pay (per unit) \\ \cline { 4 - 6 } & "Student" & "Commerical" & "Industrial" \\ \hline Large,MultidivisionalCorporations & 5,000 & $150,000 & $150 & $1,500 & $2,800 \\ \hline CorporateR&DandUniversityLabs & 2,000 & $100,000 & $100 & $1,200 & $2,000 \\ \hline ConsultantsandProfessionalCompanies & 20,000 & $200,000 & $200 & $400 & $600 \\ \hline Small Businesses & 15,000 & $200,000 & $175 & $250 & $300 \\ \hline \end{tabular}