- Create a Monte Carlo simulation model in Excel to address the following challenge: - A Ford dealer believes that demand for the 2022 Lariat F150 Pickups will be normally distributed with a mean of 200 and standard deviation of 30 . His cost of receiving an F150 is $45,000, and he sells the Lariat F150 for the full MSRP price of $55,000. Half of all the Lariat F150s not sold at full price can be sold wholesale for $48,000. He is considering ordering 200, 220, 240, 260, 280, or 3002022 Lariat F150s. - How many 2022 Lariat F150s should he order? Provide the number and explain your rationale for the decision. - Given current manufacturing and supply chain problems, he is concerned about actually receiving the ordered number of units. How could you modify the model to account for the probability of actually getting the ordered number of units? What is the PDF appropriate for this variability? Modify the model and rerun with the same six unit orders noted above. Does your answer change? Why? - To compensate for not receiving his whole order, the dealer has decided to raise the price of the units above MSRP. This will help cover his costs, but may result in reduced sales due to customer dissatisfaction. How would you change the model to address this scenario? For this question, note your answer in the workbook. It is not necessary to modify or rerun the model