Question and Spreadsheets Homework Assignment
RSM 470H1F Management Science Modeling with
Spreadsheets
Homework Assignment 4, part (b)
Given: November 27th, 2014
Due: December 2nd, 2014
PLEASE HAND IN YOUR ASSIGNMENT IN CLASS (Dec 2nd).
This is the second part of assignment 4.
Solve the following problem from the book:
9.39
You are asked to do Problem 12.6 and the problem below for yourself - no need to submit and not as part of Assignment 4. (The correct solutions of Assignment 4 from the instructor will include answers to these problems.)
Problem Seventy-five percent of calls arriving at a help line can be handled by the person who answers the phone, but the remaining 25% of them will need to be referred to someone else. Assume that every call requires one minute of attention by the person who answers the phone (either to answer the question or to figure out how the referral should be handled).
Calls that are referred need an additional amount of time, as given in the table below.
Time Required Probability
3mins
0.25
5mins
0.35
10mins
0.40
Callers are served on a first come, first served basis, and are put on hold until the line is free. Use the random numbers to simulate what happens to 10 callers. What percentage of your callers needs to be referred? Of those who had to be referred, what is the average referral time?
.82 .39 .16 .79 .56 .62 .13 .04 .42 .81
.85 .32 .64 .90 .73 .02 .76 .03 .86 .67
Spreadsheets
Homework Assignment 4, part (b)
Given: November 27th, 2014
Due: December 2nd, 2014
PLEASE HAND IN YOUR ASSIGNMENT IN CLASS (Dec 2nd).
This is the second part of assignment 4.
Solve the following problem from the book:
9.39
You are asked to do Problem 12.6 and the problem below for yourself - no need to submit and not as part of Assignment 4. (The correct solutions of Assignment 4 from the instructor will include answers to these problems.)
Problem Seventy-five percent of calls arriving at a help line can be handled by the person who answers the phone, but the remaining 25% of them will need to be referred to someone else. Assume that every call requires one minute of attention by the person who answers the phone (either to answer the question or to figure out how the referral should be handled).
Calls that are referred need an additional amount of time, as given in the table below.
Time Required Probability
3mins
0.25
5mins
0.35
10mins
0.40
Callers are served on a first come, first served basis, and are put on hold until the line is free. Use the random numbers to simulate what happens to 10 callers. What percentage of your callers needs to be referred? Of those who had to be referred, what is the average referral time?
.82 .39 .16 .79 .56 .62 .13 .04 .42 .81
.85 .32 .64 .90 .73 .02 .76 .03 .86 .67