Problem:
Consider the income statement illustrated below:
The cash balance may 31 2004 is $15000, Sales proceeds are collected as follows: 80% month of sale, 10% second month, 10% third month
Accounts receivable are $40000 on May 31, 2004, consisting of $16000 from April sales and $24,000 from May sales.
Accounts payable on May 31, 2004, are $145,000 Raleigh Company pays 25% of purchases during the month of purchase and the remainder during the following month. All operating expenses requiring cash are paid during the month of recognition. Insurance and property taxes are paid annually in December, however.
Prepare a cash budget for June. Confine your analysis to the given data. Ignore income taxes and other possible items that might affect cash
| Sales |
|
|
$ 200 |
| Inventory, May 31 |
$ 50 |
|
| purchases |
|
192 |
|
| available for sale |
|
242 |
|
| inventory, june30 |
|
40 |
|
| cost of goods sold |
|
202 |
| Gross profit |
|
|
88 |
| operating expenses |
|
|
| wages |
|
36 |
|
| utilities |
|
5 |
|
| advertising |
|
10 |
|
| depreciation |
|
1 |
|
| office expenses |
|
4 |
|
| insurance and property taxes |
3 |
59 |
| operating income |
|
|
$29 |