Question: Problem 2 The output of a process is valued at $117 per unit. The cost of labor is $25 per hour. Compute material cost per
| Problem 2 | ||||||||
| The output of a process is valued at $117 per unit. The cost of labor is $25 per hour. | ||||||||
| Compute material cost per week, labor cost per week and then compute both labor productivity (in units/hr) | ||||||||
| and total productivity ( in $/$) each week. | ||||||||
| Draw two graphs. The first will show total productivity on the Y axis and week on the x axis. | ||||||||
| The second will similarly show labor productivity (units/hr) on the Y and weeks on the x. | ||||||||
| In the yellow box, briefly comment on any insights from the graphs and data. | ||||||||
| The productivity data shows increasing trend towards the later of weeks and in start, it has quite uniform trend in productivity. | ||||||||
| week | Capital Cost | Energy Cost | units produced | Material cost/unit | Labor Hours | |||
| 1 | 5800 | 555 | 147 | 12 | 190 | |||
| 2 | 5800 | 546 | 143 | 12 | 198 | |||
| 3 | 5800 | 547 | 157 | 12 | 199 | |||
| 4 | 5800 | 553 | 150 | 12 | 196 | |||
| 5 | 5800 | 547 | 151 | 12 | 194 | |||
| 6 | 5800 | 553 | 148 | 12 | 196 | |||
| 7 | 5800 | 549 | 155 | 12 | 198 | |||
| 8 | 5800 | 548 | 148 | 12.5 | 195 | |||
| 9 | 5800 | 546 | 158 | 12.5 | 198 | |||
| 10 | 5800 | 556 | 149 | 12.5 | 197 | |||
| 11 | 5800 | 556 | 152 | 12.5 | 195 | |||
| 12 | 5800 | 552 | 157 | 12.5 | 194 | |||
| 13 | 5800 | 549 | 149 | 12.5 | 195 | |||
| 14 | 5800 | 546 | 151 | 12.5 | 197 | |||
| 15 | 5800 | 552 | 156 | 12.5 | 193 | |||
| 16 | 5800 | 547 | 148 | 12.5 | 189 | |||
| 17 | 5800 | 550 | 149 | 12.5 | 190 | |||
| 18 | 5800 | 543 | 151 | 12.5 | 186 | |||
| 19 | 5800 | 552 | 153 | 12.5 | 194 | |||
| 20 | 5800 | 551 | 162 | 12.5 | 194 | |||
| 21 | 5800 | 550 | 151 | 13 | 191 | |||
| 22 | 5800 | 548 | 157 | 13 | 187 | |||
| 23 | 5800 | 541 | 160 | 13 | 193 | |||
| 24 | 5800 | 544 | 161 | 13 | 194 | |||
| 25 | 5800 | 539 | 152 | 13 | 188 | |||
| 26 | 5800 | 544 | 164 | 13 | 188 | |||
| 27 | 5800 | 543 | 160 | 13 | 195 | |||
| 28 | 5800 | 538 | 161 | 13 | 192 | |||
| 29 | 5800 | 543 | 154 | 13 | 185 | |||
| 30 | 5800 | 537 | 166 | 13 | 185 | |||
| 31 | 5800 | 531 | 159 | 13 | 185 | |||
| 32 | 5800 | 542 | 157 | 13 | 184 | |||
| 33 | 5800 | 535 | 165 | 13 | 192 | |||
| 34 | 5800 | 532 | 155 | 13.5 | 184 | |||
| 35 | 5800 | 544 | 167 | 13.5 | 188 | |||
| 36 | 5800 | 539 | 160 | 13.5 | 191 | |||
| 37 | 7300 | 324 | 140 | 9.5 | 205 | |||
| 38 | 7300 | 320 | 147 | 9.5 | 200 | |||
| 39 | 7300 | 322 | 146 | 9.5 | 194 | |||
| 40 | 7300 | 324 | 155 | 9.5 | 185 | |||
| 41 | 7300 | 352 | 163 | 9.5 | 170 | |||
| 42 | 7300 | 390 | 163 | 9.5 | 161 | |||
| 43 | 7300 | 386 | 171 | 9.5 | 155 | |||
| 44 | 7300 | 397 | 174 | 9.5 | 153 | |||
| 45 | 7300 | 402 | 176 | 9.5 | 148 | |||
| 46 | 7300 | 398 | 173 | 9.5 | 151 | |||
| 47 | 7300 | 399 | 174 | 9.5 | 150 | |||
| 48 | 7300 | 403 | 175 | 9.5 | 153 | |||
| 49 | 7300 | 406 | 176 | 9.5 | 153 | |||
| 50 | 7300 | 402 | 165 | 9.5 | 152 | |||
| 51 | 7300 | 394 | 177 | 9.5 | 155 | |||
| 52 | 7300 | 400 | 171 | 9.5 | 155 | |||
|
| ||||||||
PLEASE JUST EXPLAIN STEP BY STEP HOW TO CREATE THE TWO DIFFERENT GRAPHS
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
