Tutorial 1 1. Kilang Roti Berhad, a manufacturer of traditional breads in Port Dickson, is preparing monthly cash budgets for the month of January, February and March 2018. The following data are available from records of the company: January February March RM RM RM Sales 100,000 150,000 200,000 Raw materials purchases 50,000 70,000 100,000 Wages 35,000 55,000 Manufacturing overhead costs 10,000 10,000 10,000 Selling and administration 5,000 5,000 5,000 The company has the following business policies: Collections of cash from customers are expected to be 75% of the sales in the month of sale and 25% in the month following the sale. The company pays cash for 80% of the raw materials purchases in the month of purchase and the balance is due in the month following the purchase. All other items besides these two are paid cash in the month they are incurred. Other relevant data are as follows: Sales: December 2017: RM110,000 Purchases of raw materials: December 2017: RM 55,000. Other receipts: January, 2018: Cash Dividend received, RM25,000 March, 2018: Cash receipts from sale of used equipment, RM30,000 Other payments: 20,000 February, 2018: payment of debt: RM 50,000 August, 2018: Cash purchase of a new equipment for RM70,000. The company proposed to pay cash dividend of RM 20,000 in March, 2018. Closing Cash balance as at December 31, 2018 is estimated at RM55,000. Required: a) Prepare a Cash Budget for Kilang Biskut Berhad for the month of January, February and March 2018. b) Analyze the Cash Budget for the month of March, 2018