Prior to beginning work on this assignment, review the Bright Day Wellness Center (BDWC) case study and each tab in the Microsoft Excel Build versus Buy Tool, beginning with the purpose and instructions, and including the total cost of ownership (TCO calculator) and the tab showing graphical results. Analyze the challenge scenario presented in the case study regarding the acquisition of a technology platform to schedule clients for services at BDWC and the financial information in the BDWC case study.
When completing the Build Versus Buy Workbook,
- Analyze the workbook instructions located in the first Microsoft Excel worksheet tab labeled “Purpose & Instructions.”
- Develop a second Microsoft Excel worksheet for both a build and buy option in the tab labeled “TCO Calculator” by inputting data from the Bright Day Wellness Center (BDWC) case study.
- Input financial data in dollars into the “TCO Calculator” worksheet tab in cells that are relevant to the case study; do not delete rows or columns in the TCO Calculator worksheet; leave any nonapplicable cells blank.
- Articulate brief comments that explain your numbers in each row of input data in the TCO Calculator by right-clicking on the cell and adding a new comment for the applicable row.
- Formulate an impression of which option (build versus buy) is costlier in its initial state and over time by observing your calculated results in the worksheet tab labeled “Results.”
The BDWC Build Versus Buy Workbook must be uploaded to the classroom in its entirety, including the three worksheets: Purpose and Instructions, TCO Calculator, and Results.