Cash $12,060 Accounts receivable 22,970 Inventory 36,620 Property, plant, and equipment, net of depreciation 123,100 Accounts payable 23,010 Common stock 153,200 Retained earnings 12,070 Additional information concerning Cullumber Inc. is as follows. 1. Gross profit is 26% of sales. 2. Actual and budgeted sales data: March (actual) April (budgeted) $48,000 73,300 3. 4. Sales are both cash and credit. Cash collections expected in April are: March April $19,200 (40% of $48,000) 43,980 (60% of $73,300) $63,180 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte Purchases March Purchases April $23,010 28,850 $51,860 5. Cash operating costs are anticipated to be $12,650 for the month of April. 6. Equipment costing $2,620 will be purchased for cash in April. 7. The company wishes to maintain a minimum cash balance of $12,780. An open line of credit is available at the bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate is 14% per year, and interest expense is accrued at the end of the month and paid in the following month.

Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter15: Capital Investment Analysis
Section: Chapter Questions
Problem 15.5.1MBA
icon
Related questions
Question

prepare cash budget for the month

Cash
$12,060
Accounts receivable
22,970
Inventory
36,620
Property, plant, and equipment, net of depreciation
123,100
Accounts payable
23,010
Common stock
153,200
Retained earnings
12,070
Additional information concerning Cullumber Inc. is as follows.
1.
Gross profit is 26% of sales.
2.
Actual and budgeted sales data:
March (actual)
April (budgeted)
$48,000
73,300
3.
4.
Sales are both cash and credit. Cash collections expected in April are:
March
April
$19,200
(40% of $48,000)
43,980
(60% of $73,300)
$63,180
Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte
Purchases March
Purchases April
$23,010
28,850
$51,860
5.
Cash operating costs are anticipated to be $12,650 for the month of April.
6.
Equipment costing $2,620 will be purchased for cash in April.
7.
The company wishes to maintain a minimum cash balance of $12,780. An open line of credit is available at the bank. All
borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate
is 14% per year, and interest expense is accrued at the end of the month and paid in the following month.
Transcribed Image Text:Cash $12,060 Accounts receivable 22,970 Inventory 36,620 Property, plant, and equipment, net of depreciation 123,100 Accounts payable 23,010 Common stock 153,200 Retained earnings 12,070 Additional information concerning Cullumber Inc. is as follows. 1. Gross profit is 26% of sales. 2. Actual and budgeted sales data: March (actual) April (budgeted) $48,000 73,300 3. 4. Sales are both cash and credit. Cash collections expected in April are: March April $19,200 (40% of $48,000) 43,980 (60% of $73,300) $63,180 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte Purchases March Purchases April $23,010 28,850 $51,860 5. Cash operating costs are anticipated to be $12,650 for the month of April. 6. Equipment costing $2,620 will be purchased for cash in April. 7. The company wishes to maintain a minimum cash balance of $12,780. An open line of credit is available at the bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate is 14% per year, and interest expense is accrued at the end of the month and paid in the following month.
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning