You are employed at a pharmaceutical firm that produces two specific supplements - a vitamin supplement designed for children and an iodine supplement for thyroid disorders. The production and sales teams need to decide how many units of each supplement they need to produce in order to maximize profits. According to market research, there exists a huge demand for both of these products and the more you produce, the more you sell. Based on the criteria, you have been given the responsibility to prescribe resource allocation in pursuit of profit maximization. build a model to determine how much of each supplement to produce. You learn that the average profit generated by each unit is $15 and $21 for the vitamin supplement and the iodine supplement respectively. The average number of labor hours required to produce each unit of both the brands is 6 hours and 7 hours respectively. The machine hours are 7 and 12 respectively. You cannot use more than 50,000 machine hours and labor laws only permit the labor to work for a total of 30,000 hours during the period. Given these constraints, create a solver model to find optimal resource allocation that will determine each pharma product production level while meeting the goal of profit-maximizing. Develop an Answer Report. Explain your analysis of the solver model.

Categories Unit Profit Units Produced Super Pharma, Inc. Vitamin Supplement lodine Supplement $ $ Totals $ Machine (hours) Labor (hours) Total Profits $ Constraints Cell Reference Condition Condition2