Case 41 Blending Aviation Gasoline at Jansen Gas page 214 For the project you will

Case 41 Blending Aviation Gasoline at Jansen Gas page 214 For the project you will

Case 4.1 Blending Aviation Gasoline at Jansen Gas, page 214 For the project, you will write a proposal for the case study and submit the final product. The final product will be an Excel spreadsheet used to create the model and either a Word document or a Power Point presentation.  The final project will be graded not only on the accuracy of the quantitative solutions, but also the analytical approach used and the presentation of the results.  Keep in mind that this course is designed for individuals interested in Business Management.  As such, the final presentation should be appropriate for a presentation in a professional setting.  It will be necessary to clearly explain the case study and present the results in a professional, yet easily understood manner. To guide you with the preparation of the your final project (case study) presentation there is a guideline document that will provide further detail relative organization, content, and information flow for your presentation.  Please select the following link (case study) to access this important information.  Be sure to use this information as your guide when writing your presentation. You have to submit your spreadsheet model for your case study on 10.04.2022.  It doesn’t need to include sensitivity analysis but your final report in the next module should.  (Please Note: Use the feedback on this spreadsheet to revise it and then add this spreadsheet file to the full report you submit in the next module.)QMMCaseStudyPresentationContent2.docxPracticalManagementScience.pdfCommentsofProfessor-DalginQMMM6CaseStudySpreadsheet-Seyfullah.Dalgin65.xlsxStudentnumber-2CaseStudy4.2.pptxStudentnumber2-CaseStudyProject_Ward-2.xlsxStudentNumber-1-4.1BlendingAviationGasolineatJansenGas.xlsxStudentnumber1-4.1BlendingAviationgas.Finalproject.pptxStudentnumber1Discussionpost-4.1BlendingAviationgas.Finalproject.docxStudentnumber2-Discussionpost-CaseStudy4.2.docx

5-Perform a sensitivity analysis on the probability of a great market To do this enter

5-Perform a sensitivity analysis on the probability of a great market To do this enter

5-Perform a sensitivity analysis on the probability of a great market. To do this, enter formulas in cells B9 and B10 (see Figure 9.4) to ensure that the probabili- ties of fair and awful remain in the same ratio, 35 to 20, and that all three probabilities continue to sum to Then let the probability of great vary from 0.25 to 0.50 in increments of 0.05. Is it ever best to abandon the product in this range? 39-Yearly automobile inspections are required for resi- dents of the state of Pennsylvania. Suppose that 12% of all inspected cars in Pennsylvania have problems that need to be corrected. Unfortunately, Pennsylvania state inspections fail to detect these problems 20% of the time. On the other hand, assume that an inspection never detects a problem when there is no problem. Consider a car that is inspected and is found to be free of problems. What is the probability that there is indeed something wrong that the inspection has failed to uncover? Problem 5 Page 471 Problem 39 Page 502 PracticalManagementScience.pdfNewModule6ProblemWorkbook.xlsxCommentsofProfessor-DalginQMMM6CaseStudySpreadsheet-Seyfullah.Dalgin65.xlsxCommentsofProfessor-DalginQMMM6CaseStudySpreadsheet-Seyfullah.Dalgin65.xlsx