Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Problem
A new, empty ready mix truck arrives to a batch plant every 2 to 7 minutes (i.e., the time between arrival of trucks is uniformly distributed between 2 and 7 minutes).
The trucks are either 3 mA3 or 6 mA3 in size, and there is an equal chance that the next one to arrive is either 3 mA3 or 6mA3 in size. The large trucks load at the batch plant in 5 minutes, the small ones in 3 minutes. Only one truck can load at the batch plant at a time.
Simulate the arrival of 1000 trucks (the first assigned paper (Banks 1999) provides a similar example for a one bank teller operation).
Determine the average time a truck waits for the batch plant and the % of time that the batch plant is idle. What is the largest number of trucks that simultaneously have to wait for the plant (i.e., what is the longest that the truck line gets to be)?
With the provided information and the functions you just learned, you can build your own spreadsheet or you can use the template.
Attachment:- Spreadsheet simulation.rar
Verified Expert
This assignment discuss for the simulation result using excel solver. As per given case study, the truck arrival and transportation time varies with size and quantity. The case study require to solve percentage of batch plant is idle. Find the largest number of truck waiting for the plant. The solution is provide using excel solver, formula and Microsoft excel.
What is the history of Algebra? Where it began? When it began? Who discovers? Who are the related people in the history of Algebra and what they contribute? Further explain,
Find the Total bulb power in W Total bulb power lost as heat in W Total bulb power lost as heat in joules/second Total bulb power lost as heat in joules Garage air bolume in m^3 garage air mass in kg temperature change in K?
a rectangular beam made using concrete with fc 6000 psi and steel with fy60000 psi has a width b 20 in. the concrete
Draw the bending moment diagram for the beam ABCD subjected to the loading obtained from 2). (The location and magnitude of the maximum bending moment must be calculated)
Air enters the compressor of an ideal gas refrigeration cycle at 12°C and 50 kPa and the turbine at 47°C and 250 kPa. The mass flow rate of air through the cycle is 0.08 kg/s.
Water flowing in a wide channel of depth 35 cm undergoes hydraulic jump that resulted in energy dissipation of 72%. Estimate (a) the downstream depth, (b) the volume flow rate per meter of width.
The composite shaft is made of a steel sleeve, which is bonded to a brass core. The outer diameters of the two parts are d1 = 40 mm for the brass core and d2 = 50 mm for the steel sleeve.
The cylinder has a length of 120 cm and a diameter of 12 cm. The field sample with a porosity of 0.24 is tested under a constant head difference of 160 cm with water at 10 degree Celcius.
Determine the relationship which governs the velocities of the two cylinders A and B. Express all velocities as positive down. How many degrees of freedom are present?
A freeway has a capacity of 4500 veh/hr. A traffic accident occurs at 9AM and the freeway is closed. At 9:15 AM, the freeway is partially opened with capacity of 1500 veh/hr. Freeway is restored to full capacity 4500 veh/hr at 9:30 am.
The coefficients of kinetic friction between the blocks and the inclined plane are a=0.1,b=0.3. Neglect the mass of the link. Angle between the inclined plane and the surface is 30 degree.
A trapezoidal channel having side slopes of 2 horizontal and 1 vertical discharges 14.35 m3/s of water at a velocity of 1.0m/s. The channel lining has a roughness coefficient, n = 0.013. Find the dimensions of the channel for the least expenditure..
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd