Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help on question 5 and check if question 7- 10 are correct. Thank you. 5. From the Open Inventory table, try to get the
Please help on question 5 and check if question 7- 10 are correct. Thank you.
5. From the Open Inventory table, try to get the TOTAL # of open parts for each of the ROWs below: | Use Sumproduct | ||||||||||
Table 6 | Total | ||||||||||
G3572 | |||||||||||
D5904 | |||||||||||
D1476 | |||||||||||
D0557 | |||||||||||
C9208 | |||||||||||
C1319 | |||||||||||
W0933 | |||||||||||
W6415 | |||||||||||
W1117 | |||||||||||
W1051 |
Open Inventory | ||||||
On Hand | Rail Yard | On Boat | In Quality | Mfg Qty | ||
G3572 | 2 | 12 | 18 | 28 | 38 | |
D5904 | 9 | 19 | 29 | 39 | 49 | |
D1476 | 18 | 28 | 38 | 48 | 58 | |
D0557 | 41 | 51 | 61 | 71 | 81 | |
C9208 | 82 | 92 | 102 | 112 | 122 | |
C1319 | 169 | 179 | 189 | 199 | 209 | |
W0933 | 338 | 348 | 358 | 368 | 378 | |
W6415 | 169 | 179 | 189 | 199 | 209 | |
W1051 | 338 | 348 | 358 | 368 | 378 | |
W1117 | 169 | 179 | 189 | 199 | 209 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started