Part $1(0\mathrm{.}5$ pts$).$ In Excel, in a new tab called $"$TP$",$ prepare a mathematical expression $($formula$)$ for Wawa$$s total profit $($call it TP$)$ if the gross profit margin is $45\%$ of the selling price for each bottle of Wawa$-$brand diet green tea $($GT$)$ and the GT sells for $$1\mathrm{.}19$ per bottle. But there's more: Wawa also allocates a five$-$cent per bottle cost overhead to account for refrigeration and other inventory management costs. Oh$,$ and the sales tax in New Jersey is $6\mathrm{.}625\%.$ Then use this expression to calculate the TP for the next week from today for three different scenarios: if weekly sales of Wawa$-$brand diet green tea are $100,200,$ and $500$ bottles.

Part $2(0\mathrm{.}5$ pts$).$ In Excel, in a new tab called FPPS$,$ prepare a mathematical expression $($formula$)$ for Wawa fuel profit per store $($call it FPPS$)$ when per gallon gross profit is $$0\mathrm{.}75$ per gallon of gasoline $($G$)$ fuel sold and $$0\mathrm{.}83$ per gallon of diesel $($D$)$ fuel sold. Assume operating costs $($OC$)$ to pump each gallon of gasoline and diesel fuel are each $$0\mathrm{.}25$ per gallon and must be subtracted from gross profit to derive FPPS$.$ For both types of fuel, a New Jersey fuel sales tax $($FST$)$ of $$0\mathrm{.}29$ per gallon must be subtracted from the gross profit number and must be paid to the State of New Jersey. Then show what might be the FPPS for the next calendar month from today if sales of $($a$)$ gasoline fuel are $10,000$ and diesel fuel are $1,000,($b$)$ gasoline fuel are $20,000,$ and diesel is $2,000$ gallons, $($c$)$ gasoline fuel is $30,000$ and diesel fuel is $3,000$ gallons.

Rubric:

$1.$ In a single Excel file, an accurate mathematical model expression for Part $1$ and Part $2$ is provided; each is worth $50\%$ of the assignment grade. Partial credit may be awarded for partially accurate models.