Question: Question 7: The following time estimates (in months) for ten activities required for the planning of a huge hospital complex are shown in the table below:

a) In the headings of the last two columns show the formulas for tiMeand variance. Show the times and variances for activities A, B, C and D. The times and variances have been shown for all other activities. Obey the rules of rounding (if the last digit is 5 or more, round the previous digit up. If the last digit is 4 or less, keep the previous digit as is. This applies to all your problems). (1 mark)

b) Draw a CPM/Pert diagram of the activities using the following convention. You may use PAINT to copy your network onto your word document or attach a separate sheet to your assignment. Show ‘start’ and ‘finish’ nodes: (3 marks)

c) Calculate the expected project length, variance of the critical path, standard deviation of the critical path and the activities along the critical path. (1 mark)

d) What is the probability the activities will NOT be completed within the due time of nine and a half years? Is 9.5 years an unrealistic estimate? (1 mark)

Question: Question 3: The advertising director for a hardware company with a chain of four retail stores is considering two media possibilities: One plan is for a series of half-page advertisements in the Sunday newspaper, and the other is for advertising time on television. The stores are expanding their do-it-yourself tools, and the advertising director is interested in an exposure level of at least 40% within the city and 60% in the suburban areas. The TV viewing time under consideration has an exposure rating per spot of 5% in city homes and 3% in suburban homes. The Sunday newspaper has corresponding exposure rates of 4% and 3% per ad. The cost of a half-page advertisement is $925; a television spot costs $2,000. The advertising director would like to select the least costly advertising strategy that would meet desired exposure levels.

a) Show the decision variables (0.5 mark)

b) Show the objective function (0.5 mark)

c) Show and name the constraints in standard form (suitable for using Excel)* (1 mark)

*Constraints must be shown in ‘standard form’ as required by the question. You also need to do this in the exam. Note X’s are on the LHS of the equation and numbers are on the RHS.

d) Imagine you have been hired by the advertising director to solve the problem by using Excel. Do so and write a conclusion of your findings for the director. (2 marks)

Question: Question 4: A farm in the south-west of Western Australia comprises 300 hectares and has available water of 250,000 litres per season, and costs $100 per planted hectare per season to operate. Wheat, corn and barley can be grown on the property. The following information is pertinent:

The farm forecasts a maximum demand of wheat of 5,000 tonnes; for corn, 6,000 tonnes, and for barley, 4,000 tonnes. Also, the farm has a contract to supply at least 2,500 tonnes of wheat to a particular customer. The objective is to determine the number of hectares of each crop that should be planted on the farm in order to maximise profit? You are not required to solve this problem. Simply show:

a) Objective Function (1 mark)

b) The constraints on water and on land. (1 mark)

Question: Question 5: A company manufactures office desks at two locations: O’Connor and Murton. The firm distributes the desks through regional warehouses located in Auburn, Stirling and Australind. Estimates of the monthly supplies available at each factory and the monthly office desk demands at each of the three warehouses are shown in the following table:-

The desks are shipped to three warehouses.

To ship office desks from a factory to a warehouse involves transportation costs (dollar costs per desk shipped).

All costs are in dollars.

a) Solve this problem using Excel. Write down the numbers desks shipped from each factory to each warehouse and the total cost of shipping involved (i.e. form a worded conclusion). (1.5 marks.)

b) Is this a balanced or unbalanced transportation problem? Show the signs for the demand and supply constraints (0.5 mark).

Question: Question 6: a) Determine the bicycle pathway that will require the minimum amount of construction to connect all the attractive areas of a park. Also show the total distance (arcs are measured in metres). (2 marks)

b) A large department store chain has stores in seven country areas. What route do you recommend for the driver of the delivery truck at the warehouse (represented by node 1) to take to each of the seven suburbs (represented by nodes 2 to 8)? The network of roads is shown in the diagram below (the diagram is not drawn to scale but the number on each road gives the road distances in kilometres between the junctions). Use a relevant process or algorithm to find the shortest route and state the distance. (2 marks)

c) The following network shows a telecommunications network connecting various trunk terminals to relay telephone calls. Equipment automatically routes a particular call over the first clear path found between the trunks connected to the respective telephones. The physical configuration of the system for determining how many calls can be made between any two connected trucks must be set in advance. How well a particular telephone system works can be quantified in terms of the maximum number of calls it can accommodate. Each call routed between two trunks can be treated as a flow. Determine the maximum flow that can be achieved for the network from the source at A to the sink at L by completing Table 1 below. (2 marks)