Canadian Cannabis Consortium Company Version CCCC The CCCC wishes to develop its initial product planning design as it takes advantage of new legalization laws in Canada and the US for cannabis products. It expects to expand and modify their cannabis distribution in the future, but they wish to maximize their protability initially prior to the new market hitting equilibrium. CCCC has 5 production facilities/farms (Code named Fl through F5) where raw cannabis is grown. The F anns' (Fx) cannabis attributes include the maximum crop available (lbs), the per lb. growing cost, the THC measure per 1b., and the CBD measure per 1b. As a policy, the minimum amount of cannabis that can be used from each Farm is 60% of the maximum. And don't forget to model the maximum as well. The data is shown on the next page. CCCC will take cannabis from the five farms and blend them together to make three products 7 PAIN, RELAX and FOCUS. Each product has a different sales price (per lb.) and a different cost to manufacture (also per 1b.). Additionally each product has different requirements in terms of the weighted average value of THC and CBD. PAIN: THC levels must average less than or equal to 11.2. RELAX: THC levels must average greater than or equal to 12.5 FOCUS: THC levels must average less than or equal to 10.1 CBD: All three products must INDIVIDUALLY average at least 8.7. PAIN - an individual farm cannot provide more than 35% of the total cannabis used in PAIN. RELAX an individual farm cannot provide more than 32.5% of the total cannabis used in RELAX. FOCUS - does not have this requirement. Finally, each of the three products must make up at least 25% of total production (measured in lbs.). Additionally, you cannot make more than 1000 lbs. of any one product. CCCC wishes to determine how to optimally design the production of its 3 products using the cannabis grown at its 5 farms. All costs and revenues are measured on a per pound basis. Costs are production costs and growing costs (see data provided). Revenues come from total product made times the sales price. The goal of your model is to maximize revenue less costs. At the very end, when your model is working well, save the solution without integers and then force the variables to be integers. If it takes longer than 3 minutes, kill and save that solution. Summarize your solution with some sort of rudimentary picture, graphic or brief discussion. DATA MAX Cost THC CBD F1 F2 F3 F4 F5 Sales Manu cost PAIN 46 9 RELAX 40 8 FOCUS 54 13 This is version 1 of the problem. I reserve the right to alter if errors are uncovered