Hommie Delicacies Ltd (HDL) produces three different beverages - Orapine, Cocopine and Mangopine-for the Greater-Accra regional market. Obaapa OK, the financial controller, has received a sales forecast from the marketing department for the company's coming financial year. HDL Ltd has experienced considerable sales volume variations and variable costs over two (2) years. Obaapa believes the forecast should carefully be evaluated using cost-volume- profit analysis. The initial budget information for the financial year 2020 is as follows: Orapine Cocopine Mangopine Unit sales demand (bottles) 40,000 60,000 100,000 GHS GHS GHS Selling price per bottle 28 36 48 Variable manufacturing cost per bottle 13 12 26 Variable selling cost per bottle 5 4 6 Total fixed manufacturing overheads for the period GHS 2,000,000 GHS 600,000 Total fixed selling overheads for the period You are required to: Determine how many bottles each of the different fruit juice HDL Ltd must sell to break even. Determine also the sales amount for each product at break-even, assuming the sales mix remains as budgeted.

Hommie Delicacies Ltd (HDL) produces three different beverages - Orapine, Cocopine and Mangopine-for the Greater-Accra regional market. Obaapa OK, the financial controller, has received a sales forecast from the marketing department for the company's coming financial year. HDL Ltd has experienced considerable sales volume variations and variable costs over two (2) years. Obaapa believes the forecast should carefully be evaluated using cost-volume- profit analysis. The initial budget information for the financial year 2020 is as follows: Orapine Cocopine Mangopine Unit sales demand (bottles) 40,000 60,000 100,000 GHS GHS GHS Selling price per bottle 28 36 48 Variable manufacturing cost per bottle 13 12 26 Variable selling cost per bottle 5 4 6 Total fixed manufacturing overheads for the period GHS 2,000,000 GHS 600,000 Total fixed selling overheads for the period You are required to: Determine how many bottles each of the different fruit juice HDL Ltd must sell to break even. Determine also the sales amount for each product at break-even, assuming the sales mix remains as budgeted.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 34P: Kimball Company has developed the following cost formulas:...

See similar textbooks

Similar questions

Nico Parts, Inc., produces electronic products with short life cycles (of less than two years). Development has to be rapid, and the profitability of the products is tied strongly to the ability to find designs that will keep production and logistics costs low. Recently, management has also decided that post-purchase costs are important in design decisions. Last month, a proposal for a new product was presented to management. The total market was projected at 200,000 units (for the two-year period). The proposed selling price was 130 per unit. At this price, market share was expected to be 25 percent. The manufacturing and logistics costs were estimated to be 120 per unit. Upon reviewing the projected figures, Brian Metcalf, president of Nico, called in his chief design engineer, Mark Williams, and his marketing manager, Cathy McCourt. The following conversation was recorded: BRIAN: Mark, as you know, we agreed that a profit of 15 per unit is needed for this new product. Also, as I look at the projected market share, 25 percent isnt acceptable. Total profits need to be increased. Cathy, what suggestions do you have? CATHY: Simple. Decrease the selling price to 125 and we expand our market share to 35 percent. To increase total profits, however, we need some cost reductions as well. BRIAN: Youre right. However, keep in mind that I do not want to earn a profit that is less than 15 per unit. MARK: Does that 15 per unit factor in preproduction costs? You know we have already spent 100,000 on developing this product. To lower costs will require more expenditure on development. BRIAN: Good point. No, the projected cost of 120 does not include the 100,000 we have already spent. I do want a design that will provide a 15-per-unit profit, including consideration of preproduction costs. CATHY: I might mention that post-purchase costs are important as well. The current design will impose about 10 per unit for using, maintaining, and disposing our product. Thats about the same as our competitors. If we can reduce that cost to about 5 per unit by designing a better product, we could probably capture about 50 percent of the market. I have just completed a marketing survey at Marks request and have found out that the current design has two features not valued by potential customers. These two features have a projected cost of 6 per unit. However, the price consumers are willing to pay for the product is the same with or without the features. Required: 1. Calculate the target cost associated with the initial 25 percent market share. Does the initial design meet this target? Now calculate the total life-cycle profit that the current (initial) design offers (including preproduction costs). 2. Assume that the two features that are apparently not valued by consumers will be eliminated. Also assume that the selling price is lowered to 125. a. Calculate the target cost for the 125 price and 35 percent market share. b. How much more cost reduction is needed? c. What are the total life-cycle profits now projected for the new product? d. Describe the three general approaches that Nico can take to reduce the projected cost to this new target. Of the three approaches, which is likely to produce the most reduction? 3. Suppose that the Engineering Department has two new designs: Design A and Design B. Both designs eliminate the two nonvalued features. Both designs also reduce production and logistics costs by an additional 8 per unit. Design A, however, leaves post-purchase costs at 10 per unit, while Design B reduces post-purchase costs to 4 per unit. Developing and testing Design A costs an additional 150,000, while Design B costs an additional 300,000. Assuming a price of 125, calculate the total life-cycle profits under each design. Which would you choose? Explain. What if the design you chose cost an additional 500,000 instead of 150,000 or 300,000? Would this have changed your decision? 4. Refer to Requirement 3. For every extra dollar spent on preproduction activities, how much benefit was generated? What does this say about the importance of knowing the linkages between preproduction activities and later activities?
At 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.
More-Power Company has projected sales of 75,000 regular sanders and 30,000 mini-sanders for next year. The projected income statement is as follows: Required: 1. Set up the given income statement on a spreadsheet (e.g., ExcelTM). Then, substitute the following sales mixes, and calculate operating income. Be sure to print the results for each sales mix (a through d). 2. Calculate the break-even units for each product for each of the preceding sales mixes.
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.
The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.
Kimball Company has developed the following cost formulas: Materialusage:Ym=80X;r=0.95Laborusage(direct):Yl=20X;r=0.96Overheadactivity:Yo=350,000+100X;r=0.75Sellingactivity:Ys=50,000+10X;r=0.93 where X=Directlaborhours The company has a policy of producing on demand and keeps very little, if any, finished goods inventory (thus, units produced equals units sold). Each unit uses one direct labor hour for production. The president of Kimball Company has recently implemented a policy that any special orders will be accepted if they cover the costs that the orders cause. This policy was implemented because Kimballs industry is in a recession and the company is producing well below capacity (and expects to continue doing so for the coming year). The president is willing to accept orders that minimally cover their variable costs so that the company can keep its employees and avoid layoffs. Also, any orders above variable costs will increase overall profitability of the company. Required: 1. Compute the total unit variable cost. Suppose that Kimball has an opportunity to accept an order for 20,000 units at 220 per unit. Should Kimball accept the order? (The order would not displace any of Kimballs regular orders.) 2. Explain the significance of the coefficient of correlation measures for the cost formulas. Did these measures have a bearing on your answer in Requirement 1? Should they have a bearing? Why or why not? 3. Suppose that a multiple regression equation is developed for overhead costs: Y = 100,000 + 100X1 + 5,000X2 + 300X3, where X1 = direct labor hours, X2 = number of setups, and X3 = engineering hours. The coefficient of determination for the equation is 0.94. Assume that the order of 20,000 units requires 12 setups and 600 engineering hours. Given this new information, should the company accept the special order referred to in Requirement 1? Is there any other information about cost behavior that you would like to have? Explain.
Uchdorf Manufacturing just completed a study of its purchasing activity with the objective of improving its efficiency. The driver for the activity is number of purchase orders. The following data pertain to the activity for the most recent year: Activity supply: five purchasing agents capable of processing 2,400 orders per year (12,000 orders) Purchasing agent cost (salary): 45,600 per year Actual usage: 10,600 orders per year Value-added quantity: 7,000 orders per year Required: 1. Calculate the volume variance and explain its significance. 2. Calculate the unused capacity variance and explain its use. 3. What if the actual usage drops to 9,000 orders? What effect will this have on capacity management? What will be the level of spending reduction if the value-added standard is met?
Harvey Company produces two models of blenders: the Super Model (priced at 400) and the Special Model (priced at 200). Recently, Harvey has been losing market share with its Special Model because of competitors offering blenders with the same quality and features but at a lower price. A careful market study revealed that if Harvey could reduce the price of its Special Model to 180, it would regain its former share of the market. Management, however, is convinced that any price reduction must be accompanied by a cost reduction of the same amount so that per-unit profitability is not affected. Earl Wise, company controller, has indicated that poor overhead costing assignments may be distorting managements view of each products cost and, therefore, the ability to know how to set selling prices. Earl has identified the following overhead activities: machining, inspection, and rework. The three activities, their costs, and practical capacities are as follows: The consumption patterns of the two products are as follows: Harvey assigns overhead costs to the two products using a plantwide rate based on machine hours. Required: 1. Calculate the unit overhead cost of the Special Model using machine hours to assign overhead costs. Now, repeat the calculation using ABC to assign overhead costs. Did improving the accuracy of cost assignments solve Harveys competitive problem? What did it reveal? 2. Now, assume that in addition to improving the accuracy of cost assignments, Earl observes that defective supplier components are the root cause of both the inspection and rework activities. Suppose further that Harvey has found a new supplier that provides higher-quality components such that inspection and rework costs are reduced by 50 percent. Now, calculate the cost of the Special Model (assuming that inspection and rework times are also reduced by 50 percent) using ABC. The relative consumption patterns also remain the same. Comment on the difference between ABC and ABM.
The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Multiple regression was run on the above data; the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 total purchase orders and 45 nonstandard orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders and 580 nonstandard orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 2? (Round your answers to the nearest dollar.)
Boxer 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?
Katayama Company produces a variety of products. One division makes neoprene wetsuits. The divisions projected income statement for the coming year is as follows: Required: 1. Compute the contribution margin per unit, and calculate the break-even point in units. Repeat, using the contribution margin ratio. 2. The divisional manager has decided to increase the advertising budget by 140,000 and cut the average selling price to 200. These actions will increase sales revenues by 1 million. Will this improve the divisions financial situation? Prepare a new income statement to support your answer. 3. Suppose sales revenues exceed the estimated amount on the income statement by 612,000. Without preparing a new income statement, determine by how much profits are underestimated. 4. How many units must be sold to earn an after-tax profit of 1.254 million? Assume a tax rate of 34 percent. (Round your answer up to the next whole unit.) 5. Compute the margin of safety in dollars based on the given income statement. 6. Compute the operating leverage based on the given income statement. (Round to three significant digits.) If sales revenues are 20 percent greater than expected, what is the percentage increase in profits?
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: