Prior to beginning work on this assignment, review the Bright Day Wellness Center (BDWC) case study and each tab in the Build versus Buy Tool Microsoft Excel workbook 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 as well as the financial information in the BDWC case study.
When completing the Workbook,
- Analyze the workbook instructions located in the first Microsoft Excel worksheet tab labeled “Purpose & Instructions.”
- Develop the 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 which 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 where you input data in the TCO Calculator by right clicking on the cell and adding a new comment in it 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.”
- Critique the TCO results for reflection in your Week 5 Journal entry.
The BDWC Build Versus Buy Microsoft Excel workbook must be uploaded to the classroom in its entirety including the three worksheets: Purpose and Instructions, TCO Calculator, and Results.