Question

Walmart is considering the installation of customer kiosks in their Supercenters. The kiosks will allow customers...

Walmart is considering the installation of customer kiosks in their Supercenters. 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 $18,000,000 in 2018 to develop and implement the system software. • Starting in 2019 there will be an annual software maintenance fee of $15,000 per store in which kiosks are installed to cover bug fixes and upgrades. • Walmart has a total of 3,029 Supercenters with kiosk installation occurring on the following schedule: 600 stores in 2018, 850 stores in 2019, 950 stores in 2020, and the remaining 629 stores in 2021 • Each store will have 6 customer kiosks installed. One kiosk 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 $34,000 which represents the kiosk’s purchase and installation. • There is an annual hardware maintenance fee of $8,000 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. • Supercenters are open 365 days per year. • The sales associate labor rate is $10.00 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 60 additional items per day, averaging $3.40 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 Walmart break even on this project? • Based on their target rate of return of 15%, should Walmart go forward with this project? • In what year will Walmart break even if the employee labor rate per hour is $12? • What is the NPV if the annual hardware maintenance fee is reduced by $1,000? can you please provide Formulas for this in excel form? EX: =(c4+d4)

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
Walmart is considering the installation of customer kiosks in their Supercenters. The kiosks will allow customers...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • How will Walmart's use of robots change its break even point? Walmart (WMT) is robotic janitors...

    How will Walmart's use of robots change its break even point? Walmart (WMT) is robotic janitors in some of its stores. Walmart has purchased several Autonomous Cleaner (Auto-C) robots from Brain Corporation. An Auto-C robot looks like a Zamboni, the machine used to clean ice rinks. The robots scrub floors and clean store aisles. Sensors in the robots allow them to navigate around customers and other objects, so the robots can be used during store operating hours. Management at Walmart...

  • 1. A manufacturing company is considering the installation of a standby power supply system. A used...

    1. A manufacturing company is considering the installation of a standby power supply system. A used generator can be installed for £ 18,000; while a completely new generator can be installed for £ 24,000. Annual operating costs are estimated to be £ 8200 for the used generator and £7000 for the new one. Both generators are anticipated to survive for 20 years with zero salvage value at that time. Yearly maintenance costs of the used and new generators are £...

  • Redbox Succeeds by Identifying Market Need" . Redbox’s tell-tale bright red kiosks in stores and fast-food...

    Redbox Succeeds by Identifying Market Need" . Redbox’s tell-tale bright red kiosks in stores and fast-food restaurants across the country have become an image of what a good business model can accomplish. The company’s ability to offer customers a convenient and inexpensive DVD rental option has allowed it to succeed despite the widespread growth of streaming services such as Netflix and Amazon. However, the firm acknowledges the future of streaming, and Redbox has allegedly been discussing the launch of a...

  • 0.7. A large automobile manufacturer is considering the installation of a high-tech material handling system for $25...

    0.7. A large automobile manufacturer is considering the installation of a high-tech material handling system for $25,000,000. This system will save $7,500,000 per year in manual labor, and it will incur $2,750,000 in annual operating and maintenance expenditures. The salvage value at the end of the system's 10-year life is $1,500,000. If the company's hurdle rate (MARR) is 10% per year, should the system be recommended for implementation? Use IRR method to make your recommendation

  • Burger World is considering opening a drive-through window for customer service. Management estimates that customers will...

    Burger World is considering opening a drive-through window for customer service. Management estimates that customers will arrive at the rate of 15 per hour. The server who will staff the drive-up window can service customers at the rate of one every three minutes. Assuming Poisson arrivals and exponential service, find: 40. Utilization of the teller A) 45% B) 55% C) 65% D) None of the above 41. Average number of customers in the waiting line A) 2.25 B) 5.22 C)...

  • Why has Zara’s RFID rollout been less problematic than those at Walmart and JCPenney? How does...

    Why has Zara’s RFID rollout been less problematic than those at Walmart and JCPenney? How does Zara’s use of RFID reduce concerns that customer products will be tracked post purchase? How does Zara reduce the expense associated with tagging each item? (Please be sure to write in as much detail as is needed to respond in a way that clearly responds to the question at hand, while clarifying and elaborating with examples and details, where possible) Key Takeaways - Zara...

  • Why has Zara’s RFID rollout been less problematic than those at Walmart and JCPenney? How does...

    Why has Zara’s RFID rollout been less problematic than those at Walmart and JCPenney? How does Zara’s use of RFID reduce concerns that customer products will be tracked post purchase? How does Zara reduce the expense associated with tagging each item? (Please be sure to write in as much detail as is needed to respond in a way that clearly responds to the question at hand, while clarifying and elaborating with examples and details, where possible) Key Takeaways - Zara...

  • Calculating Customer Margin

    Foam Products, Inc., makes foam seat cushions for the automotive and aerospace industries. The company’s activity-based costing system has four activity cost pools, which are listed below along with their activity measures and activity rates: Activity Cost PoolActivity MeasureActivity RateSupporting direct laborNumber of direct labor-hours$9per direct labor-hourBatch processingNumber of batches$89per batchOrder processingNumber of orders$282per orderCustomer serviceNumber of customers$2,623per customer The company just completed a single order from Interstate Trucking for 2,100 custom seat cushions. The order was produced in five batches. Each...

  • Walmart Inventory Shrinkage (a GVV Case) The facts of this case are from the Walmart shrinkage...

    Walmart Inventory Shrinkage (a GVV Case) The facts of this case are from the Walmart shrinkage fraud discussed in an article in The Nation on June 11, 2014. “Literary license” has been exercised for the purpose of emphasizing important issues related to organizational ethics at Walmart. Any resemblance to actual people and events is coincidental. Shane O’Hara always tried to do the right thing. He was in touch with his values and always tried to act in accordance with them,...

  • Diller products Inc. is considering purchasing a robot to update their flexible manufacturing system. selected data...

    Diller products Inc. is considering purchasing a robot to update their flexible manufacturing system. selected data relating to the robot are provided below Cost of robot 1,600,000 Software and installation 700,000 Annual savings in labor cost ? Annual savings in inventory carrying costs 190,000 Monthy increase in power and maintenance costs.    2,500 Salvage value in 12 years 90,000 Useful life 12 years Engineering statistics suggest that the use of the robot will result in a savings of 40,000 direct...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT