A company is developing a new software. There are 3 versions.educational, large scale,high speed. Currently, the developers are close to completing the Educational version, but they have done little more than outline the other two versions. The estimated R&D expenditures required to finish those tasks are $100,000 for the Large-Scale version, and $150,000 for the High-Speed version. The actual variable costs are estimated to be $10 for the Educational version, $20 for the Large-Scale version, and $36 for the HighSpeed version. Develop an excel model that will compute sales of each version in each market segment and calculate the profit. Further, answer which version should be brought to market and at what price. What is the maximum profit? Show formulas.

Segment Students Laboratories Consultants Small companies Large companies Market Size 400,000 1,200 12,000 24,000 6,000 Marketing Costs $350,000 75,000 150,000 200.000 100,000 Segment Students Laboratories Consultants Small companies Large companies Educational $25 125 100 Large-Scale $40 300 500 High-Speed $75 1,000 750 500 2,500 250 150 1.000