Your company is interested in bidding a project with a large earthmoving component. An estimated 3 million cubic yards of material is to be loaded with a 992K wheel loader and 777 rigid frame haul trucks. You are responsible for selecting the appropriate equipment spread and estimating the unit cost. The 992K loader has a bucket capacity of 14 cy and the 777 haul trucks have a capacity of 75 cy. The internal rental rates for the 992K and 777 are $300/hr and $191/hr, respectively. You have worked through the Cat Performance Manual and estimated the loader cycle time to be 0.7 mins and the following for the truck cycle: - Haul: 11 mins - Dump: 2.7 mins - Return: 8 mins Overall, the earthmoving fleets work an average of 50 mins per hour. Prepare an analysis based on this information. How many pass loads and trucks will achieve the lowest unit cost?

discuss the results, emphasizing the operation's lowest unit cost and maximum productivity. then leverage Excel for efficient problem computations. show ALL Work & excel work please.