Given the data for a project in table Q3, using the following assumptions:1.8 hours as working day2.The company will work all days.3.Maximum number of workers available per day is 64.Activities cannot be break down5.Budget will distributed equally per day, except for activities (B, H and L), thepayment will be after two days of working: means that the first payment will beat the end of day2, then day four and so on.6.They estimate that the work will starts on the first of November 2017Develop a report containing the followings:Date of finishBAD O GYEK1.2.Early start and Slack time for each activity3.Resource histogram4.Cumulative Budget baseline curve5.Interpret the final reportco Table Q3Duration (Hrs)No of WorkersBudgetActivitypredecessorANone48120006432000C1610000324.12000B,C328000B,C166000GB,C16410000H.64160003.16400032112000K32316000H.48112000Total Budget ofRM150000

Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Answered: Given the data for a project in table…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

Three point estimates and bottom up estimating are used in developing: (select one correct answer) Schedules Risks Cost estimates Scope
Operational Plans are preared for • a. Usually 3 months b. All of these c. Usually for 5 years d. Usually one year
1 Cara's clients, Emily and Dave, have just had a baby and she would like to do something nice for them. She signs them up for a baby registry that sends them a small gift. Emily and Dave will be sent information and service lists that are geared toward helping new parents. She provided their names, address and phone numbers so that they will not miss any of the activities provided in the package. Has Cara dealt with her clients appropriately? NUYLOTNQhObm1bEVKUTO90 a0 Cara did not protect her clients' privacy when she shared their personal information with the baby registry. O Cara should not make this a regular practice. Her clients will begin to expect gifts and she will not be able to sustain this. CO Cara should have set up an appointment to re-evaluate her clients' needs now that they have had a baby. 40 Cara's gift is very thoughtful and will help to build a relationship with her clients. NUTYks10TNRUQ2h0bmkbEVKUTO90
Fred Ridgeway has been given the responsibility of managing a training and development program. He knows the earliest start time, the latest start time, and the total costs of each activity. The information is given in the table. (The Latest start time is not given since you are not being asked to determine the budget based on that.) Using earliest start times, determine Fred’s total monthly budget. Construct a full table to show the correct budget. (This takes up space so start on the left and use both pages or turn the page landscape (wide).) Activity ES(months) LS Time(months) TOTAL COST($1,000s) A 0 - 6 12 B 2 - 3 7 C 4 - 7 6 D 4 - 4 12 E 6 - 5 5 F 12 - 2 5.5 G 11 - 4 8 H 13 - 3 4 I 7 - 6 2 J 7 - 4 6
Consider a project with seven tasks. Three tasks – tasks 3, 4, and 5 – require a specific resource for completion; all needed resources must be available at the site before a task can be started. Task Duration Predecessor (s) Units of Value of Resource Completed Task Needed 3 3 10 $4000 3 1 10 S3000 3 12 $5000 1 4 7 2, 5,6 Each resource unit cost $100; no quantity discounts are available. In addition, it costs $2 per unit per time period to hold this resource in stock, and it costs $45 just to place an order for materials (independent of the number of units ordered). When should each task in the project be started and when and how many resources should be ordered to minimize total project costs? 1. 1, en en 1. 2. en
Unlike management reserves, contingency reserves are not likely to be spent and are not part of the project's budget baseline, but they can be included in the total project budget. Question 29 options: True False
time 1 2 3 4 5 6 7 8 9 10 Returns on Project A 70.00% -24.00% 46.00% 46.00% 0.00% 9.00% -83.00% 68.00% -39.00% 112.00% Returns on Project B 63.00% -21.60% 41.40% 41.40% 0.00% 8.10% -74.70% 61.20% -35.10% 100.80% The risk of a portfolio composed of 50% in project A and 50% in project B is greater than the risk of either project A or Project B. True False
You are in charge of a project at the local community center. The center needs to remodel one of the rooms in time for the start of a new program. Delays in the project mean that the center must rent other space at a nearby church at additional cost. Time and cost data for your project are contained in 7.10. Your interest is in minimizing the cost of theproject to the community center.a. Using the normal times for each activity, what is the earliest date you can complete the project?b. Suppose the variable overhead costs are $50 per day for your project. Also, suppose that the center must pay $40 per day for a temporary room on day 15 or beyond. Find the minimum-cost project schedule.
Today you got the budget approval from the Vice President to schedule the training session and pay Prof. Jim Salu his professional fee and reimburse him for expenses up to GH¢500.00. He will have to submit all receipts and an itemised list of expenses to be reimbursed. You cannot reimburse him if he does not have receipts. You also have to explain the mechanics of the training session. You will use the company conference room, which has a screen, flip charts an overhead projector and VCR, but you will need to reserve them if the Professor wants to use them. Write a letter to Professor Jim Salu. You do not have to persuade him since he had already informally agreed, but you do want him to look forward to the job and to do his best work.
A new order filling system is needs to be installed as soon as possible. The following activities need to be completed in the order shown below. Also provided is the cost information to reduce the normal activity times. 4. Activity Crash Normal Crash Immediate Predecessors Normal Time Time Cost ($) Cost ($) A 7 5 2000 3500 --- В 10 8 3000 5700 A 8. 7 3000 3800 A D 6. 4 1600 2600 C E 7 4 2000 4100 3 1200 2800 D, E В, С F, G G 11 8 8200 10900 H 4 3 2600 4800 Crash the project to 25 days. What will the total crashing cost be? а. b. с. What activities will be crashed?
1.You’re managing a project to install 400 windows in a new skyscraper and need to figure outyour budget. Each week of the project costs the same: your team members are paid a total of $4,000every week, and you need $2,000 worth of parts each week to do the work. If the project isscheduled to last 16 weeks, calculate theBAC, PV, EV, AC, SPI, SV, CPI, SPI, CV for the project? 2.You’re managing a highway construction project. Your total budget is $650,000, and there isa total of 7,500 hours of work scheduled on the project. You check with your accountingdepartment, and they tell you that you’ve spent a total of $400,000. According to the schedule,your crew should have worked 4,500 hours, but your foreman says that the crew was allowed towork some overtime, and they’ve put in 5,100 hours of work. Calculate theBAC, PV, EV, AC, SPI, SV, CPI, SPI, CV for the project?
Problem 1 The following data represent the plan of a project in Magic Corporation: Times (weeks) Activity A B C D DEF H 1 J Predecessor A A A B, C D E, F G G H, I a 4 2 2 1 3 4 1 1 3 1 m 5 4 4 WSST 5 4 5 3 8 42 b 12 12 6 9 565 6 9 11 3

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS