You will build an optimization model and practice using the Solver function in Excel to perform prescriptive analytics. Imagine that you are employed at a pharmaceutical firm that produces two specific supplements: a vitamin supplement 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 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. You will build a model to determine how much of each supplement to produce. FOLLOW THE ATTACHED INSTRUCTIONS.
qualityassignments.net is a custom writing service that provides online on-demand writing work for assistance purposes. All the work should be used in accordance with the appropriate policies and applicable laws.
Phone: +1 (940) 905 5542