Question

iRequirements 1 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 $11,500 and requires a minimum cash balance of $300 at the end of each month. It has a cash balance on May 1 of $100. a. Given your answer to requirement 1, will Best Breath need to borrow cash to cover its 2. payments for May and maintain a minimum cash balance of S300 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 $300 at the end of May. (Again, assume a balance of $100 on May 1.) 3. Why do Best Breaths managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Has preparing the cash budget been helpful? Explain briefly.

Questions are 2b (Fill the Cash Budget for May), and 3.  

IF UNCLEAR Requirement 2b says: 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 Best Breath would have to borrow to cover its cash payments for May and maintain a minimum cash balance of $300at the end of May.​ (Again, assume a balance of $100 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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Hi, giving below answer for part-2 which is explained below in working. Please get back if need any further explanation. Happy to help.

If think this helped, please hit LIKE button.

Original Number May Revenue decrease by 10% May Cost increase by 5%
Cash Balance beginning 100 100 100
Add Receipts (Working-1) 12575 11443 12575
Total Cash Available 12675 11543 12675
Disbursments (Working-1) 11500 11500 12075
Minimum Cash Balance Desired 300 300 300
Total Cash Needed 11800 11800 12375
Cash Excee (Deficiency) 875 -257 300
Working-1
Receipts Same as Original
May Sales Revenue collected in May (97% of (7500-10% decrease) 6548
April Service revenue collected in May (Same as original) 1250
May Service Revenue collected in May (75% of (5400-10% decrease) 3645
Total 11443
Disbursment Same as original 5% increase from 11500=12075
Add a comment
Know the answer?
Add Answer to:
Questions are 2b (Fill the Cash Budget for May), and 3.   IF UNCLEAR Requirement 2b says:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • E6-34 (similar to) Health World is a retail store selling home oxygen equipment. Health World also...

    E6-34 (similar to) Health World is a retail store selling home oxygen equipment. Health World also services home oxygen equipn due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2018 is as fc (Click the icon to view the forecast of sales and service revenue.) (Click the icon to view the coll Read the requirements. Requirement 1. Calculate the cash that Health World expects to collect in May and in June 2018. Show calcu...

  • Requirement 1 Cash receipt from customer's Budget Dec Total You are provided with the following Sales...

    Requirement 1 Cash receipt from customer's Budget Dec Total You are provided with the following Sales Budget, Purchases Budget and selling and administrative expenses budget for Salhiya World Co. for the last quarter of the year 2019. Nov Oct. Oct. Collections From Oct. Sales From Sep Sales Total Oct collection Nev, Cellections: Froem Nov. Sales From Oct Sales Total Nov collections Dec. Collections: From Dec. Sales Frem Nov. Sales Total Dec. collections Total cash receipt (ISles Budeet Tetal 135,000 45,000...

  • Requirement 1 Cash receipt from customer's Budget Dec Total You are provided with the following Sales...

    Requirement 1 Cash receipt from customer's Budget Dec Total You are provided with the following Sales Budget, Purchases Budget and selling and administrative expenses budget for Salhiya World Co. for the last quarter of the year 2019. Nov Oct. Oct. Collections From Oct. Sales From Sep Sales Total Oct collection Nev, Cellections: Froem Nov. Sales From Oct Sales Total Nov collections Dec. Collections: From Dec. Sales Frem Nov. Sales Total Dec. collections Total cash receipt (ISles Budeet Tetal 135,000 45,000...

  • 20-34 (Simal 10 World is a real store selling home oxygen equipment. He World also services...

    20-34 (Simal 10 World is a real store selling home oxygen equipment. He World also services home oxygen equipment for which the company is customers monthly Heath World has budgeted for increases in service revenue of $800 each Onth due to a recent advertising campaign. The forecast of sales and service revenue for March June 2018 is as follows: Click the icon to view the forecast of sales and service revenue) Click the icon to view the collection information) Beard...

  • Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts an...

    Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $41,196 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...

  • Kaiser, Inc. has the following budgeted cash collections from the cash receipts budget and cash payments...

    Kaiser, Inc. has the following budgeted cash collections from the cash receipts budget and cash payments (excluding loan principal repayments and interest payments) from the cash disbursements budget for the next quarter (April, May, & June). Cash Receipts Cash Payments April $30,024 $27,064 May $32,398 $39,383 June $36,064 $32,772 In addition, Kaiser's beginning cash balance as of April 1 is $15,290. Kaiser, Inc. would like to maintain a minimum $15,000 cash balance at all times. In order to achieve this...

  • A) Prepare Drew Consulting's cash budget for January AND February B) How much cash will Drew...

    A) Prepare Drew Consulting's cash budget for January AND February B) How much cash will Drew borrow in February if cash receipts from customers that month total $39,000 instead of $49,000 Assume Drew Consulting began January with $15,000 cash. Management forecasts that cash receipts from credit customers will be $48,000 in January and $49,000 in February. Projected cash payments include equipment purchases ($18,000 in January and $41,000 in February) and selling and administrative expenses ($3,000 each month). Drew's bank requires...

  • Crane Company is preparing a cash summary budget using the data below. They have already prepared...

    Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash $63000 $95000 Receipts Expected Cash Payments $45000 $76000 Management always wants to maintain a $41,492 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...

  • Crane Company is preparing a cash summary budget using the data below. They have already prepared...

    Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: November October Beginning Cash Balance $16000 Expected Cash Receipts $95000 $63000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $39,637 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...

  • Crane Company is preparing a cash summary budget using the data below. They have already prepared...

    Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $38,593 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT