how do I made this table in excel getting the same values? .Read from the textbo

Question

how do I made this table in excel getting the same values?

.Read from the textbook the Example 2 1, the assignment is based on this example Have available the Microsoft Excel software program Construct the table in Example 2.1in the Microsoft Excel work sheet The construction of the Microsoft Excel sheets and the answered questions has a total grading value of 10 points .The deadine for hand in this exercise is indicated on "Calendar, which is located in "Tools' in the Blackboard platform Steps 1. Start the Microsoft Excel software program 2. Use the example 2. 1 data to complete the assignment Microsoft Excel work sheet job requires (cubic yard) montly rental 50000 1000 Site A : Site duration Imenths) duration (weeks) OST FACTOR Average hauling distance Montly rental of site 17 100) 5000 to set up and remove equipment1300025000 10 er day asperweek Site A 275,000 1003 3 3 Enter the data in the Microsoft Excel work sheet exactly as above When finished, make sure to elick Submit u, clili Save as Draf to sove changes orid continue working later, or elick Caneel to qut without saving Cancel Save Draft 1219 PM DXLL

Explanation / Answer

Answer: See the table below:

Job Requires (Cubic yard) 50000 monthly rental 1000 Site A Site B job duration (months) 4 4 job duration (weeks) 17 COST FACTOR Average Hauling Distance 6 4.3 monthly rental of site 1000 5000 Cost to setup and remove equipment 15000 25000 Hauling experience 1.15 1.15 Flagperson 0 56 per day/5 days per week Cost Fixed Variable Site A Site B Rent ? =D7*D11 =E7*E11 Setup/Removed ? 15000 25000 Flagperson ? 0 5'00'96 Hauling ? =D10*D3*D13 =E10*D3*D13 Total =SUM(F18:F21) =SUM(G18:G21)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.