Question

In: Accounting

Target Customer Kiosks Target is considering the installation of customer kiosks in their stores. The kiosks...

Target Customer Kiosks

Target is considering the installation of customer kiosks in their stores. The kiosks will allow customers to search for products, tell them if the products are in stock, and show them on a map where in the store the products are located. Use the following facts to conduct a break-even analysis of the customer kiosk technology.

Costs

·         There will be a one-time cost of $45,000,000 in 2018 to develop and implement the system software.

·         Starting in 2019 there will be an annual software maintenance fee of $16,000 per store in which kiosks are installed to cover bug fixes and upgrades.

·         Target has a total of 3,000 stores with kiosk installation occurring on the following schedule: 500 stores in 2018, 700 stores in 2019, 800 stores in 2020, and the remaining 1,000 stores in 2021

·         Each store will have 8 customer kiosks installed. Two kiosks will be located at each entrance with the other kiosks located at select spots within the store.

·         There is a one-time cost per kiosk of $32,000 which represents the kiosk’s purchase and installation.

·         There is an annual hardware maintenance fee of $4,500 to maintain each installed kiosk starting in the year the kiosk is installed.

Benefits

The tangible benefits come from reduced labor costs and increased sales revenue.

·         The kiosks are expected to reduce the need for employees to spend time directing customers to products. This time savings will result in reduced labor costs equivalent to employing one employee during regular store hours from 8am-8pm per store where kiosks are installed.

·         Target stores are open 365 days per year.

·         The sales associate labor rate is $10.50 per hour.

·         The kiosks are also expected to increase the likelihood that customers will find all of the items they are looking to purchase. It is estimated that each store with kiosks will sell 130 additional items per day, averaging $1.85 per item.

Calculations

The break-even analysis will cover a 6-year period from 2018-2023.

For each year:

·         Calculate the system costs and benefits.

·         Calculate the net benefits of the system and the break-even totals for the system. Break even totals are simply the accumulated net benefits. The project breaks even when the accumulated net benefits value is positive.

For the total time period:

·         Calculate the net present value (NPV) of the investment using a rate of 15%.

·         Calculate the internal rate of return (IRR).

Answer the four questions at the bottom of the spreadsheet.

·         In what year will Target break even on this project?

·         Based on their target rate of return of 15%, should Target go forward with this project?

·         In what year will Target break even if the employee labor rate per hour is $11?

·         What is the NPV if the annual hardware maintenance fee is increased by $500?

Please fill in the following TEMPLATE only for UPVOTE

Break Even Analysis for Target Customer Kiosks
Variables 2018 2019 2020 2021 2022 2023
Count of new stores installing kiosks
Running total of stores with kiosks installed
Number of kiosks per store
One-time software development and implementation
Purchase and installation per kiosk
Annual software maintenance per store
Annual hardware maintenance per kiosk
Employee labor rate per hour
Business days per year
Regular store hours per day
Additional items sold per store with kiosks
Average revenue per additional item sold
NPV Rate
Costs 2018 2019 2020 2021 2022 2023
One-Time software development and implementation
Purchase and installation of kiosks
Annual software maintenance
Annual hardware maintenance
Total Annual Costs
Benefits 2018 2019 2020 2021 2022 2023
Reduced labor
Increased sales
Total Annual Benefits
Break-Even, NPV, and IRR Calculations 2018 2019 2020 2021 2022 2023
Net Annual Benefits
Break-Even Totals (Accumulated Net Benefits)
Net Present Value (NPV)
Internal Rate of Return (IRR)
Questions
In what year will Target break even on this project?
Based on their target rate of return of 15%, should Target go forward with this project?
In what year will Target break even if the employee labor rate per hour is $11.
What is the NPV if the annual hardware maintenance fee is increased by $500?

Solutions

Expert Solution

Break Even Analysis for Target Customer Kiosks
Variables 2018 2019 2020 2021 2022 2023
A Count of new stores installing kiosks 500 700 800 1000
B Running total of stores with kiosks installed 500 1200 2000 3000 3000 3000
C Number of kiosks per store 8 8 8 8 8 8
D One-time software development and implementation $45,000,000
E Purchase and installation per kiosk $32,000 $32,000 $32,000 $32,000
F Annual software maintenance per store $16,000 $16,000 $16,000 $16,000 $16,000 $16,000
G Annual hardware maintenance per kiosk $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
H Employee labor rate per hour $10.50 $10.50 $10.50 $10.50 $10.50 $10.50
I Business days per year 365 365 365 365 365 365
J Regular store hours per day 12 12 12 12 12 12
K Additional items sold per store with kiosks 130 130 130 130 130 130
L Average revenue per additional item sold $1.85 $1.85 $1.85 $1.85 $1.85 $1.85
M NPV Rate 0.15 0.15 0.15 0.15 0.15 0.15
Costs 2018 2019 2020 2021 2022 2023
D One-Time software development and implementation $45,000,000
P=A*C*E Purchase and installation of kiosks $128,000,000 $179,200,000 $204,800,000 $256,000,000
Q=B*F Annual software maintenance $8,000,000 $19,200,000 $32,000,000 $48,000,000 $48,000,000 $48,000,000
R=B*C*G Annual hardware maintenance $18,000,000 $43,200,000 $72,000,000 $108,000,000 $108,000,000 $108,000,000
S=D+P+Q+R Total Annual Costs $199,000,000 $241,600,000 $308,800,000 $412,000,000 $156,000,000 $156,000,000
Benefits 2018 2019 2020 2021 2022 2023
T=H*I*J*B Reduced labor $22,995,000 $55,188,000 $91,980,000 $137,970,000 $137,970,000 $137,970,000
U=I*K*L*B Increased sales $43,891,250 $105,339,000 $175,565,000 $263,347,500 $263,347,500 $263,347,500
V=T+U Total Annual Benefits $66,886,250 $160,527,000 $267,545,000 $401,317,500 $401,317,500 $401,317,500
N Year 0 1 2 3 4 5
Break-Even, NPV, and IRR Calculations 2018 2019 2020 2021 2022 2023
W=V-S Net Annual Benefits ($132,113,750) ($81,073,000) ($41,255,000) ($10,682,500) $245,317,500 $245,317,500
X Break-Even Totals (Accumulated Net Benefits) ($132,113,750) ($213,186,750) ($254,441,750) ($265,124,250) ($19,806,750) $225,510,750 SUM
PV=W/(1.15^N) Present Value of Net AnnualBenefit ($132,113,750) ($70,498,261) ($31,194,707) ($7,023,917) $140,261,077 $121,966,154 $21,396,596
NPV=Sum of PV Net Present Value (NPV) $21,396,596
IRR Internal Rate of Return (IRR) 17.58% (Using IRR function of excel over Net Annual Benefit(Row X)
Questions
In what year will Target break even on this project? 2023
Based on their target rate of return of 15%, should Target go forward with this project? Yes ,because NPV is positive
In what year will Target break even if the employee labor rate per hour is $11. 2022 Changing Value of Employee labor Rate per hour to $11
What is the NPV if the annual hardware maintenance fee is increased by $500? ($11,543,821) Changing Annual Hardware maintenance fees to $5000



Related Solutions

Consumers can purchase nonprescription medications at food stores, mass merchandise stores such as Target and Wal-Mart,...
Consumers can purchase nonprescription medications at food stores, mass merchandise stores such as Target and Wal-Mart, or pharmacies. About 45% of consumers make such purchases at pharmacies. What accounts for the popularity of pharmacies, which often charge higher prices? A study examined consumers' perceptions of overall performance of the three types of stores, using a long questionnaire that asked about such things as "neat and attractive store," "knowledgeable staff," and "assistance in choosing among various types of nonprescription medication." A...
Consumers can purchase nonprescription medications at food stores, mass merchandise stores such as Target and Wal-Mart,...
Consumers can purchase nonprescription medications at food stores, mass merchandise stores such as Target and Wal-Mart, or pharmacies. About 45% of consumers make such purchases at pharmacies. What accounts for the popularity of pharmacies, which often charge higher prices? A study examined consumers' perceptions of overall performance of the three types of stores, using a long questionnaire that asked about such things as "neat and attractive store," "knowledgeable staff," and "assistance in choosing among various types of nonprescription medication." A...
The company is considering the installation of a high-end server for handling the system with the...
The company is considering the installation of a high-end server for handling the system with the first initial cost of $25,000,000. This system will save $7,500,000 per year in spare part cost, but it will incur $2,750,000 in annual operating and maintenance expenditures. The salvage value at the end of the system’s 4 years' life is $1.500,000. At the end of the project, the company will invest the new server for the next 4 upcoming years with initial the initial...
Explain why the key survival in a small business is the target customer
Explain why the key survival in a small business is the target customer
A business improvement district is considering the installation of a new light- ing system for the...
A business improvement district is considering the installation of a new light- ing system for the district. If the lighting system is installed, all the businesses in the area will benefit, and there will be no way in which a business that does not pay for a share of the system can be denied full benefits from the system. The system will cost $4,000 and will benefit the five members of the district as follows: Individual Benefit (in $) A...
Is the "Customer Archetype useful for analyzing the customer market a business is considering? What are...
Is the "Customer Archetype useful for analyzing the customer market a business is considering? What are the benefits and limitations of such tools for understanding and predicting consumer behavior?
A municipal water authority is considering the installation of a new water system. Two options are...
A municipal water authority is considering the installation of a new water system. Two options are being considered. The first option is a steel pipeline with an installation cost of $225 million. Annual maintenance and pumping costs begin at $15 million and increase by $1.0 million per year. The second option is a gravity fed concrete canal with an installation cost of $400 million. Annual maintenance costs begin at $0.5 million and increase by $0.4 million per year. The water...
Square Manufacturing is considering investing in a robotics manufacturing line. Installation of the line will cost...
Square Manufacturing is considering investing in a robotics manufacturing line. Installation of the line will cost an estimated $9.7 million. This amount must be paid immediately even though construction will take three years to complete (years 0, 1, and 2). Year 3 will be spent testing the production line and, hence, it will not yield any positive cash flows. If the operation is very successful, the company can expect after-tax cash savings of $6.7 million per year in each of...
A mine is considering the installation of automated equipment in its processing plant to reduce labour...
A mine is considering the installation of automated equipment in its processing plant to reduce labour costs from: $300,000 to $220,000 in year 1, from $330,000 to $240,000 in year 2, from $360,000 to $260,000 in year 3, and from $400,000 to $290,000 in year 4. The equipment will cost $200,000 now with an expected salvage value of $50,000 in four years. The minimum rate of return is 20%. Use IRR and NPV analysis to determine if the equipment should...
You are considering a new project that requires $300,000 investment in a machine, including installation and...
You are considering a new project that requires $300,000 investment in a machine, including installation and shipping cost. The life of the machine is three years, and it depreciates via 3-year MACRS methods (33.33%, 44.45%, 14.81%, and 7.41%). If you operate this project, the annual sales of the firm increases by $250,000 a year, and the annual operating expense increased by $100,000. The firm has a marginal tax rate of 34%. In order to start the project, the firm has...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT