Excel Answers

6. PGA Golf Scores At a recent PGA tournament (the

Honda Classic at Palm Beach Gardens, Florida) the

following scores were posted for eight randomly

selected golfers for two consecutive days. At a 0.05,

is there evidence of a difference in mean scores for the

two days?

Golfer 12345678

Thursday 67 65 68 68 68 70 69 70

Friday 68 70 69 71 72 69 70 70

To be able to meet delivery dates, a project consultant intimates that a project should be analyzed with activities as follows:

Activity

Immediate Predecessor

Expect Duration (weeks)

A. Initial Discussion

None

3

B. Product Design

None

5

C. Market Survey

B

3

D. Market Evaluation

A, C

4

E. Product Costing

D

8

F. Sales Plan

C

2

G. Product Pricing

F

4

H. Prototype

F

2

I. Master Inform

B

5

J. Prototype Testing

H, E, G

3

(i) Draw a network to represent the various activities of the project.

(ii) Draw up a table showing for each activity, the earliest and latest start and finish times and total float/slack.

(iii) Determine the critical path and project duration.

(iv) As a management science student, advise the management about the effect on the project completion time If the start time of activity A is delayed by 3weeks, activity G is delayed by 8 weeks and activity I by 12 weeks, how is the total time for the project affected?

Two plants supply three customers with medical supplies. The unit costs of shipping from the plants to the customers, along with the supplies and demands, are given in Table below.

The company’s goal is to minimize the cost of meeting customers’ demands.

From

To

Customer 1

Customer 2

Customer 3

Supply

Plant 1

55

65

80

35

Plant 2

10

15

25

50

Demand

10

10

10

a) Formulate a linear programming (LP) model for this problem.

b) Use solver to find the optimal transportation rule

c) As a management science student, the MD of the company seeks your expert advice on ways in which to determine the optimal transportation rule. Advise the MD, providing detailed explanation using your answer obtain in (b). Write your answer in a form of a report to the MD.

Drivers using the Accra-Tema motorway have to stop at the tollbooth to pay their tolls. Motorists arrive at the tollbooth at a rate of 200 per 8-hour-day. The single tollbooth attendant can serve, on average, 220 motorists per 8-hour-day.

i) What is the average minutes’ time a motorist waits in the queue to receive service at the toll?

ii) What is the average number of motorists in the queuing system?

iii) Management of the motorway likes to have its operators working 90% of the time. What must the arrival rate be for the tollbooth attendant to be as busy as management would like?

Productivity software (such as Excel or Google Sheets) is used by almost every business. Think in terms of your own field of study and future profession, in what ways could you use productivity software to increase efficiency in your work?

(b) Compute the Expected Value perfect Information (EVPI) and interpret it.

There are six shareholders in a business. The proportion of the total shares that is held by each of the shareholders is indicated in the figure below. In the fifth worksheet of your Excel answer book provided, create the following:

A. B. C.

1share. proportion of shares % of shares

holder

2.stuart. 1/28

3.kenneth. 1/8

4.dominic. 3/14

5.grey. 13/56

6.gregg. 2/7

7.jeff. 3/28

Express each shareholder’s proportion of shares as a percentage in cells C2 to C7. As you have not learned how to format cells in Excel, you must calculate these values yourself, and then enter each result into the relevant cell (use two decimal places). You can see from this question why it is important to sometimes express fractions as percentages – without making this change, you would not have been able to easily determine in some instances which fraction is higher/lower than the others.

https://www.bartleby.com/questions-and-answers/advanced-math-question/0999fc78-4f4c-4ac8-a9d0-690e77a0ef14

2. How would you summarize the performance of the students in the below data in excel? Use at least 5 of the functions from the relevant category of functions you have learnt in excel. 

Ram Age17 Scores85 A

Ravi Age16 Score 64 B

Roy Age15 Score91 A

Shubha Age17 Score 80 A

Reshma Age18 Score0 B 

(10 Marks)

An agriculturist has a 125-acre farm. He produces radish, Carrot and potato. Whatever he raises is fully sold in the market. He get $5 for radish per kg, $4 for carrot per kg and $5 for potato per kg. The average per acre yield is 1500kg of radish, 1800 kg of carrot and 1200 kg of potato. To produce each 100 kg of radish and carrot and 80 kg of potato, a sum of $12.5 has to be used for manure. Labour required for each acre to raise the crop is 6 man-days for radish and potato each and 5 man-days for carrot. A total of 500 man-days of labor at a rate of $40 per man-day are available. Formulate this as a linear programming model and solve by simplex method to maximize the agriculturist’s total profit.

The Unilever Company plans to allocate some or all of its monthly advertising budget of GH¢82,000 in the Mankato area. It can purchase local radio spots at GH¢120 per spot, local TV spots at GH¢600 per spot, and local newspaper advertising at GH¢220 per insertion.

The company's policy requirements specify that the company must spend at least GH¢40,000 on TV and allow monthly newspaper expenditures up to GH¢60,000.