4. Create a C/R/Psystem chart for your product line. First, complete the data matrix

shown below with appropriate R and P values that would be associated with each

given value of x. Second, use the x, C, R, P information as the basis for

your Excel Chart.

R= 0.4375(x)²+ 937.5(x).

C = -0.1733(x)²+ 424.81(x)+ 119,384

P= 0.2642(x)²+ 512.69(x) 119,384

QUESTIONS:

a. To identify Revenue R values, use the equation you previously created in

Section B, item B.3, to perform calculations at each x value.

b. To identify Profit P values, perform (R) (C) calculations at each x value.

c. Use Excels Chart feature to plot the products C, R and P values from

your completed data matrix on one set of axes. Include trend lines, trend line

equations and appropriate [(R²)] or [(R²)_adj] values.

Product	17
Units [x]	Cost [C]	Revenue [R]	Profit [P]
100	145,000
200	225,000
400	245,000
600	315,000
800	350,000
1,000	370,000
1,200	380,000