d) Find the optimal solution using Microsoft Excel's Solver. Include the answer report in your file.

1. What would your recommendation be regarding the contractual commitment to the retail stores for the solution found in (d)? For example, could they be more profitable if they reduced or increased their level of commitment (i.e. the minimum number of units sold)?
2. List the binding and non-binding constraints for the optimal solution in (d).

Need the answer for a) and b)

Question 1 (50 Marks) Sherpa Sensors Pty Ltd manufactures high-tech temperature sensors for various medical purposes, such as MRI imaging equipment and ultrasound scanners, and electronic applications, such as electrical appliances. There are four distribution methods for the temperature sensors, as shown in Table 1. Because of differing distribution and promotional costs, the product's profitability will vary with the distribution method. In addition, the advertising cost and the personal sales effort required will vary with the distribution method. The following table summarises the sensors' contribution to profit, advertising cost, and personal sales effort. Sherpa Sensors Pty Ltd has set the advertising budget at $65000, and a maximum of 3000 hours of salesforce time is available for the sales effort at the cost of $45/ hour. Management also decided to produce exactly 6000 sensors for the current production period. Finally, an ongoing contract with the national chain of retail stores requires that at least 1500 units be distributed through this distribution method. Sherpa Sensors Pty Ltd needs to establish a strategy that will provide for the distribution of the sensors to maximise the overall profitability of the sensor production. Decisions must be made about how many units should be allocated to each of the four distribution methods and how to allocate the advertising budget and salesforce effort to each of the four distribution methods. For the situation given above