Miller Cereals is a small milling company that makes a single brand of cereal. Recently, a business school intern recommended that the company introduce a second cereal in order to “diversify the product portfolio.” Currently, the company shows an operating profit that is 20 percent of sales. With the single product, other costs were twice the cost of rent.
The intern estimated that the incremental profit of the new cereal would only be 2.5 percent of the incremental revenue, but it would still add to total profit. On his last day, the intern told Miller’s marketing manager that his analysis was on the company laptop in a spreadsheet with a file name, NewProduct.xlsx. The intern then left for a 12-month walkabout in the outback of Australia and cannot be reached.
When the marketing manager opened the file, it was corrupted and could not be opened. She then found an early (incomplete) copy on the company’s backup server. The incomplete spreadsheet is shown following. The marketing manager then called a cost
Required
As the management accountant, fill in the blank cells.
Fill in the blank cells of the projected income statement.
Explanation of Solution
Projected income statement: The projected income statement represents the future financial position of the entity. The projected income statement is prepared with an objective of showing the financial results for a future period of time.
Fill in the blank cells of the projected income statement:
Company M | ||||
Projected Income Statement | ||||
For One Year | ||||
Status Quo: | % Increase | Alternative | ||
Single Product | Decrease | Two Products | Difference | |
Sales revenue | $ 150,000 (a) | 40% | $ 210,000 (b) | $ 60,000 |
Costs | ||||
Material | $ 40,000 | 50% (j) | $ 60,000 | $ 20,000 (k) |
Labor | $ 50,000 (l) | 20% | $ 60,000 | $ 10,000 (m) |
Rent | $ 6,000 (q) | 50% | $ 9,000 (s) | $ 3,000 (u) |
Depreciation | $ 8,000 | 0% (n) | $ 8,000 | $ - |
Utilities | $ 4,000 (o) | 25% (p) | $ 5,000 | $ 1,000 |
Other | $ 12,000 (r) | $ 36,500 (t) | $ 24,500 (v) | |
Total costs | $ 120,000 (g) | $ 178,500 (i) | $ 58,500 (h) | |
Operating profit | $ 30,000 (c) | 5% (f) | $ 31,500 (e) | $ 1,500 (d) |
Table (1)
Working note 1:
Compute the value of (a):
It is given that the profit has increased by 40%. (a) represents the amount of sales revenue.
Working note 2:
Compute the value of (b):
Working note 3:
Compute the value of (c):
Working note 4:
Compute the value of (d):
Working note 5:
Compute the value of (e):
Working note 5:
Compute the value of (f):
Working note 6:
Compute the value of (g):
Working note 6:
Compute the value of (h):
Working note 7:
Compute the value of (i):
Working note 8:
Compute the value of (j):
Working note 9:
Compute the value of (k):
Working note 10:
Compute the value of (l):
Working note 11:
Compute the value of (m):
Working note 12:
Compute the value of (n):
The value of n is 0 as there was no change.
Working note 13:
Compute the value of (o):
Working note 14:
Compute the value of (p):
Working note 15:
Compute the value of (q):
Value of rent:
The value of rent is half of the other costs. Thus, the value of rent will be $6,000, and that of other costs will be $12,000.
Thus,
Working note 16:
Compute the value of (r):
Working note 17:
Compute the value of (s):
Working note 18:
Compute the value of (t):
Working note 19:
Compute the value of (u):
Working note 20:
Compute the value of (v):
Want to see more full solutions like this?
Chapter 1 Solutions
Fundamentals Of Cost Accounting (6th Edition)
- Bienestar, Inc., has two plants that manufacture a line of wheelchairs. One is located in Kansas City, and the other in Tulsa. Each plant is set up as a profit center. During the past year, both plants sold their tilt wheelchair model for 1,620. Sales volume averages 20,000 units per year in each plant. Recently, the Kansas City plant reduced the price of the tilt model to 1,440. Discussion with the Kansas City manager revealed that the price reduction was possible because the plant had reduced its manufacturing and selling costs by reducing what was called non-value-added costs. The Kansas City manufacturing and selling costs for the tilt model were 1,260 per unit. The Kansas City manager offered to loan the Tulsa plant his cost accounting manager to help it achieve similar results. The Tulsa plant manager readily agreed, knowing that his plant must keep pacenot only with the Kansas City plant but also with competitors. A local competitor had also reduced its price on a similar model, and Tulsas marketing manager had indicated that the price must be matched or sales would drop dramatically. In fact, the marketing manager suggested that if the price were dropped to 1,404 by the end of the year, the plant could expand its share of the market by 20 percent. The plant manager agreed but insisted that the current profit per unit must be maintained. He also wants to know if the plant can at least match the 1,260 per-unit cost of the Kansas City plant and if the plant can achieve the cost reduction using the approach of the Kansas City plant. The plant controller and the Kansas City cost accounting manager have assembled the following data for the most recent year. The actual cost of inputs, their value-added (ideal) quantity levels, and the actual quantity levels are provided (for production of 20,000 units). Assume there is no difference between actual prices of activity units and standard prices. Required: 1. Calculate the target cost for expanding the Tulsa plants market share by 20 percent, assuming that the per-unit profitability is maintained as requested by the plant manager. 2. Calculate the non-value-added cost per unit. Assuming that non-value-added costs can be reduced to zero, can the Tulsa plant match the Kansas City per-unit cost? Can the target cost for expanding market share be achieved? What actions would you take if you were the plant manager? 3. Describe the role that benchmarking played in the effort of the Tulsa plant to protect and improve its competitive position.arrow_forwardBoxer Production, Inc., is in the process of considering a flexible manufacturing system that will help the company react more swiftly to customer needs. The controller, Mick Morrell, estimated that the system will have a 10-year life and a required return of 10% with a net present value of negative $500,000. Nevertheless, he acknowledges that he did not quantify the potential sales increases that might result from this improvement on the issue of on-time delivery, because it was too difficult to quantify. If there is a general agreement that qualitative factors may offer an additional net cash flow of $150,000 per year, how should Boxer proceed with this Investment?arrow_forwardAt Stardust Gems, a faux gem and jewelry company, the setting department is a bottleneck. The company is considering hiring an extra worker, whose salary will be $67,000 per year, to ease the problem. Using the extra worker, the company will be able to produce and sell 9,000 more units per year. The selling price per unit is $20. The cost per unit currently is $15.85 as shown: What is the annual financial impact of hiring the extra worker for the bottleneck process?arrow_forward
- Artisan Metalworks has a bottleneck in their production that occurs within the engraving department. Jamal Moore, the COO, is considering hiring an extra worker, whose salary will be $55,000 per year, to solve the problem. With this extra worker, the company could produce and sell 3,000 more units per year. Currently, the selling price per unit is $25 and the cost per unit is $7.85. Using the information provided, calculate the annual financial impact of hiring the extra worker.arrow_forwardShelby Industries has a capacity to produce 45.000 oak shelves per year and is currently selling 40,000 shelves for $32 each. Martin Hardwoods has approached Shelby about buying 1,200 shelves for a new project and is willing to pay $26 each. The shelves can be packaged in bulk; this saves Shelby $1.50 per shelf compared to the normal packaging cost. Shelves have a unit variable cost of $27 with fixed costs of $350,000. Because the shelves dont require packaging, the unit variable costs for the special order will drop from $27 per shelf to $25.50 per shelf. Shelby has enough idle capacity to accept the contract. What is the minimum price per shelf that Shelby should accept for this special order?arrow_forwardVariety Artisans has a bottleneck in their production that occurs within the engraving department. Arjun Naipul, the COO, is considering hiring an extra worker, whose salary will be $45,000 per year, to solve the problem. With this extra worker, the company could produce and sell 3,500 more units per year. Currently, the selling price per unit is $18 and the cost per unit is $5.85. Using the information provided, calculate the annual financial impact of hiring the extra worker.arrow_forward
- Keleher Industries manufactures pet doors and sells them directly to the consumer via their web site. The marketing manager believes that if the company invests in new software, they will increase their sales by 10%. The new software will increase fixed costs by $400 per month. Prepare a forecasted contribution margin income statement for Keleher Industries reflecting the new software cost and associated increase in sales. The previous annual statement is as follows:arrow_forwardBaghdad Company produces a single product. They have recently received the result of a market survey that indicates that they can increase the retail price of their product by 10% without losing customers or market share. All other costs will remain unchanged. If they enact the 10% price increase, what will be their new break-even point in units and dollars? Their most recent CVP analysis is:arrow_forwardNoFat manufactures one product, olestra, and sells it to large potato chip manufacturers as the key ingredient in nonfat snack foods, including Ruffles, Lays, Doritos, and Tostitos brand products. For each of the past 3 years, sales of olestra have been far less than the expected annual volume of 125,000 pounds. Therefore, the company has ended each year with significant unused capacity. Due to a short shelf life, NoFat must sell every pound of olestra that it produces each year. As a result, NoFats controller, Allyson Ashley, has decided to seek out potential special sales offers from other companies. One company, Patterson Union (PU)a toxic waste cleanup companyoffered to buy 10,000 pounds of olestra from NoFat during December for a price of 2.20 per pound. PU discovered through its research that olestra has proven to be very effective in cleaning up toxic waste locations designated as Superfund Sites by the U.S. Environmental Protection Agency. Allyson was excited, noting that This is another way to use our expensive olestra plant! The annual costs incurred by NoFat to produce and sell 100,000 pounds of olestra are as follows: In addition, Allyson met with several of NoFats key production managers and discovered the following information: The special order could be produced without incurring any additional marketing or customer service costs. NoFat owns the aging plant facility that it uses to manufacture olestra. NoFat incurs costs to set up and clean its machines for each production run, or batch, of olestra that it produces. The total setup costs shown in the previous table represent the production of 20 batches during the year. NoFat leases its plant machinery. The lease agreement is negotiated and signed on the first day of each year. NoFat currently leases enough machinery to produce 125,000 pounds of olestra. PU requires that an independent quality team inspects any facility from which it makes purchases. The terms of the special sales offer would require NoFat to bear the 1,000 cost of the inspection team. Based solely on financial factors, explain why NoFat should accept or reject PUs special sales offer.arrow_forward
- NoFat manufactures one product, olestra, and sells it to large potato chip manufacturers as the key ingredient in nonfat snack foods, including Ruffles, Lays, Doritos, and Tostitos brand products. For each of the past 3 years, sales of olestra have been far less than the expected annual volume of 125,000 pounds. Therefore, the company has ended each year with significant unused capacity. Due to a short shelf life, NoFat must sell every pound of olestra that it produces each year. As a result, NoFats controller, Allyson Ashley, has decided to seek out potential special sales offers from other companies. One company, Patterson Union (PU)a toxic waste cleanup companyoffered to buy 10,000 pounds of olestra from NoFat during December for a price of 2.20 per pound. PU discovered through its research that olestra has proven to be very effective in cleaning up toxic waste locations designated as Superfund Sites by the U.S. Environmental Protection Agency. Allyson was excited, noting that This is another way to use our expensive olestra plant! The annual costs incurred by NoFat to produce and sell 100,000 pounds of olestra are as follows: In addition, Allyson met with several of NoFats key production managers and discovered the following information: The special order could be produced without incurring any additional marketing or customer service costs. NoFat owns the aging plant facility that it uses to manufacture olestra. NoFat incurs costs to set up and clean its machines for each production run, or batch, of olestra that it produces. The total setup costs shown in the previous table represent the production of 20 batches during the year. NoFat leases its plant machinery. The lease agreement is negotiated and signed on the first day of each year. NoFat currently leases enough machinery to produce 125,000 pounds of olestra. PU requires that an independent quality team inspects any facility from which it makes purchases. The terms of the special sales offer would require NoFat to bear the 1,000 cost of the inspection team. Assume for this question that NoFat rejected PUs special sales offer because the 2.20 price suggested by PU was too low. In response to the rejection, PU asked NoFat to determine the price at which it would be willing to accept the special sales offer. For its regular sales, NoFat sets prices by marking up variable costs by 10%. If Allyson decides to use NoFats 10% markup pricing method to set the price for PUs special sales offer, a. Calculate the price that NoFat would charge PU for each pound of olestra. b. Calculate the relevant profit that NoFat would earn if it set the special sales price by using its markup pricing method. (Hint: Use the estimate of relevant costs that you calculated in response to Requirement 1b.) c. Explain why NoFat should accept or reject the special sales offer if it uses its markup pricing method to set the special sales price.arrow_forwardNoFat manufactures one product, olestra, and sells it to large potato chip manufacturers as the key ingredient in nonfat snack foods, including Ruffles, Lays, Doritos, and Tostitos brand products. For each of the past 3 years, sales of olestra have been far less than the expected annual volume of 125,000 pounds. Therefore, the company has ended each year with significant unused capacity. Due to a short shelf life, NoFat must sell every pound of olestra that it produces each year. As a result, NoFats controller, Allyson Ashley, has decided to seek out potential special sales offers from other companies. One company, Patterson Union (PU)a toxic waste cleanup companyoffered to buy 10,000 pounds of olestra from NoFat during December for a price of 2.20 per pound. PU discovered through its research that olestra has proven to be very effective in cleaning up toxic waste locations designated as Superfund Sites by the U.S. Environmental Protection Agency. Allyson was excited, noting that This is another way to use our expensive olestra plant! The annual costs incurred by NoFat to produce and sell 100,000 pounds of olestra are as follows: In addition, Allyson met with several of NoFats key production managers and discovered the following information: The special order could be produced without incurring any additional marketing or customer service costs. NoFat owns the aging plant facility that it uses to manufacture olestra. NoFat incurs costs to set up and clean its machines for each production run, or batch, of olestra that it produces. The total setup costs shown in the previous table represent the production of 20 batches during the year. NoFat leases its plant machinery. The lease agreement is negotiated and signed on the first day of each year. NoFat currently leases enough machinery to produce 125,000 pounds of olestra. PU requires that an independent quality team inspects any facility from which it makes purchases. The terms of the special sales offer would require NoFat to bear the 1,000 cost of the inspection team. Assume for this question that Allysons relevant analysis reveals that NoFat would earn a positive relevant profit of 10,000 from the special sale (i.e., the special sales alternative). However, after conducting this traditional, short-term relevant analysis, Allyson wonders whether it might be more profitable over the long term to downsize the company by reducing its manufacturing capacity (i.e., its plant machinery and plant facility). She is aware that downsizing requires a multiyear time horizon because companies usually cannot increase or decrease fixed plant assets every year. Therefore, Allyson has decided to use a 5-year time horizon in her long-term decision analysis. She has identified the following information regarding capacity downsizing (i.e., the downsizing alternative): The plant facility consists of several buildings. If it chooses to downsize its capacity, NoFat can immediately sell one of the buildings to an adjacent business for 30,000. If it chooses to downsize its capacity, NoFats annual lease cost for plant machinery will decrease to 9,000. Therefore, Allyson must choose between these two alternatives: Accept the special sales offer each year and earn a 10,000 relevant profit for each of the next 5 years or reject the special sales offer and downsize as described above. Assume that NoFat pays for all costs with cash. Also, assume a 10% discount rate, a 5-year time horizon, and all cash flows occur at the end of the year. Using an NPV approach to discount future cash flows to present value, a. Calculate the NPV of accepting the special sale with the assumed positive relevant profit of 10,000 per year (i.e., the special sales alternative). b. Calculate the NPV of downsizing capacity as previously described (i.e., the downsizing alternative). c. Based on the NPV of Requirements 5a and 5b, identify and explain which of these two alternatives is best for NoFat to pursue in the long term.arrow_forwardAt the beginning of the last quarter of 20x1, Youngston, Inc., a consumer products firm, hired Maria Carrillo to take over one of its divisions. The division manufactured small home appliances and was struggling to survive in a very competitive market. Maria immediately requested a projected income statement for 20x1. In response, the controller provided the following statement: After some investigation, Maria soon realized that the products being produced had a serious problem with quality. She once again requested a special study by the controllers office to supply a report on the level of quality costs. By the middle of November, Maria received the following report from the controller: Maria was surprised at the level of quality costs. They represented 30 percent of sales, which was certainly excessive. She knew that the division had to produce high-quality products to survive. The number of defective units produced needed to be reduced dramatically. Thus, Maria decided to pursue a quality-driven turnaround strategy. Revenue growth and cost reduction could both be achieved if quality could be improved. By growing revenues and decreasing costs, profitability could be increased. After meeting with the managers of production, marketing, purchasing, and human resources, Maria made the following decisions, effective immediately (end of November 20x1): a. More will be invested in employee training. Workers will be trained to detect quality problems and empowered to make improvements. Workers will be allowed a bonus of 10 percent of any cost savings produced by their suggested improvements. b. Two design engineers will be hired immediately, with expectations of hiring one or two more within a year. These engineers will be in charge of redesigning processes and products with the objective of improving quality. They will also be given the responsibility of working with selected suppliers to help improve the quality of their products and processes. Design engineers were considered a strategic necessity. c. Implement a new process: evaluation and selection of suppliers. This new process has the objective of selecting a group of suppliers that are willing and capable of providing nondefective components. d. Effective immediately, the division will begin inspecting purchased components. According to production, many of the quality problems are caused by defective components purchased from outside suppliers. Incoming inspection is viewed as a transitional activity. Once the division has developed a group of suppliers capable of delivering nondefective components, this activity will be eliminated. e. Within three years, the goal is to produce products with a defect rate less than 0.10 percent. By reducing the defect rate to this level, marketing is confident that market share will increase by at least 50 percent (as a consequence of increased customer satisfaction). Products with better quality will help establish an improved product image and reputation, allowing the division to capture new customers and increase market share. f. Accounting will be given the charge to install a quality information reporting system. Daily reports on operational quality data (e.g., percentage of defective units), weekly updates of trend graphs (posted throughout the division), and quarterly cost reports are the types of information required. g. To help direct the improvements in quality activities, kaizen costing is to be implemented. For example, for the year 20x1, a kaizen standard of 6 percent of the selling price per unit was set for rework costs, a 25 percent reduction from the current actual cost. To ensure that the quality improvements were directed and translated into concrete financial outcomes, Maria also began to implement a Balanced Scorecard for the division. By the end of 20x2, progress was being made. Sales had increased to 26,000,000, and the kaizen improvements were meeting or beating expectations. For example, rework costs had dropped to 1,500,000. At the end of 20x3, two years after the turnaround quality strategy was implemented, Maria received the following quality cost report: Maria also received an income statement for 20x3: Maria was pleased with the outcomes. Revenues had grown, and costs had been reduced by at least as much as she had projected for the two-year period. Growth next year should be even greater as she was beginning to observe a favorable effect from the higher-quality products. Also, further quality cost reductions should materialize as incoming inspections were showing much higher-quality purchased components. Required: 1. Identify the strategic objectives, classified by the Balanced Scorecard perspective. Next, suggest measures for each objective. 2. Using the results from Requirement 1, describe Marias strategy using a series of if-then statements. Next, prepare a strategy map. 3. Explain how you would evaluate the success of the quality-driven turnaround strategy. What additional information would you like to have for this evaluation? 4. Explain why Maria felt that the Balanced Scorecard would increase the likelihood that the turnaround strategy would actually produce good financial outcomes. 5. Advise Maria on how to encourage her employees to align their actions and behavior with the turnaround strategy.arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning