find cash budget

Question 3. (20 marks) Alco Inc. deals in wooden bars and had following sales revenue: Month Jan Feb Mar Apr May Jun Sales Revenue 132,000 168,000 149,000 155,000 161,000 177,000 The company charges 20% margin on the purchase price of the goods. The balance of inventory as at January 01 was $78,000 and at June 30 was $56,500. The purchases made were paid 50% in the month of purchases, 25% in the next month, and 25% in the following month