20-34 (Simal 10 World is a real store selling home oxygen equipment. He World also services home oxygen equipment for which the company is customers monthly Heath World has budgeted for increases in service revenue of $800 each Onth due to a recent 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) Beard the teamet Data Table with a minus sign of parentheses Complete all e r Cash Budget Month Total Revenue 5 11.700 Cash balance, beginning Add receipts Sales and Service Revenues Budget March June 2018 Expected Sales Revenue Expected Service Revenue $ 7.000 8,000 5.500 7,200 500 7100 300 Total cash value for needs 13.500 15.000 inimum balance des Port Dome Casheed - T ai ) HealthWorld is a retail store selling home oxygen equipment Health World also services home oxygen equipment, for which the company bill: 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 Gross Expected Revenue Collection % April May June Sales revenue: April sales revenue collected in Apr 7.760 8.000 x 7,200 8,500 May sales revenue collected in May June sales revenue collected in June 97% 97% 97% 6,984 8,245 Service revenue: 4,700 x 1,175 X 4,125 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 June service revenue collected in June 1,375 4,700 4,700 5,500 5,500 5,500 6,300 6,300 7.100 4.725 0% 75% 25% 75% 1,575 5,325 13,060 $ 13,084 S 15,145 Total collections Enter any number in the edit fields and then click Check Answer Read the requirements. Read the requirements Requirement 2a. Health World has budgeted expenditures for May of $12,200 and requires a minimum cash balance of $260 at the end of each month. It has a payments for May and maintain a minimum cash balance of $260 at the end of May? The total cash available for May exceeds the budgeted expenditures for the month, therefore, Health World will be able to cover its payments for May ar 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 ead payments for May and maintain a minimum cash balance of $260 at the end of May. (Again, assume a balance of $200 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 answer boxes. Enter a "0" if no borrowing is required.) Qu Cash Budget For May Original Numbers May Revenues Decrease 10% May Costs Increase 5% Cash balance, beginning Add receipts Total cash available for needs Total disbursements Minimum cash balance desired Total cash needed Cash excess (deficiency) Enter any number in the edit fields and then click Check Answer Clear All parts 2 remaining 1 PL