
High-low method and regression analysis. Market Thyme, 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, Market Thyme 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.
Tom Diehl has run the produce club for the first season. Tom is now a farmer but remembers a few things about cost analysis from college. In planning for next year, he wants to know how many orders will be needed each week for the club to break even, but first he must estimate the club’s fixed and variable costs. He has collected the following data over the club’s first season of operation:
Week | Number of Orders per Week | Weekly Total Costs |
1 | 415 | $26,900 |
2 | 435 | 27,200 |
3 | 285 | 24,700 |
4 | 325 | 25,200 |
5 | 450 | 27,995 |
6 | 360 | 25,900 |
7 | 420 | 27,000 |
8 | 460 | 28,315 |
9 | 380 | 26,425 |
10 | 350 | 25,750 |
- 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. Tom uses his computer to calculate the following regression formula:
Draw the regression line on your graph. Use your graph to evaluate the regression line using the criteria of economic plausibility, goodness of fit, and 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.
- 4. Did Market Thyme 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 Market Thyme receive each of 10 weeks next season to break even?

Want to see the full answer?
Check out a sample textbook solution
Chapter 10 Solutions
Horngren's Cost Accounting, Student Value Edition Plus MyLab Accounting with Pearson eText - Access Card Package (16th Edition)
Additional Business Textbook Solutions
Accounting Information Systems (14th Edition)
Corporate Finance (4th Edition) (Pearson Series in Finance) - Standalone book
Intermediate Accounting (2nd Edition)
Marketing: An Introduction (13th Edition)
Horngren's Accounting (12th Edition)
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- On January 1, 2023, Pharoah Ltd. had 702,000 common shares outstanding. During 2023, it had the following transactions that affected the common share account: Feb. 1 Issued 160,000 shares Mar. 1 Issued a 10% stock dividend May 1 Acquired 181,000 common shares and retired them June 1 Issued a 3-for-1 stock split Oct. 1 Issued 78,000 shares ♡ The company's year end is December 31Determine the weighted average number of shares outstanding as at December 31, 2023. (Round answer to O decimal places, eg. 5,275.) Weighted average number of shares outstandingarrow_forwarduse the high-low method to calculate Smithson's fixed costs per month.arrow_forwardGeneral accounting questionarrow_forward
- On January 1, 2023, Pharoah Ltd. had 702,000 common shares outstanding. During 2023, it had the following transactions that affected the common share account: Feb. 1 Issued 160,000 shares Mar. 1 Issued a 10% stock dividend May 1 Acquired 181,000 common shares and retired them June 1 Issued a 3-for-1 stock split Oct. 1 Issued 78,000 shares ♡ The company's year end is December 31Determine the weighted average number of shares outstanding as at December 31, 2023. (Round answer to O decimal places, eg. 5,275.) Weighted average number of shares outstandingarrow_forwardOn January 1, 2023, Pharoah Ltd. had 702,000 common shares outstanding. During 2023, it had the following transactions that affected the common share account: Feb. 1 Issued 160,000 shares Mar. 1 Issued a 10% stock dividend May 1 Acquired 181,000 common shares and retired them June 1 Issued a 3-for-1 stock split Oct. 1 Issued 78,000 shares ♡ The company's year end is December 31 Assume that Pharoah earned net income of $3,441,340 during 2023. In addition, it had 90,000 of 10%, $100 par, non-convertible, non-cumulative preferred shares outstanding for the entire year. Because of liquidity limitations, however, the company did not declare and pay a preferred dividend in 2023. Calculate earnings per share for 2023, using the weighted average number of shares determined above. (Round answer to 2 decimal places, e.g. 15.25.) Earnings per sharearrow_forwardI want to correct answer general accounting questionarrow_forward
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Individual Income TaxesAccountingISBN:9780357109731Author:HoffmanPublisher:CENGAGE LEARNING - CONSIGNMENTEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning



