$1.$ Create a spreadsheet model for this problem and solve it$.$ What is the optimal solution?

$2.$ If Adrian wanted to improve this solution, what additional resources would be needed and where would they be needed? Explain.

$3.$ What would TGL$$s optimal profit be if the company was

not required to supply at least $90\%$ of each distributor$$s order?

$4.$ Suppose TGL$$s agreement included the option of paying a $$10,000$ penalty if the company cannot supply at least $90\%$ of each distributor$$s order but instead supply at least $80\%$ of each distributor$$s order. Comment of the pros and cons of TGL exercising this option.