Year 1 2 3 4 5 6 7 8 9 10 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Quarterly Sales 12645.60 10298.50 9723.70 12933.00 12549.80 11442.60 10513.50 13838.70 14425.50 13073.80 13173.60 15019.90 15069.80 14283.00 13806.90 16028.70 15605.50 14168.70 14013.00 15552.60 13965.60 11583.90 11144.70 13725.00 13367.20 11211.20 10209.70 11109.00 10897.40 10844.50 13701.60 11158.50 10738.70 14283.00 13859.80 14229.60 19026.70 18918.90 18757.20 19983.60 Demand (000) 26.4 21.5 20.3 27.0 26.2 23.4 21.5 28.3 29.5 26.2 26.4 30.1 30.2 27.0 26.1 30.3 29.5 27.3 27.0 29.4 26.4 21.1 20.3 25.0 24.8 20.8 19.3 21.0 20.6 20.5 26.4 21.5 20.3 27.0 26.2 26.4 35.3 35.1 34.8 36.4 Price/Unit 479.00 479.00 479.00 479.00 479.00 489.00 489.00 489.00 489.00 499.00 499.00 499.00 499.00 529.00 529.00 529.00 529.00 519.00 519.00 529.00 529.00 549.00 549.00 549.00 539.00 539.00 529.00 529.00 529.00 529.00 519.00 519.00 529.00 529.00 529.00 539.00 539.00 539.00 539.00 549.00 Avg Temp 47.3 69.1 85.4 51.3 47.9 69.3 85.6 50.1 46.9 69.9 88.0 51.4 47.2 69.1 85.4 51.3 47.5 69.1 85.4 51.3 48.0 69.1 85.4 52.0 47.3 69.1 85.4 51.7 47.3 69.1 85.4 51.6 47.3 69.1 85.4 52.4 47.9 68.1 87.2 52.5 Employee Number 200115 200123 200129 200135 200141 200147 200153 200164 200169 200175 200181 200193 200199 200205 200211 200217 200116 200136 200154 200170 200176 200182 200188 200200 200206 200212 200117 200156 200171 200183 200189 200194 200201 200207 200219 200114 200120 200124 200128 200130 200134 200140 200142 200143 200146 200148 200149 200152 Department Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Accounting & Admin Support Executive Executive Executive Executive Executive Executive Executive Executive Executive Executive Installation Installation Installation Installation Installation Installation Installation Installation Installation Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing 200159 200163 200168 200174 200180 200186 200192 200198 200204 200210 200216 200218 200222 200112 200113 200118 200119 200126 200127 200132 200133 200138 200139 200144 200145 200150 200151 200157 200158 200161 200162 200166 200167 200172 200173 200178 200179 200184 200185 200187 200190 200191 200196 200197 200202 200203 200208 200209 200214 200215 Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing 200220 200221 200111 200125 200131 200137 200160 200165 200177 200195 200213 Marketing Marketing R and D R and D R and D R and D R and D R and D R and D R and D R and D Job Title Database Administrator Wholesale Buyer Office Admin Support Payroll Clerk Office Admin Support Payroll Clerk Office Admin Support Office Admin Support Office Admin Support Office Admin Support Office Admin Support Office Admin Support Office Admin Support Office Admin Support First Line Supervisor Offic & Admin Payroll Clerk Chief Executive Officer Executive Secretary Office Administrator Chief Financial Analyst Assistant Operations Manager Chief Human Resources Manager Chief Architectural and Engineering Manager Chief Computer and Information System Manager General Operations Manager Chief Marketing Manager Solar Photovoltaic Installer Solar Photovoltaic Installer Solar Photovoltaic Installer First-Line Supervisor, Mechanics & Installers Solar Photovoltaic Installer Solar Photovoltaic Installer Solar Photovoltaic Installer Solar Photovoltaic Installer Solar Photovoltaic Installer Welder & Brazer Machinist Helper--Production Welder & Brazer Machinist Helper--Production Helper--Production Welder & Brazer Machinist Welder & Brazer Machinist Helper--Production Welder & Brazer Machinist Welder & Brazer Machinist Helper--Production Helper--Production Welder & Brazer Machinist Age 24 26 27 37 27 34 29 40 24 35 30 31 27 42 39 29 61 36 40 62 51 59 57 64 51 58 28 34 40 42 34 37 46 39 34 48 45 32 21 19 45 22 26 29 33 20 24 31 Sex F M F F F F F F F F M F M F F F M F F M M F M M M M M M M M M M M M M M M M M M M M M M M M M M Years of Service 1 2 4 4 7 10 5 6 3 5 8 6 6 3 8 5 24 8 13 28 6 15 17 21 20 8 3 9 12 13 6 7 16 9 5 12 15 4 1 1 6 1 4 4 8 2 3 5 Salary 71000 50110 26273 41000 32300 43100 32300 33100 32300 32300 34100 32300 34100 36000 46200 35200 169000 47300 35000 79000 77100 75500 131200 101500 94800 92000 42000 41200 42400 58100 38900 40100 41200 42400 32500 38900 31000 27040 27040 28240 38100 36100 30100 36100 37500 29300 26400 35800 Welder & Brazer Machinist Helper--Production Helper--Production Welder & Brazer Machinist Helper--Production Welder & Brazer Machinist Helper--Production Welder & Brazer Machinist Welder & Brazer Machinist Helper--Production Welder & Brazer Machinist Welder & Brazer Machinist Welder & Brazer Machinist Sales Representative (W & M) Demonstrator and Product Promoter Order Clerk Marketing Manager Sales Representative (W & M) Sales Manager Sales Representative (W & M) Demonstrator and Product Promotor Sales Representative (W & M) Demonstrator and Product Promotor Sales Representative (W & M) Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Sales Representative (W & M) Sales Representative (W & M) Demonstrator and Product Promotor Demonstrator and Product Promotor Order Clerk Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Order Clerk Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Demonstrator and Product Promotor Order Clerk Marketing Manager Office Administrator Sales Representative W & M 29 19 24 61 19 53 26 58 30 29 47 56 51 27 30 37 42 38 32 58 31 51 19 48 32 22 23 26 25 23 51 47 38 21 27 20 22 30 26 29 21 20 21 25 32 29 34 41 29 51 M M M M M M M M M M M M M M F M F M F M M M M M M F F F F M M M F F F F F F F F M F F F M F F M F M 7 1 3 11 1 13 6 14 2 5 12 18 12 2 3 8 9 6 7 10 5 20 1 12 6 1 1 4 3 4 11 14 2 2 5 1 2 5 4 6 2 1 3 2 6 5 6 17 7 6 34600 27040 28240 39100 27040 47200 28240 41500 32400 30100 35000 44100 42600 75780 22300 32000 95230 75390 84500 79300 27200 81000 23400 76100 27200 23400 23400 22800 21000 28000 76100 70400 26300 24200 31400 20100 25900 27300 23900 31400 26800 24100 24100 23000 26000 27000 32400 104800 31000 72400 Order Clerk Sales Representative (W & M) Environmental Engineer Environmental Engineer Environmental Scientist Environmental Engineer Environmental Engineer Environmental Engineer Environmetnal Engineer Environmental Engineer Environmental Engineer 25 43 32 57 41 42 44 49 50 46 45 F M M M M M M M M M M 4 8 6 8 16 7 10 9 7 16 10 26100 69600 72120 89440 73500 79300 80100 84000 80000 83100 79000