BUDGET TASKS Kusut-Kusut Company is a massage oil company that wants to make a budget for 2021. Massage oil is sold in 100 ml bottles at a price of IDR 120,000 per bottle. The existing data are as follows: a.Oil sales projections for next year are: Quarter 1 = 8,000 units Quarter 2 = 8,500 units Quarter 3 - 9,000 units 4th quarter 9,500 units b. Beginning oil inventory 7500 units, with estimated inventory at the end of the following year: 1st Quarter = 7000 2nd Quarter = 6000 3rd Quarter = 4500 4th Quarter = 2500 cEach unit of oil requires 2 raw materials, namely oil and spice concentrate. The composition per bottle is 100 ml of oil and 10 grams of spice concentrate. The price of raw material for oil is IDR. 200,000 per liter. The initial inventory of raw materials for oil is 50 liters. And ending inventory is budgeted at 50% of next quarter's production needs. Especially for the fourth quarter, ending inventory of raw materials for oil is 150 liters. The price of raw material for spice concentrates is IDR 1,000 per gram. Initial inventory of raw material for spice concentrate is 10,000 grams. And ending inventory is budgeted at 20% of next quarter's production needs. Especially for the 4th quarter, ending inventory of raw materials is 5000 grams. d. Each unit requires 0.2 hours of direct labor for production where workers are paid IDR. 20,000 per hour. e. Fixed overhead is the depreciation cost of production machines of IDR 2,000,000 per quarter and shophouse rental costs of IDR 58,000,000 per year, and variable overhead is budgeted at IDR 5000 per direct labor hour. f. There are 3 operational costs accounts: Salary fee of IDR 30 million per month Depreciation fee of IDR 50 million per quarter Utility costs (electricity, water, etc.) IDR 10 million per month 8. 80% of sales are made in cash and the rest is on credit which will be repaid in the following quarter. 4th quarter 2020 sales of IDR 750 million h. Purchases are made on credit where 75% is paid in the current quarter and the remainder in the following quarter. Purchase for the 4th quarter of 2020 for IDR 250 million 1.There is a purchase of equipment amounting to IDR 100,000,000 in the second quarter Loans are made in multiples of 25 million. And repayments are also made in multiples of 25 million k Loans are always made at the beginning of the quarter and repayments are always made at the end of the quarter 1. Interest on the loan is 12% per year and is only paid when there is repayment m. The IDR 25 million note payable was paid in the third quarter because it was due, and the IDR 2.5 million note payable interest was also paid at that time. n. 2020 tax of IDR 35 million paid in the second quarter of 2021 o. The company requires a minimum cash balance of IDR 100 million at the end of each quarter Is known: balance sheet 31 Dec 2020 75.000.000 500.000.000 20.000.000 279.000.000 874.000.000 Asset current assets Cash account receivable raw material inventory finished goods inventory amount of current assets Fixed assets : furniture equipment accumulated depreciation net fixed assets Total assets Liability and equity Current liabilities Accounts payable note payable Equity Capital Retained earning Total of Liabilities and Equities 500.000.000 1.000.000.000 -150.500.000 1.349.500.000 2.223.500.000 680.000.000 25.000.000 1.000.000.000 518.500.000 2.223.500.000 Order: Prepare a budget for PT. The messiness of 2021, both the operational budget and the financial budget II Is known: balance sheet 31 Dec 2020 Asset current assets Cash account receivable raw material inventory finished goods inventory amount of current assets Fixed assets : furniture equipment accumulated depreciation net fixed assets Total assets 75.000.000 500.000.000 20.000.000 279.000.000 874.000.000 500.000.000 1.000.000.000 -150.500.000 1.349.500.000 2.223.500.000 680.000.000 25.000.000 Liability and equity Current liabilities Accountspayable note payable Equity Capital Retained earning Total of Liabilities and Equities 1.000.000.000 518.500.000 2.223.500.000