I cannot figure this out for the life of me I only need Requirement 2B

Data table Requirements 1. Calculate the cash that Breath of Life expects to collect in April, May and June 2018 from sales and service revenue. Show calculations for each month. 2. Breath of Life has budgeted expenditures for May of $13,500 and requires a minimum cash balance of $300 at the end of each month. It has a cash balance on May 1 of $550. a. Given your answer to requirement 1 , will Breath of Life need to borrow cash to cover its payments for May and maintain a minimum cash balance of $300 at the end of May? b. Assume (independently for each situation) that (1) May total revenues might also be 10% lower or that (2) total costs might be 5% higher. Under each of those two scenarios, show the total net cash for May and the amount Breath of Life would have to borrow to cover its cash payments for May and maintain a minimum cash balance of $300 at the end of More info May. (Again, assume a balance of $550 on May 1.) 3. Why do Breath of Life's managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Has preparing the cash budget been helpful? Explain briefly. March service revenue collected Almost all of the sales revenues of the oxygen equipment are credit card sales; cash sales are negligible. The credit card company deposits 97% of the revenues recorded each day into Breath of Life's account overnight. For the servicing of home oxygen equipment, 75% of oxygen services billed each month is collected in the month of the service, and 25% is collected in the month following the service. advertising campaign. The forecast of sales and service revenue for March-June 2018 is as follows: (Click the icon to view the forecast of sales and service revenue.) (Click the icon to view the collection information.) Read the requirements. Requirement 1. Calculate the cash that Breath of Life expects to collect in May and in June 2018. Show calculations for each month. select " 0%" in the "Collection \%" column and enter a "0" in the appropriate May or June column.) cash to cover its payments for May and maintain a minimum cash balance of $300 at the end of May? The total cash available for May the budgeted expenditures for the month; therefore, Breath of Life be able to cover its payments for May and maintain a minimum cash balance of $300 at the end of May. borrow to cover its cash payments for May and maintain a minimum cash balance of $300 at the end of May. (Again, assume a balance of $550 on May 1 .) parentheses. Complete all answer boxes. Enter a "0" if no borrowing is required.)