1. Engineering has collected data on alternative process costs for building transmissions in the worksheet Transmission costs. Can you determine whether one of the proposed processes is better than the current process?
Unit Tractor Transmission Costs | ||
Current | Process A | Process B |
$242.00 | $242.00 | $292.00 |
$176.00 | $275.00 | $321.00 |
$286.00 | $199.00 | $314.00 |
$269.00 | $219.00 | $242.00 |
$327.00 | $273.00 | $278.00 |
$264.00 | $265.00 | $300.00 |
$296.00 | $435.00 | $301.00 |
$333.00 | $285.00 | $286.00 |
$242.00 | $384.00 | $315.00 |
$288.00 | $387.00 | $300.00 |
$314.00 | $299.00 | $304.00 |
$302.00 | $145.00 | $300.00 |
$335.00 | $266.00 | $351.00 |
$242.00 | $216.00 | $277.00 |
$281.00 | $331.00 | $284.00 |
$289.00 | $247.00 | $276.00 |
$259.00 | $280.00 | $312.00 |
$322.00 | $267.00 | $273.00 |
$209.00 | $210.00 | $281.00 |
$282.00 | $391.00 | $303.00 |
$304.00 | $297.00 | $306.00 |
$391.00 | $346.00 | $312.00 |
$236.00 | $230.00 | $287.00 |
$383.00 | $332.00 | $306.00 |
$299.00 | $301.00 | $312.00 |
$300.00 | $277.00 | $295.00 |
$278.00 | $336.00 | $288.00 |
$303.00 | $217.00 | $313.00 |
$315.00 | $274.00 | $286.00 |
$321.00 | $339.00 | $338.00 |
IN order to know which process is better
We have to average the cost of each process of all the situations
Current Process $289.6
Process A $285.5
Process B $298.43
Therefore Process A should be preferred over the current Process
1. Engineering has collected data on alternative process costs for building transmissions in the worksheet Transmission...