please make a schedule cash budget using this information

PT AA prepares estimates of cash receipts and disbursements for the first 6 months of 2021 as follows: a. Estimated Acceptance Month Sales AR Other Revenue 4.000.000 5.000.000 7.300.000 9.600.000 8.000.000 9.000.000 January February March April May June 4.000.000 5.000.000 6.500.000 7.600.000 6.600.000 6.700.000 2.000.000 2.000.000 2.200.000 1.800.000 1.400.000 1.240.000 b. The estimated expenses are as follows: Double tap to add text Month Purchase Raw Labor Sales Expenses Administrative Material January February March April May June 6.000.000 6.000.000 5.000.000 5.500.000 6.000.000 6.000.000 2.500.000 2.500.000 2.000.000 2.500.000 2.500.000 3.000.000 2.000.000 3.000.000 2.000.000 2.000.000 2.500.000 2.300.000 3.500.000 3.500.000 4.000.000 4.000.000 4.000.000 4.200.000 c. Payment of income tax in March is IDR 1,000,000 Requested: From the data above, prepare a cash budget for the company. Solution: 1. Created an operating transaction at PT AA PT AA's 2021 first semester cash receipts and disbursements budget (in thousands of Rp) Double tap to add text Feb Jan Mar April June May Description Estimation income Cash Sales AR Collection Other Total Estimation Expenditures Purchase Raw Material Labour Sales Exp Adm Exp Tax Total Surplus (defisit) 4.000 4.000 2.000 10.000 6.000 2.500 2.000 3.500 0 14.000 (4.000) 5,000 5.000 2.000 12.000 6.000 2.500 3.000 3.500 0 15.000 (3.000) 7.300 6.500 2200 16.000 5.000 2.000 2.000 4.000 1.000 14.000 2.000 9.600 7.600 1.800 19.000 5.500 2.500 2.000 4.000 0 14.000 5.000 8.000 6.600 1,400 16.000 6.000 2.500 2.500 4.000 0 15.000 1.000 9.000 6.700 1.240 16.940 6.000 3.000 2.300 4.200 0 15.500 1.400 For the purposes of the schedule for receiving and paying loans and interest, the following additional data is required: Estimated cash balance at the end of December 2020 = IDR 1,000,000 Cash iron inventory is set at Rp. 500,000,- The loan from bank X is received at the beginning of the month and interest payments are made at the end of the month. Repayment of debts is made at the beginning of the month. Bank interest is set at month. 2% per The next step is to determine the amount of credit that will be requested for the months of January and February. The deficit in January is Rp. 4,000,000.- Cash iron inventory is set at Rp. 500,000. At the beginning of January, Rp. 1,000,000 cash is available. 2% credit interest must be paid at the end of the month. Then the amount of credit that will be requested is: 4,000,000+ 500,000 -1,000,000 + 2/100X = X X = 3,571,428,571,- . So if we borrow from the bank for IDR 3,571,428,571, then at the end of January the cash balance is equal to the iron stock. In this example, for example, the amount of credit requested from bank X for the month of January is Rp. 3,600,000 and for the month of February, Rp. 3,300,000. Part of the repayment of the credit will be made at the beginning of April in the amount of Rp. 2,000,000, - and the remaining Rp. 4,900,000, - paid at the beginning of May. Then make the schedule cash budget. PT AA prepares estimates of cash receipts and disbursements for the first 6 months of 2021 as follows: a. Estimated Acceptance Month Sales AR Other Revenue 4.000.000 5.000.000 7.300.000 9.600.000 8.000.000 9.000.000 January February March April May June 4.000.000 5.000.000 6.500.000 7.600.000 6.600.000 6.700.000 2.000.000 2.000.000 2.200.000 1.800.000 1.400.000 1.240.000 b. The estimated expenses are as follows: Double tap to add text Month Purchase Raw Labor Sales Expenses Administrative Material January February March April May June 6.000.000 6.000.000 5.000.000 5.500.000 6.000.000 6.000.000 2.500.000 2.500.000 2.000.000 2.500.000 2.500.000 3.000.000 2.000.000 3.000.000 2.000.000 2.000.000 2.500.000 2.300.000 3.500.000 3.500.000 4.000.000 4.000.000 4.000.000 4.200.000 c. Payment of income tax in March is IDR 1,000,000 Requested: From the data above, prepare a cash budget for the company. Solution: 1. Created an operating transaction at PT AA PT AA's 2021 first semester cash receipts and disbursements budget (in thousands of Rp) Double tap to add text Feb Jan Mar April June May Description Estimation income Cash Sales AR Collection Other Total Estimation Expenditures Purchase Raw Material Labour Sales Exp Adm Exp Tax Total Surplus (defisit) 4.000 4.000 2.000 10.000 6.000 2.500 2.000 3.500 0 14.000 (4.000) 5,000 5.000 2.000 12.000 6.000 2.500 3.000 3.500 0 15.000 (3.000) 7.300 6.500 2200 16.000 5.000 2.000 2.000 4.000 1.000 14.000 2.000 9.600 7.600 1.800 19.000 5.500 2.500 2.000 4.000 0 14.000 5.000 8.000 6.600 1,400 16.000 6.000 2.500 2.500 4.000 0 15.000 1.000 9.000 6.700 1.240 16.940 6.000 3.000 2.300 4.200 0 15.500 1.400 For the purposes of the schedule for receiving and paying loans and interest, the following additional data is required: Estimated cash balance at the end of December 2020 = IDR 1,000,000 Cash iron inventory is set at Rp. 500,000,- The loan from bank X is received at the beginning of the month and interest payments are made at the end of the month. Repayment of debts is made at the beginning of the month. Bank interest is set at month. 2% per The next step is to determine the amount of credit that will be requested for the months of January and February. The deficit in January is Rp. 4,000,000.- Cash iron inventory is set at Rp. 500,000. At the beginning of January, Rp. 1,000,000 cash is available. 2% credit interest must be paid at the end of the month. Then the amount of credit that will be requested is: 4,000,000+ 500,000 -1,000,000 + 2/100X = X X = 3,571,428,571,- . So if we borrow from the bank for IDR 3,571,428,571, then at the end of January the cash balance is equal to the iron stock. In this example, for example, the amount of credit requested from bank X for the month of January is Rp. 3,600,000 and for the month of February, Rp. 3,300,000. Part of the repayment of the credit will be made at the beginning of April in the amount of Rp. 2,000,000, - and the remaining Rp. 4,900,000, - paid at the beginning of May. Then make the schedule cash budget.