How do you solve for Underage Cost, Overage Cost, Retailer Exp. Profit, Manufacturer Exp. Profit, and Supply Chain Exp. Profit?

Please use Excel to solve and PLEASE include$/$show Excel formulas for calculations.

The Green Company is a retailer of gourmet bottled pickles that purchases its products from Whole, a gourmet food manufacturer. Green buys units $($from Whole$)$ at a price of $$15$ per unit and sells them to customers at $$45$ per unit. Currently Whole produces to Green$$s order and delivers all requirements at the start of the period. Leftover inventory at the end of the season will be donated to a charity organization for free. The demand is lost when Green does not have inventory. Whole$$s production cost is $$10$ per unit.