Question and Spreadsheets Homework Assignment

Satisfactory Essays
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

You May Also Find These Documents Helpful

  • Good Essays

    Learner’s Comments ( What went well, What could you improve) Assessor’s name: Assessor’s signature: Date: Learner’s Declaration: I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person. Signed: ................................................…

    • 2830 Words
    • 14 Pages
    Good Essays
  • Better Essays

    Spreadsheets

    • 1059 Words
    • 5 Pages

    International Business – Coaching – Spreadsheet and Databases International Business offers a versatile selection of professions after graduation. As a result, I chose to focus on business leadership coaching, just like at the beginning of this semester. As an important note my parents own a coaching company, BoMentis, and my dream is to either take over it one day or at least work with them. Based on my research and personal experience, coaching has spread increasingly all throughout the world…

    • 1059 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Spreadsheet and Function

    • 851 Words
    • 4 Pages

    Spreadsheet Exercises Using Excel Learning Objective: These exercises are designed to familiarize you with a spreadsheet application software called MS Excel. After the completion of the lab, you should be able to: 1. work with MS Excel or other spreadsheet programs 2. use functions and formulas in a spreadsheet application software for calculation 3. explain what functions and formulas are, how they work, and the difference between them Formulas Well, a formula is a simple calculation…

    • 851 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Assignment Homework

    • 1073 Words
    • 5 Pages

    Name: Homework (50 points) Using the student schema from week 2, provide answers to the following questions. Question SQL statement or Answer 1. Generate statistics for the student, enrollment, grade, and zipcode tables (15 pts) SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('D02246617', 'STUDENT'); SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('D02246617', 'ENROLLMENT'); SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('D02246617', 'GRADE'); SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('D02246617', 'ZIPCODE');…

    • 1073 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    History of Spreadsheet

    • 918 Words
    • 4 Pages

    A Brief History of Spreadsheets by D. J. Power Editor, DSSResources.COM Spreadsheets have been used by accountants for hundreds of years. Computerized or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspaper and magazine stories celebrate Dan Bricklin as the "father" of the electronic spreadsheet. In 1978, Harvard Business School student, Daniel Bricklin, came up with the idea for an interactive visible calculator (see email from…

    • 918 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Homework questions

    • 457 Words
    • 2 Pages

    Chapter 1 #18 a. The services provided by Consumers Union are very similar to assurance services provided by CPA firms. The services provided by Consumers Union and assurance services provided by CPA firms are designed to improve the quality of information for decision makers. CPAs are valued for their independence, and the reports provided by Consumers Union are valued because Consumers Union is independent of the products tested. 1-18 (continued) b. The concepts of information risk for…

    • 457 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Homework Assignment

    • 997 Words
    • 4 Pages

    Homework Week 1 1) Define the steps in the risk management process. There are 5 steps involved in risk management. 1) risk identification, 2) risk analysis, 3) risk control, 4) treatment, and 5) risk financing. Risk identification is the identification of the cause or causes of an accidental loss. Risk analysis is the examination of risk management techniques or methods in order to prevent future accidental losses. Risk contril is developing the besy risk manaegemtn techniques and methods…

    • 997 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Homework Assignment

    • 314 Words
    • 2 Pages

    Tashley Stockham ASSIGNMENT for Week 2 3. According to this appeals court, what errors were made by the judge at trial? The judge erred in “refusing to allow the defendants to introduce evidence that no other employees were treated abusively…and in denying defendants’ requested jury charge on mitigation.” (McAdams 173) McAdams, T. Law, Business and Society, 10th Edition. McGraw-Hill Learning Solutions, 40848. . 7. Would the police violate a suspect’s Fourth Amendment rights against unlawful…

    • 314 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Running head: MODULE 4 HOMEWORK ASSIGNMENT MODULE 4 HOMEWORK ASSIGNMENT King of the South Allied American University Author Note This paper was prepared for MKT 120, MODULE 4 HOMEWORK ASSIGNMENT taught by PROFESSOR K December 1st, PART I: Read Pay What It’s Worth. Would this concept work in an upscale restaurant? Why or why not? I must admit that upon reading the article, “The Customer Experience: Pay What It’s Worth,” my jaw dropped to the floor. I read…

    • 1502 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Homework Assignment

    • 155 Words
    • 1 Page

    Activity One 1. Get into groups of 4. 2. Your teacher will give each group a picture. 3. Describe the picture. Write a profile of the person as follows: Example: He is a policeman. He has coke and pizza for lunch. He likes swimming. He doesn’t like cycling. He’s tall and plump. He’s got a beard. He’s wearing blue jeans and a yellow T-shirt. He’s sitting down eating chips. 4. You have 15 minutes to discuss and write down the descriptions of this person in the table below. 5. Then re-invent…

    • 155 Words
    • 1 Page
    Satisfactory Essays