see the case and answer the question.

Case3:High-low method and regression analysis. Mars Co., a cooperative of organic family

owned farms, has recently started a fresh produce club to provide support to the group’s member

farms and to promote the benefits of eating organic, locally produced food. Families pay a

seasonal membership fee of $100 and place their orders a week in advance for a price of $40 per

order. In turn, Mars Co. delivers fresh-picked seasonal local produce to several neighborhood

distribution points. Five hundred families joined the club for the first season, but the number of

orders varied from week to week.

Pam Luck has run the produce club for the first season. Pam is now a farmer but remembers a

few things about cost analysis from college. In planning for next year, she wants to know how

many orders will be needed each week for the club to break even, but first she must estimate the

club’s fixed and variable costs. She has collected the following data over the club’s first 12 weeks

of operation:

Week Number of Orders per Week Weekly Total Costs

1 380 26,425

2 385 26,600

3 285 24,700

4 325 25,200

5 350 25,750

6 420 27,000

7 360 25,900

8 435 27,200

9 415 26,900

10 450 27,995

11 390 26,750

12 460 28,315

Required (1 thru 5 for written analysis):

1. Plot the relationship between number of orders per week and weekly total costs.

2. Estimate the cost equation using the high-low method, and draw this line on your graph.

3. Estimate the cost equation using the regression analysis, and provide the regression equation

formula such as:

Weekly total costs = A + ($B  Number of orders per week)

4. Did Mars Co. break even this season? Remember that each of the families paid a seasonal

membership fee of $100.

5. Assume that 500 families join the club next year and that prices and costs do not change. How

many orders, on average, must Mars Co. receive each of 12 weeks next season to break even?

6 (For presentation only). Draw the regression line on your graph. Use your graph to evaluate

the regression line using

1) the criteria of economic plausibility,

2) goodness of fit, and

3) significance of the independent variable.

Is the cost function estimated using the high-low method a close approximation of the cost

function estimated using the regression method? Explain briefly.