Question

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.  

      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.

Revenue.  R= [(p)][(x)] = [–0.4375(x) + 937.5][(x)] = –0.4375(x)²+ 937.5(x).

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

      c.  Use Excel’s Chart feature to plot the product’s “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

Answer 1