Assignment #1: JET Copies Case Problem - Homework Help, Online by 5xa5sH4i

VIEWS: 0 PAGES: 2

									                  Assignment #1: JET Copies Case Problem

Read the “JET Copies” Case Problem on pages 678-679 of the text. Using simulation
estimate the loss of revenue due to copier breakdown for one year, as follows:

   1.   In Excel, use a suitable method for generating the number of days needed to repair the copier,
        when it is out of service, according to the discrete distribution shown.
   2.   In Excel, use a suitable method for simulating the interval between successive breakdowns,
        according to the continuous distribution shown.
   3.   In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of
        service.
   4.   Put all of this together to simulate the lost revenue due to copier breakdowns over 1 year to answer
        the question asked in the case study.
   5.   In a word processing program, write a brief description/explanation of how you implemented each
        component of the model. Write 1-2 paragraphs for each component of the model (days-to-repair;
        interval between breakdowns; lost revenue; putting it together).
   6.   Answer the question posed in the case study. How confident are you that this answer is a good
        one? What are the limits of the study? Write at least one paragraph.

There are two deliverables for this Case Problem, the Excel spreadsheet and the
written description/explanation. Please submit both of them electronically via the
dropbox.



        The assignment will be graded using the associated rubric.

                               ·                          Create statistical analysis of
Outcome
                               simulation results.
Assessed:
                        ·       Communicate issues in management science
                 Grading Rubric for JET Copies Case Problem
   There are 12 possible points in each of the five criteria for a total of 60 points
                                      possible.
   Criteria            0                   1                  2                  3
                Unacceptable         Developing         Competent           Exemplary
                  (0 points)         (6 points)          (9 points)         (12 points)
 1. Model       Did not submit This                   Used a method Used an
 number of      or did not         component was that is                  appropriate
 days to        model this         modeled, but       recognizably        method and
 repair         component in       the method         appropriate,        correctly
                an appropriate     and/or             but the             implemented
                manner             implementation implementation it
                                   had mistakes       had minor
                                   that affected      mistakes
                                   the validity of
                                   the model
 2. Model       Did not submit This                   Used a method Used an
 number of      or did not         component was that is                  appropriate
 weeks          model this         modeled, but       recognizably        method and
 between        component in       the method         appropriate,        correctly
 breakdowns     an appropriate     and/or             but the             implemented
                manner             implementation implementation it
                                   had mistakes       had minor
 Criteria            0                    1                 2                   3
                Unacceptable        Developing         Competent           Exemplary
                 (0 points)         (6 points)          (9 points)         (12 points)
                                  that affected       mistakes
                                  the validity of
                                  the model
3. Model lost   Did not submit    This                Used a method       Used an
revenue due     or did not        component was       that is             appropriate
to              model this        modeled, but        recognizably        method and
breakdowns      component in      the method          appropriate,        correctly
                an appropriate    and/or              but the             implemented
                manner            implementation      implementation      it
                                  had mistakes        had minor
                                  that affected       mistakes
                                  the validity of
                                  the model
4. Provide      Did not submit    Provided            Provided            Provided fully
written         or described      partially           sufficiently        developed
description     insufficiently.   developed           developed           written
and             Omitted key       written             written             description
explanation     points.           description that    description that    that is correct
of the                            matches the         matches the         and matches
simulation                        method 70 –         method 80 –         the method
                                  79% accuracy.       89% accuracy.       used with 90
                                                                          – 100%
                                                                          accuracy.
5. Combine      Did not submit    Provided            Provided            Provided fully
model           or result not     partially correct   sufficiently        correct
components      provided,         result. Omitted     correct result.     result.
to produce a    and/or            discussion of       Identified          Identified
coherent        discussed         confidence.         confidence and      confidence
answer to       insufficiently.   Discussed           discussed           and discussed
the question                      limitations         limitations         limitations
posed in the                      partially with      sufficiently with   fully with 90 –
case study.                       70 – 79%            80 – 89%            100%
(a) Answer                        accuracy, logic,    accuracy,           accuracy,
the question                      and clarity.        accuracy, logic,    logic, and
posed in the                                          and clarity.        clarity.
case study.
(b) How
confident are
you that this
answer is a
good one?
(c) What are
the limits of
the study?

								
To top