Breathe Right is a retail store selling home oxygen equipment Breathe Right also services home oxygen equipment, for which the company bills customers monthly Breathe Right has budgeted for increases in service revenue of S700 each month 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) Read the requirements Requirement 1. Calculate the cash that Breathe Right 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 "O" in the Collection %* column and enter a "o' in the appropriate Mayor June column) Gross Expected Revenue Collection% April May Sales revenue: April sales revenue collected in Apr 97% May sales revenue collected in May 8,148 Jurre sales revenue collected in June 97% Service revenue: March service revenue collected in Apr. 35% March service revenue collected in May Enter any number in the edit fields and then click Check Answer. Juno 8,730 9.000 x 8.400 x 9.400 x 97% 10 9.118 1,540 4.400 4.400 0% 2 parts Clear All remaining Check Answer Breathe Right is a retail store selling home oxygen equipment. Breathe Right also services home oxygen equipment, for which the company Breathe Right has budgeted for increases in service revenue of $700 each month due to a recent advertising campaign. The forecast of sales 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 June sales revenue collected in June 97% 9,118 9,400 X 35% 1.540 0% 0% 0 65% 3,315 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 June service revenue collected in June 4.400 X 4,400 x 4,400 x 5,100 x 5,100 x 5,100 x 5,800 x 5,800 x 35% 1,785 0% 0 65% 3.770 35% 2.030 4,225 6,500 x 65% Total collections 13,585 $ 13.703 $ 15,373 Dent - Den Dat he had no infe49 EAN anime minimal baten the Enter any number in the edit fields and then click Check Answer. Requirement 2a. Breathe Right has budgeted expenditures for May of $13,500 and requires a minimum cash balance of $270 at the end of each month. It has a cash balance on May 1 of $100. Given your answer to requirement 1, will Breathe Right need to borrow cash to cover its payments for May and maintain a minimum cash balance of $270 at the end of May? The total cash available for May exceeds the budgeted expenditures for the month; therefore, Breathe Right wil be able to cover its payments for May and maintain a minimum cash balance of $270 at the end of May. 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 Breathe Right would have to borrow to cover its cash payments for May and maintain a minimum cash balance of S270 at the end of May. (Again, assume a balance of $100 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. (Enteral amounts to the nearest cont. Enter a cash deficiency with a minus sign or parentheses Complete all answer boxen. Enter a *O* # no borrowing in required) Cash Budget For May Original May Revenues May Costs Enter any number in the edit fields and then click Check Answer. First calculate the cash excess or deficiency for May using the original numbers and under each scenario presented. On the ne required. (Enter all amounts to the nearest cent. Enter a cash deficiency with a minus sign or parentheses. Complete all answe required.) Cash Budget For May Original May Revenues May Costs Numbers Decrease 10% Increase 5% Cash balance, beginning 100 100 100 13703 Add receipts Total cash available for needs 13803 Total disbursements 270 Minimum cash balance desired Total cash needed Cash excess (doficiency) 35 dolor Sales and 5 e 2018 is as follows: the icon to view the forecast of sales and service revenue.) (Click the icon to view the collection information.) requirement i Data Table alate the cas Enter allan X - hou if Month March alance, begini ipts Sales and Service Revenues Budget March-June 2018 Expected Sales Revenue Expected Service Revenue Total Revenue $ 8,000 $ 4,400 $ 12,400 9,000 5,100 14,100 8,400 5,800 14,200 9,400 6,500 15,900 April May Juno sh available sbursements m cash balang Print Done ash neodod ss or deficiency for Marucing the ori inal number and under asb.cconario procented Do the nordline, enter the to the ne xes. Enter a More Info 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 Breathe Right's account overnight. For the servicing of home oxygen equipment, 65% of oxygen services billed each month is collected in the month of the service, and 35% is collected in the month following the service. eds Print Done esired