MAT540 HELP - Need EXCEL sheet!
frehilAssignment #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:
- 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.
- In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.
- In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service.
- 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.
- 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).
- 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.
- 10 years ago
- 50
Answer(7)
Purchase the answer to view it
NOT RATED
- simulation_study-jet_copier.docx
- simulation_study-jet_copier.xls
Purchase the answer to view it
NOT RATED
- jet_copies.docx
- simulation.xlsx
Purchase the answer to view it
NOT RATED
- jet_case_studies.docx
Purchase the answer to view it
NOT RATED
- mat540_assignment_1_simulation.xls
- mat540_assignment_1.doc
Purchase the answer to view it
NOT RATED
- week_3_assignment_1_-_jet_copies_case_problem.doc
- week_3_assignment_1_-_jet_copies_case_problem.xlsx
Purchase the answer to view it
NOT RATED
- jet_copies.docx
- simulation.xlsx
Purchase the answer to view it
NOT RATED
- mat_540_-_quantitative_methods_-_jet_copies_-_case_study_analysis.docx
Bids(1)
other Questions(10)
- Week 4 CYU
- XBIS 219 Amazon Evolution
- Health
- an issue of common stock last year divident is $1.75. Its growth rate is 5.7%. What is its price if...
- American Foreign Affairs
- Diversity "B"
- ENGLISH 121 ACADEMIC WRITING: CAUSE AND EFFECT ESSAY
- The following are the cash flows of two projects: YearProject AProject B0â$280 â$280 1160 180 2160 180 3160 180 4160 ------
- science/chemistry/biology write up
- statistic (excel program needed) homework help