Question: Improving Decision Making using spreadsheet analysis: A local manufacturing company asks you to help them make a decision about whether to rent or buy new

Improving Decision Making using spreadsheet analysis: A local manufacturing company asks you to help them make a decision about whether to rent or buy new technology. Youll use spreadsheet software (Excel) to compare the total three-year cost of licensing and maintaining new manufacturing software or renting the software, AnalyticalThinking, from an online software service provider.The company would like to implement new production planning, quality control, and scheduling software for use by 25 members of its manufacturing staff. Management is trying to determine whether to purchase the software from a commercial vendor along with any hardware required to run the software or to use a hosted software solution from a software service provider. (The hosted software runs on the service providers computer.) You have been asked to help management with this rent vs. buy decision by calculating the total cost of each option over a three-year period. The costs of purchasing the software (actually for purchasing a 3-year license from the vendor to use its software package) includes the initial purchase price of the software (licensing fee of $100,000 paid in the first year), the cost of implementing and customizing the software in the first year ($20,000), one new server to run the software (a first-year purchase of $7000), one information systems specialist devoting half of his or her time to supporting the software ($65,000 in full-time annual salary and benefits with a 3% annual salary increase each year after the first year), user training in the first year ($10,000 first year and 3000 second and third years), and the cost of annual software upgrades ($5,000). The costs of renting hosted software are the rental fees ($2000 annually per user), implementation and customization costs ($12,000 in the first year), and training ($10,000 in the first year, $2000 in second and third years), and technical support one-eighth annual $65,000 salary). Use Excel software to calculate the total cost of renting or purchasing this software over a three-year period. Identify the lowest-price alternative that meets the companys requirements. Give me formulas and excel sheet. I need formulas! Make it in excel sheets. Please

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!