Question

A survey of Australian organisations on the degree of satisfaction with budgeting systems found that many...

  1. A survey of Australian organisations on the degree of satisfaction with budgeting systems found that many organisations (almost 40%) were negative about the value of their firm’s budgeting system. What are some possible reasons for this negativity about the value of budgeting systems? Given this negativity, should firms simply reduce their focus on budgets? Discuss.
  1. The following information has been obtained from the financial records of Albury Ltd, a retailer of cosmetic products:

Sales

Purchases

June

$60,000

$36,000

July

$78,000

$54,000

August

$66,000

$60,000

  • Receipts from customers are normally 70 percent in the month of sale, 20 percent in the month following the sale, and 9 percent in the second month following the sale. One percent of all sales are expected to be uncollectable.
  • All purchases are paid for in the month following the purchase.
  • Cash payments for expenses (other than purchases) are expected to be $14,400 for the month of August.
  • Albury’s cash balance on 1 August was $22,000.

Required

Prepare a cash budget for August that identifies the expected cash receipts, cash payments and ending cash balance on 31 August.

Homework Answers

Answer #1
Cash Budget for August
Opening Cash Balance        22,000
Add: Expected Cash Receipts*        67,200
Total Available Cash        89,200
Less: Expected Cash Payments for Purchases**        54,000 (Payment made for July Purchases)
Less: Expected Cash Payments for Others        14,400
Ending Cash Balance        20,800
Expected Cash Receipts*:
For August Sales(66000*70%)        46,200
For July Sales(78000*20%)        15,600
For June Sales(60000*9%)           5,400
Total        67,200
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following information is from Tejas WindowTint’s financial records. Month Sales Purchases April $ 81,000 $...
The following information is from Tejas WindowTint’s financial records. Month Sales Purchases April $ 81,000 $ 48,000 May 66,000 44,000 June 63,000 32,000 July 72,000 50,000 Collections from customers are normally 66 percent in the month of sale, 18 percent in the month following the sale, and 14 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 3 percent discount allowed on purchases...
The following information is from Barkley’s Auto Alarm Company financial records. Collections from customers are normally...
The following information is from Barkley’s Auto Alarm Company financial records. Collections from customers are normally 70 percent in the month of sale, 20 percent in the month following the sale, and 9 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 3 percent discount allowed on purchases paid for by the tenth of the following month. Purchases for December are budgeted at...
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are...
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 70 percent of their fees in the month the service is provided. In the month following service, Paul collects 25 percent of service fees. The final 5 percent is collected in the second month following service. Paul purchases his supplies on credit, and pays 50 percent in the month of purchase and the remaining 50 percent...
The following information is from White Mountain Furniture Showroom’s financial records. Month Sales Purchases July $...
The following information is from White Mountain Furniture Showroom’s financial records. Month Sales Purchases July $ 80,000 $ 42,000 August 68,000 47,000 September 67,000 35,000 October 86,000 53,000 Collections from customers are normally 67 percent in the month of sale, 20 percent in the month following the sale, and 11 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 3 percent discount allowed...
Jones company has sales of $400,000 in July and $500,000 in August. It’s purchases are $250,000...
Jones company has sales of $400,000 in July and $500,000 in August. It’s purchases are $250,000 in July and $300,000 in August. Accounts payable at the beginning of July are $110,000. All sales are for cash. Payments for purchases are paid for half in the month of purchase and half in the following month. Expenses for each month are the following; rent $10,000; depreciation, $4,000; Utilities, $1,000; sales salaries, 10% of sales; administrative expenses, 5% of sales. Prepare a cash...
E8-18 Preparing Cash Receipts and Cash Payments Budgets [LO 8-4] Martin Clothing Company is a retail...
E8-18 Preparing Cash Receipts and Cash Payments Budgets [LO 8-4] Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month Sales Purchases Cash Expenses Paid May $ 100,000 $ 60,000 $ 19,000 June 116,000 93,000 26,000 July 136,000 117,000...
Bennett Inc. found that about 45% of its sales during the month were for cash. Bennett...
Bennett Inc. found that about 45% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May. $ Calculate...
Bennett Inc. found that about 25% of its sales during the month were for cash. Bennett...
Bennett Inc. found that about 25% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May. $ Calculate...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected in the month of sale, 15% of sales on account are collected in the first month following the sale, 10% of sales on account are collected in the second month following the sale. Total budgeted sales in June ($40,000 of total sales are sales on account) $80,000 Total budgeted sales in July ($40,000 of total sales are sales on account) $95,000 Total budgeted sales...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected...
Company A developed the following budgeted data: Budgeted Sales…… 70% of sales on account are collected in the month of sale, 15% of sales on account are collected in the first month following the sale, 10% of sales on account are collected in the second month following the sale. Total budgeted sales in June ($40,000 of total sales are sales on account) $80,000 Total budgeted sales in July ($40,000 of total sales are sales on account) $95,000 Total budgeted sales...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT