Question: SECTION B Answer any TWO questions Question 2 (Cash Budget) Munchkin Ltd (ML) is a rapidly growing company which produces luxury food for up-

SECTION B Answer any TWO questions Question 2 (Cash Budget) Munchkin Ltd (ML) is a rapidly growing company which produces luxury food for up- market cat owners. The owner and director, Mr Patel, is trying to produce a cash flow forecast to ensure he can afford to invest in a brand-new cat food machine that will be installed in his factory in Northern Ireland. The purchase of the cat food machine will cost 150,000, and Mr Patel intends to buy it for cash in March. ML has retail customers from its own private shop as well as large supermarket contracts. These customers pay by cash or credit. On average 20% of customers pay by cash while the remaining customers pay by credit. Of the credit customers, one quarter pay in the current month and the remaining three quarters of credit customers pay one month after sale. As Mr Patel believes the root of his success is his ingredients in the food, he ensures he keeps good relations with the suppliers and tries to pay them in the month of purchase. In reality, he pays 80% in the month of purchase and the balance one month after the purchase. The extension of credit for those he pays one month late carries an additional interest charge of 2% on the balance which is paid at the same time. Months Sales Purchases Expenses January 100,000 55,000 16,000 February 120,000 60,000 13,000 March 200,000 80,000 14,000 April 250,000 100,000 15,000 Within expenses Mr Patel includes 5,000 per month of salary costs, which are paid at the end of month in which they are incurred. The remaining expenses are paid one month after they are incurred and includes depreciation of 1,000 per month. The deprecation relates to a retail van which was bought at 34,000 (cost). It is depreciated monthly on a straight-line basis. On 1 February ML has an opening overdraft balance of 20,000 and an approved overdraft limit of 35,000. QUESTION CONTINUES ON NEXT PAGE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
