Consider the simple model someone built on in this Excel Ass…

Consider the simple model someone built on in this Excel Assessment template file. Following best practices discussed in class, convert it to an optimization problem that finds — according to the model — the best price to help the company achieve the highest projected profit while keeping the total costs per unit sold (i.e., [total cost]/[Units sold]) less than or equal to $100 per unit. Then, answer the questions below.

Imagine a very smart badger built a Python model as a functi…

Imagine a very smart badger built a Python model as a function that can predict your company’s profits next year based on various inputs that you would need to provide. How did this class suggest you leverage optimization and this model to increase profits?