production budget. Solution of typical tasks Working capital, of which

The company's cash flows can be both positive (cash receipts from the sale of goods) and negative (payment to the supplier). Since the organization, as a rule, has a large number of suppliers and buyers with whom agreements have been concluded that provide for various payment methods (prepayment, deferred payment), the problem arises of comparing positive and negative cash flows over time. In the process of analyzing this problem, the concept of the financial cycle arises.

The financial cycle (cash turnover cycle) of an enterprise is the period between the start of payment to suppliers for raw materials, materials, goods received from them for resale (payment of accounts payable) and the beginning of the receipt of funds from buyers for the products supplied to them (payment of receivables).

The financial cycle may consist of the following stages:

1. Payment to the supplier.

2. Shipment of goods from the warehouse of the supplier.

3. Delivery of goods to the warehouse of the organization.

4. Warehousing of goods.

5. Shipment of goods from the warehouse of the organization.

6. Delivery of goods to the buyer.

7. Deferred payment period.

8. Receipt of payment from the buyer.

All this time, the company's funds take various forms of current assets (until the moment of their transformation back into money) (Fig. 1).

Rice. 1. Forms of current assets of the enterprise during the financial cycle

Thus, the financial cycle is a period during which funds are involved in circulation and cannot be used by the enterprise in an arbitrary way. That is, until a full turnover is completed, it is impossible to involve working capital in a new cycle to make a profit. Therefore, the reduction of any of the stages (except for payment to the supplier) in time means an increase in the efficiency of the use of working capital.

Reducing the financial cycle leads to an increase in profits due to an increase in the turnover of goods.

Note! When planning its activities, the enterprise must monitor the state of the duration of the financial cycle and, if necessary, adjust it by changing contractual terms with buyers and suppliers.

The duration of the financial cycle for a trade enterprise is determined by the following formula:

DFC \u003d POS + POD - POKZ,

where DFC is the duration of the financial cycle (money turnover cycle) of the enterprise, in days;

POS - the period of turnover of the company's stocks, in days;

PODZ - the average period of turnover of current receivables, in days;

POKZ - the average period of turnover of the current accounts payable, in days.

The inventory turnover period is the reciprocal of the inventory turnover ratio.

Inventory turnover ratio is the ratio of the cost of goods sold during the reporting period to the average value of inventory in this period.

This ratio shows how many times, on average, the company's inventory is sold over a certain period of time. Therefore, the inventory turnover period is a private division of the duration of the analyzed period in days by the turnover ratio for this period.

Example 1

The annual cost of goods sold amounted to 170 million rubles, the average balance of goods in the warehouse was 6.5 million rubles. The inventory turnover ratio will be 26.15 turnover (170 million rubles / 6.5 million rubles). That is, for the year the warehouse turned around about 26 times.

Based on these data, we calculate the period of inventory turnover: POS = 365 days. / 26.15 turnover = 14 days. This means that an average of 14 days elapses from the moment of receipt at the warehouse until the sale of the goods to the buyer.

The next indicator used in calculating the duration of the financial cycle is the period of turnover of receivables. It characterizes the average period of time during which funds from buyers are received on settlement accounts or at the cash desk of the enterprise. The lower the value of this indicator, the more favorable conditions the company is in.

The period of turnover of receivables is calculated by the formula:

POD = Analyzed period in days / Accounts receivable turnover ratio.

The accounts receivable turnover ratio is calculated as the ratio of proceeds from the sale of goods to the average amount of accounts receivable (less provisions for doubtful debts):

Accounts receivable turnover ratio = Revenue / Average accounts receivable.

The accounts receivable turnover ratio shows how many times receivables have been converted into cash or how much revenue is received from one ruble of receivables. The higher its value, the shorter the period of time elapses between the shipment of products to consumers and the moment they are paid. High values ​​of this indicator have a positive effect on the liquidity and solvency of the enterprise.

Example 2

We use the data of example 1. Let's say that for the year the revenue from the sale of goods amounted to 220 million rubles. The average annual amount of receivables is 5 million rubles. The receivables turnover ratio will be 44 turnovers (220 million rubles / 5 million rubles). That is, for the analyzed year, accounts receivable turned around 44 times on average.

The receivables turnover period, respectively, will be equal to eight days (365 days / 44 turnovers). This means that the average deferral of debtor payments is 8 days.

The accounts payable turnover ratio is a financial indicator calculated as the ratio of the cost of goods sold to the average annual value of accounts payable. The accounts payable turnover ratio shows how many times over a period (per year) accounts payable is turned over:

POKZ = Analyzed period in days / Accounts payable turnover ratio.

The accounts payable turnover ratio is a financial indicator calculated as the ratio of the cost of goods sold to the average annual value of accounts payable. The accounts payable turnover ratio shows how many times over a period (per year) accounts payable is turned over:

Accounts payable turnover ratio = Cost price / Average accounts payable.

The higher this indicator, the faster the company settles accounts with its suppliers. Decreased turnover can mean both problems paying bills, and better management of supplier relationships, providing a more profitable, deferred payment schedule and using accounts payable as a source of cheap financial resources.

Example 3

Let's say the average annual amount of accounts payable from an enterprise is 4.5 million rubles, and the annual cost of goods sold is 170 million rubles. The accounts payable turnover ratio will amount to 37.77 turnover (170 million rubles / 4.5 million rubles). The period of turnover of accounts payable for the corresponding year is 10 days (365 days / 37.77 turnover).

Based on the data obtained on the periods of inventory turnover, receivables and payables, it is possible to calculate the duration of the financial cycle.

The inventory turnover period in the warehouse is 14 days (that is, 14 days pass from the moment the goods arrive at the warehouse until they are sold to customers). The receivables turnover period is 8 days (average deferred payment period provided to buyers). That is, from the moment the goods are received from the supplier (the appearance of accounts payable) until the moment the money is received from the buyer, 22 days (14 + 8) pass. The period of turnover of accounts payable is 10 days (that is, accounts payable are paid on average 10 days from the date of occurrence). Thus, after the receipt of the goods at the warehouse, payment to the supplier occurs after 10 days, and the receipt of money from the buyer - after 22 days. It turns out a gap of 12 days (22 - 10), which is the financial cycle (Fig. 2).

Rice. 2. Cash turnover of the enterprise

This means that the organization's funds are immobilized in receivables and stocks for 12 days, they cannot participate in new turnovers.

Note! Employees of the commercial service of the organization must understand that the duration of the financial cycle is a tool that directly affects the amount of profit from sales (due to an increase in cash turnover over the period).

Suppose the management of the organization, when drawing up a business plan for the next year, set the following task: to estimate the planned duration of the financial cycle and, if necessary, develop ways to reduce it.

To assess the planned duration of the financial cycle, it is necessary to calculate the main indicators for its calculation, which are included in the business plan:

1) proceeds from sales for the planned period;

2) the cost of goods sold for the planned period;

3) the average size of commodity stocks;

4) the average amount of receivables;

5) the average amount of accounts payable.

The plan for sales revenue, cost of goods sold and inventory balances is an integral part of the sales budget and inventory budget. These data are usually easy to obtain (they are calculated based on the annual sales forecast, the planned markup and the seasonality index).

Let's look at these indicators with an example.

Example 4

The initial data are presented in table. 1.

Table 1. Planned indicators of sales revenue, cost of goods sold and inventory balances

Month

Revenue from the sale of goods, thousand rubles

Cost of goods sold, thousand rubles

Remains of commodity stocks at the end of the period, thousand rubles

September

Total for the year

Average for the year

Based on the data presented, it is possible to calculate the inventory turnover ratio, which will be equal to 40.46 turnover per year (230,633 thousand rubles / 5,701 thousand rubles). Therefore, the average inventory turnover period will be 9 days (365 days / 40.46 turnover).

As for the planning of receivables and payables, then the situation is much more complicated. The fact is that for different buyers and suppliers, contractual terms regarding the terms of payment for goods can differ significantly (someone works on an advance payment, someone has a delay of 10 days, someone has 15 days, etc.) .

When planning receivables and payables, you can use the method of collection coefficients, which consists in determining in a practical way the share of revenue (goods sold) that is paid by the client (collected) for a particular period (last month, current month, in subsequent months). Let's assume that accounting at the enterprise allows you to distribute the proceeds from the sale of goods over certain periods. Let's analyze the actual data on revenue and payment for the first half of the current year (Table 2).


Table 2. Calculation of collection coefficients of receivables based on actual data for the first half of the current year

Revenue, thousand rubles

Payment by buyers, thousand rubles

Last month

Current month

Next month

Second month after the current

From Table. 2 shows that, for example, out of the total cost of goods shipped to customers in January (20,053 thousand rubles), 1,500 thousand rubles. was paid in December last year (prepayment), 14,572 thousand rubles. - in the current month, 3824 thousand rubles. - in February, 157 thousand rubles. in March of this year. Based on the summary data on payments, collection rates were calculated (7.86% - prepayment made last month, 57.59% - payment in the current month, 20.99% - deferred payment with payment in the next month, 13.56% - deferred payment with payment in two months).

Similarly, the coefficients of collection of accounts payable for the first half of the current year were calculated (Table 3).

Table 3. Calculation of coefficients of collection of accounts payable based on actual data for the first half of the current year

Purchase of goods, thousand rubles

Payment to suppliers, thousand rubles

Last month

Current month

Next month

Second month after the current

Based on the data on the purchase of goods and on payments to suppliers, the coefficients of collection of accounts payable were calculated (8.23% - prepayment made last month, 66.31% - payment in the current month, 16.86% - deferred payment with payment in the next month, 8.60% - deferred payment with payment in two months).

When the collection coefficients are known, it is possible to calculate the forecast amount of receivables and payables based on planned data on sales revenue and the volume of purchases of goods from suppliers.

In addition to the data from the business plan for the current year, you will need forecast data for November and December of the year preceding the planned one, and for January of the year following the planned one (since in January payment is made for November and December of the last year, and in December - prepayment for January next year). The calculations are presented in table. 4, 5.

Table 4. Calculation of planned receivables

Revenue, thousand rubles

Payment, thousand rubles

November of the previous year

December of the previous year

September

January next year

Let us explain with an example the amount of money predicted to be received from buyers in March of the planned year:

2868 thousand rubles - payment of debts for goods shipped in January (21,148 thousand rubles × 13.56%);

5236 thousand rubles - payment of debts for goods shipped in February (24,944 thousand rubles × 20.99%);

RUB 12,925 thousand - payment for goods shipped in the current month (22,443 thousand rubles × 57.59%);

2598 thousand rubles - advance payment against shipments to be made in April (33,057 thousand rubles × 7.86%).

Total: 23,627 thousand rubles

Accounts receivable at the end of the month is calculated as follows:

DZk \u003d DZn + V - O,

where DZK - the amount of receivables at the end of the month;

DZn - the amount of receivables at the beginning of the month;

B - revenue for shipped goods;

O - payment received from buyers.

Accounts payable is calculated in a similar way.

Table 5. Calculation of planned accounts payable

Purchase of goods, thousand rubles

Payment to suppliers, thousand rubles

November of the previous year

December of the previous year

September

January next year

After the data on the balances of receivables and payables at the end of each month of the planned year have been received, it is possible to calculate the average annual size of these indicators (Table 6).

Table 6. Average annual planned amount of receivables and payables

Accounts receivable at the end of the period, thousand rubles

Accounts payable at the end of the period, thousand rubles

September

Average for the year

Based on data on sales revenue, cost of goods sold, inventory balances, average annual amounts of receivables and payables, it is possible to calculate the indicators of turnover and the duration of the financial cycle (Table 7).

Table 7. Indicators of turnover and duration of the financial cycle

According to the business plan, the duration of the financial cycle for the coming year is 6 days

Note! This indicator has an analytical value and can be used, for example, when analyzing the reasons for the irregular operation of an enterprise.

If the planned length of the financial cycle does not suit the management, the enterprise should take measures to reduce it. To do this, it is necessary, firstly, to try to change the terms of contracts with suppliers, getting them to delay payment as much as possible, and secondly, to develop a system of contracts with buyers with flexible terms of terms and forms of payment:

Prepayment - usually implies a discount;

Partial prepayment - combines prepayment and sale with deferred payment;

Provisional billing - effective for long-term contracts, provides a regular inflow of funds;

Bank guarantee - assumes that the bank will reimburse the required amount (in case the debtor fails to fulfill its obligations);

Transfer for sale - provides that the organization retains ownership of the goods until payment for them is received;

Establishment of remuneration for sales personnel depending on the effectiveness of sales measures and the timing of receipt of payments.

The measures taken should help to maximize the cash flow to the enterprise, and, consequently, increase profits by increasing turnover.

A. F. Garifulin,
economist

Theoretical Introduction

Cash flow management (CFM) allows you to forecast cash flow, establish the financial feasibility of the plan, determine the timing and amount of required borrowings. The cash flow forecasting procedure is performed in the following sequence:

1. Forecasting cash receipts by sub-periods. The main source of cash receipts is the sale of goods (sales for cash or on credit).

2. Forecasting the outflow of funds by sub-periods (the main element is the repayment of accounts payable).

3. Calculation of the net cash flow (balance) by sub-periods by comparing the projected receipts and payments.

4. Calculation of the cumulative cash flow (taking into account the balance of previous sub-periods). An example is presented in Table. 5.1.

Table 5.1

Cash flow plan, thousand rubles

(cash at the beginning of the period - 100 thousand rubles)

Name, thousand rubles

Periods

Income

Net cash flow

Cumulative balance

The criterion for the financial feasibility of the plan is the availability of sufficient financial resources in each of the time periods included in the plan. A specific sign of the financial unfeasibility of the plan is the presence of negative numbers in the "cumulative balance" line. The transfer of the financial plan into the category of the implemented one is possible by attracting additional financing, taking into account the total need in the context of sub-periods. The technology includes the determination of sub-periods for which the cumulative balance is negative, as well as the formation of measures to reduce the cash deficit (increase in receipts, decrease in payments, transfer of payments and receipts to earlier or later dates, etc.). If the plan received after the redistribution remains financially unrealizable, it is possible to attract additional funds.

The conclusion about the advisability of attracting borrowed funds is based on qualitative comparisons of availability deficits in future periods with former deficits (without borrowed funds), as well as by analyzing the availability of funds (deficit) at the end of the planning period. In the process of analysis, the sources and conditions of loans are determined: the terms and volumes of loan repayment and interest payments, the loan interest rate.

The procedure for determining the required amount and terms of borrowed funds consists of the following steps:

1) adding a line: "borrowed funds";

2) highlighting the first interval with a shortage of availability,

3) fixing borrowed funds in the first interval in an amount equal to the shortage of availability in this period;

4) change in the value of receipts in this interval: the "taken" loan is added to receipts in the same period;

5) for new data, the calculation of rows 3 and 4 of the table is repeated and periods with negative numbers in row 4 are highlighted;

6) stopping criterion: if there are no periods with negative numbers, then the problem is solved and the procedure stops; if there are periods with negative values ​​in the fourth row, then the cycle repeats.

5.2. Guidelines

Cash at the beginning of the period is 100 thousand rubles. Create a DDS plan. Is the plan financially feasible? If necessary, calculate the amount of borrowed funds required.

Name,

thousand roubles.

Periods

Income

Solution.

1. Calculate a) net cash flow as the difference between receipts and payments in each period, b) cumulative balance (cumulatively, taking into account the presence of cash at the beginning of the period).

Name, thousand rubles

Periods

Income

Net cash flow

Cumulative balance

2. The financial plan is unrealizable, as there is a negative cumulative balance (in 4.5 and 6 periods). At the initial stage, it is proposed to raise funds by taking a loan in the 4th period in the amount of 31 thousand rubles.

Name, thousand rubles

Periods

Income

Net cash flow

Cumulative balance

Borrowed funds

3. Recalculation of the financial plan after taking a loan shows the presence of a negative cumulative balance in the 6th period. In this regard, additional financing is required by taking a loan in the 6th period in the amount of 77 thousand rubles.

Name, thousand rubles

Periods

Income

Net cash flow

Cumulative balance

Borrowed funds

4. The recalculated plan is financially feasible.

5.3. Tasks for independent work

Task 1. Financial resources at the beginning of the period are 90 den. units Calculate the availability of funds for each period. Determine when the plan will be financially unrealizable. Determine the timing and amount of necessary borrowings.

Name,

den. units

Periods

Income

Task 2. The company entered the market with a new product, the cost of which is 3 thousand rubles, and the selling price is 5 thousand rubles. The company pays and uses raw materials on the day of delivery, and receives money from customers with a one-day lag. The products are in demand, and therefore, it was decided to increase production by 10% daily. The sales volume in 1 day was 1,000 units. Predict the cash flow for the work week.

Task 3. Company A produces a product with a cost of 0.30 million rubles and a retail price of 0.65 million rubles. The received raw materials are paid in cash at the time of delivery. Production facilities allow the production of 1,000 units. in Week. The company has 40 million rubles in the account. Company B purchases products in the amount of 1,000 units. per week for eight weeks and is ready to pay 1 million rubles. per item, however, payment can be made after receipt of the last shipment. Calculate the term and amount of credit required to complete the order.

Task 4. The company manufactures products with the following characteristics (per unit of production): raw material costs - 2 thousand rubles; labor costs - 1 thousand rubles. The selling price is 8 thousand rubles.

Forecast of production and sales volumes

Months

June

July

Production (piece)

All direct expenses are paid in the same month in which they occurred. Sales of products are carried out on credit, the crediting period is 1 month. In July, the company purchases new equipment for 1,000 thousand rubles, payment for which will be made in October. Fixed overhead costs amount to 200 thousand rubles a month. Make a cash flow forecast for six months, taking into account the balance of funds in the account in the amount of 200 thousand rubles.

Cash flow forecast for 6 months, thousand rubles

Months

June

July

opening balance

Income

Total payments:

Variables

Permanent

One-time

Cash flow

Final balance

Task 5. Mr. Ivanov decided to open his own enterprise on January 1, investing 30 thousand rubles in it. He plans to buy a truck for 400 thousand rubles. and deliver vegetables to stores. The garage for the truck will be rented on the terms of 5 thousand rubles. per quarter, paid in advance. You will need to spend an additional 25 thousand rubles. for garage and truck equipment. It is assumed that the proceeds from the sale of vegetables in the next six months will be 384 thousand rubles. and will be evenly distributed over this period. Ivanov plans to set a trade markup on the purchase price of vegetables in the amount of 60%. Vegetables will be purchased and sold daily and for cash. Prepare a monthly cash flow forecast for six months and calculate the amount of additional borrowing required.

Task 6. Revenue growth of 4% per month is expected. The cost of raw materials is 30% of sales. Raw materials are purchased one month before consumption and paid two months after receipt. Calculate the cash outflow.

Cash flow forecast, thousand rubles

Months

March

June

Purchase of raw materials

Cash outflow

Cumulative balance

Task 7. Revenue in January amounted to 300 thousand rubles; in the future, it is expected to increase at a rate of 2% per month. Payment for the supplied products is carried out on the following terms: 20% of the monthly sales volume is cash proceeds; 40% is sold on credit with payment within a month and a 3% discount; the remaining production is paid for within 2 months, while 5% of this amount is bad debts. Calculate the amount of cash receipts for 6 months.

Previous

Problem 4.1. The production output is 30,000 pcs. per quarter, the metal consumption rate is 20 kg per 1 product, the metal price is 12 rubles. for 1 kg. Calculate the value of the production stock, if the norm of the transport stock is 2 days, the preparatory stock is 2.5 days. The volume of deliveries, see table. 4.2.

Table 4.2

1. Determine the weighted average delivery interval:

2. Determine the current stock rate:

D tech. = 0.5 ∙ 14 = 7 days.

3. Determine the safety stock rate:

D str. \u003d 0.5 ∙ 7 \u003d 3.5 days.

4. Define the general average rate of production stock:

D MPZ \u003d 7 + 3.5 + 2 + 2.5 \u003d 15 days.

5. Determine the daily (one-day) consumption of materials:

6. Let's define the SOS standard in the MPZ in monetary terms:

N MPZ \u003d 15 ∙ 80 \u003d 1200 thousand rubles.

Task 4.2. Determine the average delivery interval, current and insurance stocks in days. The initial data are given in table. 4.3.

Table 4.3

1. Determine the average delivery interval:

2. Determine the current warehouse stock:

D tech. = 0.5 ∙ 34 = 17 days.

3. Define the safety stock:

D str. \u003d 0.5 ∙ 17 \u003d 8.5 days.

Task 4.3. The planned consumption in the first quarter for material A amounted to 200 thousand rubles, for material B - 40 thousand rubles, for material C - 120 thousand rubles. Determine: the average rate of working capital for all inventories; one-day consumption of materials; SOS standard in MPZ in monetary terms. The norms of working capital stocks in days for certain types of inventory, see table. 4.4.

Table 4.4

1. Determine the average rate in days for all materials:

2. Determine the one-day consumption of materials:

3. Let's define the standard of own working capital in production stocks in monetary terms:

H MPZ \u003d P day. D MPZ \u003d 4 ∙ 46 \u003d 184 thousand rubles.

Task 4.4. The monthly amount of expenses of the CO is 12 million rubles, incl. one-time costs for the purchase of MPZ - 4.8 million rubles, which corresponds to 40%, and incremental costs - 7.2 million rubles. Determine the cost escalation factor.

Let's define the cost increase factor:

Task 4.5. Planned quarterly expenses - 46 thousand rubles, incl. one-time - 24 thousand rubles, accruing - 22 thousand rubles. Determine the duration of the production cycle, the coefficient of increase in costs, the norm and standard of SOS for work in progress based on the data in Table. 4.5.

Table 4.5

1. Determine the average duration of the production cycle:

D c \u003d 40 0.35 + 8 0.4 + 16 0.1 + 2 0.15 \u003d 19.1 days.

3. Determine the rate of funds for work in progress in days:

D NP \u003d D c ​​K n.z. = 19.1 0.76 = 14.5 days.

4. Let's determine the average daily costs for the production of products at the quarterly cost, i.e. according to the cost estimate for production:

5. Determine the standard of own working capital for work in progress in monetary terms:

H NP \u003d 3 days. D c K n.z. \u003d 511 19.1 0.76 \u003d 511 14.5 \u003d 7418 rubles.

Problem 4.6. There is the following information on stocks and purchases of electric motors for the production of vacuum cleaners, see table. 4.6. For the reporting year, the proceeds from the sale of electric motors amounted to 579.7 thousand rubles. The balance of electric motors at the end of the reporting year - 60 pcs. Calculate by three methods the cost of stocks of electric motors, cost and profit of sales.

Table 4.6

Note. The sequence of calculations is based on the use of the following formula: products for sale (stocks at the beginning of the period + purchases) - stocks at the end of the period = cost of goods sold.

The problem is solved in a tabular way, see table. 4.7.

Table 4.7

Problem 4.7. The total cost of production is 100 rubles, the annual output is 125 thousand items, the duration of the production cycle is 4 days. Costs on the first day - 30 rubles, on the second - 30 rubles, on the third - 20 rubles, on the fourth - 20 rubles. Determine the rate of increase in costs, the rate and standard of working capital in work in progress.

1. Let's determine the coefficient of increase in costs:

2. Let's define the SOS rate in work in progress:

3. Determine the standard of own working capital in work in progress in monetary terms:

Problem 4.8. The amount of expenses at the beginning of the planned year according to the balance sheet is 150 thousand rubles. The planned amount of expenses for future periods in the coming period is 240 thousand rubles. The amount of expenses attributable to the cost of production in the planned period is 180 thousand rubles. Determine the standard of working capital in deferred expenses.

Let's define the SOS standard in RBP in monetary terms:

N RBP \u003d R n.g. + R bud. - R plan. \u003d 150 + 240 - 180 \u003d 210 thousand rubles.

Problem 4.9. Annual output - 5000 units. products, the price of 1 kg of metal is 8 thousand rubles. The net weight of the machine is 460 kg, the amount of actual waste is 120 kg. As a result of improving the technology, waste is planned to be reduced by 15%. Determine the metal utilization rate, the share of waste before and after the change in technology, the specific savings of metal after the change in technology and the annual savings.

1. Define waste after technology change:

Oh fact. \u003d 120 (1−0.15) \u003d 102 kg.

2. Let's determine the metal utilization factors:

3. Determine the share of waste:

4. Let's determine the specific savings of metal after changing the technology:

5. Determine the annual metal savings:

Problem 4.10. The plant produced bulldozers with a capacity of 130 hp, their net weight was 4.5 tons. The consumption rate (rough weight) of metal for the manufacture of one bulldozer was 6 tons. After improving the design of the bulldozer and introducing new technology into production, its capacity increased to 165 liters .With. while maintaining the same net weight, and the consumption rate decreased to 5 tons.

To determine the indicators of the use of metal before and after the improvement of the design and the introduction of new technology.

1. Let's determine the indicators of metal use:

2. Let's define indicators of relative material consumption:

3. Determine the integral indicators of the use of metal:

4. Determine the total metal savings per 1 hp:

Problem 4.11. The annual volume of production and sales of products is 50,000 pieces, the time of warehouse processing of materials is 2 days. Calculate the amount of stocks of raw materials in natural units and the organization's need for working capital in monetary terms based on the data in Table. 4.8.

Table 4.8

1. Determine the annual need for material A in tones:

M A \u003d H R (A) Q\u003d 3.6 50000 \u003d 180000 kg, or 180 tons.

2. Determine the number of deliveries of material A per year:

3. Determine the interval between two deliveries of material A in days:

4. Determine the rate of production stock of material A:

5. Determine the one-day consumption of material A in natural units:

6. Determine the standard in working capital for material A in rubles. :

H A \u003d P day. D A C \u003d 0.5 120 73.5 \u003d 4410 thousand rubles.

7. Determine the annual standard for material B in tons:

M B = N R (B) Q\u003d 1.44 50000 \u003d 72000 kg, or 72 tons.

8. Determine the number of deliveries per year of material B:

9. Determine the interval between two deliveries of material B:

10. Determine the rate of production stock in days for material B:

11. Determine the one-day consumption of material B in tones:

12. Determine the need for working capital of material B in rubles. :

N B \u003d R day (B) C D B \u003d 0.2 950 143 \u003d 27170 thousand rubles.

13. Determine the total capital requirement for materials A and B:

N A + B \u003d N A + N B \u003d 4410 + 27170 \u003d 31580 thousand rubles.

Problem 4.12. Determine the average annual cost of working capital using various formulas, if the amount of working capital is known for three options: 1) at the beginning of the year - 100 thousand rubles; at the end of the year - 110 thousand rubles; 2) as of January 1, 2009 - 120 thousand rubles; as of April 1, 2009 - 130 thousand rubles; as of July 1, 2009 - 125 thousand rubles; 140 thousand rubles; 3) as of 01/01/2009 - 110 thousand rubles, from 01/06/2009 an additional 12 thousand rubles were attracted, from 10/1/2009 - 4 thousand rubles were released.

1. Determine the average annual balance of working capital by applying the formula for calculating a simple average:

2. Determine the average annual balance of working capital by applying the formula for calculating a simple chronological average:

3. Determine the average annual balance of working capital by applying the formula for calculating the weighted average:

Problem 2.13. The annual production volume is 720 items, the sales revenue is 115.5 million rubles, the cost of one item is 150 thousand rubles. The duration of the production cycle is 15 days. The consumption of basic materials for one product is 100 thousand rubles. at a stock rate of 25 days. The consumption of auxiliary materials for the annual output is 5.4 million rubles. at a reserve rate of 40 days, fuel - 4.32 million rubles. at a stock rate of 30 days, other inventories - 3.06 million rubles. at a stock rate of 60 days. Deferred expenses - 1.2 million rubles. The stock norm in finished goods is five days. Next year, the volume of sold products should increase by 20% with the same amount of normalized working capital. Determine: annual consumption of basic materials; one-day consumption of materials (main, auxiliary, other) and fuel; standard of working capital in production stocks of materials; cost increase factor; daily output of products at the planned cost; norms of working capital in work in progress and in finished products, as well as the total norm of working capital; turnover ratios of working capital of the reporting and planned year.

1. Determine the annual consumption of basic materials:

M \u003d QH p1 \u003d 720 100 \u003d 72,000 thousand rubles.

2. Determine the one-day expense:

a) basic materials:

c) fuel:

d) other materials:

3. Let's determine the standard of funds in the production stocks of materials:

N MPZ \u003d D MPZ R day. .

a) basic materials:

H main.m. = 200 25 = 5000 thousand rubles;

b) auxiliary materials:

H aux. = 15 40 = 600 thousand rubles;

c) fuel:

H fuel = 12 30 = 360 thousand rubles;

d) other materials:

N pr. m. = 8.5 60 = 510 thousand. rub.;

e) all types of materials:

N MPZ \u003d 5000 + 600 + 360 + 510 \u003d 6470 thousand rubles.

4. Let's determine the coefficient of increase in costs:

5. Let's determine the daily output of products at the planned cost:

6. Define the SOS standard in work in progress:

H NP \u003d 15 0.834 300 \u003d 3735 thousand rubles.

7. Determine the standard of working capital in finished products:

N GP \u003d 5 300 \u003d 1500 thousand rubles.

8. Let's define the general standard of own working capital (NSOS):

H total \u003d N SOS \u003d N MPZ + Z NP + Z GP + Z RBP \u003d 6470 + 3735 + 1500 + 1200 \u003d 12905 thousand rubles.

9. Determine the turnover ratio for the reporting year:

10. Determine the turnover ratio of the SOS of the planned year:

Problem 4.14. Determine the turnover ratio of working capital if it is known that the proceeds from sales are 20% more than the cost of annual output. Initial data in table. 4.9.

Table 4.9

1. Determine the standard of working capital in the inventory:

2. Determine the cost increase factor:

3. Determine the standard of working capital in WIP:

4. Define the standard of working capital in finished products:

5. Let's define the general standard of working capital:

H total = 30 +79.2 +33 =142.2 thousand rubles.

6. Determine the turnover ratio of working capital:

Problem 4.15. Calculate the release of working capital due to an increase in the turnover ratio, the additional need for working capital in the reporting period due to the growth in sales, evaluate the overall performance of the organization based on the data in Table. 4.10.

Table 4.10

The problem can be solved in two ways

The first way to solve the problem

1. Determine the turnover ratios by years:

base: reporting:

2. Determine the absolute release (or attraction) of working capital in the reporting year:

3. Let's determine the relative release of working capital due to the growth of the turnover ratio:

4. Let's determine the conditional need for working capital to fulfill the planned production plan for the reporting year:

5. Let's determine the conditional additional need for working capital to fulfill the planned production plan for the reporting year:

6. Let's determine the overall result obtained under the influence of two factors (growth in sales and increase in its volume):

ΔO total = + 60 - 50 = + 10 thousand rubles.

The second way to solve the problem

1. Let's determine the relative release of working capital due to the growth of the turnover ratio:

2. Let's determine the additional need for working capital to fulfill the planned production plan for the reporting year:

3. Define the overall result:

∆tot. = ΔK vol. + ΔВ р = + 60 - 50 = + 10 thousand rubles.

Problem 2.16. The volume of products sold in the base year is 120 million rubles, the average annual balance of working capital is 30 million rubles; in the reporting year, the volume of production and sales should increase by 10%, and the duration of one turnover of working capital, on the contrary, should decrease by 10 days. Determine the turnover and load ratios, the duration of turnover by years, the absolute and relative release of working capital.

End of solution

10. Let's determine the relative release of COC in different ways:

Problem 4.17. The volume of production and sales in the base year is 120 million rubles. with an average annual balance of working capital of 30 million rubles; in the reporting year, the volume of production and sales should increase by 20%, and the turnover of working capital will increase by 2 turnovers. Determine the proceeds from the sale of the reporting year, turnover and load ratios, the duration of turnover in the base and reporting years, the amount of working capital balances of the reporting year and the absolute and relative release of own working capital.

End of solution

9. Define the absolute release of working capital:

10. Let's define the relative release of own working capital in different ways.

Table 8 Calculation of the influence of factors on the change in the equity ratio

Index

At the beginning of the period, thousand rubles

dkjjfhdeuwenfd

At the end of the period, thousand rubles

Change (+, -), thousand rubles

Equity

Fixed assets

current assets

Own working capital

Impact on the change in the equity ratio of factors, total

Including: a) equity

b) non-current assets

c) current assets

The combined influence of factors:

Calculations show that the change in the equity ratio was significantly affected by the change in current assets (increase by 520,650 thousand rubles at the end of the reporting period), as well as the change in non-current assets (increase by 663,142 thousand rubles at the end of the reporting period). The cumulative effect of the three factors was -0.324. The increase in current assets had a positive impact (+1.08), while the increase in non-current assets had a negative impact (-1.657).

The distribution structure of equity capital is also calculated, i.e. the share of own working capital and the share of own fixed capital in its total amount.

The ratio of own working capital to its total amount is called the "capital maneuverability coefficient", which shows how much of the own capital is in circulation, i.e. in a form that allows you to freely maneuver these means. The ratio should be high enough to allow flexibility in the use of the enterprise's own funds.