simulation problem

Project Description:

problem:
you are working in a small shop wrapping christmas presents. every day you get a delivery of boxes to be wrapped, if
you finish early you get a bonus, if you finish late you pay a penalty. the wrapping process, for each box, is as follows:
1. preparation (this includes picking the box to be wrapped, reading instructions, pulling out and cutting wrapping
paper and ribbons, decorations and tape).
2. wrapping (you wrap the box, decorate it, etc.).
3. finishing (label and put away the wrapped box, clean up mess).
from past experience you have determined how long it takes to complete each of the three steps using three probability
distributions.
preparation depends on box size, the complexity of the request (e.g., some may request green paper and red
bows), and your ability to locate the needed items quickly. the time to prepare follows the below discrete
distribution:

time (in minutes) probability
1 .1
2 .2
3 .3
4 .3
5 .1
wrapping depends on box size and the complexity of request. the time to properly wrap a gift box follows the
normal distribution with a mean of 16 minutes and a standard deviation of 2 minutes.
finishing is a fairly standard process and takes between 1 and 3 minutes, it follows the uniform distribution.
1. use excel to simulate wrapping a single gift box. run this simulation at least 20,000 times, i.e., generate 20,000+
possible values for the amount of time it takes to wrap a single gift box. how much time on average does it take? what
is the maximum/minimum time to do so? generate a frequency distribution table that you think describes the single gift
wrapping experience well (include this table in your report). what does it tell you?
2. suppose that each day at 8:00am you receive exactly 25 boxes to wrap, if you finish by 4:30pm (i.e., in 510 minutes or
less) you get a bonus, if you finish after 5:10pm (i.e., you take more than 550 minutes) you have to pay a fee for late
delivery. use excel to simulate wrapping 25 gift boxes. run this simulation at least 5,000 times, i.e., generate 5,000+
possible values for the amount of time it takes to wrap 25 gift boxes. hint: you will need a two dimensional table with
5,000+ rows and 25 columns (one for each gift box to be wrapped). you will need to generate the total single gift
wrapping time in one cell. generate a frequency distribution table that you think describes daily wrapping experience of
the 25 boxes well (include this table in your report). what does it tell you? what is the likelihood that in any particular
day you get a bonus? what is the likelihood that in any particular day you pay a fee? if the bonus is $120 and the late fee
is also $120, how would you feel?

the report must be self‐contained, and have a beginning, middle and an end; it should not be a list of items, or
disjoint answers to questions. do not refer to your excel file in your report, e.g., a statement such as: ”..the
average can be found in the worksheet..” is not acceptable, it should be “..the average is 10.2 weeks..” (write it
as if the reader will not have access to your excel file).
 the report should be one to two pages long (do not exceed 2 pages, but note that tables and graphs do not
count against the page requirement). margins: 0.7. font: 11pts. spacing: single.

follow this by a brief introduction to the problem and then describe what you have learned from your
simulation. make sure to address the questions listed in the problem below, but feel free to add anything else
that you learned or found interesting. how would you improve the simulation (to be more realistic)? consider
that this is a very basic, no frills, scenario: what does this simulation not address? what would you add/include?
what would you change? what more could you learn then?

this is only a 15 point assignmet that needs to be done by friday december 7 2012. my price is $20. it's fairly simple. could have dont it myself, but i dont have time.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 2
1 Current viewersl
13 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.6
    16 Jobs 9 Reviews
    $0 in 0 Day
  • 4.2
    37 Jobs 24 Reviews
    $0 in 0 Day