hoe to answer this question

GameX Inc. manufactures and sells gaming keyboards that are targeted at active video garners. The keyboards are sold for RM41.50 each. With the recent downturn in the Malaysian economy. the selling price of the product will be reduced by 6% starting in 2023. GameX's projected sales for the year 2023 are as follows: September The company also projected that they would be able to sell a total of 30,200 in the first quarter of 2024. The balance of account receivable is expected to be RM45,670 at the beginning of the year 2023. Based on experience, 30% of the company's sales are on a cash basis. On average, 80% ol the account receivables will be collected in the quarter of the sales; 15% in the first quarter after the sale; 3% in the second quarter after the sale: and 2% will be unoollectible. The company's poticy is to have ending inventory of nished goods equal to 17% of the next quarter's sales. The main materials in the production of the keyboard are plastic. flexible rubber, and electronic circuits. It is estimated that the cost of purchasing these materials amounted to 40% of each quarter's sales amount. The company normally pays for the purchases 75% in the quarter in which the purchase is made. 15% in the next quarter, and 10% in the following quarter. The balance of account payable at the end of quarter 4 2022 is expected to be RM178,440. Finished goods require 2 hours and 24 minutes to complete, and dired labour is paid at RM5.60 per hour. The manufacturing overhead incurred by the company is 35% of each quarter's purchases. Other operating expenses payable monthly are: administrative expense of RM10,500; marketing. selling and distribution expense of RM8,400. Included in the administrative expense is a depreciation expense of RM1,000 per month. The company will receive interest at 5% on a fixed deposit of RMSSODOO in the month of March. In addition. the company also plans to increase BHEABPNm-OU CONFIDENTIAL APRIL2022IPBI. ASSIGNMENTIPMAM 43 its production capacity by acquiring a new production machine costing RM250,000. The deposit of 10% will be paid in April. and the instalment of RM5.500 per month will be paid starting from the month of May. Management of the company would like to have a cash balance ct at least RM25.000 at the beginning of each quarter for contingencies. Therefore. an agreement with a local bank has been made so that the company can borrow in increments of RM5.000. with a maximum amount of RM60,000 in the event at cash deficiencies at a rate of 6% per annum. However, the borrowed amount will be paid as soon as the company has enough money to make a full setttement of the amount. The beginning cash balance in the first quarter is estimated to be RM89,500. Required: Prepare the sales budget. production budget, direct labor budget, schedule of cash collection, schedule of cash disbursement for materials. and cash budget for each quarter and for the year 2023 in total. (30 points) (Note: show all the calcutations and round off your answer.)