Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help answering the nimber for may revenue decrease 10% which are the three empty boxes. Oxygen World is a retail store selling home

image text in transcribed
image text in transcribed
image text in transcribed
i need help answering the nimber for may revenue decrease 10% which are the three empty boxes.
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 $500 each month due to a recent advertising campaign. The forecast of sales and service revenue for March June 2021 is as folows: Click the icon to view the forecast of sales and service revenue) (Click the icon to view the collection information) Read the requirements 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. Sales and Service Revenues Budget March-June 2021 Expected Sales Expected Service Total Month Revenue Revenue Revenue March $ 7.500 5 4,200 $ 11,700 April 9.500 4.700 14,200 May 8,700 5.200 13,900 June 9.900 5,700 15,600 Print Done Requirement Zb. 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 $280 at the end of May. (Again, assume a balance of 5650 on May 1.) First calculate the cash excess or deliciency for May using the original numbers and under each senario 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 al input fields. Enter a "oi no borrowing is required.) $ Cash balance, beginning Add receipts Total cash available for needs Total disbursements Minimum cash balance desired Total cash needed Cash excess (deficiency) Original May Revenues Numbers Decrease 10% 650.00 $ 650.00 $ 13,489.00 14,139.00 12,800.00 12,800.00 280.00 280.00 May Costs Increase 5% 650.00 13,489.00 14,139.00 13,440.00 280.00 $ 13,080.00 $ 13,080.00 $ 13,720.00 $ 1,059.00 $ 419.00

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

Managerial Accounting Special Edition For California State University Los Angeles

Authors: Garrison

14th Edition

0077519973, 978-0077519971

More Books

Students also viewed these Accounting questions

Question

Prepare a short profile of victor marie hugo ?

Answered: 1 week ago

Question

Prepare a short profile of Henry words worth Longfellow?

Answered: 1 week ago

Question

What is RAM as far as telecommunication is concerned?

Answered: 1 week ago

Question

Question 1: What is reproductive system? Question 2: What is Semen?

Answered: 1 week ago

Question

1. Are my sources credible?

Answered: 1 week ago

Question

3. Are my sources accurate?

Answered: 1 week ago

Question

1. Is it a topic you are interested in and know something about?

Answered: 1 week ago