In: Accounting
Cash Budget
Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following:
August | September | |||
Cash sales | $6,000 | $4,500 | ||
Credit sales | 59,000 | 62,000 | ||
Total sales | $65,000 | $66,500 |
Janet tells you that she expects cash sales of $5,000 and credit sales of $64,000 for October. She likes to have $3,000 on hand at the end of the month and is concerned about the potential October ending balance.
Required:
Prepare a cash budget for October. Include supporting schedules for cash collections and cash payments. Round your intermediate computations and final answers to the nearest dollar.
Wooster Sporting Goods Store | ||
Cash Budget | ||
For the Month of October | ||
Beginning cash balance | $ | |
Collections: | ||
Cash sales | ||
Credit sales: | ||
October | ||
September | ||
August | ||
Total cash available | $ | |
Disbursements: | ||
Inventory purchases: | ||
October | $ | |
September | ||
Salaries and wages | ||
Rent | ||
Taxes | ||
Other operating expenses | ||
Owner withdrawal | ||
Advertising | ||
Internet and telephone | ||
Ending cash balance | $ |
Particulars | Amount |
Collections | |
Cash at beginning of the month | 1110 |
Cash Sales | 5000 |
Credit Sales | |
October | 25600 |
September | 22320 |
August | 12980 |
Total Cash Available (A) | 67010 |
Disbursement | |
Inventory Purchases | |
October | 21735 |
September | 25603 |
Salaries and wages | 3850 |
Rent | 3150 |
Taxes | 1635 |
Other operating Expenses | 3800 |
Owner withdrawal | 3500 |
Advertising | 1500 |
Internet and telephone | 320 |
Total Disbursal (B) | 65093 |
Ending Cash Balance (A-B) | 1917 |
Note1: Calculation of October Credit Sales ( 40 % of 64000) i. e 25600
September's credit sales received in October: (36 % of 62000) i.e 22320
Credit sale of August received in October :( 22% of 59000) i.e 12980
Note 2: October's Credit Purchase= . 70 x. 45 x 69000= 21735
September's credit purchase to be paid in October= .70 x. 55 x 66500 = 25603
Janet wants to have closing cash balance of $3000 closing cash balance as per cash budget is $1917 so the expected shortfall is $ 1083.