Question: Please, I want to solve this question in excel. Please, please for example Question 1: A taxicab company operates one vehicle during the 09:00 A.M.

Please, I want to solve this question in excel. Please, please

Please, I want to solve this question in excel.

for example

Please, I want to solve this question in excel.Please, I want to solve this question in excel.

Question 1: A taxicab company operates one vehicle during the 09:00 A.M. to 05:00 P.M. period. The demand for taxi follows the distribution shown: 15 24 37 39 45 Time between Calls (Minutes) Probability 0.14 0.23 0.17 0.42 0.04 The distribution of time to complete a service is as follows: 40 42 45 50 Service Time (Minute) 15 Probability 0.42 0.35 0.13 0.06 0.04 Using EXCEL simulate for 60 customers, Calculate waiting times of the customers. Problem There are two car hops : Able and Baker. Able works a bit faster than Baker. Tine 2 2 Pay 0.40 DEO Perform the simulation for six callers and construct the simulation table for the same. Distribution of their service time is shown below. 44 Problem For Able 2 3 4 5 Service Time 0.30 0.28 0.25 0.17 For Baker! 3 4 5 6 Service Time 020 Random digits for arrival are: 0.20 26, 98, 90, 26, 42 Random digits for service are: 95, 21, 51, 92, 89, 38 45 Step 1: Calculating Inter Arrival time and service time Calculate Arrival time distribution and Assign Random number Time between Probability Cumulative Random Digit arrivals (Minutes) Probability Assignment 1 0.25 0.25 01-25 2 0.40 0.65 26-65 3 0.20 0.85 66-85 4 0.15 1.00 86-00 Calculate Service Distribution and Assign Random number: For Able: Service Time Probability 2 3 4 5 0.30 10.28 0.25 0.17 Cumulative Probability 0.30 0.58 0.83 1.00 Random Digit Assignment 01-30 31-58 59 83 9400 For Baker: Service Time Probability 3 Cumulative Probability 0.35 0.60 0.00 1.00 0.35 0.25 0.20 0.20 Random Digit Assignment 01-35 36-60 61-80 81-00 4 5 16 6 47 Inter Arrival time distribution: Customer Random Digit inter arrival Ansignment Time 1 2 2 26 2 2 3 3 98 4 4 90 4 5 5 26 2 6 42 Construction of Sirhutation Table: Calle Inter Arni ABLE BAKER Calle Time No Arrival TSS Servi TSE TSB Servi TSE in Time CO ce Dels Syst Time Time Time y em 1 0 0 5 5 0 S 2 2 2 3 50 3 4 6 3 9 0 4 4 10 5 15 LO 5 2 12 12 18 0 6 6 2 14 15 3 318 1 4 2 5 6 D 3 10 D 5 48 2.2 Simulation of Inventory Systems (1) This inventory system has a periodic review of length N, at which time the inventory level is checked. An order is made to bring the inventory up to the level M In this inventory system the lead time i e, the length of time between the placement and receipt of an order) is zero. Demand is shown as being uniform

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!