Question: Please explain well step by step because i have to do it in excel This production data was recorded during the last quarter of operations
Please explain well step by step because i have to do it in excel
This production data was recorded during the last quarter of operations at Metal Company.
| Week | Unit Produced | Machine Hours |
| 1 | 1,692 | 4,153 |
| 2 | 1,330 | 2,529 |
| 3 | 1,559 | 3,184 |
| 4 | 1,633 | 3,531 |
| 5 | 1,432 | 2,893 |
| 6 | 1,572 | 2,282 |
| 7 | 1,372 | 2,955 |
| 8 | 1,433 | 3,016 |
| 9 | 1,795 | 4,200 |
| 10 | 1,464 | 2,772 |
| 11 | 1,723 | 2,166 |
| 12 | 1,278 | 2,507 |
Required
a)Plot machine hours versus units produced.
b)Estimate the number of machine hours per unit of production using the high-low method.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
