ABC, firm, specializes in creating Al tools tailored for facilities. As their product is a newcomer in the market, its appeal to potential clients increases if it's already implemented in other institutions. For instance, having Hospital B utilize ABC's product could influence Hospital D's decision to purchase. Initial sales efforts are focused on smaller institutions like Hospitals A and B. These hospitals are open to endorsing ABC's product, enhancing its market appeal. ABC's ultimate target is Hospital H, known for its size, prestige, and lucrative potential. Directly pitching to Hospital H is ineffective at this stage due to the lack of existing users. The strategy to ultimately engage Hospital H involves a specific sequence of sales, outlined in the diagram below. Determine the optimal sales strategy for ABC, outlining the sequence in which they should approach various hospitals to maximize their publicity impact upon securing a deal with Hospital H. It's crucial to note that while it's not mandatory to engage with every hospital, ensuring a successful sale to Hospital H is a key objective. Formulate the above problem in Excel. Clearly label the decision variables, objective function, and constraints. In a separate place on the spreadsheet tab, write the expressions for objective function and constraints. Briefly provide rationale for using a certain method for finding the optimal solution in Solver.The information on publicity points earned in selling the product for each of the pairs is shown in the table below.

 

Transcribed Image Text:

Software Company (ABC) From ABC ABC Hospital A Hospital A Hospital B Hospital B Hospital A Hospital C Hospital D Hospital D Hospital E Hospital F Hospital G Hospital B To Hospital A Hospital B Hospital C Hospital D Hospital D Hospital E Hospital F Hospital F Hospital G Hospital G Hospital H Hospital H The information on publicity points earned in selling the product for each of the pairs is shown in the table below. 41 53 35 45 25 28 Hospital C 36 39 Hospital D Publicity Points Earned 72 65 51 48 Hospital E Hospital F Hospital G Hospital H Software Company (ABC) From ABC ABC Hospital A Hospital A Hospital B Hospital B Hospital A Hospital C Hospital D Hospital D Hospital E Hospital F Hospital G Hospital B To Hospital A Hospital B Hospital C Hospital D Hospital D Hospital E Hospital F Hospital F Hospital G Hospital G Hospital H Hospital H The information on publicity points earned in selling the product for each of the pairs is shown in the table below. 41 53 35 45 25 28 Hospital C 36 39 Hospital D Publicity Points Earned 72 65 51 48 Hospital E Hospital F Hospital G Hospital H

Answer rating: 100% (QA)

Examination of the Ideal Deals System for ABC In this procedure breakdown a numerical streamlining model is utilized to decide the best deals successi... View the full answer