Announcement
QUARTER FINAL | BUSINESS CASE - BCS 04
Finance Manager Submission BCS 04
NMO 2020
Financial Health of DND LLP
Submission Date & Time : 2020-03-22 05:08:24
Submitted By: Raju Kumar Ramekbal Chaurasiya - Finance Manager From Team Fire
Case UnderstandingAs our business segment is in Dairy Products and there are very large number of suppliers and buyers that we are in perfect competition and where we are price takers. So to sustain in this industry we have operate very efficiently. But our firm is struggling to make profit and our monthly loss is 5,71,250 INR. This can be wipe out only either by reducing the cost or by increasing market share (user) or both. So to sustain in industry we have to do both. And both will only possible when all dept. work with coordinate, efficiently. And as a finance manager I have to look arrangement of finance for other dept. for their various activities to perform their function properly. So arrangement of finance, allocation of it, reviewing it, creating reserve for long term business objective (i.e expansion, diversification etc.)
BCS Solution Summary(i) Budget Budget is statement of future expenses and income. So from rising resources and proper allocation to various dept. is very important to operate successfully and smoothly. As at current we are making loss of 5,71,250 INR per month. But industry prospective is looking very good in upcoming years. So I plan to use debt fund as interest rate are low and govt. policy is supportive providing tax concession for start up. So we have taken 1 Cr loan under credit guarantee Scheme. Under this scheme central govt. provides collateral free loan upto 2 Cr. And with coordinate to other dept. and their requirements I have provide funds for their operation and also for capital expenditure is provide. We will incur 36,00,000 as capital expenditure in IT system, Quality.We have deficit of 63,52,875 in FY 2020-21. (ii) Financial Plan As in current FY(2019-20) we are making loss of 5,71,250 INR per month. But as per Estimated P&L Ac shows loss of 5,15,270 per Month. And in this we have taken huge expenditure of Training, Marketing as a revenue expenditure but these expense will benefit in long run. The reason for loss is training and development program expenditure, Marketing activities like free products, coupons, Gift etc for capturing market share. But by the ending of FY 2021-22 we will reach at brake even point or little profit. Then we will look to big investment in cold storage, warehouse, hiring more Human Power, increasing presence in more cities, increasing product portfolio etc. by rising funds from angel investor, Private players, or venture capital as per that market condition.
Solution(i)Budget for Next Financial Year
Master Annual Budget for 2020-21
Master Annual Budget for 2020-21 | ||||||||
Sources of Fund | Amt | Application of fund | Amt | |||||
Revenue from operation | 157164750 | Purchase of Material | 140000000 | |||||
Loan from Bank for 4 years | 10000000 | Marketing Dept. | 4000000 | |||||
Deficit | 6352875 | HR Dept. | 15698000 | |||||
Finance/admin/Acc Dept. | 5100000 | |||||||
IT Dept. | 3350000 | |||||||
Advisory fee | 100000 | |||||||
Quality Management | 1000000 | |||||||
Capital Expenditure | 3600000 | |||||||
Other Activities | 669625 | |||||||
Total | 173517625 | Total | 173517625 |
Notes:
Revenue from operation: It is based on monthly Sales forecast which is given in below table:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Budgets of respective department.
Marketing Dept.
Marketing Dept. | |||||||||
Resource | Amt | Application | Amt | ||||||
By Master budget Allocation | 4000000 | Digital Marketing | 1000000 | ||||||
Advertise | 1000000 | ||||||||
Customers Coupons/Gift etc | 500000 | ||||||||
Offers at festival Occasion | 800000 | ||||||||
Promo code | 500000 | ||||||||
Other Activities | 200000 | ||||||||
Total | 4000000 | Total | 4000000 |
I consult with Marketing dept. then I allocated fund for above mention purpose.
HR Dept.
HR Department | |||||||||
Resource | Amt | Application | Amt | ||||||
By Master budget Allocation | 3938000 | Cost of employee | 14208000 | ||||||
By Revenue from operation | 11760000 | (i) Fixed cost | 11760000 | ||||||
(ii) Incentive scheme | 2448000 | ||||||||
Bonus | 240000 | ||||||||
Training and Devolpement | 800000 | ||||||||
Recreational, Annual function | 350000 | ||||||||
Other Activities | 100000 | ||||||||
Total | 15698000 | Total | 15698000 |
Note : Please look at uploaded pdf for the all calculation reference.
Finance/Admin/Accounts Dept.
Finance/Accounts/Administratative Dept. | |||||||||
Resource | Amt | Application | Amt | ||||||
By Master budget Allocation | 5100000 | Finance Cost | |||||||
(i)Interest payment of loan | 1000000 | ||||||||
Principal amount payment | 2500000 | ||||||||
Maintaining of Books of A/c | 800000 | ||||||||
Documentation & Paper work by Admin | 700000 | ||||||||
Other activities | 100000 | ||||||||
Total | 5100000 | Total | 5100000 |
Note: Please look at uploaded pdf for all calculation.
IT dept.
IT dept. | |||||||||
Resource | Amt | Application | Amt | ||||||
By Master budget Allocation | 3350000 | Hardware investment | 1500000 | ||||||
Maintainace of Hardware | 150000 | ||||||||
Software devolpement | 1000000 | ||||||||
Maintainace of Software | 200000 | ||||||||
Datebase management System | 500000 | ||||||||
Total | 3350000 | Total | 3350000 |
Business Advisory:
For business advisor we pay 50,000 Rs per Year to our both advisor.
For Purchase of material I calculated 85% of our revenue. So 85% of 15,71,64,750
is 13,35,90,038. So approx 14Cr I allocated.
Quality Management and Capital expenditure is very essential for any business so I also allocate for this.
(i)Financial Plan
Before moving to our financial plan first we look to our estimated Profit & loss A/c for year ending 2020-21. And plan of capital expenditure in FY 2020-21.
Profit & loss A/c for year ending 2020-21
Estimated Profit and loss a/c for FY 2020-21 | ||||||||
Income | Amt | Expense | Amt | |||||
Revenue from operation | 157164750 | Marterial | 140000000 | |||||
Empolyee Cost | 14208000 | |||||||
Bouns | 240000 | |||||||
Training | 800000 | |||||||
Recreational, Annual function | 350000 | |||||||
Marketing | 4000000 | |||||||
IT expense | 350000 | |||||||
Admin | 1500000 | |||||||
Finance Cost | 1000000 | |||||||
Loss | 6183250 | Advisory | 100000 | |||||
Quality | 400000 | |||||||
others expense | 400000 | |||||||
Total | 163348000 | Total | 163348000 |
This is Estimated P&L A/c.
In Previous Year we are making loss of 5,71,250 INR per month but in next financial Year we will make loss 61,83,250/12=5,15,270 INR per month.
Capital expenditure
Capltal Expenditure | Amt | ||
IT Hardware | 1500000 | ||
Software development | 1000000 | ||
Database management system | 500000 | ||
Quality Management System | 600000 | ||
Total | 3600000 |
Notes:
- Training cost 8,00,000 is taken as revenue expenditure in FY 2020-21 but it will benefit for long term.
- Same for Marketing.
- As in IT we will incur 31,00,000 we will benefit for long term.
- In quality management we will incur 6,00,000 as capital expenditure and 400000 is allocated for it’s maintenance.
- Material, Employee, Bonus, Training, Recreational, Annual function, Marketing is as per budget.
- IT expense is Maintenance of Hardware and Software is 3,50,000.
Now as in next financial year(2020-21) we have developed our IT system, Skill full Human resource, Quality management system which lead to more revenue in FY 2021-22 and our company will start making profit little bit at end of FY 2021-22
And also we will reduce our loan to 50,00,000. As on 1 Apr 2020 our loan is 1 Cr and on 31 mar 2021 we will paid 25,00,000 and on 31 mar 2022 will again paid 2500000. So on 1 Apr 2022 our loan is 50,00,000.
Then in 2022-23 we will try to create get funds from angel Investor or from Private player, or venture Capital etc as per market condition at that time. To future expand our business (by increasing product portfolio, reaching to other cities, cold storage, warehouse creation, etc as per of business.
Optional Assignment
ConclusionAs DND LLP is in perfect competition all firm earns normal profit. And all firm are price takers. So operating efficiently, reducing cost, increasing market share is only way to survive in the industry. As DND LLP is in Dairy product quality matters very much, perishable nature of products is big challenge that firm has to face. So to survive in longer run expenditure on quality management, cold storage, etc are needed. Customer grievances need to be solved to retain customer. Expanding business in product as well as cities to serve is going to be very crucial for next 5 Years.
Attached File Details
Comments
Dr Saroj Kumar Dutta
Well Tried Mr. Raju, Keep it up !
Rajni Khosala
Quite an extensive overview to the case.All firms in such situations have to think between reducing losses and increasing sales.In such generic firm type Training cost should be minimum or not existing since employees hired are already from same trade. Overall a good split section wise!
Sandeep Bhatt
As finance leader, it is very important to look for the funds for the startup. Debt and Equity combination is n excellent case to raise funds
Raju Kumar Ramekbal Chaurasiya
Dear Sandeep This firm is LLP(Limited Liability Partnership so fund via equity cannot be raised. As for fund raising proposal is concern we have taken loan of 1 Cr from bank for FY 2020-21.
Participant
Raju Kumar Ramekbal Chaurasiya
UPL LTD., Store Assistance
I\'m doing MBA form Mangalmay Institute of Management & Technology. I want to develop my career in financial sector.
Team Earth BCS 04 Submission
Total Team Points: 79980
Team Fire BCS 04 Submission
Total Team Points: 84915
Team Water BCS 04 Submission
Total Team Points: 59255
Team Sky BCS 04 Submission
Total Team Points: 106350
Team Air BCS 04 Submission
Total Team Points: 90750