# Solve clearly Cox Electric makes electronic components and has estimated the following for a new design of one oF its products: ﬁxed Cost – \$19,000 Material cost per unit –

Solve clearly Cox Electric makes electronic components and has estimated the following for a new design of one oF its products:
ﬁxed Cost – \$19,000 Material cost per unit – \$0.15 Labor cost per unit – \$0.10 Revenue per unit – \$0.65 Production Volume – 12,000 Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all it produces, build a spreadsheet model that
calculates the proﬁt by subtracting the ﬁxed cost and total variable cost from total revenue, and answer the following questions. (3) Construct a cIne-vlliravr data table with production volume as the column Input and proﬁt as the output. Breakeven occurs when profit goes from a negative to a
positive value; that is, breakeven is when total revenue – total cost, yielding a profit of zero. \l’anur production volume from 5,Dﬂﬂ to Emma in increments of
5,000. In which interval of production volume doe; breakeven occur? |:| to E units (I!) Use Goal Seek to ﬁnd the exact breakeven point. Assign Set cell: equal to the location of proﬁt, To value: – D, and By changing cell: equal to the location of
the production volume in your model. |:|

0 replies