FMP 3

Mandeville Compamy's sales forecast for the first four months of 2022 are as follons: Additional information provided is as follows: (i) Sales for December 2019 were $50,000. (ii) Seventy percent (70%) of sales will be for cash, while the remaining 30% will be collected in the first month following the sale. (iii) Raw material is purchased each month at 60% of the current month's sales. The supplier is paid a month after delivery. For example, purchases for January are based on expected sales for January and payment is made a month after in February: (iv) Wages is $6,500 per mouth. (v) Other expense is $4,500 each month. (ti) Mandeville Co ordered equipment costing $15,800 in Jamuary. A 40% deposit will be made at ordering and the balance paid a month later. (vii) Tares will be paid on March 31: $7,250 (viii) Mandeville Company's eash balance on 31 December 2018 was $10,000; and will be the minimum balance applied going forward. (ix) Short-term credit is arranged at an interest rate of 12 percent per aunum ( 1 percent per month) to be paid monthly. The intereat on any short-term borrowing is paid in the month after it is incurted. Required: Use the information above to prepare the cach budget for Mandeville Company covering January to Apni 2022