Premium Essay

Three Years Average

In: Business and Management

Submitted By franzina
Words 4474
Pages 18
N.B.: 1) Attempt any Four Questions 2) All questions carry equal marks.
NO. 1
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...

Similar Documents

Premium Essay

Forcasting with Indicies

...in Anchorage, Alaska with distribution plants in 21 states. The company has recently hired a new CEO who has asked that I make a seasonal demand forecast based on the last four years of winter historical inventory data that has been recorded. The winter historical inventory data is based on actual demand in numbers of snow shovels manufactured by Geist Industries. To minimize the data and make it more manageable for analysis, I have devised a twelve month average for each of the four years and plotted the resulting data to forecast the upcoming year’s demand in Figure A. The following formula was used to calculate the twelve month average individually for years one through four: Total Demand (Actual) for Year (January thru December) = Individual Year Average 12 (Figure A) I have extended the trend line to forecast the 5th year demand, in this case to provide a forecasted average that follows a similar trend to that which has been displayed in the past four years. The trend line that has been established displays an R2 value of 0.9553 allowing a conclusion that the data set is relatively useful in forecasting future demand. Using the 12 month average for the last four years of data we can safely assume that next years average demand will be potentially somewhere in the neighborhood of 49,000. Analyzing the Historical Inventory Data Figure B illustrates the Winter Historical Inventory Data. ......

Words: 1369 - Pages: 6

Free Essay

Forcasting with Indicies

...to happen in the future. The winter historical data for the University of Phoenix covers four years of demand in actual units. Each year has been broken down to 12 months of data. The data is presented in figure 1.1 Typical Seasonal Demand for Winter Highs Actual Demands (in units) Month Year 1 Year 2 Year 3 Year 4 Forecast 1 55,200 39,800 32,180 62,300 2 57,350 64,100 38,600 66,500 3 15,400 47,600 25,020 31,400 4 27,700 43,050 51,300 36,500 5 21,400 39,300 31,790 16,800 6 17,100 10,300 31,100 18,900 7 18,000 45,100 59,800 35,500 8 19,800 46,530 30,740 51,250 9 15,700 22,100 47,800 34,400 10 53,600 41,350 73,890 68,000 11 83,200 46,000 60,200 68,100 12 72,900 41,800 55,200 61,100 Avg. Figure 1.1 (University of Phoenix, 2011). The Time-Series Method is an example of quantitative forecasting. This forecasting model uses historical data to try to predict future events .Knowing the data from the last four years, will help to predict how long the demand in units bases on the past (Encyclopedia of Business and Finance, 2006). The data has been used in creating a scatter chart. Figure 1.2 There is a 64.8% increase in the average units from year one to year two, a 10.3% increase from year two to year three, and a 2.4% increase from year three to year four. As the percentage of growth has increased at a lesser percent each year, it follows that...

Words: 758 - Pages: 4

Free Essay

Businessplan

...In year one, each department is getting an executive and a mid-level FTE. However, R&D department get one junior FTE employee as most of the activities came from R&D department. With two employees for the two support departments (G&A and S&M) it will give adequate resources to strategically position the company for large expansion the following year. The compensations for the executives are relatively low compare to market condition therefore, stock options will be used. With the established pay band from year one a pay increase of 8 to 16 percent across the board to bring up the pay band closer to market average to attract talents. In year 2, R&D added two more mid-level FTE to perfecting the product to increase the chance gaining FDA approval of the product. S&M department increased one senior-level, five mid-level and four junior-level FTEs. Those include one senior, two mid-level and three junior marketing FTEs to introduce the product to different markets. Six sale FTEs (one senior, four mid-level and and one junior-level) to handle sales and searching for new customers. G&A department added two FTEs (one mid-level and one junior –level) to accommodate the personnel and office space growth. Revenue from year 2 prompted an aggressive increase in personnel budgeting in order to introduce the product to different markets. In year three, senior level received the highest pay raise with 12-13 percent. As fast as the company’s growth,...

Words: 603 - Pages: 3

Premium Essay

Paper

...Loupu Nyenlekewoi HAS 525 Fanancial Health Management Dr. April 27, 2014 Strayer University 8.1 Assignment Exercise: a.1) FIFO Time | Purchase or Sale | Units | Cost | Total = Cost x Units | 1 | I | 25 | 000 | $0.00 | 2 | P | 6 | 500 | $3,000.00 | 3 | S | 90 | 000 | $0.00 | 4 | P | 32 | 000 | $0.00 | 5 | p | 20 | 000 | $0.00 | Calculate Unit Items: Units available for sale = 6 + 32 = 38 Units sold = 25 + 90 + 20 = 135 Units in Ending Inventory = 38 - 135 = -97 Calculate Ending Inventory (last Cost Entry): Ending Inventory = -97 units x $0.00 cost = $0.00 Cost of goods sold: Unit Unit cost Total Inventory 500 $ 50 $25,000 Purchase 1 400 $ 80 $6,500 Purchase 2 100 $ 65 $32, 000 Purchase 3 400 $ 50 $ 20, 000 = 1400 = $83, 500 b.1) LIFO- Time | Purchase or Sale | Units | Cost | Total = Cost x Units | 1 | I | 25 | 000 | $0.00 | 2 | P | 6 | 500 | $3,000.00 | 3 | S | 90 | 000 | $0.00 | 4 | P | 32 | 000 | $0.00 | 5 | p | 20 | 000 | $0.00 | Calculate Unit Items: Units available for sale = 6 + 32 = 38 Units sold = 25 + 90 + 20 = 135 Units in Ending Inventory = 38 - 135 = -97 Calculate Ending......

Words: 1217 - Pages: 5

Premium Essay

Volume One Accounting Practice Problems Questions Answers Solutions

...STUDENT CASES to accompany Accounting & Auditing Research: Tools & Strategies, 7e NOTE: In addition to the in-chapter and end-of-chapter exercises which serve as short cases you will find the following short cases arranged by course title that can also be utilized as short cases that require the student to access the authoritative literature to address the issue presented in the case. Solutions to the cases below are available to instructors on the Weirich Accounting & Auditing Research 7e instructor website at www.wiley.com/college/weirich. Other excellent sources of longer and more detailed cases include the Deloitte Trueblood cases (www.deloitte.com/more/DTF/cases_subj.htm), as well as the AICPA cases (www.aicpa.org). Topical Index of Student Cases INTERMEDIATE ACCOUNTING Case 1: Reporting acquisition and repayment transactions in the Statement of Cash Flows Case 2: Recording a forfeited payment Case 3: Revenue and expense recognition associated extended warranties Case 4: Accounting for “due on demand” note payable Case 5: Purchase of a controlling interest with a greenmail premium Case 6: Revenue recognition in the construction industry Case 7: Accrual and measurement of interest payments Case 8: Recognition of an asset transfer when title has not yet been received Case 9: Capitalization of interest and property taxes on a construction project Case 10: Deferred compensation and life insurance policy......

Words: 5765 - Pages: 24

Premium Essay

Sid More Paper Wprk

...STUDENT CASES to accompany Accounting & Auditing Research: Tools & Strategies, 7e NOTE: In addition to the in-chapter and end-of-chapter exercises which serve as short cases you will find the following short cases arranged by course title that can also be utilized as short cases that require the student to access the authoritative literature to address the issue presented in the case. Solutions to the cases below are available to instructors on the Weirich Accounting & Auditing Research 7e instructor website at www.wiley.com/college/weirich. Other excellent sources of longer and more detailed cases include the Deloitte Trueblood cases (www.deloitte.com/more/DTF/cases_subj.htm), as well as the AICPA cases (www.aicpa.org). Topical Index of Student Cases INTERMEDIATE ACCOUNTING Case 1: Reporting acquisition and repayment transactions in the Statement of Cash Flows Case 2: Recording a forfeited payment Case 3: Revenue and expense recognition associated extended warranties Case 4: Accounting for “due on demand” note payable Case 5: Purchase of a controlling interest with a greenmail premium Case 6: Revenue recognition in the construction industry Case 7: Accrual and measurement of interest payments Case 8: Recognition of an asset transfer when title has not yet been received Case 9: Capitalization of interest and property taxes on a construction project Case 10: Deferred compensation and life insurance policy......

Words: 5765 - Pages: 24

Premium Essay

Alternative Fuel Company Case

...reasons to use the CNG vehicles was incentives which the local gas utility offered. This company has been in operation for over 30 years, being a family owned business with a fleet of some 400 vehicles which serves more than 5,000 customers on a daily basis. Like most cab companies the cabs are assigned to individual drivers as independent contractors, paying a daily rent in order to use Barwoods vehicles. “Of course, cost is still an issue with many alternative sources of fuel, according to Chuck Combs, who is the program lead for alternative energy at China Lake and provides the Navy and Marine Corps with technical expertise in solar and fuel cell efforts”. (Hillburn, 2007) Here will be discussed how the alternative fuel automobile company has a first year market forecast of 1000 units by identifying the forecasting model with an explanation of why it is the obvious choice, while during the first three years of operation the automobile company had actual sales of: year one 800 units, year two 1200 units, year three 2000 units and by using a simple three year moving average calculation of the predicted demand for year four with an explanation of reasoning, in addition the sales department expects the growth in year four to closely resemble the average growth experienced in the last two years, with a prediction of the number of units expected in year four along with a discussion on whether or not to recommend this quantity as...

Words: 1726 - Pages: 7

Free Essay

Climate Profiles of Cities Around the World

...Class Project #1 - Climate Profiles of Cities Around The World Luis Gonzalez GEOG 1301 - Physical Geography Bryant Evans This essay will discuss three cities, Houston, Texas, Alice Springs, Australia and Bridgetown, Barbados. It will emphasize the similarities and differences between them. There will be five factors that will be discussed which are average monthly high and annual temperatures, average monthly low and annual temperatures, average monthly and annual precipitation, average monthly and annual wind speeds, and average monthly and annual evening relative humidity readings. Houston Texas is my birth place. In Houston we have nearly four hundred events throughout the year. There’s fun for all the family from and is a diverse city which contains many cultures. Here are some of the interesting places that this wonderful city has to offer; there is NASA which is 25 miles southeast of downtown. It is like a museum for me but of things from present times, communications and space artifacts. Also, we have Discovery Green which is in downtown Houston. This park is in down town which attract all ages to gather and enjoy the outdoors. Facts: * Houston was founded on August 30, 1836 by brothers Augustus Chapman Allen and John Kirby Allen * Population-2,099,451 * Houston's latitude is 29 degrees 45 minutes north and its longitude is 95 degrees 22 minutes west * Houston is 43 feet above sea level. Sites-......

Words: 1556 - Pages: 7

Premium Essay

Statistics

...Descriptives Notes Output Created 05-SEP-2012 16:32:29 Comments Input Active Dataset DataSet0 Filter Weight Split File N of Rows in Working Data File 51 Missing Value Handling Definition of Missing User defined missing values are treated as missing. Cases Used All non-missing data are used. Syntax DESCRIPTIVES VARIABLES=Income /STATISTICS=MEAN STDDEV VARIANCE RANGE MIN MAX SKEWNESS. Resources Processor Time 00:00:00.00 Elapsed Time 00:00:00.02 [DataSet0] Descriptive Statistics N Range Minimum Maximum Mean Std. Deviation Statistic Statistic Statistic Statistic Statistic Statistic Three-Year-Average Median Income(2008-2010) 51 $29,453 $36,850 $66,303 $50,734.18 $7,555.310 Valid N (listwise) 51 Descriptive Statistics Variance Skewness Statistic Statistic Std. Error Three-Year-Average Median Income(2008-2010) 57082705.308 .389 .333 Valid N (listwise) EXAMINE VARIABLES=Income /PLOT BOXPLOT STEMLEAF /COMPARE GROUPS /PERCENTILES(5,10,25,50,75,90,95) HAVERAGE /STATISTICS DESCRIPTIVES EXTREME /CINTERVAL 95 /MISSING LISTWISE /NOTOTAL. Explore Notes Output Created 05-SEP-2012 16:32:55 Comments Input Active Dataset DataSet0 Filter Weight Split File N of Rows in Working Data File 51 Missing Value Handling Definition of Missing User-defined missing values for dependent variables are treated as missing. Cases Used Statistics are based on cases with no missing......

Words: 519 - Pages: 3

Free Essay

Ukljlkjlk

...(an average of 8% per year for the past three years), shrinking market share (an average of 3 % per year for the past five years) and an increasingly competitive market (with an average increase of 20% in automotive stores over the past three years). the management of Sears, failed to raise their level of thinking to the Explore, Discover and Design phase of the Model. Instead they implemented a series of policies and procedures which gave pressure to bringing sales lead to the motivate of employees that misleading and selling unnecessary parts and services to the customers. ------------------------------------------------------------------------------------------------------------------------ Answer ISSUE STATEMENT : Facing an average of 8% per year decline on revenues for the past three years, shrinking market share of 3% per year for the past 5 years, as well as the increasing number of competitors, the management of Sear roebuck & co. had failed to think critically and strategically in order to come up with a new, suitable plan but spurring performance of its employees via a flawed incentive compensation scheme which resulted in misleading and selling customer unnecessary goods. 1. Due to the face of declining revenues (an average of 8% per year for the past three years), shrinking market share (an average of 3 % per year for the past five years) and an increasing competitive market (with an average increase of 20% in automotive stores over the past three......

Words: 720 - Pages: 3

Premium Essay

Lunch

...Current ratio shows how many assets a business has compared to liabilities. The industry average for current ratio is 2.5:1, meaning Khalida’s fashion company has been above average for the past three years, the business is doing better than expected as they have a higher average. In 2011 the ratio was 2.7:1 and it has increased by 0.2 meaning that the improvement is better than expected. If the ratio was 1:1 this would be bad because it would make it hard to pay back the creditors. It should be between 1.5 it means they would have enough to pay back the creditors. It is good that the industry average is so high however it could be better for the business if it was lower so the money could spread out t through the business to improve it. Solvency Current ratio=20000(current assets)7000(current liabilities)=2.9:1 Acid test ratio: shows the asset compared to liabilities but without the stock. It shows how well a business can meet its liability without having to sell stock. The industry average for current ratio is 1:1, therefore for the past three years Khalida’s fashion company has been below average his would be better if it is the same as the industry average or better but because it is worse it means that other businesses in the industry are doing better. In 2011 the ratio was 0.9:1 but in 2012 and 2013 it decreased by 0.2. this is similar to current ratio whereby the ratio should be higher than 1 but less than 2. This means that the business is doing poor Acid......

Words: 873 - Pages: 4

Free Essay

Forecasting

...fiscal years: 20X1 $5,250,000 20X2 $5,500,000 20X3 $6,000,000 20X4 $6,750,000 Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20X2, a value of 2 to the data for 20X3, and a value of 3 to the data for 20X4. For exponential smoothing, assume that the last forecast for fiscal year 20X4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why Moving Averages Fiscal Year Expenses 20X2 $ 5,500,000 20X3 6,000,000 20X4 6,750,000 20X2-X4 6,083,333 20X5 6,083,333 = $2,277,776 3 I followed Rule 3. Older data are less important than more recent data. I decided to only go back three years so I added personnel expenses for 20X2, 20X3, and 20X4 and divided the total sum by three to forecast personnel expenses for 20X5. Weighted Moving Averages Fiscal Year ......

Words: 707 - Pages: 3

Premium Essay

Operations Management

...PROBLEMS 1. Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. Second, calculate the three-period moving-average forecast for periods 4 through 10. Third, calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data. Calculate the mean absolute deviation (MAD) and the cumulative sum of forecast error (CFE) for each forecasting procedure. Which forecasting procedure would you select? Why? Month Demand 1 45 2 48 3 42 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Answer: Month Demand Exponential Error Absolute Deviation Simple Moving Average Error Absolute Deviation Weighted Moving Average Error Absolute Deviation Smoothing 1 45 2 48 3 42 45.00 4 48 43.80 4.20 4.20 45.00 3.00 3.00 43.5 4.50 4.50 5 49 45.48 3.52 3.52 46.00 3.00 3.00 46.8 2.20 2.20 6 54 46.89 7.11 7.11 46.33 7.67 7.67 48.1 5.90 5.90 7 47 49.73 -2.73 2.73 50.33 -3.33 3.33 52.4 -5.40 5.40 8 50 48.64 1.36 1.36 50.00 0.00 0.00 48.6 1.40 1.40 9 46 49.18 -3.18 3.18 50.33 -4.33 4.33 49.8 -3.80 3.80 10 47 47.91 -0.91 0.91 47.67 -0.67 0.67 46.9 0.10 0.10 Sum 9.37 23.02 5.33 22.00 4.90 22.20 Mean 1.34 3.29 0.76 3.14 0.70 3.33 Exponential Simple Moving Average Weighted Moving......

Words: 1181 - Pages: 5

Premium Essay

Google

...the index contained 30 million documents, whereas today the index includes billions of web pages. Industry Google operates in the Internet Information Provider industry within the Technology sector. Its focus is on “building products and services that benefit [their] users and enable them to find information quickly and easily (Google 2005 Annual Report, 5).” In order to do so, the company follows a development philosophy which differs from other industries. Google initially makes products available early in the development stages by posting them on Google Labs, located on Google’s website. Based on user’s reaction to the product, the company will then promote the product to “beta” status for further testing by users. After about a year or so, Google will decide if the product is of high quality and utility. If the company is satisfied with it, the beta label is removed and it is made a...

Words: 1693 - Pages: 7

Premium Essay

Wacc Example

...Executive Summary: Midland Energy Resources, Inc. is a global energy company with a broad array of products and services. The company operates within three different operations including oil and gas exploration and production (E&P), refining and marketing (R&M), and petrochemicals. Midland has proven to be a very profitable company, with reported operating revenue of $248.5 billion and operating income of $42.2 billion. The company has been in business for over 120 years and employed more than 80,000 individuals. Janet Mortensen, the senior vice president of project finance for Midland Energy Resources, has been asked to calculate the weighted average cost of capital (WACC) for the company as a whole, as well as each of its three divisions as part of an annual budgeting process. Midland’s Three Divisions: Exploration & Production Oil exploration and production (E&P) is Midland’s most profitable business, and its net margin over the previous five years was among the highest in the industry. With oil prices at historic highs in early 2007, Midland anticipated heavy investment in acquisitions of promising properties, in development of its proved undeveloped reserves, and in expanding production. They also needed to account for competition from areas such as the Middle East, Central Asia, Russia, and West Africa. Refining and Marketing Midland had ownership interests in forty refineries around the world with distillation capacity of five million barrels a day. Measured by revenue...

Words: 1750 - Pages: 7