IIBMS MBA CASE STUDY ANSWER SHEETS – Suppose you are Mr.Keen Kumar, the new manager. What steps will you take for the growth of Cooking LPG Ltd.
IIBMS MBA CASE STUDY ANSWER SHEETS – Suppose you are Mr.Keen Kumar, the new manager. What steps will you take for the growth of Cooking LPG Ltd.
www.answersheets.in
info.answersheets@gmail.com
+91 95030-94040
Finance Management
Attempt any Four cases
CASE : 01
COOKING LPG LTD
DETERMINATION OF WORKING CAPTIAL
Introduction
Cooking LPG Ltd, Gurgaon, is a private sector firm dealing in the bottling and supply of domestic LPG for household consumption since 1995. The firm has a network of distributors in the districts of Gurgaon and Faridabad. The bottling plant of the firm is located on National Highway – 8 (New Delhi – Jaipur), approx. 12 kms from Gurgaon. The firm has been consistently performing we.” and plans to expand its market to include the whole National Capital Region.
The production process of the plant consists of receipt of the bulk LPG through tank trucks, storage in tanks, bottling operations and distribution to dealers. During the bottling process, the cylinders are subjected to pressurized filling of LPG followed by quality control and safety checks such as weight, leakage and other defects. The cylinders passing through this process are sealed and dispatched to dealers through trucks. The supply and distribution section of the plant prepares the invoice which goes along with the truck to the distributor.
Statement of the Problem :
Mr. I. M. Smart, DGM(Finance) of the company, was analyzing the financial performance of the company during the current year. The various profitability ratios and parameters of the company indicated a very satisfactory performance. Still, Mr. Smart was not fully content-specially with the management of the working capital by the company. He could recall that during the past year, in spite of stable demand pattern, they had to, time and again, resort to bank overdrafts due to non-availability of cash for making various payments. He is aware that such aberrations in the finances have a cost and adversely affects the performance of the company. However, he was unable to pinpoint the cause of the problem.
He discussed the problem with Mr. U.R. Keenkumar, the new manager (Finance). After critically examining the details, Mr. Keenkumar realized that the working capital was hitherto estimated only as approximation by some rule of thumb without any proper computation based on sound financial policies and, therefore, suggested a reworking of the working capital (WC) requirement. Mr. Smart assigned the task of determination of WC to him.
Profile of Cooking LPG Ltd.
1) Purchases : The company purchases LPG in bulk from various importers ex-Mumbai and Kandla, @ Rs. 11,000 per MT. This is transported to its Bottling Plant at Gurgaon through 15 MT capacity tank trucks (called bullets), hired on annual contract basis. The average transportation cost per bullet ex-either location is Rs. 30,000. Normally, 2 bullets per day are received at the plant. The company make payments for bulk supplies once in a month, resulting in average time-lag of 15 days.
2) Storage and Bottling : The bulk storage capacity at the plant is 150 MT (2 x 75 MT storage tanks) and the plant is capable of filling 30 MT LPG in cylinders per day. The plant operates for 25 days per month on an average. The desired level of inventory at various stages is as under.
-
LPG in bulk (tanks and pipeline quantity in the plant) – three days average production / sales.
-
Filled Cylinders – 2 days average sales.
-
Work-in Process inventory – zero.
3) Marketing : The LPG is supplied by the company in 12 kg cylinders, invoiced @ Rs. 250 per cylinder. The rate of applicable sales tax on the invoice is 4 per cent. A commission of Rs. 15 per cylinder is paid to the distributor on the invoice itself. The filled cylinders are delivered on company’s expense at the distributor’s godown, in exchange of equal number of empty cylinders. The deliveries are made in truck-loads only, the capacity of each truck being 250 cylinders. The distributors are required to pay for deliveries through bank draft. On receipt of the draft, the cylinders are normally dispatched on the same day. However, for every truck purchased on pre-paid basis, the company extends a credit of 7 days to the distributors on one truck-load.
4) Salaries and Wages : The following payments are made :
-
Direct labour – Re. 0.75 per cylinder (Bottling expenses) – paid on last day of the month.
-
Security agency – Rs. 30,000 per month paid on 10th of subsequent month.
-
Administrative staff and managers – Rs. 3.75 lakh per annum, paid on monthly basis on the last working day.
5) Overheads :
-
Administrative (staff, car, communication etc) – Rs. 25,000 per month – paid on the 10th of subsequent month.
-
Power (including on DG set) – Rs. 1,00,000 per month paid on the 7th Subsequent month.
-
Renewal of various licenses (pollution, factory, labour CCE etc.) – Rs. 15,000 per annum paid at the beginning of the year.
-
Insurance – Rs. 5,00,000 per annum to be paid at the beginning of the year.
-
Housekeeping etc – Rs. 10,000 per month paid on the 10th of the subsequent month.
-
Regular maintenance of plant – Rs. 50,000 per month paid on the 10th of every month to the vendors. This includes expenditure on account of lubricants, spares and other stores.
-
Regular maintenance of cylinders (statutory testing) – Rs. 5 lakh per annum – paid on monthly basis on the 15th of the subsequent month.
-
All transportation charges as per contracts – paid on the 10th subsequent month.
-
Sales tax as per applicable rates is deposited on the 7th of the subsequent month.
6) Sales : Average sales are 2,500 cylinders per day during the year. However, during the winter months (December to February), there is an incremental demand of 20 per cent.
7) Average Inventories : The average stocks maintained by the company as per its policy guidelines :
-
Consumables (caps, ceiling material, valves etc) – Rs. 2 lakh. This amounts to 15 days consumption.
-
Maintenance spares – Rs. 1 lakh
-
Lubricants – Rs. 20,000
-
Diesel (for DG sets and fire engines) – Rs. 15,000
-
Other stores (stationary, safety items) – Rs. 20,000
8) Minimum cash balance including bank balance required is Rs. 5 lakh.
9) Additional Information for Calculating Incremental Working Capital During Winter.
-
No increase in any inventories take place except in the inventory of bulk LPG, which increases in the same proportion as the increase of the demand. The actual requirements of LPG for additional supplies are procured under the same terms and conditions from the suppliers.
-
The labour cost for additional production is paid at double the rate during wintes.
-
No changes in other administrative overheads.
-
The expenditure on power consumption during winter increased by 10 per cent. However, during other months the power consumption remains the same as the decrease owing to reduced production is offset by increased consumption on account of compressors /Acs.
-
Additional amount of Rs. 3 lakh is kept as cash balance to meet exigencies during winter.
-
No change in time schedules for any payables / receivables.
-
The storage of finished goods inventory is restricted to a maximum 5,000 cylinders due to statutory requirements.
Suppose you are Mr.Keen Kumar, the new manager. What steps will you take for the growth of Cooking LPG Ltd.?
Welcome to Answer sheets
We at Answer sheets offer all types of online academic assistance, be it homework help, coursework help, case study help, Assignment help, Project Reports, Thesis, Research paper writing help.
And for each service, each subject and each topic, we dedicate an expert writer who has knowledge in that specific field of study. Experience impeccable academic writing service like never before.
Our experts understand that the time of the customers is very precious. The professors of universities and colleges are very rigorous about the submission deadlines of projects or assignments. Hence, the key objective of our case study help service is to deliver the assignments to the customers even before the promised submission deadlines.
We keep the quality measures for all papers which mean we will provide best essays. Our editing services are also excellent. Before submitting any essays, we will check whether the papers writer well or not. The high standards of academic writing will exceed your expectations. With our quality service, we have satisfied more number of people across the world and also work with different universities in Australia, UK, USA, Dubai, Oman, etc.
At our Answer sheets services, our experts are familiar about the formatting styles that are followed in the academic world. Our experts have a great knowledge about the formatting styles such as MLA, Harvard, APA, Turabian, and many others. All types of formats for the case study help are available at our case study help services. In addition, our experts can solve the case studies as per the instructions of the customers.
The experts of our Answer sheets services are highly qualified and professional. We have CAs CFAs & PhD on our panel who have years of experience in the writing of case study / Assignments.
At our Answer sheets services, our experts never plagiarize the content from the other sources for the solutions of case studies. We have strict policies regarding plagiarism at our organization. We have never faced any complaint so far regarding plagiarism from our customers. We use new technologies and modern plagiarism checking software’s to detect plagiarism from our papers.
Case Study Solutions, Assignments done by MIB, CA, PhD, & CFA
The experts of our Answer sheets services are highly qualified and professional. We have CAs CFAs & PhD on our panel who have years of experience in the writing of case study. In addition, our experts have the expertise of how a case study should be done by using the information that is mentioned in the case study. All the experts of case study help services are competent and they have all the skills that are required in order to solve a case study. A case study that is solved by our experts looks professional and will surely fetch great grades.
O % Plagiarism
At our Answer sheets services, our experts never plagiarize the content from the other sources for the solutions of case studies. We have strict policies regarding plagiarism at our organization. We have never faced any complaint so far regarding plagiarism from our customers. We use new technologies and modern plagiarism checking software’s to detect plagiarism from our papers.
Best Price Guarantee
You get premium service at the best market price. Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors, in case they do – “We will beat the price”.
Confidentiality
We keep our clients’ personal data confidential. In addition to this payment, info is protected, so you no need to worry about any factors. Feel free to refer to the support team for more information and get some essential details related to the payment methods. Our company aims to keep all your details safe; our advanced security standards will exceed your expectations.
Benefits:
Quality Control and Simplicity
We only focus on the quality and offer best quality essays for all time. So you will receive well-crafted and 100% unique content. Need some alterations? You have great chances to get the essays for free.
Direct Communication and Support:
You can easily control the writing process based on your needs; we help you a lot. You can approach our writers directly and requesting drafts. Our dedicated team of experts is available to offer responsive support for 24/7. So just contact us, we ready to help you.
IIBMS MBA CASE STUDY ANSWER SHEETS,
IIBMS MBA CASE STUDY SOLUTIONS,
IIBMS EMBA CASE STUDY ANSWER SHEETS,
IIBMS EMBA CASE STUDY SOLUTIONS,
IIBMS DMS CASE STUDY ANSWER SHEETS,
IIBMS DMS CASE STUDY SOLUTIONS,
IIBMS MMS CASE STUDY ANSWER SHEETS,
IIBMS MIB CASE STUDY SOLUTIONS,
EMBA IIBMS CASE STUDY SOLUTIONS.