9. Oxygen World is a retail store selling home oxygen equipment. Oxygen World also services home oxygen equipment, for which the company bills customers monthly. Oxygen World has budgeted for increases in service revenue of $600 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2021 is as follows: 1 (Click the icon to view the forecast of sales and service revenue.) 2 (Click the icon to view the collection information.) Read the reguirements 3. Requirement 1. Calculate the cash that Oxygen World expects to collect in May and in June 2021. 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 input fields. 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.) Requirement 2a. Oxygen World has budgeted expenditures for May of $13,500 and requires a minimum cash balance of $240 at the end of each month. It has a cash balance on May 1 of $300. Given your answer to requirement 1 , will Oxygen World need to borrow cash to cover its payments for May and maintain a minimum cash balance of $240 at the end of May? The total cash available for May (13) the budgeted expenditures for the month; therefore, Oxygen World (14) be able to cover its payments for May and maintain a minimum cash balance of $240 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 Oxygen World would have to borrow to cover its cash payments for May and maintain a minimum cash balance of $240 at the end of May. (Again, assume a balance of $300 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 input fields. Enter a "0" if no borrowing is required.) Requirement 3. Why do Oxygen World'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. Oxygen World's managers prepare a cash budget in addition to the operating income budget to plan (15) to ensure that the company has adequate (16) If Oxygen World is profitable on an accrual accounting basis, (17) to make scheduled payments for its expenses. Oxygen World's managers (18) Building a profitable operating plan (19) that adequate cash will be available, so Oxygen World's managers (20) 1: Data Table 2: 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 Oxygen World's account overnight. For the servicing of home oxygen equipment, 70% of oxygen services billed each month is collected in the month of the service, and 30% is collected in the month following the service. 3: Requirements 1. Calculate the cash that Oxygen World expects to collect in April, May and June 2021 from sales and service revenue. Show calculations for each month. 2. Oxygen World has budgeted expenditures for May of $13,500 and requires a minimum cash balance of $240 at the end of each month. It has a cash balance on May 1 of $300. a. Given your answer to requirement 1 , will Oxygen World need to borrow cash to cover its payments for May and maintain a minimum cash balance of $240 at the end of May? b. 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 Oxygen World would have to borrow ts cover its cash payments for May and maintain a minimum cash balance of $240 at the end of May. (Again, assume a balance of $300 on May 1.) 3. Why do Oxygen World'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. seguejen6 Data table 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 Oxygen World's account overnight. For the servicing of home oxygen equipment, 70% of oxygen services billed each month is collected in the month of the service, and 30% is collected in the month following the service. 9. Oxygen World is a retail store selling home oxygen equipment. Oxygen World also services home oxygen equipment, for which the company bills customers monthly. Oxygen World has budgeted for increases in service revenue of $600 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2021 is as follows: 1 (Click the icon to view the forecast of sales and service revenue.) 2 (Click the icon to view the collection information.) Read the reguirements 3. Requirement 1. Calculate the cash that Oxygen World expects to collect in May and in June 2021. 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 input fields. 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.) Requirement 2a. Oxygen World has budgeted expenditures for May of $13,500 and requires a minimum cash balance of $240 at the end of each month. It has a cash balance on May 1 of $300. Given your answer to requirement 1 , will Oxygen World need to borrow cash to cover its payments for May and maintain a minimum cash balance of $240 at the end of May? The total cash available for May (13) the budgeted expenditures for the month; therefore, Oxygen World (14) be able to cover its payments for May and maintain a minimum cash balance of $240 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 Oxygen World would have to borrow to cover its cash payments for May and maintain a minimum cash balance of $240 at the end of May. (Again, assume a balance of $300 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 input fields. Enter a "0" if no borrowing is required.) Requirement 3. Why do Oxygen World'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. Oxygen World's managers prepare a cash budget in addition to the operating income budget to plan (15) to ensure that the company has adequate (16) If Oxygen World is profitable on an accrual accounting basis, (17) to make scheduled payments for its expenses. Oxygen World's managers (18) Building a profitable operating plan (19) that adequate cash will be available, so Oxygen World's managers (20) 1: Data Table 2: 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 Oxygen World's account overnight. For the servicing of home oxygen equipment, 70% of oxygen services billed each month is collected in the month of the service, and 30% is collected in the month following the service. 3: Requirements 1. Calculate the cash that Oxygen World expects to collect in April, May and June 2021 from sales and service revenue. Show calculations for each month. 2. Oxygen World has budgeted expenditures for May of $13,500 and requires a minimum cash balance of $240 at the end of each month. It has a cash balance on May 1 of $300. a. Given your answer to requirement 1 , will Oxygen World need to borrow cash to cover its payments for May and maintain a minimum cash balance of $240 at the end of May? b. 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 Oxygen World would have to borrow ts cover its cash payments for May and maintain a minimum cash balance of $240 at the end of May. (Again, assume a balance of $300 on May 1.) 3. Why do Oxygen World'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. seguejen6 Data table 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 Oxygen World's account overnight. For the servicing of home oxygen equipment, 70% of oxygen services billed each month is collected in the month of the service, and 30% is collected in the month following the service