DATA INPUT AREA Average unit selling price $18.00 Sales Unit sales for February 2018 Unit sales for March 2018 Expected unit sales for April 2018 Expected unit sales for May 2018 Expected unit sales for June 2018 1,62,000 1,83,600 1,98,000 2,07,000 2,16,000 2,43,000 2,88,000 9 Expected unit sales for July 2018 10 Expected unit sales for August 2018 Amount of ending inventory to keep 11 on hand 8% 13 Cash collections 14 Collected in month of sales 15 Collected in month following sale 16 7 Cash budget details 18 Cash balance, March 31 19 Minimum cash on hand 60% 40% 5,49,000 6,00,000 3% 10,02,000 o Interest rate on borrowing 21 New equipment in May MATION DATA DATA INPUT AREA Average unit selling price $18.00 Sales Unit sales for February 2018 Unit sales for March 2018 Expected unit sales for April 2018 Expected unit sales for May 2018 Expected unit sales for June 2018 1,62,000 1,83,600 1,98,000 2,07,000 2,16,000 2,43,000 2,88,000 9 Expected unit sales for July 2018 10 Expected unit sales for August 2018 Amount of ending inventory to keep 11 on hand 8% 13 Cash collections 14 Collected in month of sales 15 Collected in month following sale 16 7 Cash budget details 18 Cash balance, March 31 19 Minimum cash on hand 60% 40% 5,49,000 6,00,000 3% 10,02,000 o Interest rate on borrowing 21 New equipment in May MATION DATA