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. <\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/153636"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=153636"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/153636\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=153636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=153636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=153636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}