Hi Please solve for requirement 2B the 3rd picture

Health Mart is a retail store selling home oxygen equipment. HealthMart also services home oxygen equipment, for which the company bills customers monthly. Health Mart has budgeted for increases in service revenue of $200 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2018 is as follows: E: (Click the icon to view the forecast of sales and service revenue.) (Click the icon to view the collection information.) Read the red x Data Table Requiremer Start by sho collections fa column and total cash bllection %" Sales and Service Revenues Budget March-June 2018 Expected Sales Revenue Expected Service Revenue Month Total Revenue March $ 6,000 $ 4,000 $ 10.000 April 8,000 4,200 12.200 Sales rever May 7,500 4,400 11,900 April sales re June 9,000 4,600 13,600 May sales re June sales Print Done Service rev! HealthMart is a retail store selling home oxygen equipment. HealthMart also services home oxygen equipment, for which the company bills customers monthly. Health Mart has budgeted for increases in servi revenue of $200 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2018 is as follows: B 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 HealthMart expects to collect in May and in June 2018. Show calculations for each month. Start by showing the cash collections of sales revenue, then complete the schedule by entering in the service revenue collections and the total cash collections for each month. (Complete all answer boxes. If there were no collections of revenue for a certain month, select "0%" in the Collection %" column and enter a "0" in the appropriate May or June column.) Gross Expected Revenue Collection % April May June Sales revenue: April sales revenue collected in Apr 8,000 x 97% 7,760 7,500 x 97% = 7,275 May sales revenue collected in May June sales revenue collected in June 9,000 X 97% = 8,730 40% = 1,600 4,000 x 4,000 x 0 0% 0% 4,000 X = 0 Service revenue: March service revenue collected in Apr. March service revenue collected in May March service revenue collected in June April service revenue collected in Apr. April service revenue collected in May April service revenue collected in June May service revenue collected in May May service revenue collected in June 60% 2,520 4,200 x 4,200 x 40% = 1,680 4,200 X 0 0% 60% 4,400 x 2,640 4,400 x 40% 1,760 June service revenue collected in June 4,600 X 60% 2.760 $ 11,880 $ 11,595 $ 13,250 Total collections Requirement 2a. HealthMart has budgeted expenditures for May of $11,000 and requires a minimum cash balance of $250 at the end of each month. It has a cash balance on May 1 of $400. Given your answer to requirement 1, will Health Mart need to borrow cash to cover its payments for May and maintain a minimum cash balance of $250 at the end of May? The total cash available for May exceeds end of May. the budgeted expenditures for the month; therefore, HealthMart will be able to cover its payments for May and maintain a minimum cash balance of $250 at the Requirement 2b. Assume (independently for each situation) that (1) May total revenues might 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 Health Mart would have to borrow to cover its cash payments for May and maintain a minimum cash balance of $250 at the end of May. (Again, assume a balance of $400 on May 1.) First calculate the cash excess or deficiency for May using the original numbers and under each scenario presented. On the next line, enter the amount of borrowing required. (Enter all amounts to the nearest cent. Enter a cash deficiency with a minus sign or parentheses. Complete all answer boxes. Enter a "0" if no borrowing is required.) Cash Budget For May Original May Revenues May Costs Numbers Decrease 10% Increase 5% Cash balance, beginning 400 400 400 Add receipts 11,595 Total cash available for needs 11995 Total disbursements 11000 11000 250 250 250 Minimum cash balance desired Total cash needed Cash excess (deficiency) Enter any number in the edit fields and then click Check