Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

Payal Plastics Company Payal Plastics Company (PPC) is engaged in the manufacture of…

  1. User

    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' 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's cash sales are 20% and credit sales 80%. The company'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'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's profit of Rs.2.5 lakh is due in April. The financial manager estimated that PPC'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)
  2. Assistant
    1. Cash Budget for PPC:

    The cash budget for PPC for the period starting from April 2019 to September 2019 is as follows:

    Cash Receipts: April: Cash Sales: 260,000 x 0.2 = 52,000 Collection from Credit Sales (January): 240,000 x 0.5 = 120,000 Total Cash Receipts in April = 52,000 + 120,000 = 172,000

    May: Cash Sales: 210,000 x 0.2 = 42,000 Collection from Credit Sales (February): 280,000 x 0.3 = 84,000 Collection from Credit Sales (March): 320,000 x 0.3 = 96,000 Total Cash Receipts in May = 42,000 + 84,000 + 96,000 = 222,000

    June: Cash Sales: 160,000 x 0.2 = 32,000 Collection from Credit Sales (April): 260,000 x 0.3 = 78,000 Collection from Credit Sales (May): 210,000 x 0.3 = 63,000 Total Cash Receipts in June = 32,000 + 78,000 + 63,000 = 173,000

    July: Collection from Credit Sales (June): 160,000 x 0.5 = 80,000 Total Cash Receipts in July = 80,000

    August: Collection from Credit Sales (July): 240,000 x 0.5 = 120,000 Total Cash Receipts in August = 120,000

    September: Collection from Credit Sales (August): 200,000 x 0.5 = 100,000 Total Cash Receipts in September = 100,000

    Cash Payments: Raw Material Purchases: (70% of Sales) April: 260,000 x 0.7 = 182,000 May: 210,000 x 0.7 = 147,000 June: 160,000 x 0.7 = 112,000 July: 240,000 x 0.7 = 168,000 August: 200,000 x 0.7 = 140,000 September: 160,000 x 0.7 = 112,000

    Payments to Suppliers: April: 182,000 x 0.6 = 109,200 May: 147,000 x 0.2 = 29,400 June: 112,000 x 0.2 = 22,400 July: 168,000 x 0.2 = 33,600 August: 140,000 x 0.2 = 28,000 September: 112,000 x 0.2 = 22,400

    Wages and Salaries: April: 42,000 May: 39,000 June: 32,000 July: 40,000 August: 32,000 September: 28,000

    General Administrative Expenses: 2.5% of Sales April: 260,000 x 0.025 = 6,500 May: 210,000 x 0.025 = 5,250 June: 160,000 x 0.025 = 4,000 July: 240,000 x 0.025 = 6,000 August: 200,000 x 0.025 = 5,000 September: 160,000 x 0.025 = 4,000

    Marketing Expenses: 5% of Sales April: 260,000 x 0.05 = 13,000 May: 210,000 x 0.05 = 10,500 June: 160,000 x 0.05 = 8,000 July: 240,000 x 0.05 = 12,000 August: 200,000 x 0.05 = 10,000 September: 160,000 x 0.05 = 8,000

    Power and Fuel Expenses: 4% of Sales April: 260,000 x 0.04 = 10,400 May: 210,000 x 0.04 = 8,400 June: 160,000 x 0.04 = 6,400 July: 240,000 x 0.04 = 9,600 August: 200,000 x 0.04 = 8,000 September: 160,000 x 0.04 = 6,400

    Depreciation: 12,00,000 / 6 = 2,00,000

    Capital Expenditure: May: 70,00,000 x 0.5 = 35,00,000 June: 70,00,000 x 0.5 = 35,00,000

    Interest Expense: June: 20,00,000 x 0.08 = 1,60,000

    Tax Payments: April: 2,50,000 June: 24,00,000 x 0.25 = 6,00,000 September: 24,00,000 x 0.25 = 6,00,000

    Beginning Cash Balance (April): 1,40,000

    Using the above information, we can prepare the cash budget by listing the cash inflows (receipts) and cash outflows (payments) for each month, and then calculating the ending cash balance after accounting for all the inflows and outflows.

    Cash Receipts (in Rs.): April: 172,000 May: 222,000 June: 173,000 July: 80,000 August: 120,000 September: 100,000

    Cash Payments (in Rs.):

    April: Raw Material Purchases: 182,000 Payment to Suppliers: 109,200 Wages and Salaries: 42,000 General Administrative Expenses: 6,500 Marketing Expenses: 13,000 Power and Fuel Expenses: 10,400 Depreciation: 2,00,000 Tax Payment: 2,50,000 Total Cash Payments in April: 5,13,100

    May: Raw Material Purchases: 147,000 Payment to Suppliers: 29,400 Wages and Salaries: 39,000 General Administrative Expenses: 5,250 Marketing Expenses: 10,500 Power and Fuel Expenses: 8,400 Capital Expenditure: 35,00,000 x 0.5 = 17,50,000 Total Cash Payments in May: 23,38,550

    June: Raw Material Purchases: 112,000 Payment to Suppliers: 22,400 Wages and Salaries: 32,000 General Administrative Expenses: 4,000 Marketing Expenses: 8,000 Power and Fuel Expenses: 6,400 Depreciation: 2,00,000 Capital Expenditure: 35,00,000 x 0.5 = 17,50,000 Total Cash Payments in June: 20,24,800

    July: Raw Material Purchases: 168,000 Payment to Suppliers: 33,600 Wages and Salaries: 40,000 General Administrative Expenses: 6,000 Marketing Expenses: 12,000 Power and Fuel Expenses: 9,600 Total Cash Payments in July: 2,69,200

    August: Raw Material Purchases: 140,000 Payment to Suppliers: 28,000 Wages and Salaries: 32,000 General Administrative Expenses: 5,000 Marketing Expenses: 10,000 Power and Fuel Expenses: 8,000 Total Cash Payments in August: 2,23,000

    September: Raw Material Purchases: 112,000 Payment to Suppliers: 22,400 Wages and Salaries: 28,000 General Administrative Expenses: 4,000 Marketing Expenses: 8,000 Power and Fuel Expenses: 6,400 Capital Expenditure: 35,00,000 x 0.5 = 17,50,000 Tax Payments: 24,00,000 x 0.25 = 6,00,000 Total Cash Payments in September: 23,31,800

    Ending Cash Balance (in Rs.): April: 1,40,000 + 172,000 - 5,13,100 = 99,900 May: 99,900 + 222,000 - 23,38,550 = 1,83,350 June: 1,83,350 + 173,000 - 20,24,800 = 1,36,550 July: 1,36,550 + 80,000 - 2,69,200 = -52,650 (Deficit) August: -52,650 + 1,20,000 - 2,23,000 = -1,55,650 (Deficit) September: -1,55,650 + 1,00,000 - 23,31,800 = -78,450 (Deficit)

    Explanation of Results:

    Based on the cash budget prepared above, it is evident that PPC will face a deficit in cash starting from July onwards. This means that the company's cash inflows will not be sufficient to cover its cash outflows in these months. The deficit situation continues in August and September as well.

    The main factors contributing to the deficit are the significant cash outflows for capital expenditure in May and June, along with the payment of taxes in April and June. Additionally, the cash collections from credit sales are delayed, which further affects the cash flow.

    To address the deficit situation, PPC needs to either increase its cash inflows (e.g., through higher cash sales, improved collections from credit sales) or reduce its cash outflows (e.g., by decreasing operating expenses, delaying non-essential capital expenditures). The company may also consider negotiating better credit terms with suppliers to improve its cash flow.

    1. Implications of +/- 10% Sales Forecasts:

    Assuming the sales forecasts are off by +/- 10%, let's calculate the revised cash budgets:

    If Sales Forecasts are increased by 10%: Cash Receipts will increase by 10% for each month based on the revised sales figures. Other cash payments, such as raw material purchases, wages and salaries, administrative and marketing expenses, and power and fuel expenses, will remain unchanged. The ending cash balance for each month will be higher compared to the original budget.

    If Sales Forecasts are decreased by 10%: Cash Receipts will decrease by 10% for each month based on the revised sales figures. Other cash payments, such as raw material purchases, wages and salaries, administrative and marketing expenses, and power and fuel expenses, will remain unchanged. The ending cash balance for each month will be lower compared to the original budget.

    The implications of these revisions in the cash budget will depend on the overall impact on the cash inflows and outflows. If the revisions lead to higher cash inflows, it can help improve the cash position and reduce the deficit. On the other hand, if the revisions result in lower cash inflows, the deficit situation may worsen. It is important for PPC to analyze the overall impact of these changes and adjust its operational and financial strategies accordingly.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.