Solve clearly Cox Electric makes electronic components and has estimated the following for a new design of one oF its products: fixed 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:
fixed 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 profit by subtracting the fixed 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 profit 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,Dflfl to Emma in increments of
5,000. In which interval of production volume doe; breakeven occur? |:| to E units (I!) Use Goal Seek to find the exact breakeven point. Assign Set cell: equal to the location of profit, To value: – D, and By changing cell: equal to the location of
the production volume in your model. |:|

Do you need us to help you on this or any other assignment?


Make an Order Now
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.