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 solutionChapter 10 Solutions
COST ACCOUNTING
Additional Business Textbook Solutions
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
Fundamentals Of Financial Accounting
Horngren's Accounting (12th Edition)
Financial Accounting
Principles Of Taxation For Business And Investment Planning 2020 Edition
Accounting For Governmental & Nonprofit Entities
- Southwestern Freight Forwarders is planning to hold a fundraising event to build an elementary school according to the company’s corporate social responsibility targets, at one of the local country clubs. It has two options for the event: OPTION 1: Crestview Country Cluba. Fixed rental cost of $1,000b. $12 per person for food OPTION 2: Tallgrass Country Cluba. Fixed rental cost of $3,000b. A caterer who charges $8.00 per person for food Southwestern Freight Forwarders has budgeted $1,800 for administrative and marketing expenses. It plans to hire a band which will cost another $800. Tickets are expected to be $30 per person. Local freight businesssupporters will donate any other items required for the event. a) Which option provides the least amount of risk? b) Which option provides the greatest operating income if 600 people attend? c) Which option provides the greatest degree of operating leverage if 600 people attend? d) Which option would you choose? Why?arrow_forwardThere are 300 purely competitive farms in the local dairy market. Of the 300 dairy farms, 298 have a cost structure that generates profits of $18 for every $300 invested. Instructions: Enter your answers as a whole number. a. What is the percentage rate of return for these 298 dairies? percent b. The other two dairies have a cost structure that generates profits of $26 for every $200 invested. What is their percentage rate of return? percent c. Assuming that the normal rate of profit in the economy is 10 percent, and that firms cannot copy each other's technology, will there be entry or exit? (Click to select) ♥ d. Will the change in the number of firms affect the two that earn $26 for every $200 invested? O No, because those two firms are too small. O No, because the exiting firms didn't belong in the industry. O Yes, because those two firms can claim a larger market share. O Yes, because those exiting firms will spread their technology. e. What will be the rate of return earned by…arrow_forwardThe University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives fourteen free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium: Registration Processing: Speaker Costs: Continental Breakfast: Lunch: Parking: $150 $8.50 per person 3@$800 $2,400 $4.00 per person $7.00 per person $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but nonmembers who do not attend will be refunded 50%…arrow_forward
- Consider the following hypothetical sales scenario. A large community college buys and takes delivery of 50 iMac computers from a local Apple store. The invoiced price is $2,800 per unit and includes hardware, software essential to the functionality of the hardware, third-party software including Microsoft Office for Mac and Adobe Creative Suite, and two years of tech service and support. Apple uses vendor-specific objective evidence to determine unit prices of $2,500 and $300 for hardware and the essential software, respectively. The third-party software typically retails for $500 (but Apple purchases it at a 50% discount) and equivalent service and support contracts are $100 per year. The customer (the community college) can opt to purchase subsequent essential software and OS upgrades. Indicate how Apple should record gross revenue for the transaction at the time the customer takes delivery of the computers. Your response should include specific dollar amounts.arrow_forwardThe University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium: Registration Processing: Speaker Costs: 3@$800 Continental Breakfast: Lunch: Parking: $150 $8.50 per person $2,400 $4.00 per person $7.00 per person $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but for nonmembers…arrow_forwardThe University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium: $150 Registration Processing: $8.50 per person Speaker Costs: 3@$800 $2,400 Continental Breakfast: $4.00 per person Lunch: $7.00 per person Parking: $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do…arrow_forward
- The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium: Registration Processing: Speaker Costs: Continental Breakfast: Lunch: Parking: (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but nonmembers who do not attend will be refunded 50% of the price. Build a spreadsheet model that calculates a…arrow_forwardThe University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium Registration processing Speaker costs Continental breakfast Lunch Parking $150 $8.50 per person 3@$800 = $2,400 $4.00 per person $7.00 per person $5.00 per person (a) Build a spreadsheet model that calculates a profit or loss for 100 nonmember registrants. If required, round your answer to two decimal places. $ 5606.44 (b) Use…arrow_forwardThe University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $80 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium $150 Registration processing $8.50 per person Speaker costs 30$800 = $2,400 Continental breakfast $4.00 per person Lunch $7.00 per person Parking $5.00 per person (a) Build a spreadsheet model that calculates a profit or loss for 100 nonmember registrants. If required, round your answer to two decimal places. (b) Use Goal Seek to…arrow_forward
- The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives ten free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium: Registration Processing: Speaker Costs: Continental Breakfast: Lunch: Parking: $150 $8.50 per person 3@$800 = $2,400 $4.00 per person $7.00 per person $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but nonmembers who do not…arrow_forwardThe University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives seven free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: Rental cost for the auditorium: $150 Registration Processing: $8.50 per person Speaker Costs: 3@$800 = $2,400 Continental Breakfast: $4.00 per person Lunch: $7.00 per person Parking: $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not…arrow_forwardThere are 300 farms in the perfectly competitive local dairy market. Of the 300 dairy farms, 298 have a cost structure that generates profits of $24 for every $300 invested. Instructions: Enter your answers as whole numbers. a. What is the percentage rate of return for these 298 dairies? percent. b. The other two dairies have a cost structure that generates profits of $22 for every $200 invested. What is their percentage rate of return? percent. c. Assuming that the normal rate of profit in the economy is 9 percent, and farms cannot copy each others' technology, will there be entry or exit? (Click to select) Will the change in the number of farms affect the two that earn $22 for every $200 invested? (Cick to select) What will be the rate of return earned by most farms in the industry in long-run equilibrium? O percent. If farms can copy each others' technology, what will be the rate of return eventually earned by all farms? percent.arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningIndividual Income TaxesAccountingISBN:9780357109731Author:HoffmanPublisher:CENGAGE LEARNING - CONSIGNMENT
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,