Problem 11) Davis Construction is going to install cable linesto a housing development

Subject:Computer SciencePrice: Bought3

Share With

Problem 11) Davis Construction is going to install cable linesto a housing development. The goal is to
minimize the total length of cable used. The development is shown to the right,
with each house as a numbered blue circle, and the distances between houses
given in hundreds of feet. How should the houses be connected?Show
work below using Table 9.4 in the chapter as an example.*Start from Node 13*Problem 22.
The number of cars arriving per hour at Lundberg’s Car Wash during the
past 200 hours of operation is observed
and
recorded in the orange table below.
A. Calculate the probabilities in column C, and
calculate the cumulative probabilities in column E. Fill in the lower bound for the probability
ranges in column D, so that Excel can use =VLOOKUP on D3:F7. Hint: Programs 13.2, 13.5, and 13.6 all show
how to create the ranges to use VLOOKUP.
B. Using the random numbers given in B12:B26,
simulate 15 hours of car arrivals and compute the average number of arrivals
per hour.

C.
Have Excel generate random numbers between 0 and 1 in cells H12:H26, and repeat
the simulation.Problem 33.
Kathy’s Custom Cakes has between 0 and 4 new customers per day,
with a probability distribution shown in the orange table. Depending on a
number of factors, Kathy is able to complete between 1 and 4 cakes per day,
with a probability distribution shown in the purple table.
A. Set up the appropriate probability ranges in
C3:D7 and in I3:J6. Use these ranges and
the random numbers provided to run 15 simulations on the number of new
customers per day (D12:D26), and on the possible levels of production
(G12:G26).
B. Start with 0 backorders. Calculate the Total
Waiting column as the number of backorders plus the number of new customers for
the day. Calculate Actual Production by noting that Kathy will produce the
lesser of total waiting customers and her possible production. If actual
production is less than the number of total waiting customers, those become
backorders on the next day.

C. Find the average number of backorders per
day. If Kathy gives a $10 gift card to each customer whose cake becomes
backordered, how much should Kathy budget for gift cards per month (of 30
days)?