please show complete solution

Problem 3 Assumptions: 1. Revenues for the first five months of the year are as follows: MONTH REVENUES JANUARY 1,000,000 FEBRUARY 900,000 MARCH 800,000 APRIL 600,000 MAY 500,000 2. Of the total sales transactions, 50% will be received in cash, while the other 50% will be collected after one month. 3. Purchases for the first five months of the year are as follows: MONTH PURCHASES JANUARY 300,000 FEBRUARY 200,000 MARCH 300,000 APRIL 100,000 MAY 100,000 4. All purchases are paid in cash. 5. Other monthly expenses are payment of rent, office supples, and salaries amounting to 10,000, 30,000, and 20,000 correspondingly. 6. Beginning cash 100,000. Required: Prepare the cash budget for BTS Inc