PROBLEM 1 Cox Electric makes electronic components and has estimated the following for a new design of one of its products: (a) Build mathematical model for calculating profit and find the resulting profit if Cox Electric makes 12,000 units of a new product. Cox Electric Breakeven Analysis Parameters Revenue per Unit Fixed Costs Material Cost per Unit Labor Cost per Unit Profit / Loss (b) Construct one-way data table with production volumn as the column input and profit as the output. Vary production from 0 to 100,000 in increments of 10,000 . In which interval of production volume does breakeven occur? (c) Use Goal Seek to find exact breakeven point. Assign Set cell: equal to the location of profit, To value: =0, and By changing cell: equal to the location of the production volume in the model