Directions:
- Click on “Lab:Measurements (Part 2)” above to view the essential questions and answers needed to solve this problem. The information can be found in Question 1.
- Download the following Excel File: Unit4LabPartII. Edit the excel file by changing just the blue cells.
- Use the file to find the total costs for both options: 1. Paying for the delivery truck and 2. Picking up the soil yourself.
- 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.
Then for the write-up, you will explain what is going on in each section of the spreadsheet.
- Explain and show the difference in cost calculation
- Make a conclusion based on that information. Which is cheaper? Which is better?
- Upload your edited spreadsheet with your last name added to the file name e.g. Unit4LabPartIIGriffin.xls
75 points possible.
Due Mon 10/11/21, 11:59 pm
.Directions:
- Question 1 will have the essential information for the lab. You will submit your spreadsheet in Question 2.
- Download the following Excel File: Unit4LabPartII. Edit the excel file by changing just the blue cells.
- Use the file to find the total costs for both options: 1. Paying for the delivery truck and 2. Picking up the soil yourself.
- 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.Then for the write-up, you will explain what is going on in each section of the spreadsheet.
- Explain and show the difference in cost calculation
- Make a conclusion based on that information. Which is cheaper? Which is better?
- Upload your edited spreadsheet with your last name added to the file name e.g. Unit4LabPartIIGriffin.xls
- 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 he’ll 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?
0 comments