Please use the Excel Solver tool to get an answer report! Please show excel sheet and steps! Thank you so much!

A contractor is planning a job that will require a large amount of gravel and sand. The estimates for the necessary gravel and sand are: There are two pits from which material can be obtained, and the plan is to haul from these two pits and separate (screen) on the job whatever material is needed. Analysis shows that the material at each pit has the following composition: It costs $8/yd3 for material and hauling from pit A and $16/yd3 from pit B. Define decision variables and set this up as a linear programming problem to minimize cost