I need help to make the following Budgets for sales (cash collections), the budget for production, and the budget of direct materials (cash disbursements). For the period ending 31st December.

Below is the data regards the production process of a manufacturing company:

- Managers forecasts of sales in the three following months (October, November, and December) are

68.000, 60.000, and 65.000 liters. The selling price is 5 per liter.

- All sales are on account. The Companys collection pattern is: 70% collected in the month of sale, 26% collected in the following month, and 4% uncollectible. Receivables available at the end of September are 70.000 (they will be collected in full);

-Materials ending stocks have to be equal to 10% of the following months production needs

(September ending stocks: 2.000 KG). Quarter-ending stocks should be 2.600 KG.

- Products ending inventory has to be equal to 15% of the months budgeted sales in units (September

ending stocks: 5.000 liters);

- Each liter to be produced requires 0,7 KG of direct materials and the price of direct materials is 0,5

per KG.

- Months purchases of direct materials are fully paid in the following month.