The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 401 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Exercise 9-45Â Cash Budget
The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following:
Â
Â
|
a. b. |
Cash balance on June 1 is $736. Actual sales for April and May are as follows: |
 |
|||
|
 |
 |
April |
 |
May |
 |
|
 |
Cash sales |
$10,000 |
 |
$18,000 |
 |
|
 |
Credit sales |
28,900 |
 |
35,000 |
 |
|
 |
Total sales |
$38,900 |
 |
$53,000 |
 |
Â
c.       Credit sales are collected over a three-month period: 40% in the month of sale, 30% in the second month, and 20% in the third month. The sales collected in the third month are sub- ject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible.
Â
Â
Â
Â
Â
Â
d.      Inventory purchases average 64% of a month’s total sales. Of those purchases, 20% are paid for in the month of purchase. The remaining 80% are paid for in the following month.
e.       Salaries and wages total $11,750 per month, including a $4,500 salary paid to the owner.
f.       Rent is $4,100 per month.
g.       Taxes to be paid in June are $6,780.
The owner also tells you that he expects cash sales of $18,600 and credit sales of $54,000 for June. No minimum cash balance is required. The owner of the company doesn’t have access to short-term loans.
Required:
1.      Prepare a cash budget for June. Include supporting schedules for cash collections and cash payments.
2.      CONCEPTUAL CONNECTION Did the business show a negative cash balance for June? Suppose that the owner has no hope of establishing a line of credit for the business, what recommendations would you give the owner for dealing with a negative cash
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll