Please use the below table format to answer.

2. 2 Cash budget: Prepare a Cash Budget. (month by month) with below format. Note the following: i. Cash sales is 80% and credit sales is 20% to be received 1 month later ii. Cash purchases is 70% and credit purchases is 30% to be received 1 month later iii. All expenses is expected to increase by 10% every 3 months MIKE SPORT SHOES SDN BHD is planning to buy a machine in January worth RM 230,000 and a vehicle in March for RM 60,000 using cash. The owner will put in RM 350,000 in the bank in January to start the business. The owner is planning to withdraw monthly RM500 to pay his personal expenses starting in March. iv. V. vi. (0) 12 Month Sales Plan Jan Feb Mar April May June July Aug Sep Oct Nov Dec Total Unit 500 550 535 520 490 510 550 600 605 580 600 620 6.6K Price (RM) 250 250 250 250 250 250 250 250 250 250 250 250 3K Sales(RM) 125 K 137 5K 133 130 .75 K K 122. 5K 127. 5K 137. 150 5K 151. 25K 145 K 150 K 155 1665 K K 12 Month Production Plan - Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec Total Unit 520 560 530 525 500 505 555 600 610 580 590 620 6.69 5K 150 150 150 150 150 150 150 150 150 150 150 150 1.8K Cost per Unit (RM) 87K 93K Production 78K 84K costs(RM) 79.5 K 78.7 75K 5K 75.7 5K 83.2 90K 5K 91.5 88.5 1004 .25K Jan-Dec 2021 RM Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total RECEIPTS Cash Sales Credit Sales Capital 2,000 1,300 1,000 2500 TOTAL RECEIPTS (A) PAYMENTS Cash Purchases Credit Purchases Transport charges Fixed Asset Purchases Rent/Rates Insurance Utilities Telephone Wages Forklift rental Advertising Drawings TOTAL PAYMENTS (B) NET CASHFLOW (A-B) O/Bal Bank CI/Bal Bank 500 1,2000 1,000 250