Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

X Company is considering outsourcing its email system. Total costs related to la

ID: 2463324 • Letter: X

Question

X Company is considering outsourcing its email system. Total costs related to last month's in-house email operation, when there were 3,810 employee mailboxes, were as follows: Variable costs: Email license $18,288 Virus protection license 5,334 Miscellaneous 15,240 Fixed costs Computer hardware 22,860 $9,601 of the computer hardware costs were common costs that will continue even if the email system is abandoned, and X Company will still need to pay for the virus protection license. Y Company has offered to operate an email system for X Company for $11.70 per mailbox. Next year, X Company estimates that 3,935 mailboxes will be required per month. By how much will X Company's monthly profits change if they decide to outsource its email function to Y Company instead of managing the service internally? [A positive number means that make costs are more than buy costs; a negative number means that make costs are less than the buy costs.]

Explanation / Answer

Answer:

The problem is related to Make or Buy Decision. In this case the decision should be taken based on relevant cost for making product or relevant cost for buying product from outside. The costs which are common under both the situations should be ignored (i.e. not considered) while taking the decision for make or buy the product.

First we calculated Variable Cost Per Email Operation from Last month (data given in the question)

Total Cost related to last month (In-House email operation -- 3,810 Employees)

Cost Per Email Operation

Variable Cost:

Email License

$18,288

$4.80

Virus Protection License

$5,334

$1.40

Miscellaneous

$15,240

$4.00

Fixed Costs Computer Hardware

$22,860

Total Cost

$61,722

Now, the next year, Company estimates mailboxes per month = 3,935

In this situation, first of all we need to calculate the In-House Email operation Cost for next year based on 3,935 Email Operations in month as follows:

Total Cost of month related to next year (In-House email operation -- 3,935 Employees)

Cost Per Email Operation

Variable Cost:

Email License

$18,888

$4.80

Virus Protection License

$5,509

$1.40

Miscellaneous

$15,740

$4.00

Fixed Costs Computer Hardware

$22,860

Total Cost

$62,997

Now, we need to calculate the Total Cost if Email Operations are Outsource for 3,935 Employees as follows:

Total Cost of month related to next year (Outsourcing of Email Operations – 3,935 Employees)

Cost Per Email Operation

Variable Cost:

Operating Cost for email system

$46,039.50

$11.70

Virus Protection License

$5,509

$1.40

Total Cost

$51,548.50

Now we need to prepare a Comparative Cost Statement for In-House Operation Management and Outsource Operation as follows:

Comparative Cost Statement for Next Year (Email Operation – 3,935 Employees Per Month)

In-House Operation Cost

Outsource Operation Cost

Variable Cost:

Email License

$18,888

Operating Cost for email system (Outsource)

$46,039.50

Virus Protection License (note 1)

-

-

Miscellaneous

$15,740

Unavoidable Fixed Cost - Computer Hardware (note 2)

$9,601

Total Cost

$44,229

$46,039.50

Note 1 – Company will still need to pay Virus Protection License cost whether the company will do In House Operation or outsource the operation. Since this cost is common under both the option. It is not treated as relevant cost for decision making. Hence it is ignored. The costs which are common under each alternative course of action is IRRELEVANT Cost and should be ignored in decision making.

Note 2 -- In the question it is given that $9,601 Computer Hardware Costs were common costs that will continue even if the email system is abandoned. It means if the In-House system abandoned this cost will continue to incur to the company. Hence it is relevant for decision making.

Analysis:

From the above Comparative Cost Statement it is clear that the cost of managing In-House Operation of Email System is less than outsourcing it. If Company goes for Outsourcing the Email System it will incur additional cost of $1,810.50 ($46,039.50 - $44,229). In other words, company’s profit will be decreased by $1,810.50 if they go for outsourcing of Email system.

Therefore, X Company’s monthly profits will be decreased by $1,810.50 if they decide to outsource its email function to Y Company instead of managing the service internally.

Answer is -$1,810.50

Total Cost related to last month (In-House email operation -- 3,810 Employees)

Cost Per Email Operation

Variable Cost:

Email License

$18,288

$4.80

Virus Protection License

$5,334

$1.40

Miscellaneous

$15,240

$4.00

Fixed Costs Computer Hardware

$22,860

Total Cost

$61,722