Best Breath is a retail store selling home oxygen equipment. Best Breath also services home oxygen​ equipment, for which the company bills customers monthly. Best Breath has budgeted for increases in service revenue of $100 each month due to a recent advertising campaign. The forecast of sales and service revenue for​ March-June 2018 is as​ follows:   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 Best Breath​'s account overnight. For the servicing of home oxygen​ equipment, 75% of oxygen services billed each month is collected in the month of the​ service, and 25% is collected in the month following the service.

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter9: Cost Accounting For Service Businesses, The Balanced Scorecard, And Quality Costs
Section: Chapter Questions
Problem 3E: Prepare a revenue budget for the year ending December 31, 2016.
icon
Related questions
Question
Best Breath is a retail store selling home oxygen equipment.
Best Breath also services home oxygen​ equipment, for which the company bills customers monthly. Best Breath has budgeted for increases in service revenue of $100 each month due to a recent advertising campaign. The forecast of sales and service revenue for​ March-June 2018 is as​ follows:
 
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 Best Breath​'s account overnight. For the servicing of home oxygen​ equipment, 75% of oxygen services billed each month is collected in the month of the​ service, and 25% is collected in the month following the service.
Data Table
Sales and Service Revenues Budget March-June 2018
Month
Expected Sales Revenue
Expected Service Revenue
Total Revenue
March
$ 7,000
$
4,100
2$
11,100
April
9,000
4,200
13,200
May
8,600
4,300
12,900
June
9,700
4,400
14,100
Transcribed Image Text:Data Table Sales and Service Revenues Budget March-June 2018 Month Expected Sales Revenue Expected Service Revenue Total Revenue March $ 7,000 $ 4,100 2$ 11,100 April 9,000 4,200 13,200 May 8,600 4,300 12,900 June 9,700 4,400 14,100
Requirements
1.
Calculate the cash that Best Breath expects to collect in April, May and June 2018 from sales
and service revenue. Show calculations for each month.
Best Breath has budgeted expenditures for May of $12,200 and requires a minimum cash
balance of $240 at the end of each month. It has a cash balance on May 1 of $200.
2.
a. Given your answer to requirement 1, will Best Breath 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 also 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 Best Breath 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 $200 on May 1.)
3.
Why do Best Breath'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.
Transcribed Image Text:Requirements 1. Calculate the cash that Best Breath expects to collect in April, May and June 2018 from sales and service revenue. Show calculations for each month. Best Breath has budgeted expenditures for May of $12,200 and requires a minimum cash balance of $240 at the end of each month. It has a cash balance on May 1 of $200. 2. a. Given your answer to requirement 1, will Best Breath 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 also 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 Best Breath 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 $200 on May 1.) 3. Why do Best Breath'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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,