Financial Management (1,15)

Working Capital Cool Water, Inc. sells bottled water. The firm keeps in inventory plastic bottles at 10% of the monthly projected sales. These plastic bottles cost $0.005 each. The monthly sales for the coming year are as follows: Expected Sales Month (Unit) January 2,000,000 Answer.. 1. Upload your working sheet. February 2.200.000 March 2,700,000 3,000,000 April May 3.600.000 June July 5,500,000 7.000.000 August 9,000,000 September 6.000.000 October 4,000,000 November 2.500.000 December 1,300,000 Jan Next 2.200.000 Show the anticipated cost of plastic bottles each month for these projected sales, the beginning inventory volume and ending inventory volume each month, and the monthly increase or decrease in cash flow for inventory given that an increase is a use of cash and a decrease is a source of cash. a Template Month Expected Sales (Unit) COGS Bey End Working Capital Increase in It Inventory Ballwentory Bancrease Nuded January February March April May June July August September October November December Jan Next 2,000,000 2,200,000 2.700,000 3.000.000 3.600,000 5.500.000 7,000,000 9.000.000 6.000.000 1.000.000 2.500,000 1.500,000 2.900.000 Total RM HM