Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
The Bremer Co. manufactures cordless telephones Bremer is planning to implement a JIT production system, which requires annual tooling costs of $150,000. Bremer estimates that the following annual benefits would arise from JIT production.
a. Average inventory will decline by $700,000 from $900,000 to $200,00
b. Insurance, space, materials handling, and setup costs, which currently total $200,00 would decline by 30%
c. The emphasis on quality inherent in JIT system would reduce rework costs by 20% Bremer currently incurs $350,000 on rework.
d. Better quality would eneble Bremer to raise the prices of its products by $3 per unit. Bremer sells $30,000 unit each year.
Bremer required rate of return on inventory investment is 12% per year
Required:
Calculate the net benefit or cost to the Bremer Corporation From implementing a JIT production system.
The Knot manufactures men’s neckwear at its Spartanburg plant. The Knot is considering implementing a JIT production system. The following are the estimated costs and benefits of JIT production:
a. Annual additional tooling costs $250,000 annually.
b. Average inventory would decline by 80% from the current level of $1,000,000.
c. Insurance, space, materials-handling, and setup costs, which currently total $400,000 annually, would decline by 20%.
d. The emphasis on quality inherent in JIT production would reduce rework costs by 25%. The Knot currently incurs $160,000 in annual rework costs.
e. Improved product quality under JIT production would enable The Knot to raise the price of its product by $2 per unit. The Knot sells 100,000 units each year.
The Knot’s required rate of return on inventory investment is 15% per year.
Q. What nonfinancial and qualitative factors should The Knot consider when making the decision to adopt JIT production?
The Knot manufactures men’s neckwear at its Spartanburg plant. The Knot is considering implementing a JIT production system. The following are the estimated costs and benefits of JIT production:
a. Annual additional tooling costs $250,000 annually.
b. Average inventory would decline by 80% from the current level of $1,000,000.
c. Insurance, space, materials-handling, and setup costs, which currently total $400,000 annually, would decline by 20%.
d. The emphasis on quality inherent in JIT production would reduce rework costs by 25%. The Knot currently incurs $160,000 in annual rework costs.
e. Improved product quality under JIT production would enable The Knot to raise the price of its product by $2 per unit. The Knot sells 100,000 units each year.
The Knot’s required rate of return on inventory investment is 15% per year.
Q. Calculate the net benefit or cost to The Knot if it adopts JIT production at the Spartanburg plant.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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?arrow_forwardHudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation? Construct a risk profile for the optimal decision in part (a). What is the probability of the cost exceeding $700,000?arrow_forwardNico 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?arrow_forward
- Mallette Manufacturing, Inc., produces washing machines, dryers, and dishwashers. Because of increasing competition, Mallette is considering investing in an automated manufacturing system. Since competition is most keen for dishwashers, the production process for this line has been selected for initial evaluation. The automated system for the dishwasher line would replace an existing system (purchased one year ago for 6 million). Although the existing system will be fully depreciated in nine years, it is expected to last another 10 years. The automated system would also have a useful life of 10 years. The existing system is capable of producing 100,000 dishwashers per year. Sales and production data using the existing system are provided by the Accounting Department: All cash expenses with the exception of depreciation, which is 6 per unit. The existing equipment is being depreciated using straight-line with no salvage value considered. The automated system will cost 34 million to purchase, plus an estimated 20 million in software and implementation. (Assume that all investment outlays occur at the beginning of the first year.) If the automated equipment is purchased, the old equipment can be sold for 3 million. The automated system will require fewer parts for production and will produce with less waste. Because of this, the direct material cost per unit will be reduced by 25 percent. Automation will also require fewer support activities, and as a consequence, volume-related overhead will be reduced by 4 per unit and direct fixed overhead (other than depreciation) by 17 per unit. Direct labor is reduced by 60 percent. Assume, for simplicity, that the new investment will be depreciated on a pure straight-line basis for tax purposes with no salvage value. Ignore the half-life convention. The firms cost of capital is 12 percent, but management chooses to use 20 percent as the required rate of return for evaluation of investments. The combined federal and state tax rate is 40 percent. Required: 1. Compute the net present value for the old system and the automated system. Which system would the company choose? 2. Repeat the net present value analysis of Requirement 1, using 12 percent as the discount rate. 3. Upon seeing the projected sales for the old system, the marketing manager commented: Sales of 100,000 units per year cannot be maintained in the current competitive environment for more than one year unless we buy the automated system. The automated system will allow us to compete on the basis of quality and lead time. If we keep the old system, our sales will drop by 10,000 units per year. Repeat the net present value analysis, using this new information and a 12 percent discount rate. 4. An industrial engineer for Mallette noticed that salvage value for the automated equipment had not been included in the analysis. He estimated that the equipment could be sold for 4 million at the end of 10 years. He also estimated that the equipment of the old system would have no salvage value at the end of 10 years. Repeat the net present value analysis using this information, the information in Requirement 3, and a 12 percent discount rate. 5. Given the outcomes of the previous four requirements, comment on the importance of providing accurate inputs for assessing investments in automated manufacturing systems.arrow_forwardArtisan 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_forwardDen-Tex Company is evaluating a proposal to replace its HID (high intensity discharge) lighting with LED (light emitting diode) lighting throughout its warehouse. LED lighting consumes less power and lasts longer than HID lighting for similar performance. The following information was developed: a. Determine the investment cost for replacing the 700 fixtures. b. Determine the annual utility cost savings from employing the new energy solution. c. Should the proposal be accepted? Evaluate the proposal using net present value, assuming a 15-year life and 8% minimum rate of return. (Present value factors are available in Appendix A.)arrow_forward
- Newmarge Products Inc. is evaluating a new design for one of its manufacturing processes. The new design will eliminate the production of a toxic solid residue. The initial cost of the system is estimated at 860,000 and includes computerized equipment, software, and installation. There is no expected salvage value. The new system has a useful life of 8 years and is projected to produce cash operating savings of 225,000 per year over the old system (reducing labor costs and costs of processing and disposing of toxic waste). The cost of capital is 16%. Required: 1. Compute the NPV of the new system. 2. One year after implementation, the internal audit staff noted the following about the new system: (1) the cost of acquiring the system was 60,000 more than expected due to higher installation costs, and (2) the annual cost savings were 20,000 less than expected because more labor cost was needed than anticipated. Using the changes in expected costs and benefits, compute the NPV as if this information had been available one year ago. Did the company make the right decision? 3. CONCEPTUAL CONNECTION Upon reporting the results mentioned in the postaudit, the marketing manager responded in a memo to the internal audit department indicating that cash inflows also had increased by a net of 60,000 per year because of increased purchases by environmentally sensitive customers. Describe the effect that this has on the analysis in Requirement 2. 4. CONCEPTUAL CONNECTION Why is a postaudit beneficial to a firm?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_forwardGina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?arrow_forward
- 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_forwardHome Garden Inc. is considering the construction of a distribution warehouse in West Virginia to service its east coast stores based on the following estimates: a. Determine the net present value of building the warehouse, assuming a construction cost of 20,000,000, an annual net cost savings of 4,000,000, and a desired rate of return of 14%. Use the present value tables provided in Appendix A. b. Determine the net present value of building the warehouse, assuming a construction cost of 25,000,000, an annual net cost savings of 2,500,000, and a desired rate of return of 14%. Use the present value tables provided in Appendix A. c. Interpret the results of parts (a) and (b).arrow_forwardJavier Company has sales of 8 million and quality costs of 1,600,000. The company is embarking on a major quality improvement program. During the next three years, Javier intends to attack failure costs by increasing its appraisal and prevention costs. The right prevention activities will be selected, and appraisal costs will be reduced according to the results achieved. For the coming year, management is considering six specific activities: quality training, process control, product inspection, supplier evaluation, prototype testing, and redesign of two major products. To encourage managers to focus on reducing non-value-added quality costs and select the right activities, a bonus pool is established relating to reduction of quality costs. The bonus pool is equal to 10 percent of the total reduction in quality costs. Current quality costs and the costs of these six activities are given in the following table. Each activity is added sequentially so that its effect on the cost categories can be assessed. For example, after quality training is added, the control costs increase to 320,000, and the failure costs drop to 1,040,000. Even though the activities are presented sequentially, they are totally independent of each other. Thus, only beneficial activities need be selected. Required: 1. Identify the control activities that should be implemented, and calculate the total quality costs associated with this selection. Assume that an activity is selected only if it increases the bonus pool. 2. Given the activities selected in Requirement 1, calculate the following: a. The reduction in total quality costs b. The percentage distribution for control and failure costs c. The amount for this years bonus pool 3. Suppose that a quality engineer complained about the gainsharing incentive system. Basically, he argued that the bonus should be based only on reductions of failure and appraisal costs. In this way, investment in prevention activities would be encouraged, and eventually, failure and appraisal costs would be eliminated. After eliminating the non-value-added costs, focus could then be placed on the level of prevention costs. If this approach were adopted, what activities would be selected? Do you agree or disagree with this approach? Explain.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License