1.
Calculate the after-tax cash flows for the manual and robotic systems by preparing a schedule.
1.
Explanation of Solution
Calculate the after-tax cash flows for the manual and robotic systems by preparing a schedule:
For manual systems:
Year | Revenue | Expenses | Cash flow | |
(1) (a) | (2) (b) | (3) (c) | ||
1 | $240,000 | ($180,000) | $8,000 | $68,000 |
2 | $240,000 | ($180,000) | $8,000 | $68,000 |
3 | $240,000 | ($180,000) | $8,000 | $68,000 |
4 | $240,000 | ($180,000) | $8,000 | $68,000 |
5 | $240,000 | ($180,000) | $8,000 | $68,000 |
6 | $240,000 | ($180,000) | $8,000 | $68,000 |
7 | $240,000 | ($180,000) | $8,000 | $68,000 |
8 | $240,000 | ($180,000) | $8,000 | $68,000 |
9 | $240,000 | ($180,000) | $8,000 | $68,000 |
10 | $240,000 | ($180,000) | $8,000 | $68,000 |
Table (1)
Working note (1):
Compute the amount of annual revenue:
Working note (2):
Compute the amount of expense:
Working note (3):
Compute the amount of after tax depreciation expense:
For robotic systems:
Year | Revenue | Expenses | Depreciation after tax | Other expenses (9) | Cash flow |
(4) (a) | (7) (b) | (8) (c) | |||
$64,000 | $(480,000) | $(416,000) | |||
1 | $240,000 | ($124,320) | $29,723 | - | $145,403 |
2 | $270,000 | ($132,960) | $50,939 | - | $187,979 |
3 | $300,000 | ($141,600) | $36,379 | - | $194,779 |
4 | $360,000 | ($158,880) | $25,979 | - | $227,099 |
5 | $360,000 | ($158,880) | $18,574 | - | $219,694 |
6 | $360,000 | ($158,880) | $18,554 | - | $219,694 |
7 | $360,000 | ($158,880) | $18,554 | - | $219,694 |
8 | $360,000 | ($158,880) | $9,277 | - | $210,397 |
9 | $360,000 | ($158,880) | - | - | $201,120 |
10 | $372,000 | ($158,880) | - | - | $213,120 |
Table (2)
Working Note (4):
Compute the amount of revenue:
Year | Sales | Revenue | |
(a) | (b) | ||
1 | $400,000 | 60% | $240,000 |
2 | $450,000 | 60% | $270,000 |
3 | $500,000 | 60% | $300,000 |
4 | $600,000 | 60% | $360,000 |
5 | $600,000 | 60% | $360,000 |
6 | $600,000 | 60% | $360,000 |
7 | $600,000 | 60% | $360,000 |
8 | $600,000 | 60% | $360,000 |
9 | $600,000 | 60% | $360,000 |
10 | $620,000 | 60% | $372,000 |
Table (3)
Working Note (5):
Compute the fixed expense:
Working Note (6):
Compute the total variable expense percentage:
Particulars | Cost as a % of sales | |||
(a) | (b) | |||
Direct materials | 75% | 60% | ||
Variable overhead | 66.67% | 60% | ||
Variable selling | 90% | 60% | ||
Total |
Table (4)
Working Note (7):
Compute the amount of expense:
Year | Sales units | Variable cost % (6) | Fixed cost (5) | Expense |
(a) | (b) | (c) | ||
1 | $400,000 | 0.1728 | 55,200 | ($124,320) |
2 | $450,000 | 0.1728 | 55,200 | ($132,960) |
3 | $500,000 | 0.1728 | 55,200 | ($141,600) |
4 | $600,000 | 0.1728 | 55,200 | ($158,880) |
5 | $600,000 | 0.1728 | 55,200 | ($158,880) |
6 | $600,000 | 0.1728 | 55,200 | ($158,880) |
7 | $600,000 | 0.1728 | 55,200 | ($158,880) |
8 | $600,000 | 0.1728 | 55,200 | ($158,880) |
9 | $600,000 | 0.1728 | 55,200 | ($158,880) |
10 | $620,000 | 0.1728 | 55,200 | ($158,880) |
Table (5)
Working note (8):
Step 1: Compute the depreciation expenses after tax:
Calculate the amount of depreciation expenses under MARCS:
Year | Initial investments | Deprecation rate | MACRS for 7 years | Depreciation |
(a) | (b) | (c) | ||
1 | $520,000 | 40% | 0.1429 | $29,723 |
2 | $520,000 | 40% | 0.2449 | $50,939 |
3 | $520,000 | 40% | 0.1749 | $36,379 |
4 | $520,000 | 40% | 0.1249 | $25,979 |
5 | $520,000 | 40% | 0.893 | $18,574 |
6 | $520,000 | 40% | 0.892 | $18,554 |
7 | $520,000 | 40% | 0.893 | $18,554 |
8 | $520,000 | 40% | 0.446 | $9,277 |
Table (6)
Compute the amount of net investment:
2.
Ascertain the net present value for each system and describe whether it is advisable for the company to invest in the robotic system or manual systems.
2.
Explanation of Solution
Ascertain the net present value for each system and describe whether it is advisable for the company to invest in the robotic system as follows:
For manual systems:
Year | Cash flow | Discount factor @ 12% | Cash flow |
(a) | (b) | ||
0 | 0 | 1.000 | 0 |
1 | $68,000 | 0.893 | $60,724 |
2 | $68,000 | 0.797 | $54,196 |
3 | $68,000 | 0.712 | $48,416 |
4 | $68,000 | 0.636 | $43,248 |
5 | $68,000 | 0.567 | $38,556 |
6 | $68,000 | 0.507 | $34,476 |
7 | $68,000 | 0.452 | $30,736 |
8 | $68,000 | 0.404 | $27,472 |
9 | $68,000 | 0.361 | $24,480 |
10 | $68,000 | 0.322 | $21,896 |
Net present value | $384,200 |
Table (7)
For robotic systems:
Year | Cash flow | Discount factor @ 12% | Cash flow |
(a) | (b) | ||
0 | $(416,000) | 1.000 | $(416,000) |
1 | $145,403 | 0.893 | $129,845 |
2 | $187,979 | 0.797 | $149,819 |
3 | $194,779 | 0.712 | $138,683 |
4 | $227,099 | 0.636 | $144,435 |
5 | $219,694 | 0.567 | $124,566 |
6 | $219,694 | 0.507 | $111,385 |
7 | $219,694 | 0.452 | $99,302 |
8 | $210,397 | 0.404 | $85,000 |
9 | $201,120 | 0.361 | $72,604 |
10 | $213,120 | 0.322 | $68,625 |
Net present value | $708,255 |
Table (8)
From the above calculation it is clear that the net present value of robotic systems is higher than the net present value of manual systems. Hence, the company should invest in the robotic system.
3.
Ascertain the net present value for the given situation using 12 % and 20 % discount factors, and describe whether the robotic system would be acquired if 20% is used. State whether this conservative approach could have a negative impact on a firm’s ability.
3.
Explanation of Solution
Under 12%:
Year | Cash flow | Discount factor @ 12% | Cash flow |
(a) | (b) | ||
0 | $(340,000) | 1.000 | $(340,000) |
1 | $80,000 | 0.893 | $71,440 |
2 | $80,000 | 0.797 | $63,760 |
3 | $80,000 | 0.712 | $56,960 |
4 | $80,000 | 0.636 | $50,880 |
5 | $80,000 | 0.567 | $45,360 |
6 | $80,000 | 0.507 | $40,560 |
7 | $80,000 | 0.452 | $36,160 |
8 | $80,000 | 0.404 | $32,320 |
9 | $80,000 | 0.361 | $28,880 |
10 | $80,000 | 0.322 | $25,760 |
Net present value | $112,000 |
Table (9)
Under 20%:
Year | Cash flow | Discount factor @ 20% | Cash flow |
(a) | (b) | ||
0 | $(340,000) | 1.000 | $(340,000) |
1 | $80,000 | 0.833 | $66,640 |
2 | $80,000 | 0.694 | $55,520 |
3 | $80,000 | 0.579 | $46,320 |
4 | $80,000 | 0.482 | $38,560 |
5 | $80,000 | 0.402 | $32,160 |
6 | $80,000 | 0.335 | $26,800 |
7 | $80,000 | 0.279 | $22,320 |
8 | $80,000 | 0.233 | $18,640 |
9 | $80,000 | 0.194 | $15,440 |
10 | $80,000 | 0.162 | $12,960 |
Net present value | $(4,640) |
Table (10)
From the above calculation it is clear that the company would not acquire the robotic system, if it uses 20% discount rate.
In this case, using an excessive discount rate could damage the ability of the firm to stay competitive. Because the usage of excessive discount rate may lead a firm to reject new technology (which would increase the quality and productivity). Whereas, the other firms would invest in the new technology, as a result their products will be priced lower and would have a higher quality. Thus, these features would probable cause severe difficulty for the more conservative firm.
Want to see more full solutions like this?
Chapter 19 Solutions
Cornerstones of Cost Management (Cornerstones Series)
- Quincy Farms is a producer of items made from farm products that are distributed to supermarkets. For many years, Quincys products have had strong regional sales on the basis of brand recognition. However, other companies have been marketing similar products in the area, and price competition has become increasingly important. Doug Gilbert, the companys controller, is planning to implement a standard costing system for Quincy and has gathered considerable information from his coworkers on production and direct materials requirements for Quincys products. Doug believes that the use of standard costing will allow Quincy to improve cost control and make better operating decisions. Quincys most popular product is strawberry jam. The jam is produced in 10-gallon batches, and each batch requires six quarts of good strawberries. The fresh strawberries are sorted by hand before entering the production process. Because of imperfections in the strawberries and spoilage, one quart of strawberries is discarded for every four quarts of acceptable berries. Three minutes is the standard direct labor time required for sorting strawberries in order to obtain one quart of strawberries. The acceptable strawberries are then processed with the other ingredients: processing requires 12 minutes of direct labor time per batch. After processing, the jam is packaged in quart containers. Doug has gathered the following information from Joe Adams, Quincys cost accountant, relative to processing the strawberry jam. a. Quincy purchases strawberries at a cost of 0.80 per quart. All other ingredients cost a total of 0.45 per gallon. b. Direct labor is paid at the rate of 9.00 per hour. c. The total cost of direct material and direct labor required to package the jam is 0.38 per quart. Joe has a friend who owns a strawberry farm that has been losing money in recent years. Because of good crops, there has been an oversupply of strawberries, and prices have dropped to 0.50 per quart. Joe has arranged for Quincy to purchase strawberries from his friends farm in hopes that the 0.80 per quart will put his friends farm in the black. Required: 1. Discuss which coworkers Doug probably consulted to set standards. What factors should Doug consider in establishing the standards for direct materials and direct labor? 2. Develop the standard cost sheet for the prime costs of a 10-gallon batch of strawberry jam. 3. Citing the specific standards of the IMA Statement of Ethical Professional Practice described in Chapter 1, explain why Joes behavior regarding the cost information provided to Doug is unethical. (CMA adapted)arrow_forwardKagle design engineers are in the process of developing a new green product, one that will significantly reduce impact on the environment and yet still provide the desired customer functionality. Currently, two designs are being considered. The manager of Kagle has told the engineers that the cost for the new product cannot exceed 550 per unit (target cost). In the past, the Cost Accounting Department has given estimated costs using a unit-based system. At the request of the Engineering Department, Cost Accounting is providing both unit-and activity-based accounting information (made possible by a recent pilot study producing the activity-based data). Unit-based system: Variable conversion activity rate: 100 per direct labor hour Material usage rate: 20 per part ABC system: Labor usage: 15 per direct labor hour Material usage (direct materials): 20 per part Machining: 75 per machine hour Purchasing activity: 150 per purchase order Setup activity: 3,000 per setup hour Warranty activity: 500 per returned unit (usually requires extensive rework) Customer repair cost: 25 per repair hour (average) Required: 1. Select the lower-cost design using unit-based costing. Are logistical and post-purchase activities considered in this analysis? 2. Select the lower-cost design using ABC analysis. Explain why the analysis differs from the unit-based analysis. 3. What if the post-purchase cost was an environmental contaminant and amounted to 10 per unit for Design A and 40 per unit for Design B? Assume that the environmental cost is borne by society. Now which is the better design?arrow_forwardJolene Askew, manager of Feagan Company, has committed her company to a strategically sound cost reduction program. Emphasizing life-cycle cost management is a major part of this effort. Jolene is convinced that production costs can be reduced by paying more attention to the relationships between design and manufacturing. Design engineers need to know what causes manufacturing costs. She instructed her controller to develop a manufacturing cost formula for a newly proposed product. Marketing had already projected sales of 25,000 units for the new product. (The life cycle was estimated to be 18 months. The company expected to have 50 percent of the market and priced its product to achieve this goal.) The projected selling price was 20 per unit. The following cost formula was developed: Y=200,000+10X1 where X1=Machinehours(Theproductisexpectedtouseonemachinehourforeveryunitproduced.) Upon seeing the cost formula, Jolene quickly calculated the projected gross profit to be 50,000. This produced a gross profit of 2 per unit, well below the targeted gross profit of 4 per unit. Jolene then sent a memo to the Engineering Department, instructing them to search for a new design that would lower the costs of production by at least 50,000 so that the target profit could be met. Within two days, the Engineering Department proposed a new design that would reduce unit-variable cost from 10 per machine hour to 8 per machine hour (Design Z). The chief engineer, upon reviewing the design, questioned the validity of the controllers cost formula. He suggested a more careful assessment of the proposed designs effect on activities other than machining. Based on this suggestion, the following revised cost formula was developed. This cost formula reflected the cost relationships of the most recent design (Design Z). Y=140,000+8X1+5,000X2+2,000X3 where X1=MachinehoursX2=NumberofbatchesX3=Numberofengineeringchangeorders Based on scheduling and inventory considerations, the product would be produced in batches of 1,000; thus, 25 batches would be needed over the products life cycle. Furthermore, based on past experience, the product would likely generate about 20 engineering change orders. This new insight into the linkage of the product with its underlying activities led to a different design (Design W). This second design also lowered the unit-level cost by 2 per unit but decreased the number of design support requirements from 20 orders to 10 orders. Attention was also given to the setup activity, and the design engineer assigned to the product created a design that reduced setup time and lowered variable setup costs from 5,000 to 3,000 per setup. Furthermore, Design W also creates excess activity capacity for the setup activity, and resource spending for setup activity capacity can be decreased by 40,000, reducing the fixed cost component in the equation by this amount. Design W was recommended and accepted. As prototypes of the design were tested, an additional benefit emerged. Based on test results, the post-purchase costs dropped from an estimated 0.70 per unit sold to 0.40 per unit sold. Using this information, the Marketing Department revised the projected market share upward from 50 percent to 60 percent (with no price decrease). Required: 1. Calculate the expected gross profit per unit for Design Z using the controllers original cost formula. According to this outcome, does Design Z reach the targeted unit profit? Repeat, using the engineers revised cost formula. Explain why Design Z failed to meet the targeted profit. What does this say about the use of unit-based costing for life-cycle cost management? 2. Calculate the expected profit per unit using Design W. Comment on the value of activity information for life-cycle cost management. 3. The benefit of the post-purchase cost reduction of Design W was discovered in testing. What direct benefit did it create for Feagan Company (in dollars)? Reducing post-purchase costs was not a specific design objective. Should it have been? Are there any other design objectives that should have been considered?arrow_forward
- A seminar was recently attended by the Managing Director of XYZ Manufacturing Company Limited located at Sheffield. The focus of the seminar was “optimising scarce resources utility in a manufacturing setting with particular reference to linear programming”. On his return to his base, he called for a meeting with the Management to share his experience from the seminar and the impact this will have on the decision by the Board to produce two major products in the years ahead. A group of external research experts had previously been commissioned and the following represents information from the research carried out by them The expected products are “Best” and “Smart” with expected costs statistics as follows: Best £ Smart £ Material costs (5kg@£50/kg) 250 (3kg@£50/kg) 150 Labour costs Machinery time (4 hours @£15/Hr) 60 (2hours @£15/Hr) 30 Other Processing Time (4 hours @£10/hr) 40 (5hours@£10/Hr) 50 The applicable pricing…arrow_forwardKagle design engineers are in the process of developing a new “green” product, one that will significantly reduce impact on the environment and yet still provide the desired customer functionality. Currently, two designs are being considered. The manager of Kagle has told the engineers that the cost for the new product cannot exceed $550 per unit (target cost). In the past, the Cost Accounting Department has given estimated costs using a unit-based system. At the request of the Engineering Department, Cost Accounting is providing both unit- and activity-based accounting information (made possible by a recent pilot study producing the activity-based data). Unit-based system:Variable conversion activity rate: $100 per direct labor hourMaterial usage rate: $20 per partABC system:Labor usage: $15 per direct labor hourMaterial usage (direct materials): $20 per partMachining: $75 per machine hourPurchasing activity: $150 per purchase orderSetup activity: $3,000 per setup hourWarranty…arrow_forwardTim Johnson is a news reporter and feature writer for The Wall Street Review, an important daily newspaper for financial managers. Tim’s assignment is to develop two feature articles: one on life-cycle costing and one on business analytics, including interviews with chief financial officers and operating managers. Tim has a generous travel budget for research into company history, operations, and market analysis for the firms he selects for the article. Tim has asked you to recommend industries and firms that would be good candidates for the article. What would you advise? Explain your recommendations.arrow_forward
- Jim Salters, the COO of CryoDerm, has asked his cost management team for a product-line profitability analysis for his firm’s two products, Zderm and Bderm. The two skincare products require a large amount of research and development and advertising. After receiving the following statement fromCryoDerm’s costing team, Jim concludes that Zderm is the more profitable product and that perhaps cost-cutting measures should be applied to Bderm. Zderm Bderm Total Sales $3,000,000 $2,000,000 $5,000,000 Cost of Goods Sold ($1,900,000) ($1,600,000) ($3,500,000) Gross Profit $1,100,000 $ 400,000 $1,500,000 R&D (900,000) Selling expenses (100,000) Profit before taxes $ 500,000 Required:(i) Briefly explain why Jim may be wrong in his assessment of the relative performance of the twoproducts. (ii) Suppose that 80% of the R&D and selling expenses are traceable to Zderm. Prepare life-cycle income statements for each product. What does this indicate…arrow_forwardAt Jeekes PolyChem Products LLC, customers needs are translated into product specifications by the design or engineering department. Which of the following objectives of production management is addressed by Jeekes Polychem Products LLC? a. Right time b. Right quality c. Right quantity d. Right cost Mr. Saud bought a new mobile phone for himself. He explained to his friend that the mobile phone has a camera, Facebook facility, and music facility in addition to the basic functions like phone calls and messaging. Which dimension of "product quality" is Mr. Saud referring to? a. Features b. Aesthetics c. Reputation d. Conformancearrow_forwardBen and Sons Co Ltd, a machine intensive manufacturing company situated in the Northen province of Zambia intends to introduce a high technology product in response to the market dynamics. Major proportion of the product’s cost will depend on the decisions made early in its lifecycle. The product will face competition from four major brands already on the market. The Managing Director, Mr William Mwape, has just attended a seminar organized by CA Zambia which covered modern management accounting techniques such as lifecycle costing, JIT system, backflush and throughput accounting etc. He now wishes to implement the knowledge acquired in order to maximize return over the product’s lifecycle. Required: (c) State possible ways of improving throughput accounting ratio of a product.arrow_forward
- Mary Jones and Jack Smart have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. Jack has years of food processing experience, and Mary has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000 and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. Jack and Mary has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above…arrow_forwardMary Jones and Jack Smart have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. Jack has years of food processing experience, and Mary has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000 and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. Jack and Mary has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above…arrow_forwardRaindeer PLC is a highly profitable electronics company that manufactures a range of innovativeproducts for industrial use. Its success is based to a large extent on the ability of the company’sdevelopment group to generate new ideas that result in commercially viable products. The latestof these products is just about to undergo some final tests and a decision has to be taken whetheror not to proceed with an investment in the facilities required for manufacturing. You have beenasked to undertake an evaluation of this investment.The company has already spent £750,000 on the development of this product. The final testing ofthe product will cost about £40,000. The head of the development group is very confident that thetests will be successful based on the work already undertaken. Another company has alreadyoffered Raindeer £1.10 million for the product’s patent and an exclusive right to its manufactureand sale, even though the final tests are still to be completed. This sum being…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub