case analysis

see the case and answer the question.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.

Order your essay today and save 30% with the discount code ESSAYHELP