Homework Section 8 Please complete the following problems and show all of your work Produced Total Cost 500 $ 127,000 1.000 $ 154,000 1.500 $ 196,000 2,000 $ 221,000 Selling price: $85 You expect to sell 300 per month (a) Graph the data is the data approximately line ar? (b) What is your visual estimate of the fixed cost? (c) Use Regression to fit a linear model to this data What is the slope and the y-intercept of the linear model? (d) What is the fixed cost and variable cost for this production? (e) Find the equation for C(x) ( Graph C() on the data graph from part (a). What are the two "model points that you used to graph this line? (g) Find the equations for R(x) and P(x). (h) What is the break-even point? 0 You have just sold your 2,000th unit. How much longer (in time) until you break even? 0 Graph P(x), R(x), and C'(x) on the same set of axis Graph and label the intersection point Show all work & applicable excel formadas Homework Section 8 Please complete the following problems and show all of your work Produced Total Cost 500 $ 127,000 1.000 $ 154,000 1.500 $ 196,000 2,000 $ 221,000 Selling price: $85 You expect to sell 300 per month (a) Graph the data is the data approximately line ar? (b) What is your visual estimate of the fixed cost? (c) Use Regression to fit a linear model to this data What is the slope and the y-intercept of the linear model? (d) What is the fixed cost and variable cost for this production? (e) Find the equation for C(x) ( Graph C() on the data graph from part (a). What are the two "model points that you used to graph this line? (g) Find the equations for R(x) and P(x). (h) What is the break-even point? 0 You have just sold your 2,000th unit. How much longer (in time) until you break even? 0 Graph P(x), R(x), and C'(x) on the same set of axis Graph and label the intersection point Show all work & applicable excel formadas