Reference no: EM132673591

All sales are on credit and past records indicate that collections are as follows: 20% in the month of sale, 55% in the month after sale and 25% in the second month after sale. Labour and materials are paid as follows: 60% in the month the expenses are incurred and 40% in the month following that.

Other budgeted expenses during the period July to December are as follows: selling, general and administration of $30,000 per month; rent of $10,000 per month; and depreciation of $20,000 per month. Where relevant, payments are made in the month the expenses are incurred. Taxation payments of $33,000 each will be made at the end of September and end of December. In October, company motor vehicles will be traded-in for new models with an expected net cash payment of $80,000. The motor vehicles are expected to have an 8 year life. The cash balance at 1 July is $10,000.

Required:

Problem (a) Make a cash budget for the company for July through to December (inclusive)