$($b$)$

Using mathematical notation similar to that used for Nowlin Plastics, give a mathematical model for calculating profit. $($Write your answer in terms of the following variables q $=$ Production Volume $($quantity produced$),$ R $=$ Revenue Per Unit, FC $=$ the Fixed Costs of Production, MC $=$ Material Cost per Unit, LC $=$ Labor Cost per Unit, and P$($q$)=$ Total Profit for producing $($and selling$)$ q units.$)$

P$($q$)=$

$($c$)$

Implement your model from part $($b$)$ in Excel using the principles of good spreadsheet design.

A B C

$1$ Cox Electric Breakeven Analysis

$2$

$3$ Parameters

$4$ Revenue per Unit $$0\mathrm{.}63$

$5$ Fixed Costs $$12,000\mathrm{.}00$

$6$ Materials Cost per Unit $$0\mathrm{.}16$

$7$ Labor Cost per Unit $$0\mathrm{.}11$

$8$

$9$

$10$ Model

$11$ Production Volume

$12$

$13$ Total Revenue

$---$Select$---$

$14$

$15$ Materials Cost

$---$Select$---$

$16$ Labor Cost

$---$Select$---$

$17$ Fixed Cost

$---$Select$---$

$18$ Total Cost

$---$Select$---$

$19$

$20$ Profit

$---$Select$---$

$21$

$($d$)$

If Cox Electric makes $18,000$ units of the new product, what is the resulting profit $($in dollars$)?$

$