HW - Excel Review - No Grade.xlsx

HW - Excel Review - No Grade.xlsx - In the table below four...

This preview shows page 1 - 5 out of 70 pages.

City 1 City 2 City 3 Total Plant 1 12 23 17 52 Plant 2 14 15 18 47 Plant 3 24 11 32 67 Plant 4 31 27 14 72 Total 81 76 81 In the table below, four production plants have recorded their shipments made to three different cities. Using name function, find the total number of shipments made by each plant and the total number received by each city.
Image of page 1

Subscribe to view the full document.

Equipment Type Cost For New Age Useful Life Salvage Value Age&Useful Life? boom crane $ 575.50 1 3 $300.00 No chain hoist $ 149.99 5 5 $100.00 Yes electric winch $ 497.50 1 6 $250.00 No fork lift $ 2,499.95 3 7 $2,000.00 #NAME? leveling jack $ 112.50 4 4 $75.00 #NAME? motorized trolloey $ 1,299.95 2 5 $1,000.00 #NAME? The manager of a manufacturing plant is about to place an annual order for new material handlin equipment for the plant. Every year he must determine which equipment to replace and which t keep for another year. The factors involved in this decision include the cost of new equipment, th age of the current equipment, the equipment’s useful life, and the salvage value of the equipmen The table below displays the data for each of these factors. Any piece of equipment that is as old its useful life must be replaced. The manager will also replace any piece of equipment with a net cost (the cost for a new piece of equipment minus the equipment’s salvage value ) under $250. Using logical functions and the conditions mentioned above, complete the final column the table with a “Yes” or a “No” to indicate whether or not the equipment should be replaced. The manager of a manufacturing plant is about to place an annual order for new material handlin equipment for the plant. Every year he must determine which equipment to replace and which t keep for another year. The factors involved in this decision include the cost of new equipment, th age of the current equipment, the equipment’s useful life, and the salvage value of the equipmen The table below displays the data for each of these factors. Any piece of equipment that is as old its useful life must be replaced. The manager will also replace any piece of equipment with a net cost (the cost for a new piece of equipment minus the equipment’s salvage value ) under $250. Using logical functions and the conditions mentioned above, complete the final column the table with a “Yes” or a “No” to indicate whether or not the equipment should be replaced.
Image of page 2
Net Cost <250? Replace? No No #NAME? Yes Yes Yes #NAME? No #NAME? Yes #NAME? No to he d as t n of ng to he nt. d as t n of
Image of page 3

Subscribe to view the full document.

Flight No. Airplane Start City Destination Departure Time Travel Time 563 Boeing 737 Orlando Los Angeles 12:15 7:15 231 Boeing 747 Chicago Dallas 17:25 5:20 456 Boeing 737 New York Las Vegas 14:00 8:40 765 MD 180 San Jose Seattle 6:35 1:50 345 MD 200 Chicago Sacramento 9:50 3:45 893 Boeing 737 New York Detroit 11:25 2:00 569 Boeing 737 Tampa Chicago 13:30 5:05 Flight No. Airplane Start City Destination Departure Time Travel Time 563 Boeing 727 Orlando Los Angeles 12:15 7:15 231 Boeing 747 Chicago Dallas 17:25 5:20 456 Boeing 737 New York Las Vegas 14:00 8:40 765 MD 180 San Jose Seattle 6:35 1:50 345 MD 200 Chicago Sacramento 9:50 3:45 893 Boeing 737 New York Detroit 11:25 2:00 569 Boeing 737 Tampa Chicago 13:30 5:05
Image of page 4
Image of page 5
  • Fall '17
  • 175

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern