CIS Excel
MUMEI
EX11-7.xlsxProduct Info
| Pacific Robotics | |||||||
| January Profit | |||||||
| Hourly Labor Cost | $70.00 | ||||||
| Product Number | Hours | Parts Cost | Cost to Produce | Retail Price | Unit Profit | Units Produced | Total Profit |
| 23654 | 15 | $896 | $ 1,946.00 | $ 2,854.00 | $ 908.00 | 157 | $ 142,556.00 |
| 12574 | 17 | $1,002 | $ 2,192.00 | $ 2,964.00 | $ 772.00 | 87 | $ 67,164.00 |
| 35521 | 22 | $1,421 | $ 2,961.00 | $ 3,964.00 | $ 1,003.00 | 101 | $ 101,303.00 |
| 54496 | 84 | $1,080 | $ 6,960.00 | $ 8,251.00 | $ 1,291.00 | 92 | $ 118,772.00 |
| Total Profit | $ 429,795.00 | ||||||
