Quagmire Inc. has prepared the following sales budget for the quarter of April,
ID: 2436299 • Letter: Q
Question
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:
All of the sales are on credit.
Quagmire collects from customers as follows:
40% of sales in the month of sale
25% in the month following the sale, and
35% in the second month following the sale.
Quagmire expects cost of goods sold to be 60% of sales.
They keep 10% of next months expected cost of goods sold in ending inventory. Below are budgeted purchases of inventory.
All purchases are paid for in the SAME month as the purchase.
Below is the budget for variable and fixed selling and administrative expenses.
Selling and admin expenses are paid in the month AFTER they are incurred.
Fixed expenses include depreciation of 13500 each month.
Quagmire has $185000 of cash on hand at he beginning of May.
Prepare a cash budget for May and June. (Use excel so that multiple attempts are easier.)
1. Compute the beginning balance in cash for June.
2. Compute the ending balance in cash for June.
Explanation / Answer
Answers
May
June
Beginning Cash balance
$ 185,000.00
$ 135,320.00
Cash receipts
$ 387,900.00
$ 359,100.00
Total Cash available
$ 572,900.00
$ 494,420.00
Cash paid for purchases
$ 254,880.00
$ 210,600.00
Selling & admin expenses:
Variable
$ 61,200.00
$ 86,400.00
Fixed (exc; depreciation)
$ 121,500.00
$ 121,500.00
Total Cash payments
$ 437,580.00
$ 418,500.00
Ending Cash balance
$ 135,320.00
$ 75,920.00
May
June
Beginning Cash balance
$ 185,000.00
$ 135,320.00
Cash receipts
$ 387,900.00
$ 359,100.00
Total Cash available
$ 572,900.00
$ 494,420.00
Cash paid for purchases
$ 254,880.00
$ 210,600.00
Selling & admin expenses:
Variable
$ 61,200.00
$ 86,400.00
Fixed (exc; depreciation)
$ 121,500.00
$ 121,500.00
Total Cash payments
$ 437,580.00
$ 418,500.00
Ending Cash balance
$ 135,320.00
$ 75,920.00