Finance - control 1

Pay with:
i agree with "Terms for Customers"
Sold: 0
Refunds: 0

Uploaded: 22.09.2013
Content: 30922200939580.rar (101,94 kB)

Description

Object of research - industrial enterprise (organization «ABC»), which produces two types of products.

1. Sales of the company in December amounted to product A - 2500 and on the product B - 800 pcs. Price per unit of product A was 250 rubles. / Pcs., The product B - 1500 rub. / Pcs. Projected sales of the product in the first quarter should make monthly 3500, 4000, 4000 pcs., In the second quarter - 4000 pcs. Projected sales of the product B - 1000, 1100, 1200 pcs., The conservation of this trend in the second quarter.

2. The company management provides a quarterly increase in the price of the product A 4% compared to December, and for the product B - 50 rub. / Pcs. from the second quarter.

3. Management of the organization has established the following policy in the field of sales: 30% of monthly sales are paid in the same month, 50%, 15% and 5% - in the next. At the beginning of December, the debt on the part of customers was 750 thousand. Rub.

4. In accordance with the calculation carried out by the cost of producing the product A is 100 rub. / Pcs., The product B - 600 rub. / Pcs.

5. Stocks of finished products in stock are 6% of the monthly sales volume of the next period.

6. Inventories of raw materials make up 15% of the production requirements of next month.

7. Salaries of key staff for the manufacturing of a product A is 40 rub. / Pcs., The product B - 100 rub. / Pcs.

8. The costs associated with the delivery of finished goods to customers make up 0.6% of sales, commission dealers lined at the level of 2% of sales, the cost of packaging and packaging - 0.1% of sales, the cost of warehousing and storage set at 15% of the value of stocks of finished products.

9. Monthly expenses for advertising and market research are set at 45 and 16 thousand. Rub. respectively. The amount of funds allocated for representation expenses, fixed at a monthly 20 thousand. Rub.

10. The number of products distributed free to customers in order to increase brand awareness for the month is 40% formed by stocks of finished products.

11. Expenses for customer relationship management are set at 7% of sales. At the same time attracting new customers is allocated 65% of the total.

12. The organization buys raw materials for industrial purposes under the following conditions: 45% of monthly purchases of raw materials purchased on a prepaid basis with payments for the current month (the organization receives a discount of 1.5%); 35% and 20% of raw material purchased paid in the following month. Unpaid debts to suppliers and contractors in the beginning of December is 600 thousand. Rub.

Additional information

13. Amounts due to personnel on payment shall be repaid as follows: 40% of the salary paid in the same month, 60% - in the future.

14. In December, the organization received a loan in the amount of 1541.8 thousand. Rub., Which will be repaid in equal installments through June of next year, interest will be paid after the repayment of the principal amount (interest on the loan were not charged).

15. In early December, to finance current assets the organization has attracted short-term bank loan in the amount of 700 thousand. Rub., Accrued interest on the loan in December amounted to 12 thousand. Rub. Return of the outstanding loan amount in equal installments during January, February, March, April and May. Interest on short-term credit are charged monthly for the remainder of the principal amount and paid at the beginning of next month.

16. In early December, the organization posted on ruble bank deposit account funds in the amount of 550 thousand. Rub. at 9% per annum. Payment of interest is carried out at the end of the contract period. The agreement signed with the bank for six months.

17. Under the terms of the organization´s policy in the area of \u200b\u200bworking capital management minimum level (insurance residue) in cash at the end of each month, must not be less than 80 thousand. Rub. At the beginning of December, the cash balance was 350 thousand. Rub.

18. The general meeting of shareholders of the organization found that about 75% of the net profit for the period will be used to finance renovation of fixed assets.

19. The total value of fixed assets in the month of December was 1500 thousand. Rub.

20. The authorized capital of the organization has not changed from the time of registration and is 2,000 thousand. Rub. In the planning period the capital increase is not planned.

Required:

1. On the basis of initial data to make operational and financial budgets of the organization.

2. To make a general conclusion about the planned changes in financial condition of the organization, to assess how changes its ability to generate cash flow to analyze the changes in the financial and economic activities taking into account the interests of the owners of the organization.


Training

1. On the basis of a plan-actual analysis of budget execution of sales in January to conduct a factor analysis of the change in revenue for each type of product.

Budget Sales

Indicator December January February March April May June

The planned sale, pcs .:

Product A 2500 3500 4000 4000 4000 4000 4000

Product B 800 1000 1100 1200 1300 1400 1500

Price per unit, rub. / Pcs.

A product 250 260 260 260 270 270 270

Product B 1500 1500 1500 1500 1550 1550 1550

Proceeds from sales (total sales), ths. Rub.

Total 1825 2410 2690 2840 3095 3250 3405

Product A 625 910 1040 1040 1080 1080 1080

Product B 1200 1500 1650 1800 2015 2170 2325


2. On the basis of data on the actual performance of the budget sales with "3-sigma rule" to analyze significant deviations from the planned revenue performance.

Budget Sales

Indicator December January February March April May June

The planned sale, pcs .:

Product A 2500 3500 4000 4000 4000 4000 4000

Product B 800 1000 1100 1200 1300 1400 1500

Price per unit, rub. / Pcs.

A product 250 260 260 260 270 270 270

Product B 1500 1500 1500 1500 1550 1550 1550

Proceeds from sales (total sales), ths. Rub.

Total 1825 2410 2690 2840 3095 3250 3405

Product A 625 910 1040 1040 1080 1080 1080

Product B 1200 1500 1650 1800 2015 2170 2325

References

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.com the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)