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 threeyear 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 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 threeyear period. The costs of purchasing the software actually for purchasing a year license from the vendor to use its software package includes the initial purchase price of the software licensing fee of $ paid in the first year the cost of implementing and customizing the software in the first year $ one new server to run the software a firstyear purchase of $ one information systems specialist devoting half of his or her time to supporting the software $ in fulltime annual salary and benefits with a annual salary increase each year after the first year user training in the first year $ first year and second and third years and the cost of annual software upgrades $ The costs of renting hosted software are the rental fees $ annually per user implementation and customization costs $ in the first year and training $ in the first year, $ in second and third years and technical support oneeighth annual $ salary Use Excel software to calculate the total cost of renting or purchasing this software over a threeyear period. Identify the lowestprice 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
