Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 10, Problem 10.36P
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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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.
MARKETING:
Kroger, the country's leading grocery-only chain, added a line of private label organic and natural foods call Simple Truth to its stores. If you've priced organic foods, you know they are more expensive. For example, a dozen conventionally farmed Grade-A eggs at Kroger costs consumers
$1.501.50,
whereas Simple Truth eggs are priced at
$3.453.45
per dozen. One study found that, overall, the average price of organic foods is 85 percent more than that of conventional foods. However, if prices get too high, consumers will not purchase the organic options. One element of sustainability is organic farming, which costs much more than conventional farming, and those higher costs are passed on to consumers. Suppose that a conventional egg farmer's average fixed costs per year for conventionally-farmed eggs are $1 million per year, but an organic egg farmer's fixed costs are
fourfour
times that amount. Further assume that the organic farmer's variable costs of…
Dairyplus processes organic milk into plain yogurt.
Dairyplus sells plain yogurt to hospitals, nursing homes, and restaurants in bulk, one-gallon containers. Each batch, processed at a cost of $830, yields 300 gallons of plain yogurt. Dairyplus sells the one-gallon tubs for $8 each, and spends $0.14 for each plastic tub. Dairyplus has recently begun to reconsider its strategy. Dairyplus wonders if it would be more profitable to sell individual-size portions of fruited organic yogurt at local food stores. Dairyplus could further process each batch of plain yogurt into
6,400 individual portions (3/4 cup each) of fruited yogurt. A recent market analysis indicates that demand for the product exists. Dairyplus would sell each individual portion for $0.58. Packaging would cost $0.05 per portion, and fruit would cost $0.09 per portion. Fixed costs would not change.
Should Dairyplus continue to sell only the gallon-size plain yogurt (sell as is) or convert the plain…
Chapter 10 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Ch. 10 - What two assumptions are frequently made when...Ch. 10 - Describe three alternative linear cost functions.Ch. 10 - What is the difference between a linear and a...Ch. 10 - High correlation between two variables means that...Ch. 10 - Name four approaches to estimating a cost...Ch. 10 - Describe the conference method for estimating a...Ch. 10 - Describe the account analysis method for...Ch. 10 - List the six steps in estimating a cost function...Ch. 10 - When using the high-low method, should you base...Ch. 10 - Describe three criteria for evaluating cost...
Ch. 10 - Define learning curve. Outline two models that can...Ch. 10 - Discuss four frequently encountered problems when...Ch. 10 - Prob. 10.13QCh. 10 - All the independent variables in a cost function...Ch. 10 - Multicollinearity exists when the dependent...Ch. 10 - HL Co. uses the high-low method to derive a total...Ch. 10 - A firm uses simple linear regression to forecast...Ch. 10 - In regression analysis, the coefficient of...Ch. 10 - A regression equation is set up, where the...Ch. 10 - What would be the approximate value of the...Ch. 10 - Estimating a cost function. The controller of the...Ch. 10 - Identifying variable-, fixed-, and mixed-cost...Ch. 10 - Various cost-behavior patterns. (CPA, adapted)....Ch. 10 - Matching graphs with descriptions of cost and...Ch. 10 - Account analysis, high-low. Stein Corporation...Ch. 10 - Account analysis method. Gower, Inc., a...Ch. 10 - Prob. 10.27ECh. 10 - Estimating a cost function, high-low method. Lacy...Ch. 10 - Linear cost approximation. Dr. Young, of Young and...Ch. 10 - Cost-volume-profit and regression analysis....Ch. 10 - Regression analysis, service company. (CMA,...Ch. 10 - High-low, regression. May Blackwell is the new...Ch. 10 - Learning curve, cumulative average-time learning...Ch. 10 - Learning curve, incremental unit-time learning...Ch. 10 - High-low method. Wayne Mueller financial analyst...Ch. 10 - High-low method and regression analysis. Market...Ch. 10 - High-low method; regression analysis. (CIMA,...Ch. 10 - Regression, activity-based costing, choosing cost...Ch. 10 - Interpreting regression results. Spirit...Ch. 10 - Cost estimation, cumulative average-time learning...Ch. 10 - Cost estimation, incremental unit-time learning...Ch. 10 - Regression; choosing among models. Apollo Hospital...Ch. 10 - Multiple regression (continuation of 10-42). After...Ch. 10 - Cost estimation. Hankuk Electronics started...Ch. 10 - Prob. 10.45PCh. 10 - Interpreting regression results, matching time...Ch. 10 - Purchasing department cost drivers, activity-based...Ch. 10 - Purchasing department cost drivers, multiple...
Additional Business Textbook Solutions
Find more solutions based on key concepts
18. What is the calculation for return on assets (ROA)? Explain what ROA measures.
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
Preparing Financial Statements from a Trial Balance The following accounts are taken from Equilibrium Riding, I...
Fundamentals Of Financial Accounting
1. For Frank’s Funky Sounds, straight-line depreciation on the trucks is a
Learning Objective 1
a. variable cos...
Horngren's Accounting (12th Edition)
Calculate profit margin on sales ratio. (LO 5). Suppose a firm had sales of $200,000 and net income of $7,000 f...
Financial Accounting
This year, Prewer Inc. received a 160,000 dividend on its investment consisting of 16 percent of the outstandin...
Principles Of Taxation For Business And Investment Planning 2020 Edition
What are assets limited as to use and how do they differ from restricted assets?
Accounting For Governmental & Nonprofit Entities
Knowledge Booster
Similar questions
- The Parents for Better Schools of Fresno, California, collected recipes from members and published a cookbook entitled Food for Everyone. The book will sell for $20 per copy. The chairwoman of the cookbook development committee estimated that the club needed to sell 800 books to break even on its $3,600 investment. What is the variable cost per unit assumed in the Parents for Better Schools’ analysis?arrow_forwardFreshly Farms plants 80 acres of Brussels sprouts every spring. Freshly sells its sprouts to a farmers cooperative, which sells them to a wholesaler, which sells them to retailers, which sells them to consumers. The farmers cooperative buys Freshly Brussels sprouts for $0.98 per pound. The cooperative takes a 16% margin on the cooperative's selling price. The wholesaler takes a 16% markup on the wholesaler's cost. The retailer takes a 15% margin on the retailer's selling price. How much does a consumer pay to the retailer for one pound of Freshly Farms Brussels sprouts? (Rounding: penny.) ANSWER IS: 1.59, but HOW is that the answer? Please explain.arrow_forwardGreat Oaks Farm grows organic vegetables and sells them to local restaurants after processing. The farms leading produce is Salad in a bag, which is mixed of organic salad green ingredients prepared ready to serve. The company sells a large bag to restaurants for $25. It calculates the variable cost per bag at $19, including $1. For delivery, and the average total cost per bag is $22. Because the vegetables are perishable and Great Oaks Farm is experiencing a large crop, the farm has extra capacity. Another company offers to purchase 2500 bags during the next month at $21 per bag. Delivery to the company cost $0.75 per bag. It can meet most of the request but would sacrifice 400 bags of regular sales to fill the special order. a. using differential analysi, what is the impact on profits of accepting this special order? b. What nonquantitative issues should management consider before making a final decision? c. How would the analysis change if the special order were for…arrow_forward
- MARKETING: Kroger, the country's leading grocery-only chain, added a line of private label organic and natural foods call Simple Truth to its stores. If you've priced organic foods, you know they are more expensive. For example, a dozen conventionally farmed Grade-A eggs at Kroger costs consumers $1.61.6, whereas Simple Truth eggs are priced at $3.43.4 per dozen. One study found that, overall, the average price of organic foods is 85 percent more than that of conventional foods. However, if prices get too high, consumers will not purchase the organic options. One element of sustainability is organic farming, which costs much more than conventional farming, and those higher costs are passed on to consumers. Suppose that a conventional egg farmer's average fixed costs per year for conventionally-farmed eggs are $1 million per year, but an organic egg farmer's fixed costs are threethree times that amount. Further assume that the organic farmer's variable costs of…arrow_forwardCrepe Creations (CC) is considering franchising its unique brand of crepes to stall- holders on Hermoza Beach, which is four miles long. CC estimates that, on an average day, there are 1,000 sunbathers evenly spread along the beach and each sunbather will buy one crepe per day provided that the price plus any disutility cost does not exceed $5. Each sunbather incurs a disutility cost of getting up from resting to get a crepe and returning to their beach spot of 25 cents for every 1⁄4 mile the sunbather has to walk to get to the CC stall. Each crepe costs $0.50 to make and CC incurs a $40 overhead cost per day to operate a stall. What price should CC charge if it only has one store? What profit would CC gain if it only has one store? How many franchises should CC award given that it determines the prices the stall holders can charge and that it will have a profit-sharing royalty scheme with the stall holders? What is price of a crepe at each stall?arrow_forwardBerry Farm produces organic tomatoes and strawberries. In June 2024, it transported 125 boxes of strawberries with a price of $24 per box to the Bay Farmers’ Market. Berry Farm paid an upfront fee of $200 to present its products at the market for one week, and the market earns a 20% profit margin on each item sold, but Berry Farm is responsible for any items that remain unsold at the end of the week. Required: The market was able to sell 80 boxes of strawberries to customers. How much revenue should Berry Farm recognize with respect to this transaction?arrow_forward
- pecial OrderFull Belly Farm grows organic vegetables and sells them to distributors and local restaurants after processing. Assume the farm’s leading product for restaurant customers is a mixture of organic green salad ingredients prepared and ready to serve. The company sells a large bag to restaurants for $30. It calculates the variable cost per bag at $20 (including $1 for local delivery), and the average total cost per bag is $24. Growing conditions have been very good this season and Full Belly has extra capacity.A representative of a restaurant association in another city has offered to buy fresh salad stock from the company to augment its regular supply during an upcoming international festival. The restaurant association wants to buy 3,600 bags during the next month for $22 per bag. Delivery to restaurants in the other city will cost the company $0.75 per bag. It can meet most of the order with excess capacity but would sacrifice 240 bags of regular sales to fill this special…arrow_forwardTo generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3000, and the average first-year commission for each new account opened is $5800. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of the relevant parameters. Round your answers to the nearest dollar.Profit = (New Accounts Opened × $( ) – $ ( ) What type of random variable is the number of new accounts opened? (Hint: Review Appendix 16.1 for descriptions of various types of probability distributions.)The number of new accounts opened is a random variable with fill in the blank 4 trials and fill in the blank 5 probability of a success on a single trial. Assume that the number of new accounts…arrow_forwardTo generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3000, and the average first-year commission for each new account opened is $4600. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of the relevant parameters. Round your answers to the nearest dollar.Profit = (New Accounts Opened × $ fill in the blank 1) – $ fill in the blank 2 What type of random variable is the number of new accounts opened? (Hint: Review Appendix 16.1 for descriptions of various types of probability distributions.)The number of new accounts opened is a random variable with fill in the blank 4 trials and fill in the blank 5 probability of a success on a single trial. Assume that the…arrow_forward
- Fast Foods Giant (FFG) is a fast food chain and purchases 100,000 pounds of soybean oil per month to fry French fries. FFG typically purchases soybean oil on the local spot market and the company has not entered into any forward purchase contracts for its soybean oil. FFG’s management team has prepared a business plan for the year which assumes $30.00 per pound soybean oil prices. Margins in the fast food business are fairly slim, though, so management is concerned that a significant increase in the price of oil could cause the company to miss its earnings projections. Spot soybean oil prices have been acceptable over the first six months of the year, but management is now concerned about December oil prices. On July 1, management decides it wants to use soybean oil futures contracts to manage its price risk for purchases of soybean oil in December. Assume that FFG’s management has properly documented a cash flow hedge accounting program associated with this risk management activity,…arrow_forwardThe Grand Inn is a restaurant in Flagstaff, Arizona. It specializes in southwestern style meals in a moderate price range. Paul Weld, the manager of Grand, has determined that during the last 2 years the sales mix and contribution margin ratio of its offerings are as follows. Percent ofTotal Sales ContributionMargin Ratio Appetizers 15 % 50 % Main entrees 50 % 25 % Desserts 10 % 50 % Beverages 25 % 80 % Paul is considering a variety of options to try to improve the profitability of the restaurant. His goal is to generate a target net income of $117,000. The company has fixed costs of $1,053,000 per year. (a) Calculate the total restaurant sales and the sales of each product line that would be necessary to achieve the desired target net income. (Round intermediate calculations to 3 decimal places e.g. 0.251 and final answers to 0 decimal places, e.g. 2,510.) Total restaurant sales $ Sales from Each Product…arrow_forwardSouthwestern 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub