Question: How to show the possible contraints and objective function on excel. 2. Witch Way? You're a witch, and you are enrolled in ESPM 102C, so

How to show the possible contraints and objective function on excel.
2. Witch Way? You're a witch, and you are enrolled in ESPM 102C, so you've realized that linear programming is incredibly useful to you in spell arsenal management. Here's the deal: you want to maximize the number of spells you can cast in a day. However, your spell casting is limited by your inspiration (it can be hard to be a witch). You spend some of your time in low-inspiration mode, some of your time in medium-inspiration mode, and some of your time in high-inspiration mode. You can't be in high-inspiration mode all the time, since that level of perpetual stoke can be exhausting. To manage your inspiration levels, you do one activity for each level of inspiration each day. So, each day consists of three activities, each corresponding to an inspiration level. You can't repeat activities in a given day - that would get boring. When you perform an activity, your spell arsenal gets charged with a number of new spells, as shown in the table below. Woohoo! (New Spells) (New Spells) (New Spells) (New Spells) Inspiration Level ESPM102C Lecture Migos Concert Spells 101 MOOC Watch Shrek High 80 20 25 105 Medium 40 25 45 50 Low 5 120 20 15 a. Formulate a linear program that maximizes your spell arsenal while ensuring that you only perform one activity per inspiration level per day. b. Set up your formulation in Excel. Please share a screenshot of your work. c. Which activity should you perform for each inspiration levelStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
