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.
Planning and designing, space and ambience to reflect functional, technical, and social, and environmental considerations are part of?
What is the equation to get the table if used excel formulated , in construction methods each Columbus station end-area cut end-area fill volume of cut volume of fill stripping cut stripping fill total cut total fill adj-fill algebraic sum mass ordin..
1. you are working for urs on a building project in dearborn michigan. you are responsible for the design of the
The mass of the piston requires 300 kPa pressure to move it against the outside ambient pressure. Determine the final pressure in the cylinder, the heat transfer, and the work for the overall process.
Determine rqd impeller diameter, Qactual, h_p-actual, E, BHP required for...., NPSH_R, max elevation at which the pump can be installed.
A water main springs a leak and the geyser is estimated to be 20 feet in height. It is also estimated that about 300 gallons per minute is leaking based on flow into gutter. About how big is the hole in the water pipe
As shown in the figure, in a normal township the exterior dimensions of Sec. 6 on the west, north, east, and south sides are 80, 78, 81, and 79ch, respectively. Explain with a sketch how to divide the section into quarter sections. (See the follow..
A 3000-lb car is traveling on a paved road with Cd (coefficient of drag) = 0.35, Af (frontal area of the vehicle) = 21ft^2, and p(air density)=0.002378 slugs/ft^3. Its engine is running at 3000rpm and is producing 250ft-lb of torque.
A fluid in an aquifer is 23.6m above a reference datum; the fluid pressure is 4390 N/m2. The fluid density is 0.999E3 kg/m3. What is the total energy per unit mass What is the total energy per unit weight
Office workers complain that the noise level in their office Area 1 is greater than that in the company's other office Area 2. Six measurements are made on different days in each area, with the following results
A closed cylindrical tank filled with water has a hemispherical dome and is connected to an inverted piping system. The liquid in the top part of the piping system has a specific gravity of 0.68.
By itself, the 2500-kg pickup truck executes a 0-100 km/h acceleration run in 10 s along a level road. What would be the corresponding time when pulling the 500-kg trailer? Assume constant acceleration and neglect all retarding forces.
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