50.1K

Verified Solution

Link Copied!

please help me with all the requirements

Data table Requirements 1. Calculate the cash that OxygenMart expocts to collot in Aprl, May and June 2021 from sales and senvice revenue. Show calculations foc each month. 2. OxygenMurt has budgoted nxpenditures for May of $13,500 and fequires a minimum cash balance of $300 at the end of each month. It has a cash balance on May 1 of $300. a. Given your answer to requirement 1, will OxygenMart 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 (independenty for each stuution) that (1) Moy total revenues might bo 10k iown of that (2) total costs might be 5% higher. Under each of those two scenarios, show the botal net cash for May and the amount OxygenMart would have to borrow to civer its eash payments for May and maintan a minimum cash balunce of $300 at the and of May. (Again. nssume a balance of $300 on May 1.) 3. Why do OxygenMarts managers prepare a cash budget in addeton to the revenue, axpanses. and operaspg income budget? Has preparing the cash budget been helptul? Explain brieft, More info Amost al of the saies revenues of the oxygen equipment are credit card saies: cash sales are negligible. Tho credt card company deposits 97% of the revenues. recorded each day into OxypenMart's account overnight. For the servicing of hoene apygen equipment, 65% of axygen services billed bach month is collected in the month of the sarice, and 35% is collected in the month following the service. OxygenMart is a retail atore soling home oxygen equipment. OxygenMart alse services home axygen equipment, for which the compary bils custornars monthy OxygerMart has budgated for increases in sevice revenue of 5600 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2021 is as followa: (Click the icon to view the forecast of sales and service revenue.) (Cick the icon to view the colloction information.) Read the recouitements. Requirement 1. Calculate the cash that OxygenMart 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 sorvice revenue collections and the total cash collections for each month, (Complete at input fields, it there were no coltections of tevenue for a certain month. select "0\%" in the "Colection % " column and enter a "o" in the appropriate May or June column)

Answer & Explanation Solved by verified expert

See Answer