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. If the average hauling distance in Site B changes (cell E8) from 4.3 miles to 6 miles, which is the best alternative? a. 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. 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. 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. an initial deposit of 1,969.62 would be required in order to be able to pay 175.00 per month and end up with 8500 in three years. ![]() Questions (You only have to write in Excel one of the answers, the one you think is the correct answer to the question) 1. Select the Assignment Module 1, attach the file and submit. To use the Attach File enter the Course Content in Black Board. 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. Write the question and the answer under the Excel table that you have constructed. The following are the questions that you should answer. You may copy the questions and write the answer below the table in the Excel sheet. Excel is available from Microsoft for 160 per year or 6.99 a month when purchased. Write and answer the following questions using the Microsoft Excel spreadsheet. Microsoft Excel is an affordable and versatile spreadsheet application. The equal () sign means that you have an equation and it will compute automatically what is indicated in the cell. ![]() To format columns with numbers: right click the mouse in the cell you which to modify, select format cell, and number.Enter the information exactly as above.Enter the data in the Microsoft Excel work sheet exactly as above. Microsoft Excel work sheet А в H job requires (cubic yard) montly rental D 50000 1000 Site A Site B 17 6 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 1.15 0 1 4.3 5000 25000 1.15 96 per day/5 days per week Fixed Variable Site A =D5*D9 Cost Rent Setup/removal Flagperson Hauling 15000 Site B =E5*E9 25000 -5☎696 =E8*D1*E11 V =D8*21*011 Total =SUM(F16:F19) =SUM(G16:19) 4000 15000 =0 345000 20000 35000 8160 247250 364000 310410 3. ![]() Use the example 2.1 data to complete the assignment. Start the Microsoft Excel software program.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |