The sales information for you company is provided in the attached spreadsheet.

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	B02	B03	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