Excess cash the months Octob a. Prepare a quarterly cash budget for Sam and Suzy covering the m through December 2020 b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December : Advanced The actual sales and purchases for Xenocore Inc tember an November 2019 through April 2020, follow. The firm makes 20% of all sales for cash and collects on 40% of its salo. each of the 2 months following the sale. Other cash inflows are expected to $12,000 in September and April, $15,000 in January and March, and $27,000 February. The firm pays cash for 10% of its purchases. It pays for 50% of chases in the following month and for 40% of its purchases 2 months later. its. Din pur Year 2019 2019 2019 2019 2020 2020 2020 2020 Month September October November December January February March April Sales $210,000 250,000 170,000 160,000 140,000 180,000 200,000 250,000 Purchases $120,000 150,000 140,000 100,000 80,000 110,000 100,000 90,000