Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HealthWorld is a retail store selling home oxygen equipment. HealthWorld also services home oxygen equipment, for which the company bills customers monthly. HealthWorld has budgeted

image text in transcribedimage text in transcribed

HealthWorld is a retail store selling home oxygen equipment. HealthWorld also services home oxygen equipment, for which the company bills customers monthly. HealthWorld has budgeted for increases in service revenue of $300 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2021 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 Requirement 1. Calculate the cash that HealthWorld 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.) Data table Question 18 1. Calculate the cash that HealthWorld expects to collect in Ap 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 HealthWorld'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. Question 19 2. HealthWorld has budgeted expenditures for May of $13,000 and requires a minimum cash balance of $290 at the end of each month. It has a cash balance on May 1 of $650. a. Given your answer to requirement 1 , will HealthWorld need to borrow cash to cover its payments for May and maintain a minimum cash balance of $290 at the end of May? b. Assume (independently for each situation) that (1) May total revenues might be 10% lower Question 20 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 HealthWorld would have to borrow to cover its cash payments for May and maintain a minim assume a balance of $650 on May 1.) Question 21 3. Why do HealthWorld's managers prepare a cash budget in addition to the revenue, expenses

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SAP Audit Black Book

Authors: Bhushan Jairamdas Mamtani

1st Edition

9351194086, 978-9351194088

More Books

Students also viewed these Accounting questions

Question

4. Label problematic uses of language and their remedies

Answered: 1 week ago