CH is a building supplies company that sells products to trade and private customers. Budget data for each of the six months to March are given below:

Eighty percent of the value of credit sales is received in the month after sale, 10 percent two months after sale and 8 percent three months after sale. The balance is written off as a bad debt.Seventy five percent of the value of credit purchases is paid in the month after purchase and the remaining 25 percent is paid two months after purchase. All other operating costs are paid in the month they are incurred. CH has placed an order for four new forkflift trucks that will cost $25 000 each. The scheduled payment date is in February. The cash balance at 1 January is estimated to be $15 000.

Required:Prepare a cash budget far each of the THREE months of January, February and March.

Transcribed Image Text:

Dec Nov Feb March Oct Jan $000 $000 $000 $000 $000 $000 Credit sales Cash sales Credit purchases Other operating costs (excluding depreciation) 250 250 250 260 260 280 65 90 170 180 180 200 200 200 80 60 60 75 90 90 122 123 123 90