Payal Plastics Company

Payal Plastics Company (PPC) is engaged in the manufacture of plastic-based products for
home us. The company is located in Faridabad in Haryana. It is one of the leading
suppliers of plastic products in the markets of Haryana, Punjab and Delhi. In recent years
the competition has intensified and many small&#39; manufacturers have entered the market. PPC
has been able to face the competition on the strength of the quality and price of its
products. In spite of high competition, it has grown rapidly.

PPC is a profitable company, but it has been facing liquidity problem for a couple of
years. The company has defaulted in paying its obligations and has stretched payment to its
creditors. This has affected company’s creditworthiness. The company management is
worried that the frequent stretching of credit payments might cause suppliers to demand cash
payments for purchases. The managing director, therefore, wants the finance manager to
prepare a cash budget and make a plan for meeting a deficit situation.

The finance manager set to develop a monthly cash budget for the period starting from
April 2019 to September 2019. She obtained the actual sales figures from the records of the
last three months, and based on the past trends and future market prospects, developed the
sales forecasts as shown below:

Actual Sales (Rs. Lakhs) Sales

Forecast (Rs. Lakhs)
January 240 April 260
February 280 May 210
March 320 June 160
July 240
August 200
September 160
October 200

Of the total sales, PPC&#39;s cash sales are 20% and credit sales 80%. The company&#39;s credit terms
are 30 days. But it is able to collect only about 50% of the accounts receivables in the
first month after sales. About 30% collections take place in the second month after
the sales and the remaining in the third month of sales.

PPC&#39;s products require a very heavy use of material. The average consumption of raw
material is 70% of sales. The company buys 60% of the materials required for the next
month m the previous month. Suppliers’ credit terms are 30 days. But the records show
that the company pays for 60% of purchases in a month, 20% in two months and the
remaining in three months. The following payments are expected for wages and
salaries:

Month (Rs.

Lakhs) Month (Rs.
Lakhs)
April 42 July 40
May 39 August 32
June 32 September 28

The fixed and variable general administrative and marketing expenses are
estimated to be about Rs. 2.5 lakh per month and 5% of sales, respectively.
Power and fuel expenses are expected to be 4% of sales and depreciation Rs. 12
lakh per month. The company has planned a capital expenditure of
Rs.70 lakh, of which 50% will be paid in May and the remaining in June. On a Rs. 20
lakhs borrowing, half­ yearly interest at 16% annual rate is to be paid in the month
of June. A tax payment on the previous year&#39;s profit of Rs.2.5 lakh is due in April. The
financial manager estimated that PPC&#39;s tax liability for the year is expected to be Rs.
24 lakhs, which is payable in equal instalments in March, June, September and
December. The company is expected to have cash and bank balance of Rs.140,000 in
the beginning of April.

After collecting the information. about cash flows, the finance manager created an Excel file
by classifying each item of cash flows systematically into cash receipts and payments. Her
concern was that as and when any change in sales or collection experience is made the cash
flow forecasts should automatically get updated.

Discussion Questions
1. Prepare a Cash Budget for PPC and Provide an explanation for the results.
2. Assume Sales forecasts are off by +/- 10%. What are the implications? Show
calculations (revised cash budgets)