Nobody downloaded yet

EXCEL 5 - Assignment Example

Comments (0) Cite this document
The analysis involves identifying any trends (positive, negative or stationary) evident in the raw values in the receipts. It also entails…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER98.5% of users find it useful
Read TextPreview

Extract of sample "EXCEL 5"

Download file to see previous pages ceipts is also done to identify whether the trend is clearer, whether there are any anomalies left or any more cyclical patterns lasting more than one year. Finally, a review of the double smoothed results to determine whether the values from the projected position are reasonable. We can also determine the impact of the recent values on the projection and whether it skews the projection.
From observing the raw receipt data, it is evident that there is both positive, negative and stationary trends at different months of the line graph. The initial months show a positive trend for the first points before a negative trend begins. This trend doesn’t last long before another stationary then positive trends are observed. Essentially, there is no definite trend with the raw receipts as it emerges as a zigzag trend of positive, negative and stationary trends. Generally, a positive trend is observed. There are few anomalies observed through the projection period. The first anomaly is a spike in the 10th month of the projection period. Another spike though not too significant is evident at the 22nd month. A significant anomaly is evident at the 46th month where the highest spike in the entire projection period is observed. Other minor spikes are shown at the 36th and 40th month of the projection period respectively. There is no significant dips (decreases) in the projection period although minor decreases in the 9th, 21st, 30th, 33rd and 45th can be observed from the graph. Particular patterns can be observed in the dips (decrease) and spikes (increase) in the projection period. The spikes (increase) seem to occur after twelve months exhibiting an annual pattern over the projection period. The dips (decrease) however, do not exhibit a particular pattern as some occur after 2 months. It is also important to note that after every dip (decreases) there is a spike (increases) in the following month but not of equal proportions.
The comparison between the de-seasonalized and ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“EXCEL 5 Assignment Example | Topics and Well Written Essays - 750 words”, n.d.)
EXCEL 5 Assignment Example | Topics and Well Written Essays - 750 words. Retrieved from
(EXCEL 5 Assignment Example | Topics and Well Written Essays - 750 Words)
EXCEL 5 Assignment Example | Topics and Well Written Essays - 750 Words.
“EXCEL 5 Assignment Example | Topics and Well Written Essays - 750 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document


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

Excel Project

...grains & cereals showed an increase in 2005, its sales performance decreased in 2006. Graphic Recommendation It is recommended that the company shall focus on the top 5 performing product categories. A more focused and less diverse product portfolio would make the company more efficient and effective. The top 5 performing categories are the sales generating and revenue drivers of the company. The other products that do not perform are becoming more of a liability than an asset to the company. SELF ASSESSMENT From completing the Excel project, I learned the advantage of organizing the data before doing any analysis. Organizing the data makes it easier to read. Applying formats would...
3 Pages(750 words)Essay

Exercise for windows excel the case there are areas that are over budgeted and some that are under budgeted. Also, alternative plans should be considered if an activity was under budgeted and there is a need for decision making if additional money should be obtained. Other concepts necessary to be taken into account are quality and closure. These should be considered when purchasing operating systems, furniture, equipment and other technology related issues. It can be said that many projects are dependent on the technology that is currently in use. 2. (a) A course I take this semester is Math. (b) This course is on all Tuesdays and Thursdays of this semester. (c) Math is from 4:30 pm until 5:15 pm. (d) In the next table, it is presented a...
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 projected to increase at a rate of...
2 Pages(500 words)Essay

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


...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


...returns, and its total worth combines both of these sums. The bond’s returns are proportional to its par value, so it’s easy to express the total value as a percentage price of par. A bond that is worth a high percentage of its oar value offers large returns each year, thus making the investment better. Below are the percentages of coupon payment and face value. Sum of coupon payement     625.97 PV of face value     552.88 Bond price     1178.85 Percentage of coupon payment from bond price     53.10% Percentage of Face value from bond price     46.90% The bond price percentage was calculated using the formulae; Computation of the yield-to-call based on the fact that the bond is callable at $1,100 after the first 5 years...
11 Pages(2750 words)Essay

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

Choose 1 of the 3 topic. 1. best management theory. 2. how to lead a team excel. 3. the dangers of groupthink & the cures. 5 pages. due on 06/05

...How To Lead A Team Excel Introduction Leading is influencing and motivating the employees to achieve the company’s goals. Traditional team leadership has evolved due to the introduction of information technology in the workplace as well as organizational boundaries. Therefore, managers need to form effective teams while incorporating effective measures for their efficiency and organizational performance. Team definition A team is a small group of people who share a common purpose, commitment and performance goals and consequently have a mutual accountability (Williams and Angelo 417). Team development For overall effectiveness of the teams, managers must initially initiate 5 stages during development...
5 Pages(1250 words)Article
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 Assignment on topic EXCEL 5 for FREE!

Contact Us