How do you find the operating expense pool supplies expenses for May, June, July, Aug, Sept?

The water park is open from May through September and 60% of its sales are paid in cash, 30% are paid by credit card and 10% are school groups that are billed to the school divisions. Credit card companies deposit payment to Water World's corporate bank account the same day less a 1% processing fee. Admission fees billed to school groups are paid the following month. All expenses are paid the month they are incurred. The following projections have been completed to date (this table is also available in Excel Appendix A): Sales Staff costs Operating Expenses Depreciation expense Pool supplies expense Expected attendance $ $ $ $ 2021 Operating Year Projections May June July 160,000 $ 210,000 $ 300,000 $ (43,200) $ (56,700) $ (81,000) $ (54,400) $ (71,400) $ (102,000) $ (13,000 $ (13,000) $ (13,000) $ August September 300,000 $ 250,000 (81,000) $ (67,500) (102,000) $ (85,000) (13,000) $ (13,000) 6,880 9,030 12,900 12,900 10,750 The pool supply expense line is incomplete. Your uncle tells you that the park uses balanced chlorine kits to maintain the pools and slides at a cost of $250 per kit and the number needed is based on anticipated usage. He expects to use 10 in May, 20 in June, 40 in July, 40 in August and 20 in September but always wants to have 10% of next month's requirements on hand "just in case". There are 10 kits currently in