Any help is good help. I excluding questions 1-2 on the second image because it's just directions to download the excel file.

A neighbor of mine has a lawn that isn't looking too good. He has decided to remove all the old sod (grass), bring in a new 4 inch layer of topsoil, install new in-ground sprinklers, and reseed the lawn. He seems to think that hell be able to save money by hauling loads of topsoil from the store himself in his pickup truck, rather than paying for delivery, but I don't think he's right. You're going to help us settle this. Here are the essential questions and their answers: How big is the yard? The yard is about 5365 sq ft How much can the pickup carry? The truck bed is 80 inches long, 69 inches wide, and 20 inches tall. How much is the delivery charge? $30 per truckload on top of the soil cost. How much can the delivery truck carry? Each truckload can deliver up to 18 cubic yards. How much does the topsoil cost? $18 per cubic yard (sold in 1/4 yard increments). How far is the soil store? It is 9 miles away. It takes about 20 minutes to drive there. What gas mileage does the pickup truck get? It averages 17 miles to the gallon. What is the current gas cost? It is $3.79/gallon. Use the spreadsheet given to calculate the total costs for both options: 1. Paying for the delivery truck and 2. Picking up the soil yourself. In the textbox below explain and show all of the calculations used to answer the question. In other words, explain how to get the numbers in the pink cells of Excel. Do not use cell references, but numbers. Use the results of your calculations to guide your decision: would you recommend that my neighbor pick up the soil himself, or pay for delivery? 3. Use the file to find the total costs for both options: 1. Paying for the delivery truck and 2. Picking up the soil yourself. 4. Use that information to detail all the calculations that must be done in order to determine which way is better or cheaper. Type your work in the answer box. For each section of the Excel spreadsheet you will fill in the blue shaded cells and all the calculations will be done. Fill it all in and save it to upload. Inches, Feet and Yards - How much soil is needed? # of Square Feet Square Yards Convert Square Feet to Square Yards 0 # of Inches Yards Convert Inches to Yards Total Cubic Yards 0 Total Cost for Soil Volume of Truck Bed Given length, width and height, find the volume in cubic inches Lenth width Height Volume ol 0 Convert to cubic yards of B6 is the total amount of soil that you need, but a truck only holds the value in B11, how many truck loads are needed? If each trip to pick up a load of soil is 9 miles each way, how many total miles will be driven? #DIV/0! #DIV/0! Miles per Gallon/Cost to Pick Up Soil Calculate total cost of gas based on gas mileage and total number of miles Miles Driven Miles/per Gallon Gas price Total Cost #DIV/0! Cost to pick up Soil HDIV/0! Cost to Have Soil Delivered Amount Needed Amount For Each Load Number of Trip Cost 0 $0.00 Cost For Delivery Cost for Soil ! Total Cost for Delivery Then for the write-up, you will explain what is going on in each section of the spreadsheet. a. Explain and show the calculations to get the total soil cost b. Explain and show the calculations to get the total miles driven c. Explain and show the calculations to get the total cost of gas d. Explain and show the total cost to pick up soil calculation e. Explain and show the total cost of delivery calculation f. Explain and show the difference in cost calculation g. Make a conclusion based on that information. Which is cheaper? Which is better? A neighbor of mine has a lawn that isn't looking too good. He has decided to remove all the old sod (grass), bring in a new 4 inch layer of topsoil, install new in-ground sprinklers, and reseed the lawn. He seems to think that hell be able to save money by hauling loads of topsoil from the store himself in his pickup truck, rather than paying for delivery, but I don't think he's right. You're going to help us settle this. Here are the essential questions and their answers: How big is the yard? The yard is about 5365 sq ft How much can the pickup carry? The truck bed is 80 inches long, 69 inches wide, and 20 inches tall. How much is the delivery charge? $30 per truckload on top of the soil cost. How much can the delivery truck carry? Each truckload can deliver up to 18 cubic yards. How much does the topsoil cost? $18 per cubic yard (sold in 1/4 yard increments). How far is the soil store? It is 9 miles away. It takes about 20 minutes to drive there. What gas mileage does the pickup truck get? It averages 17 miles to the gallon. What is the current gas cost? It is $3.79/gallon. Use the spreadsheet given to calculate the total costs for both options: 1. Paying for the delivery truck and 2. Picking up the soil yourself. In the textbox below explain and show all of the calculations used to answer the question. In other words, explain how to get the numbers in the pink cells of Excel. Do not use cell references, but numbers. Use the results of your calculations to guide your decision: would you recommend that my neighbor pick up the soil himself, or pay for delivery? 3. Use the file to find the total costs for both options: 1. Paying for the delivery truck and 2. Picking up the soil yourself. 4. Use that information to detail all the calculations that must be done in order to determine which way is better or cheaper. Type your work in the answer box. For each section of the Excel spreadsheet you will fill in the blue shaded cells and all the calculations will be done. Fill it all in and save it to upload. Inches, Feet and Yards - How much soil is needed? # of Square Feet Square Yards Convert Square Feet to Square Yards 0 # of Inches Yards Convert Inches to Yards Total Cubic Yards 0 Total Cost for Soil Volume of Truck Bed Given length, width and height, find the volume in cubic inches Lenth width Height Volume ol 0 Convert to cubic yards of B6 is the total amount of soil that you need, but a truck only holds the value in B11, how many truck loads are needed? If each trip to pick up a load of soil is 9 miles each way, how many total miles will be driven? #DIV/0! #DIV/0! Miles per Gallon/Cost to Pick Up Soil Calculate total cost of gas based on gas mileage and total number of miles Miles Driven Miles/per Gallon Gas price Total Cost #DIV/0! Cost to pick up Soil HDIV/0! Cost to Have Soil Delivered Amount Needed Amount For Each Load Number of Trip Cost 0 $0.00 Cost For Delivery Cost for Soil ! Total Cost for Delivery Then for the write-up, you will explain what is going on in each section of the spreadsheet. a. Explain and show the calculations to get the total soil cost b. Explain and show the calculations to get the total miles driven c. Explain and show the calculations to get the total cost of gas d. Explain and show the total cost to pick up soil calculation e. Explain and show the total cost of delivery calculation f. Explain and show the difference in cost calculation g. Make a conclusion based on that information. Which is cheaper? Which is better