Your company, ERPWater, ordered 3,000 units of each item on Day 18 of Round 1. The lead-time was 2 days, and your inventory arrived for the beginning of Round 2. When you checked the inventory report at the start of Round 2. you saw that you had 3,000 units for each of your product codes. You were also told by the finance manager that at the beginning of Round 2, there were no outstanding Accounts Receivable. On day 7, you re-ordered more inventory, and ordered another 3,000 units of each product. If your opening bank balance for Round 2 was $16,500, how much cash will you have on hand to pay your suppliers on Day 17 and will you have to take on a bank loan? You can assume that the terms of the agreements that ERPWater gives its customers includes the day of sale, and that the terms of the agreements that ERPWater gets from its suppliers also include the date of purchase. These terms are laid out in the Job Aid. To get full marks, you need to provide your calculations to support your answer. B01 BO2 BO3 B04 B05 B06 Day 1 245 100 329 324 356 324 Day 2 675 150 239 324 645 324 Day 3 142 324 132 654 142 654 Day 4 356 324 132 245 332 150 Day 5 645 654 234 675 150 324 Day 6 142 654 329 142 324 675 Day 7 332 794 325 142 324 142 Day 8 435 0 330 142 654 407 Day 9 28 140 329 329 73 0 Day 10 356 76 239 239 0 265 Day 11 645 100 132 132 332 132 Day 12 142 150 132 132 150 234 Day 13 332 324 234 234 324 329 Day 14 142 324 176 231 324 325 Day 15 435 654 157 229 319 330 Day 16 142 250 124 250 654 330 Day 17 142 253 165 250 654 330 Your company, ERPWater, ordered 3,000 units of each item on Day 18 of Round 1. The lead-time was 2 days, and your inventory arrived for the beginning of Round 2. When you checked the inventory report at the start of Round 2. you saw that you had 3,000 units for each of your product codes. You were also told by the finance manager that at the beginning of Round 2, there were no outstanding Accounts Receivable. On day 7, you re-ordered more inventory, and ordered another 3,000 units of each product. If your opening bank balance for Round 2 was $16,500, how much cash will you have on hand to pay your suppliers on Day 17 and will you have to take on a bank loan? You can assume that the terms of the agreements that ERPWater gives its customers includes the day of sale, and that the terms of the agreements that ERPWater gets from its suppliers also include the date of purchase. These terms are laid out in the Job Aid. To get full marks, you need to provide your calculations to support your answer. B01 BO2 BO3 B04 B05 B06 Day 1 245 100 329 324 356 324 Day 2 675 150 239 324 645 324 Day 3 142 324 132 654 142 654 Day 4 356 324 132 245 332 150 Day 5 645 654 234 675 150 324 Day 6 142 654 329 142 324 675 Day 7 332 794 325 142 324 142 Day 8 435 0 330 142 654 407 Day 9 28 140 329 329 73 0 Day 10 356 76 239 239 0 265 Day 11 645 100 132 132 332 132 Day 12 142 150 132 132 150 234 Day 13 332 324 234 234 324 329 Day 14 142 324 176 231 324 325 Day 15 435 654 157 229 319 330 Day 16 142 250 124 250 654 330 Day 17 142 253 165 250 654 330
