In cell C$41,$ calculate how many gallons of beer Misty should produce of Dinner in every production run so that it will minimize inventory costs.

$-$Note: This must be a formula and use cell references.

In Cell F$34,$ calculate the maximum number of gallons MBC will have of Dinner at any given time.

$-$Note: This must be a formula.

In cell F$35,$ calculate the Annual Holding Cost for Dinner.

$-$Note: This must be a formula.

In cell F$36,$ calculate the number of production runs MBC will have for Dinner in a vear

$-$Note: This must be a formula. You must ONLY use cell references.

In cell F$37,$ calculate the Annual Setup Cost for Dinner.

$-$Note: This must be a formula. You must ONLY use cell references.

Production Quantity $($Qp$*)$