Gucker & Renney Academic Supply presented the following budgeted information to
ID: 2417208 • Letter: G
Question
Gucker & Renney Academic Supply presented the following budgeted information to prepare their November Cash Budget:
Oct
Nov
Dec
Sales
$110,000
$130,000
$180,000
Merchandise purchases
$ 85,000
$ 92,000
$105,000
Selling & Admin Expenses
$ 50,000
$ 50,000
$ 50,000
Cash Budget assumptions: All sales are on credit and are collected 40% in the month of the sale, 59% in the month following the sale, with 1% uncollectible (but still owed). Merchandise purchases are paid in full the month following the month of purchase. The monthly selling and administrative expenses include $8,000 of depreciation expense relating to display fixtures and warehouse equipment. All other selling and administrative costs are paid in cash in the month incurred. Management requires a minimum cash balance of $14,000. Any amount below this will be borrowed, using a bank credit line, but all bank borrowings must be in whole increments of $1,000. All borrowings are made at month-end. Ignore any bank interest expense charges.
a) Prepare a Cash Budget for the month of November only, showing all details. The company expects to have $15,000 of cash on hand November 1st.
November 1st Beginning Cash Bal
$15,000
Note: Show your calculations in this column
(the # of rows shown is generic).
Ending Cash Balance at Nov 30th
b) What would be the Accounts Payable balance (relating to purchases) at the end of November?
c) You MUST show/label your work for any credit!
When preparing a budgeted ending December 31st Balance Sheet, what would be the Accounts Receivable ending balance? Assume there are no uncollectible accounts at the September 30th Balance Sheet date.
Oct
Nov
Dec
Sales
$110,000
$130,000
$180,000
Merchandise purchases
$ 85,000
$ 92,000
$105,000
Selling & Admin Expenses
$ 50,000
$ 50,000
$ 50,000
Explanation / Answer
Cash budget for the month of November:
Particulars Amount
Opening balance 15,000
Sales 116,900 [ 110,000*59% + 130,000*40% ]
Merchandise purchases (85,000) [October purchases paid ]
Selling & Admin expenses (42,000) [ 50,000- 8,000 depreciation being non cash item ]
Closing cash balance before bank loan 4,900
Bank Loan for deficit amount 10,000 [$9,100 round up to next thousand ]
Cash balance available at November end 14,900 [ Target 14,000 maintained ]
b) Accounts payable balance at the end of November = $92,000 [ Since, until October payments are cleared ]
C) Accounts receivable at December end = December sales * 59% + [ Oct to Dec sales]* 1% uncollectible
= 180,000*0.59 + [110,000+ 130,000+ 180,000] *0.01
= 106,200+ 4,200
= $ 110,400
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.