please answer parts a-d

Cox Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed Cost-$12,000 Material Cost per Unit - $0.17 Labor Cost per Unit - $0.11 Revenue per Unit = $0.68 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. (a) Build an influence diagram that illustrates how to calculate profit. Profit Profit Total Cost Fixed Cost Total Revenue Production Volume Fixed Cost Havenue Revenue per Unit Total Variable cost Total Cost Total Variable cost per unit Production Tatal Volume Revenus Material Cost per Unit Labor Cast per Unit Material Coat per Unit Labor Cast per Unit Profit Total Revenue Total Cost Total Fevenue Total Cost Material Cost aer Unit Fixed Profit 9 Revenu per part Tatal Variable Post Fixed Cost Tatal Variable Obst Labor Cont Revenue per Unit per Unit Material Cost Ver Unit Production Volume Production Volume Labor Cost per Unit (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 Pla) - 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 1 Cox Electric Breakeven Analysis 2 3 4 5 Parameters Revenue per Unit Fixed Costs Materials Cost per Unit Labar Cast per Unit $0.68 $12,00D 00 $0.17 $0.11 6 7 8 9 Model Production valume 10 11 12 13 Total Revenue B11'84-85 1 14 15 =B 11/06 .] Materials Cost Labor Cost 16 B7/B6 17 Fixed Cast =IF(85>0,311,0) =SUM84:87) 18 Total Cost 19 20 Profit ( =B13-B17 21 (d) If Cox Electric makes 11,000 units of the new product, what is the resulting profit (in dollars)? $