-All constraints and linear programs should be derived with explanation and hand written. Linear programs (when asked for) should then be written in COMPLETE PROPER FORM (ALL constraints , organized order and clear identication of variable meanings). All diagrams and graphics should be presented (repeated) enough times to clearly demonstrate the work process that was followed in carrying out your work. Legibility is necessary. Excel can be used for calculations, but the pdf of this work must be \hand" augmented with clear indications of what was being carried out Excel sheets involving solver must be fully explained and the solver window itself should be screen capped and submitted as part of your presentation to show the linear program youasked excel to solve. This is the Steps please follow.And I need you to write the steps please. Step by StepPERT) Task | Regular Time Cost Total Cost of competing Tasks in the B.P.T.A$2,000$3,750$500$1,250$2,300$285,000$9,500$8,500$42,000$2,950$3,400B$1,500$120,000$5,000$6,000$30,000DEF$1,200$2,400$6,000$15,000S100,000$9,000$26,250$175,000JKLConstruct the linear program (and use solver to solve it) which would minimizing the cost(if possible) of completing the task in 48 weeks. 4. D.G.H.M. Inc. is a local busines involved in many aspects of the food supply industry. Asdemand during Covid times has increased, the management have decided to stream line theirprocess using technology and begin overhauling their operations. They will be performing thefollowing tasks :Task DescriptionDetermine requirementsPredecessorABReceive Contractor BidsSelect a ContractorOrder Computer SystemEА, ВCDesign a new Office Layout CFDesign a Network LayoutEDesign a Computer GUIHConnect ComputersInstall operating softwareTrain operatorsSimulation Test the System I, JMarket the changesD, F, GD, FHKKA study into the expected times for each Task has revealed the following information (time inweeks)Task Best Case Time Average Time Worst Case TimeA36.1626.D8.1225E10136.11G410H.8.6.I4J6.K310L.6.• Develop a report which presents the PERT diagram and determines the Expected timefor the project. Include an explanation with details of what the worst case time is andwhat the best case time is.What is the probability of the complete project being done in under 1 year (52 weeks)?in under 11 months (48 weeks)?We have just been asked to speed up the project to be ready in 48 weeks. This will requireSome additional finances to get the tasks to complete by their best ease times as necessary.As such the following information has heen complied:.

PERT: Program evaluation and review technique is an approach used in project management to represent…

Answered: 4. B.G.H.M. Inc. is a local buniness…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

Question

-All constraints and linear programs should be derived with explanation and hand written. Linear programs (when asked for) should then be written in COMPLETE PROPER FORM (ALL constraints , organized order and clear identication of variable meanings).
All diagrams and graphics should be presented (repeated) enough times to clearly demonstrate the work process that was followed in carrying out your work. Legibility is necessary.
Excel can be used for calculations, but the pdf of this work must be \hand" augmented with clear indications of what was being carried out
Excel sheets involving solver must be fully explained and the solver window itself should be screen capped and submitted as part of your presentation to show the linear program you
asked excel to solve.

This is the Steps please follow.

And I need you to write the steps please. Step by Step

PERT)

Task | Regular Time Cost Total Cost of competing Tasks in the B.P.T.
A
$2,000
$3,750
$500
$1,250
$2,300
$285,000
$9,500
$8,500
$42,000
$2,950
$3,400
B
$1,500
$120,000
$5,000
$6,000
$30,000
D
E
F
$1,200
$2,400
$6,000
$15,000
S100,000
$9,000
$26,250
$175,000
J
K
L
Construct the linear program (and use solver to solve it) which would minimizing the cost
(if possible) of completing the task in 48 weeks.

4. D.G.H.M. Inc. is a local busines involved in many aspects of the food supply industry. As
demand during Covid times has increased, the management have decided to stream line their
process using technology and begin overhauling their operations. They will be performing the
following tasks :
Task Description
Determine requirements
Predecessor
A
B
Receive Contractor Bids
Select a Contractor
Order Computer System
E
А, В
C
Design a new Office Layout C
F
Design a Network Layout
E
Design a Computer GUI
H
Connect Computers
Install operating software
Train operators
Simulation Test the System I, J
Market the changes
D, F, G
D, F
H
K
K
A study into the expected times for each Task has revealed the following information (time in
weeks)
Task Best Case Time Average Time Worst Case Time
A
3
6.
16
2
6.
D
8.
12
25
E
10
13
6.
11
G
4
10
H.
8.
6.
I
4
J
6.
K
3
10
L.
6.
• Develop a report which presents the PERT diagram and determines the Expected time
for the project. Include an explanation with details of what the worst case time is and
what the best case time is.
What is the probability of the complete project being done in under 1 year (52 weeks)?
in under 11 months (48 weeks)?
We have just been asked to speed up the project to be ready in 48 weeks. This will require
Some additional finances to get the tasks to complete by their best ease times as necessary.
As such the following information has heen complied:.

Expert Solution

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions