Nobody downloaded yet

Excel Project - Essay Example

Comments (0) Cite this document
Summary
The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER97.1% of users find it useful
Excel Project
Read TextPreview

Extract of sample "Excel Project"

Download file to see previous pages In the graph provided below, it illustrates that the sales trend of the company is increasing. The trend in the sales growth of the company is rising from the August 2004 and dips down on March, April and July 2005. The sales peaked at $115,000 in the May 2006. Please note that the data for June 2006 is incomplete where it comprises only of three days data and it shall be disregarded. This is the reason for the sales decrease in June 2006.
The sales strategies employed for 2006 is effective as illustrated by the big increase in sales from January 2006. The strategies utilized, such as discount levels, must remain consistent in order to assure the growth in sales performance of the company. It is recommended that the company consider developments in new product lines and/or expansion in the global market in order to further increase revenues.
The highest performing country is USA where it generated 19% of the total net revenues of the company. This is followed by Germany at 18%, Austria at 10% and Brazil at 8%. The rest of the countries comprise less than 50% of the total net revenues of the company. The lowest performing country is Poland and Norway which generated less than 1% of the total revenues of the company.
The company might consider focusing on the top 10 performing countries in order to exploit the buying power of the consumers. Focusing on lesser number of locations would create a more effective and efficient organization. It would minimize operations and logistics costs while increasing the marketing and distribution allocations. The countries with minimal growth shall be given up in order to free up the company’s resources.
The top performing product category for the company is the beverage product. It has performed better from other categories for the year 2004 and 2006 while it is second category for 2005. The other performing products are dairy products followed by ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Excel Project Essay Example | Topics and Well Written Essays - 750 words”, n.d.)
Retrieved from https://studentshare.org/miscellaneous/1558347-excel-project
(Excel Project Essay Example | Topics and Well Written Essays - 750 Words)
https://studentshare.org/miscellaneous/1558347-excel-project.
“Excel Project Essay Example | Topics and Well Written Essays - 750 Words”, n.d. https://studentshare.org/miscellaneous/1558347-excel-project.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Excel Project

Excel Project

...from that, the rest of the companies reported the positive returns in the given time frame. Results One basis of the results computed on the Microsoft Excel sheet along with the graphs, the analysis of 120 trading days’ activity clearly reflects that SAP performed remarkably well earning a gain of around $90,000, whereas Microsoft turned out to be the worst among all five participants reporting a net loss of around $55,000. The other three software designing firms produced mediocre results, presenting net gains $15,000, $9,000 and ?12,000 by oracle, Intuit and Sage respectively. Source Yahoo! Finance was used as the data source from the stock price data was retrieved. The reason for choosing this financial database is...
6 Pages(1500 words)Essay

MS Excel

...1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization. Microsoft Excel is a toolthat the various members of an organization utilize for various purposes and reasons. Among the most prominent users of Excel are the managers who happen to serve as the decision-makers in the firm. These people gain the most from the numerous tools that the software offers its users. Managers can utilize Excel in several ways and for several scenarios as well. Primarily though, the spreadsheet is most valuable when managers ponder on and engage in the decision making process. Its value lies in the fact that it is a highly...
2 Pages(500 words)Essay

Exercise for windows excel

...Assignment Project management can be defined as the process of knowledge, skills and techniques necessary in order to finish projects effectively and efficiently. It is considered a strategic competency for any organization, by connecting project results with business goals and enabling it to better compete in the market in which it functions. The most important part of this process is the planning, which includes the steps necessary to fulfill the task. This process has as primary step the initiation phase, in which the scope of the project and the resources necessary are clearly defined. Next, the planning phase must include the sources of funding the...
3 Pages(750 words)Essay

In excel:

...My Business and Number of Answer Report For any business to realize an increase in profits at the end of a given duration, quite a number of factors can be varied. Two parameters were chosen for this business model and that is: sales and cost of sales while maintaining all the other factors constant, e.g. those relating to customers. To do this, a spreadsheet named “Profit Analyzer” was created that projects the expected profits depending on how these two chosen parameters are expected to vary quarterly i.e. their percentage rate of increase or decrease (Ken Kaufaman, 2010). When a percentage rate of change is entered under the “Variations” column for either of the two parameters, say 105% if sales are...
2 Pages(500 words)Essay

MIS {excel project }

...Number: MIS Excel project The project is an analysis and decision tool for Capital electronics a business start-up that deals with retail sale of electronics. The business plans to invest $100,000 to purchase the items and carry out advertising. The source of the capital is from government grants, business loan and personal savings. The business loan and the Government grants will be repaid in a period of two years at an interest rate of 8 and 1.4 % respectively. The tool is made of six worksheets named products, sales, summary of sales, quantity of sold items, Cash flow and capital financing. The sheets contain different data and information. The excel...
2 Pages(500 words)Assignment

Excel Assignment

...ASSIGNMENT, BUSINESS EXCEL ASSIGNMENT By OWNERS OF SIMPLY AIRLINE, 4TH DECEMBER 2014 Dear Owner of Simply Airline, RE: THE PROGRESS I HAVE MADE IN IMPROVING THIS AIRLINE OVER THE PAST 8 QUARTERS I hereby wish to reiterate the progress that i have been able to make in the efforts ad input that I have done to make the operations of the Simply Airline improve. While in the process of ensuring the operations are effective, I managed to raise the salespersons from 1 to 2 in the first and second quarters and even raise the wage to $18000 for each employee. This was a good move as it motivated them to work harder, loyally and even be determined on operations of the business. In this context therefore...
2 Pages(500 words)Assignment

Excel

...INFS 3100 EXCEL ASSIGNMENT DUE: Wednesday, February 11 (beginning After 12:50 pm the assignment is considered a day late. See syllabus for late policy. Helpful Hint: Don’t forget to “Lock Cells” (Use absolute cell references) as needed when doing calculations for this assignment. Instructions: (use formulas or functions unless otherwise noted) 1. Download and open the template found on D2L. (Filename: 3100 Excel Assignment 1 Outline Spring 2015) 2. Set the value of the January “Beg. Of Month Inventory” equal to the “Initial Inventory” Cell. 3. Set the value of January “Production” equal to the “Initial Production” Cell. 4. Set the value of January “Units Sold” equal to the “Initial Units Sold” Cell. 5. Management predicts... “Not...
1 Pages(250 words)Assignment

Excel

.../1/2019 35.0000 1/1/2020 1,135.00 Price of Bond = c × F ×  1 − (1 + r)-t + F r (1 + r)t Present Value of Interest Payments = c × F ×  1 − (1 + r)-t r Present Value of Face Value of Bond = If the r is the interest rate prevailing in the market, c is the coupon rate on the bond, t is the time periods occurring over the term of the bond and F is the face value of the bond, the present value of interest payments is calculated using this formula. References Epmc, Inc. (2013). Project portfolio management a view from the management trenches. Hoboken, N.J., Wiley. http://rbdigital.oneclickdigital.com. Treynor Jack L., (1965)."How to Rate Management of Investment Funds", Harvard Kan, R. and Zhang, C. (1999),...
11 Pages(2750 words)Essay

EXCEL 5

...Number Lecturer Excel 5 Assignment The paper provides an observation and analysis of the projections of revenue from individualincome tax of the human resource department. The analysis involves identifying any trends (positive, negative or stationary) evident in the raw values in the receipts. It also entails identifying any anomalies such as big increases and decreases indicated by spikes and dips in the line graph. Additionally, any available patterns such as quarterly, annually or biannual, with respect to spikes and dips are identified. A comparison of the de-seasonalized and raw receipts is also done to identify whether the trend is clearer, whether there are any anomalies left or any more cyclical...
3 Pages(750 words)Assignment

Finance excel

...Retirement Plan Grade May 12th My Retirement Plan I believe I will retire when I am no longer in a healthy condition to serve society to the fullest. I believe that retirement should occur when I reach around sixty-years old. After considering the information in the Actuarial life cycle, I believe may live up to eighty years old (Cassidy, 2006). As such, as I plan for my living expenses during retirement, I will need to save enough money for twenty years, without work while maintaining the standard of living I had grew accustomed. Since I started work early, I will start to save when I am twenty years. The real rate of return is 7%, the years of retirement are twenty, and living expenses need are $36,000. The savings needed... Plan Grade May ...
1 Pages(250 words)Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Excel Project for FREE!

Contact Us