Question

In: Accounting

Case 9-2 Sergo Games [LO 1, 3] Sergo Games produces a variety of action games including...

Case 9-2 Sergo Games [LO 1, 3]

Sergo Games produces a variety of action games including a flight simulation game, Airport 10, which sold more than 800,000 copies in the past year. The programs are run on computers, and the company operates an in-house production facility that manufactures and packages CDs for shipment to customers.

            In 2017, the production plant prepared 2,600,000 CDs and incurred the following costs:

Units processed

2,600,000

Labor

$     900,000

Material

4,800,000

Supervisory salaries

350,000

Depreciation of equipment

420,000

Heat, light, phone, etc.

200,000

Total

$ 6,670,000

                                               

                       

Leslie Eastman, an accounting manager, has been given the responsibility to analyze outsourcing the production of CDs. Her report is provided below.

REQUIRED

Should the production of CDs be outsourced? Unlike Leslie, support your answer with appropriate calculations.

Sergo Games

April 19, 2018

TO: Shane Santiago, CFO

FROM: Leslie Eastman

SUBJECT: Outsourcing CD productions

In 2017, total production and packaging costs were $6,6700,000 or $2.57 per CD. The low-cost outside bidder for this business was XLS. They are a highly respected firm, and their offer is $3.52 per CD. Although the savings related to outsourcing is only $0.05 per CD, with annual production of 2,600,000 units, this amounts to $130,000 per year. The present value with a five-year horizon and an 11 percent cost of capital is $480,467. Thus, I recommend that we outsource CD productions.

            You asked me to determine the selling price of the production equipment. I had a representative of XLS walk through the facility. In his opinion, the equipment is dated, and he believes that the market value is essentially zero. At any rate, his company is not interested in purchasing the equipment even if we select them as a supplier. If we outsource, I do not believe that we can use the production facility for another purpose. As you know, the building is run down, and it’s not suitable space even for programmers!

            Finally, I want to mention another aspect of the problem that enhances the appeal of outsourcing. We currently have equipment with a book value of $2,000,000 and an average remaining value of 5 years. This generates approximately $400,000 per year of depreciation. If we outsource, we’ll have a $2,000,000 tax loss, which will save us approximately $700,000 (assuming a 35 percent tax rate). Thus, the total value of outsourcing is $1,180,467 (i.e., $480,467 + $700,000).

            Please call me if you have any questions regarding my analysis.

Solutions

Expert Solution

Leslie made a mistake in calculation of net cash outflow In the First paragraph , depreciation on equipment is a non cash expense and should be used for tax benefit purpose in calculation . Moreover , the offer for outsourcing is 3.52$ per CD , which is way higher than in house production cost . Savings figure of 0.05$ is wrong . In the third paragraph , depreciation should also be at discounted Present value instead of absolute value for better calculation and understanding. Depreciation figure is considered 400000 in 3rd paragraph whereas in the table above it is 420000.

Lets calculate the annual cash outflow :-

Labour + material + salary+ heat, light - (tax rate)depreciation on equipment  = 900000 + 4800000 + 350000 + 200000 - (0.35)420000 = 6103000

Cost per unit = total cost / no. of units = 6103000/ 2600000 = 2.34

Even if the outsourcing agency is offering 2.52$ per CD , it is expensive as compared to in house cost of 2.34$ per CD.


Related Solutions

Case 9–46 Participative Budgeting (LO 9-2, 9-3, 9-9) Patricia Eklund, controller in the division of social...
Case 9–46 Participative Budgeting (LO 9-2, 9-3, 9-9) Patricia Eklund, controller in the division of social services for the state, recognizes the importance of the budgetary process for planning, control, and motivational purposes. She believes that a properly implemented participative budgetary process for planning purposes and an evaluation procedure will motivate the managers to improve productivity within their particular departments. Based upon this philosophy, Eklund has implemented the following budgetary procedures.      • An appropriation target figure is given to...
CP9-3 Analyzing and Recording Long-Lived Asset Transactions with Partial-Year Depreciation [LO 9-2, LO 9-3, LO 9-6]...
CP9-3 Analyzing and Recording Long-Lived Asset Transactions with Partial-Year Depreciation [LO 9-2, LO 9-3, LO 9-6] [The following information applies to the questions displayed below.] Palmer Cook Productions manages and operates two rock bands. The company entered into the following transactions during a recent year.   January 2 Purchased a tour bus for $94,000 by paying $33,000 cash and signing a $61,000 note due in two years.   January 8 The bus was painted with the logos of the two bands at...
Case 9–45 Using Budgets to Evaluate Business Decisions (LO 9-2, 9-3, 9-7) CasesCity Racquetball Club (CRC)...
Case 9–45 Using Budgets to Evaluate Business Decisions (LO 9-2, 9-3, 9-7) CasesCity Racquetball Club (CRC) offers racquetball and other physical fitness facilities to its members. There are four of these clubs in the metropolitan area. Each club has between 1,800 and 2,500 members. Revenue is derived from annual membership fees and hourly court fees. The annual membership fees are as follows: Individual ............................................................................................$ 40 Student ............................................................................................... $25 Family ................................................................................................. $95 The hourly court fees vary from $6 to $10...
Required information Foundational [LO 2-1, LO 2-2, LO 2-3, LO 2-4, LO 2-6, LO 2-7] [The...
Required information Foundational [LO 2-1, LO 2-2, LO 2-3, LO 2-4, LO 2-6, LO 2-7] [The following information applies to the questions displayed below.] Martinez Company’s relevant range of production is 8,500 units to 13,500 units. When it produces and sells 11,000 units, its unit costs are as follows: Amount Per Unit   Direct materials $ 6.10   Direct labor $ 3.60   Variable manufacturing overhead $ 1.40   Fixed manufacturing overhead $ 4.10   Fixed selling expense $ 3.10   Fixed administrative expense $ 2.10...
E9-3 (Static) Preparing a Flexible Budget Performance Report [LO 9-2] Gleason Guitars produces acoustic guitars. The...
E9-3 (Static) Preparing a Flexible Budget Performance Report [LO 9-2] Gleason Guitars produces acoustic guitars. The table below contains budget and actual information for the month of June (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance).) 
KM Case Study #1 [LO 6-5, LO 6-9] Susan Lo picked up the phone and called...
KM Case Study #1 [LO 6-5, LO 6-9] Susan Lo picked up the phone and called her boss, Phil Takata, the vice president of marketing at Jewel Clasps Corporation: “Phil, I’m not sure how to go about answering the questions that came up at the meeting with the president yesterday.” "What's the problem?" “The president wanted to know the break-even point for each of the company’s products, but I am having trouble figuring them out.” “I’m sure you can handle...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT