I need help to make the following Budget for sales or cash collections, production budget, direct materials, cash disbursements, and budgeted Income Statement and Balance Sheet. For the period ending 31st December: I will rate you thank you.

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, respectively. 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.

To prepare the Master Budget (Income Statement and Balance Sheet) consider the following additional data:

-The cost of goods sold is 2,50 per liter;

- Quarters ending cash balance is 25.000;

-Selling and administrative expenses in the following three months are 90.000, 98.000, and 92.000. All selling and administrative expenses are cash expenses.

- On December 31 the company shall report the following data:

- Equipment: 200.000

- Plant: 150.000

- Share capital: 250.000

- Retained earnings: 10.66