Student Instructions: The general objective of this activity is to developed proficiency in the Microsoft Excel spreadsheet, to calculate some variable costs, fixed costs, and total costs. Also, to determine the best alternative using the minimum cost criteria, and to perform a sensitivity analysis General Requirements: . 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 deadline 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 B E H job requires (cubic yard) montly rental D 50000 1000 Site A 4 Site B 4 17 job duration (months) job duration (weeks) COST FACTOR Average hauling distance Montly rental of site Cost to set up and remove equipment Hauling expense Flagperson 1000 15000 9 10 11 12 13 14 15 5000 25000 1.15 50 1.15 0 per day/5 days per week Fixed Variable Site B Cost Rent Setup/removal Flagperson V V Site A -D5909 15000 25000 -5'E6996 E8'01'111 S01011 16 17 18 19 20 21 22 23 24 25 Total SUMF16:19) SUM(16:19) 4000 15000 0 20000 35000 8160 247250 345000 27 28 29 364000 310410 3. Enter the data in the Microsoft Excel work sheet exactly as above. Notes: . Enter the information exactly as above. . To format columns with numbers: right click the mouse in the cell you which to modify, select format cell, and number. . The equal (=) sign means that you have an equation and it will compute automatically what is indicated in the cell. 4. Write and answer the following questions using the Microsoft Excel spreadsheet. You may copy the questions and write the answer below the table in the Excel sheet. 5. The following are the questions that you should answer. Write the question and the answer under the Excel table that you have constructed. 6. Once you have built the Excel tables, with all the changes in different tables, and answered all the questions you have to send the work (Excel sheets and answered questions) to the professor using the Attach File function in Blackboard to attach your document and send it to the professor. To use the Attach File enter the Course Content in Black Board. Select the Assignment Module 1, attach the file and submit Questions (You only have to write in Excel one of the answers, the one you think is the correct answer to the question) 1. Which is the alternative with the lowest cost in the Microsoft Excel work sheet? To answer this question you should look to cell F21 and cell G 21. Remember they numbers represents costs. a Site A b. Site B c. Both are the same las nuevas funciones 2. If the monthly rent in Site A changes (cell D9) from a $1,000 per month to $3,000 per month, which is the best alternative? a Site A b. Site B c. Both are the same 3. If the monthly rent in Site B changes (cell E9) from a $5,000 per month to $4,000 per month, which is the best alternative? a. Site A b. Site B c. Both are the same 4. If the average hauling distance in Site B changes (cell E8) from 4.3 miles to 6 miles, which is the best alternative? a Site A b. Site B c. Both are the same 3. If the monthly rent in Site B changes (cell E9) from a $5,000 per month to $4,000 per month, which is the best alternative? a. Site A b. Site B c. Both are the same 4. If the average hauling distance in Site B changes (cell E8) from 4.3 miles to 6 miles, which is the best alternative? a Site A b. Site B c. Both are the same 5. If the cost of setup and remove equipment from Site B changes (cell G17) from $25,000 to $35,000, which is the best alternative? a Site A b. Site B c. Both are the same
