******REPORTINSTRUCTIONS this is what is expected from you!!********
Precision Auto Clone has hiredyou as an operations management consultant to analyze the issues outlined inthe case and make the required forecasts and recommended the proper courses ofaction. You will submit a consultantsreport to Warren presenting your findings. Do not include the computerprintouts in your report other than those explicitly specified in the ReportInstructions. Instead, explain in words the meaning of the computer printouts(interpret the results). Since Warrenhas not taken this class, you must explain what the results mean to his companyusing minimal technical jargon. Your report must be clear, grammaticallycorrect, typed (single-spaced) and be nomore than 8 pages in length. No title page please. Begin each section with a sentence thatwill capture Warrens attention and entice him to read the rest of thediscussion in that section.
Yourreport should be organized as follows:
Provide some introductory comments about the utilityof the decision support techniques employed in the case. Summarize the purposes of the consultantsreport and thank Warren for the consulting engagement.
II. Car Show AttendanceForecast
State your forecasted car show attendance and bound itwith a 95% confidence interval. Define and discuss Regression and CorrelationAnalysis so Warren has a conceptual understanding of it. Present the actual regressionequation and demonstrate how it can be used to derive the attendance forecastfor the Orlando and other future car shows.
III. Tool Crib Staffing
State the optimal tool crib staffing and expected costper hour. Briefly explain Queuing Theory to Warren so he has a conceptualunderstanding of it. Warren initial expectationwas that he only needs 2 servers because 2*15 (service rate) = 30 served perhour which exceeds the average arrival rate of 25. Why is his initialexpectation incorrect? Copy the Tool Crib Cost Analysis chart and paste it intoyour report. Discuss any pertinent information from the spread sheet concerningthe optimal result.
IV. Production Schedule
State the optimal production schedule and the profitgenerated. Briefly describe Linear Programming to Warren so he has a conceptualunderstanding of it. Are all the laborresources used up? Overtime cost in theFabrication and Assembly work centers is 150% of regular labor cost. What is the net economic benefit of overtimein each work center and what are the limits?
V. Material Requirements Planning
State the timing and quantities of the recommendedwork order releases and purchase order releases to Warren. Describe and discussMRP.
VI. Stainless Steel Inventory Lot Sizing
Describe the assumptions of the Economic OrderQuantity Model and explain why the quantity discount should or should not betaken. Copy the Inventory Lot Sizing Analysis chart and paste it into yourreport. State the optimal inventory strategy and the associated minimum annualinventory cost.
VII. Car Show Key Chain Purchase
State theoptimal plan to buy key chains from China along with the estimated averagetotal cost of this strategy. Describethe Single Period Inventory with Uncertain Demand model to Warren. Briefly explain Simulation to Warren so heconceptually understand it. Copy the Simulation chart and paste it into yourreport. Discuss how the plot illustrates the Law of Large Numbers.
VIII. New Facility Project Management
Briefly describe Project Management so Warren has aconceptual understanding of it. Explainthe project critical path concept and indicate the duration of the projectwithout expediting. Identify the taskson the critical path and discuss their importance. Given the available budget,identify the tasks that should be expedited and indicate the final projectduration with expediting.
Provide some closing remarks concerning the power ofthe decision support tools utilized in your report.
again please do not change excel numbers use it just to analyze and write I will updat mrp excel tab so you can do that at the end
Grading Criteria for Written Case Study
1. Describe and discuss the decision analytics toolsused. (Weight 30%)
2. Technical analysis andaccuracy of the resluts. (Weight 30%)
3.Clarity and user friendliness of the explanation of the technical results. (Weight40%)
What Students Are Saying About Us.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."