Excel homewrok

profilefire99m
ma1.xlsx

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