Answer Happy

Senja Nan Merah hopes that 2022 will bring new light in the business world after being badly affected by the fall in sales in 2021 as a result of the implementation of the Movement Control Order (PKP). However, after a month of operation in July 2022, Senja Nan Merah found that most buyers began to rationalize in their spending. The increase in the prices of most essential goods in the market has caused most customers to start reconsidering their spending for the purpose of frugality. As a result, Nan Merah Twilight sales began to fall. Therefore, Senja Nan Merah has decided to re-project its sales revenue for August 2022 to December 2022. Monthly merchandise inventory purchases are reduced by 60% from the original amount previously planned starting in August 2022 and for subsequent months up to December 2022. The re-projected sales revenue for Senja Nan Merah for August to December 2022 is as follows: Month Sales (RM) July 65'000 August 90'000 September 85000 October 75 000 November 118000 December 135'000
Payment for the purchase of inventory of such merchandise is made in the month in which the purchase is made Senja Nan Merah pays RM9,000 per month for business premises rental expenses and another RM22,000 for various other related expenses. The tax payment amounts to RM19,500 and is paid by Senja Nan Merah on a quarterly basis, starting in March.
The following is additional relevant information: 1. The owner of the shop lot rented by Senja Nan Merah has agreed to give a deduction of 20% from the original rental rate for the monthly rental of the business premises for 3 months starting from August until October 2022. ii. Incentives from the government are expected to help Senja Nan Merah Save various other expenses by 20% every month starting in August 2022. iii. Senja Nan Merah got permission for tax payment deferment until December 2022. iv. The minimum cash balance requirement of RM25,000 per month has now been reduced to only RM20,000 starting August 2022. If the minimum cash balance requirement cannot be met companies can obtain short-term cash financing facilities from banks at 12% per annum. QUESTION Based on the information provided, re-prepare the cash budget for Senja Nan Merah starting from August to December 2022 taking into account all the changes that have taken place.