Excel homewrok
B-4
ICA 10-4
| Specific Gravity of Material | (SG) | 1.50 | [--] | ||
| Diameter | (D) | 4.0 | [in] | ||
| Cost of Raw Material | (C) | $2.25 | [$ / lbm] | ||
| Number of Parts | (N) | 150 | [--] | ||
| Radius | (R) | [cm] | |||
| Density of Fluid | (ρ) | [g / cm^3] | |||
| Height (H) [cm] | Volume (V) [cm^3] | Mass (m) [g] | Mass (MN) [lbm] for N parts | Total Material Cost (MC) [$] | |
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 5 | |||||
| 6 | |||||
| 8 | |||||
| 10 | |||||
| 12 | |||||
| Labor Cost | (LC) | $1.50 | [$ / part] | ||
| Total Cost of N Parts | Energy Cost (EC) [$ / part] | ||||
| Height (H) [cm] | Total Material Cost (MC) [$] | $0.05 | $0.10 | $0.20 | $0.40 |
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 5 | |||||
| 6 | |||||
| 8 | |||||
| 10 | |||||
| 12 |
ICA 10-6
| Place the corresponding answer for each part in column B |
| (a) |
| (b) |
| (c) |
| (d) |
| (e) |
Review 10-1
| Potential Energy change from sea level to GSO per kilogram [MJ] | |
| Electricity Price [cents per kWh] | |
| Efficiency [%] | |
Review 10-7
| Skip part (b) |
Review 10-10
| Skip part (d) | ||||
| Upper Limit of Mixed Ice and Salt Crystals | -21 | [°C] | ||
| NaCl [%] | Temp [°C] | Dividing Temp [° C] | Phase | |
| Ice and SW to SW | SW to SW and SC | |||
| 84 | 31 | |||
| -60 | -17 | |||
| 81 | -17 | |||
| 41 | -17 | |||
| 10 | 18 | |||
| 63 | -20 | |||
| 39 | -19 | |||
| 70 | -33 | |||
| 88 | -28 | |||
| 3 | -20 | |||
| 46 | -13 | |||
| 51 | -18 | |||
| 90 | 10 | |||
| 87 | -20 | |||
| 71 | -34 | |||
| 57 | 23 | |||
| 54 | -30 | |||
| 78 | -15 | |||
| 34 | 7 | |||
| 4 | -5 | |||
| 2 | 28 | |||
| 30 | -6 | |||
| 96 | 6 | |||
| 63 | 16 | |||
| 99 | 4 | |||
| 58 | -33 | |||
| 40 | -3 | |||
| 87 | 12 | |||
| 83 | -19 | |||
| 23 | -30 | |||
| 61 | -17 | |||
| 33 | 24 | |||
| 62 | -21 | |||
| 24 | 17 | |||
| 55 | 9 | |||
| 77 | 18 | |||
| 19 | -25 | |||
| 72 | 4 | |||
| 73 | 29 | |||
| 57 | 19 | |||
| 14 | -23 | |||
| 70 | 16 | |||
| 53 | -34 | |||
| 23 | -2 | |||
| 56 | -24 | |||
| 66 | -34 | |||
| 19 | -14 | |||
| 93 | 21 | |||
| 70 | 14 | |||
| 1 | -8 | |||
| 63 | 0 | |||
| 31 | 1 | |||
| 54 | 27 | |||
| 32 | -18 | |||
| 57 | 30 | |||
| 22 | 24 | |||
| 68 | -24 | |||
| 21 | 21 | |||
| 17 | -12 | |||
| 43 | -28 | |||
| 58 | 4 | |||
| 98 | -11 | |||
| 13 | -21 | |||
| 43 | -12 | |||
| 46 | -30 |