Cox Electric Breakeven Analysis

Revenue per Unit $$0\mathrm{.}65$

Fixed Costs $$10,000\mathrm{.}00$

Material Cost per Unit $$0\mathrm{.}15$

Labor Cost per Unit $$0\mathrm{.}10$

a$.$Construct a one$-$way 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, yielding a profit of zero. Vary production volume from $0$ to $100,000$ in increments of $10,000.$ In which interval of production volume does breakeven occur? Please include and show all excel functions and answers.