P21-22A Clipboard Office
Supply’s sales are 75% cash and 25% credit. (Use the rounded sales values.)
Credit sales are collected in the month after sale. Inventory purchases are
paid 25% in the month of purchase and 75% the following month. Salaries and
sales commissions are also paid half in the month earned and half the next
month. Income tax is paid at the end of the year. The April 30, 2011, balance
sheet showed the following balances:
cash $25000
accounts payable
$53000
Salaries and commissions
payable $2500
Requirements
R1. Prepare schedules of (a) budgeted cash collections, (b)
budgeted cash payments for purchases, and (c) budgeted cash payments for
operating expenses. Show amounts for each month and totals for May and June. Round
your computations to the nearest dollar.
Prepare a cash
budget. If no financing activity took place, what is the budgeted cash balance
on June 30, 2011?
TUTORIAL PREVIEW
Req. 1
|
Clipboard
Office Supply
|
||||
|
Budgeted
Cash Collections from Customers
|
||||
|
For
May and June 2011
|
||||
|
|
|
May
|
June
|
Total
|
|
Cash sales
|
|
$38,250
|
$39,150
|
|
|
Collections of last month's credit sales
|
|
12,500
|
12,750
|
|
|
Total cash collections
|
$50,750
|
$51,900
|
$102,650
|
|
File name: P21-22A Clipboard Office Supply.xls File type: .xls PRICE: $12
