Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Herberts and Company has planned the following sales for the next four months: March April May June Total budgeted sales............. $50,000 $70,000 $90,000 $60,000 Herberts

Herberts and Company has planned the following sales for the next four months:

March

April

May

June

Total budgeted sales.............

$50,000

$70,000

$90,000

$60,000

Herberts sales are all on account,and their months sales are collected according to the following:

Month of sale..........................................................

70%

First month following month of sale..........................

20%

Second month following month of sale......................

8%

Uncollectible...........................................................

2%

Herbert and Company requires a minimum cash balance of $4,000 to start a month. If Herbert has a cash balance less than $4,000, they borrow cash to get to a $4,000 balance. If they have a cash balance greater than $4,000 they invest the amount over $4,000.

Assume the following budgeted data for June:

Purchases.......................................................

$52,000

Selling and administrative expenses.................

$10,000

Depreciation..................................................

$8,000

Equipment purchases......................................

$15,000

Cash balance, beginning of June......................

$4,000

1. You must prepare a cash budget for June that shows any borrowing needed during June. Herbert can borrow in any dollar amount, but will not pay any interest until the following month.

2. Show what the Accounts Receivable balance will be at June 30th?

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

Auditing The Art And Science Of Assurance Engagements

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Ingrid B. Splettstoesser-Hogeterp

11th Edition

0132088061, 978-0132088060

More Books

Students also viewed these Accounting questions

Question

What are the various ways to buy broadcast television time?

Answered: 1 week ago