Assignment 7(1)

docx

School

Austin Community College District *

*We aren’t endorsed by this school

Course

2390

Subject

Computer Science

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by SargentJackalMaster610

Austin Community College Computer Science and Information Technology Department BCIS 2390 – System Analysis and Design: Project Management Assignment 7 – Project Cost Management Open a new Microsoft Word document and answer the questions listed in the tasks. Save the file on your laptop or computer with your name in the filename. (Example: LSylvester_Assignment-1.doc). Task(s) 1. Given the following information for a one-year project, answer the following questions. Recall that PV is the planned value, EV is the earned value, AC is the actual cost, and BAC is the budget at completion. a. PV $22,000 b. EV $20,000 c. AC $25,000 d. BAC $120,000 a. What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? b. How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget? c. Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned? d. Use the SPI to estimate how long it will take to finish this project. e. Sketch the earned value chart for this project, using Figure 7-6 as a guide. 2. Create a cost estimate and model for building a new, state-of-the-art multimedia classroom for your organization within the next six months. The classroom should include 20 high-end personal computers with appropriate software for your organization, a network server, Internet access for all machines, an instructor station, and a projection system. Be sure to include personnel costs associated with the project management for this project. Document the assumptions you made in preparing the estimate and provide explanations for key numbers. 3. Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions:  You will charge $600 per person for a two-day class.  You estimate that 30 people will attend the class, but you want to change this input.  Your fixed costs include $500 total to rent a room for both days, setup fees of $400 for registration, and $300 for designing a postcard for advertising.  You will not include your labor costs for this estimate, but you estimate that you will spend at least 150 hours developing materials, managing the project, and giving the actual class. You would like to know what your time is worth given different scenarios.  You will order 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues.  Your variable costs include the following: a. $5 per person for registration plus 4 percent of the class fee per person to handle credit card processing; assume that everyone pays by credit card

b. $.40 per postcard for printing if you order 5,000 or more c. $.35 per postcard for mailing and postage d. $25 per person for beverages and lunch e. $30 per person for class handouts Be sure to have input cells for any variables that might change, such as the cost of postage and handouts. Calculate your profits based on each of the following numbers of people who might attend: 10, 20, 30, 40, 50, and 60. In addition, calculate what your time would be worth per hour based on the number of students. Try to use the Excel data table feature to show the profits based on the number of students. If you are unfamiliar with data tables, just repeat the calculations for each possibility of 10, 20, 30, 40, 50, and 60 students. Print your results on one page, highlighting the profits for each scenario and what your time is worth. Turn in All assignments will be completed in class and graded on Blackboard. We will discuss the assignment in class before submission to Blackboard. Once you have completed the tasks related to the assignment, submit your solution file on the Assignment link on Blackboard within the week’s folder.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

OPS102 - Week 1 - Lab - OS Exploration.docx

OPS102 - Week 3 - Lab.docx

1306 Chapter 6 Review.docx

Assignment 5.docx

A1 Activity sheet – Unplugged client-server network.docx

Assignment 2.docx

Assignment 13(2).docx

project 2 final draft.docx

Recommended textbooks for you

Information Technology Project Management

Computer Science

ISBN:9781337101356

Author:Kathy Schwalbe

Publisher:Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning