Purchase Solution

Create a time-phased budget for implementing software. Identify the primary cost drivers.

Not what you're looking for?

Ask Custom Question

Practice problem- no grade

Revise Excel Spreadsheet (attached) to a time-phased budget for implementing software. Identify the primary cost drivers.

Do not need to worry about depreciation of the software. Need to focus on understanding what the costs are, and when those costs will be incurred during the implementation process. Need the total cost for "startup."

When calculating the people (indirect) cost.... need to not only account for the time the 12 individuals will be trained, but also need to realize that the 2 people being trained by the vendor will be training the other 10 people....so there is additional people time needed to account for.

The Managed Care Department of the hospital has decided to implement a Case Management System called Ultima. The cost of the software is $450,000. This includes the cost of the software, software configuration, conversion of existing data into the software database, training for 2 people, and on-site resources for 2 days during the initial installation and go-live. A total number of 12 users will need training to operate this software. Training time is 2 days per person. This will be accomplished by the 2 people in-house that are trained by the vendor. This software system will require the purchase of 3 servers ($1,250 each) that will be configured in a cluster to support the department's request for redundancy and failover. In addition, backup software for each server is $1,500. The average salary of an IT worker is $91/hour. You will need 1 programmer (40 hours), 1 database manager (65 hours), 1 project analyst (150 hours), 1 operations analyst (20 hours), 1 interface manager (20 hours), and 1 networking analyst (10 hours).

See attached chart to change and re-post

Attachments
Purchase this Solution
Solution Summary

You will find the answer to this puzzling scenario inside...

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Motivation

This tests some key elements of major motivation theories.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

View More Free Quizzes
Related BrainMass Solutions

  • Care+ Resource Management Paper

    A time-phased budget (based on your work breakdown structure) Write a brief to the project manager in the scenario justifying your work breakdown structure and time-phased budget.

  • The Managed Care Department

    A work breakdown structure of direct, general administrative overheads b. A time-phased budget (based on your work breakdown structure) Dear student, Creating a project Plan 1. Create a task list and work breakdown structure (WBS) 2.

  • Project Management Assignment...Time-Phased Budget

    Create a time-phased budget based on the WBS.doc attachment provided. The Managed Care Department of the hospital has decided to implement a Case Management System called Ultima. The cost of the software is $450,000.

  • Project Management paper on hospital case management system

    A time-phased budget (based on your work breakdown structure) Write a 1,000 word brief to the project manager in the scenario justifying your work breakdown structure and time-phased budget. In this brief, do the following: a.

  • Role of cost drives

    Thus, "Number of Schedule Changes" would be the cost driver of "Determine Time Phased Material Requirements." As this example implies, there must be a singular cost driver for each activity, or the activity needs to be further decomposed.

  • Project Management in Health-Care

    Senior leadership would like for me to prepare a time-phased budget for final approval of this project. I will also need to provide a diagram of how I estimated direct costs, labor costs, and indirect costs.

  • Accounting Problems: USAA

    133121 Accounting Problems: USAA Identify a product or service within USAA that could use Activity Based Counting (ABC). Then identify at least two activities for ABC and the appropriate cost drivers for those activities.

  • Airtran Airways - Activity Based Costing

    171317 Airtran Airways - Activity Based Costing Identify a product or service in AirTran that could use ABC. Then identify at least two activities for ABC and the appropriate cost drivers for those activities.

  • Project Management: Identify all of the costs involved

    Label the costs either direct cost, project overhead costs, or general and administrative overhead costs. Develop a time-phased budget for the project. What will be the cumulative cost of the project?

View More Related Solutions