Question

In: Accounting

A business process outsourcing has the following avoided costs, incurred costs, and other characteristics: Costs avoided...

A business process outsourcing has the following avoided costs, incurred costs, and other characteristics:

  • Costs avoided by outsourcing:
    • Salaries, wages, and benefits = $450,000 a year
    • Furniture and equipment = $100,000 a year
    • Supplies = $150,000 a year
    • Software = $10,000 a year
    • Facility rent/lease = $75,000 a year
    • Utilities and communications = $20,000 a year
    • Transition revenue now
      • Sale of unused assets = $10,000
  • Costs incurred by outsourcing:
    • Payments to supplier = $440,000 a year
    • Contract administration = $30,000 a year
    • Transition cost now
      • Severance pay = $40,000
  • 4-year time horizon
  • Discount rate = 4% per year
  • Assume all cash flows occur at the beginning of each year
  • Assume “now” is the beginning of Year 1.

Use Excel to answer the following question. Based on the NPV of the cash flows, should this business process be outsourced?

Please show all the formulas used in excel.

Solutions

Expert Solution

NPV of Outsourcing Calculation
Time line Now : Year 1 Beginning Year 2 start Year 3 start Year 4 start
Costs Avoided by outsourcing :
Salaries & Wages             450,000           450,000          450,000           450,000
Furniture & Equipment             100,000           100,000          100,000           100,000
Supplies             150,000           150,000          150,000           150,000
Software               10,000             10,000             10,000              10,000
Facility Rent/Lease               75,000             75,000             75,000              75,000
Utilities/Communications               20,000             20,000             20,000              20,000
Transition Revenue Now
Sale of unused asset               10,000
Costs incurred by Outsourcing
Payment to Supplier           (440,000)         (440,000)         (440,000)          (440,000)
Contract Administration             (30,000)           (30,000)           (30,000)            (30,000)
Transition cost Now:
Severance Pay             (40,000)
Total Net Cash flow             305,000           335,000          335,000           335,000
Years for discounting                        -                         1                      2                       3
PV factor @4%                         1             0.9615            0.9246             0.8890
PV of Net Cash flow             305,000           322,115          309,726           297,814
NPV of Net cash flow =         1,234,655
As the NPV of outsourcing is positive, the business process should be outsourced.

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Which of the following is the cost of quality classification for costs incurred to improve process...
Which of the following is the cost of quality classification for costs incurred to improve process reliability or reduce process variation? a. rework and wastage b. external failure costs c. internal failure costs d. appraisal cost e. prevention cost
A business operated at 100% of capacity during its first month and incurred the following costs:...
A business operated at 100% of capacity during its first month and incurred the following costs: Production costs (18,600 units): Direct materials $172,100 Direct labor 234,800 Variable factory overhead 267,600 Fixed factory overhead 100,300 $774,800 Operating expenses: Variable operating expenses $131,500 Fixed operating expenses 46,900 178,400 If 1,800 units remain unsold at the end of the month, what is the amount of inventory that would be reported on the variable costing balance sheet? The actual price for a product was...
A business operated at 100% of capacity during its first month and incurred the following costs:...
A business operated at 100% of capacity during its first month and incurred the following costs: Production costs (18,100 units): Direct materials $171,800 Direct labor 220,400 Variable factory overhead 256,100 Fixed factory overhead 102,000 $750,300 Operating expenses: Variable operating expenses $128,600 Fixed operating expenses 43,000 171,600 If 1,600 units remain unsold at the end of the month and sales total $1,143,000 for the month, what would be the amount of income from operations reported on the variable costing income statement?...
Patin Corporation began business on September 23rd of the current year. It incurred the following costs...
Patin Corporation began business on September 23rd of the current year. It incurred the following costs prior to opening to customers: $26,560 employee training, $5,000 supplies, $41,457 legal, and $10,000 accounting. How much may be deducted in the first year (the current year)? (Round final answer to the nearest whole dollar.)
A business operated at 100% of capacity during its first month and incurred the following costs:...
A business operated at 100% of capacity during its first month and incurred the following costs: Production costs (10,000 units):   Direct materials $170,000   Direct labor 360,000   Variable factory overhead 190,000   Fixed factory overhead     50,000 $770,000 Operating expenses:   Variable operating expenses $ 60,000   Fixed operating expenses     18,000 78,000 If 500 units remain unsold at the end of the month, what is the amount of inventory that would be reported on the variable costing balance sheet? a.$41,500 b.$42,800 c.$38,500 d.$36,000
A business operated at 100% of capacity during its first month and incurred the following costs:...
A business operated at 100% of capacity during its first month and incurred the following costs: Production costs (5,000 units): Direct materials-$70,000 Direct labor-20,000 Variable factory overhead-10,000 Fixed factory overhead-20,000 total $102,000 Operating expenses: Variable operating expenses-$17,000 Fixed operating expenses-1,000 total $18000 Prepare a variable income statement assuming 1000 units remain unsold at the end of the month and sales total $160,000 for the month
Describe the principal costs incurred in the business that employs you today, or a prior business,...
Describe the principal costs incurred in the business that employs you today, or a prior business, and then categorize them as fixed, variable, or mixed costs. If the volume of activity increased 10%, what would happen, in general terms, to unit costs for that product or service? 100 words or more
In a decision to sell or to process further, of what relevance are costs incurred prior...
In a decision to sell or to process further, of what relevance are costs incurred prior to the decision point? Explain your answer.
Expenses are costs incurred by an organization in the process of earning revenue during a given...
Expenses are costs incurred by an organization in the process of earning revenue during a given time period. Expense accounts have a direct impact on the profitability of an organization. List three expense accounts related to payroll. Describe when you would expect the account to be cleared to zero. Explain the methods you could use to reconcile these accounts.
Expenses are costs incurred by an organization in the process of earning revenue during a given...
Expenses are costs incurred by an organization in the process of earning revenue during a given time period. Expense accounts have a direct impact on the profitability of an organization. List three expense accounts related to payroll. Describe when you would expect the account to be cleared to zero. Explain the methods you could use to reconcile these accounts. pay roll fundamental 2 chapter 1
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT