Bushnell's Sand and Gravel (BSG) is a small firm that supplies sand, gravel, and topsoil to contractors and landscaping firms. BSG maintains an inventory of high-quality, screened topsoil for supplying the weekly orders for two companies: Bath Landscaping Service and Pittsford Lawn Care, Inc. BSG wants to determine how many cubic yards of screened topsoil to have in inventory at the beginning of each week to satisfy the needs of both its customers. The objective is to establish the lowest possible inventory level that would have a .95 probability of satisfying the combined weekly orders from both customers. The demand distributions for the two customers are as follows:

Simulate 20 weeks of operation for beginning inventories of 70 and of 80 cubic yards. Based on your limited simulation results, how many cubic yards should BSG maintain in inventory? Discuss what you do in a full-scale simulation of this problem.

Transcribed Image Text:

Weekly Relative Demand Frequency Bath Landscaping 10 15 20 25 30 0.20 0.35 0.30 0.10 0.05 Pittsford Lawn Care 30 40 50 60 0.20 0.40 0.30 0.10