A grocery store sells fresh produce, and its daily demand fo…
A grocery store sells fresh produce, and its daily demand follows a Poisson distribution with a mean of 40 units per day. The ordering lead time follows a triangular distribution with a minimum of 1 day, most likely of 2 days and a maximum of 4 days, meaning that lead times are uncertain. Reminder: lead time is the time between ordering and order arrival. The store follows an inventory policy where it reorders 200 units when inventory drops below 100 units. Simulate the inventory system over a 60-day period to estimate the probability of a stockout (having zero inventory before a replenishment arrives). You need to create a template yourself for this problem. Rename it under your name before submitting it.
Read DetailsQuestion F10 – Use Excel File F10 for your answer. A typical…
Question F10 – Use Excel File F10 for your answer. A typical electric car dealer places new orders with the manufacturer in September. Jake’s car dealer is trying to determine how many model 2024 cars to order. Each car ordered in September costs $45,000. The demand for the new electric cars has the following probability distribution. Each car sells for $54,000. If the demand for 2024 cars exceeds the number of cars ordered in September, Jake must reorder at a cost of $50,000 per car. Excess electric cars can be salvaged at $39,000 per car. Cars demand Probability 25 0.25 30 0.20 35 0.15 40 0.20 45 0.20 Assume Jake orders 60 cars in September. What is Jake’s average profit? Please build a simulation model to answer this question. Please complete and upload this partial template: F_2023_Excel F10.xlsx
Read DetailsQuestion F6 Johns Hopkins University has three parking lots…
Question F6 Johns Hopkins University has three parking lots on its Homewood campus, LOT A, LOT B, and LOT C. The following table shows each lot’s capacity and the number of parking pass holders. Lot Capacity Total number of faculty and staff parking pass holders LOT A 250 310 LOT B 300 345 LOT C 350 400 The number of people showing up in each lot is independent of the others. On a typical day, the probability of a LOT A parking permit holder showing up is 85%, a LOT B parking permit holder showing up is 87%, and a LOT C parking permit holder showing up is 89%. Using what kind of distribution (with what parameter values) can you model the number of parking permit holders showing up in LOT A?
Read DetailsA manufacturing company produces a specialized component tha…
A manufacturing company produces a specialized component that has a defect rate of 3% per unit. However, before the defective unit reaches the customer, it passes through three independent quality control (QC) checkpoints: Checkpoint 1 detects 75% of defects. Checkpoint 2 detects 70% of the defects that remain after Checkpoint 1. Checkpoint 3 detects 50% of the defects that remain after Checkpoint 2. If a customer receives a component, what is the probability that it is defective? Model the system using simulation. You need to create a template yourself for this problem. Rename it under your name before submitting it.
Read Details