1. PURPOSE OF THE DATA
In this spread sheet the purpose of the data was to show the forecast of Humber Computing Solutions for the period of one year for three different services/products. The data represents the income from each product/service and total income and the same for expenditures. There is also a section that shows the amount of hours clients had issues with products/services and what was offered back to them as a way of compensation for any income they could have lost to no fault of their own. The data was supposed to be easy to read and understand by whoever was using the data sheet the graphs and charts were well displayed on their own pages rather than having them all squashed to fit one page.
Although many formulas have been used all are performing the same type of calculation. Each monthly sum is using the add formula to calculate the month by month income. There are many formulas that are possible to use but in this case the add formula was the one that fit the purpose. There are also two IF statements in the data sheet. (Office.microsoft.com, 2014) “The IF function checks to see if a condition you specify is true or false. If true, one thing happens if false, something else happens” as described by the makers of Excel. The IF statements are logical tests so in this data sheet the bonus IF statement =IF(O28
The cash flow forecast was made easier to u...
... middle of paper ...
...y show as currency in the income and expenditure cells.
7. TEST PLAN
For all workbooks produced a test plan should be available to be consulted by whoever needs to use the document and can outline how to put issues right if any occur.
In the test plan every aspect that is automated was tested to make sure it worked. One of the routines failed and this was an IF statement the problem was the = was missing from the code and once added the problem was rectified and the test passed.
The test plan will tell the user exactly what cells are being used for each automated formula or macro.
Office, microsoft.com, (2014). The IF function: what it is, and how to use it - Excel. [online] Available at: http://office.microsoft.com/en-gb/excel-help/the-if-function-what-it-is-and-how-to-use-it-RZ102425926.aspx [Accessed 22 May. 2014].
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- At some point in your life you’re going to have to use Word, Excel and PowerPoint whether it’s in your personal life or your professional one. I must say though my favorite and most productive of the three would have to be Excel. Excel is a spreadsheet design by Microsoft that can be ran on numerous operating systems. From Windows servers 2008 to windows 8.1 with a memory of 1or 2 gm rams. Although if you want to access the graphic features on excel it is best to use a 2 GB ram which is (64- bit).... [tags: Spreadsheet, Microsoft Office, Microsoft]
853 words (2.4 pages)
- Spreadsheets are never ending grids which store data in columns and rows, Columns go up in letters while rows go up in numbers. Each cell has its own address for e.g. B7. The column letter always goes first in cell addresses. Basic and complex formulas can be used in spreadsheets to complete various tasks and once they have been implemented into the spreadsheet it’ll automatically change parts of the spreadsheet if you change anything or add extra things. E.g a sum formula in 10 rows with a total if there are only 9 different numbers to add and then you add another number into the 10th row it’ll automatically add that to the other 9 numbers without you having to do anything.... [tags: complex problems, payroll, forecasting]
818 words (2.3 pages)
- It took me the whole forty-five minutes to work on the excel spreadsheet. The excel spreadsheet project was going really well for me until I got three quarters of the way to the end. I am really struggling on the formulas and once I pick them up I should be good. Your year in school and when you expect to graduate. I am in my junior year at Western Michigan University. And I am expected to graduate, in my spring semester, of the year 2018. Explain why are you taking this class. I am taking this class so I can learn the techniques needed to be successful, when managing sales employees.... [tags: Spreadsheet, Microsoft Excel]
732 words (2.1 pages)
- Three methods that L.L. Bean uses to determine past demand data and a specific item forecast to decide how many units of that to stock are: frozen forecast, A/F ratio demand, and forecast demand. Frozen forecast is based on items in the future period, which is done by the forecasting department and it involves book forecasting and past demand data. One advantage is that this forecast is used together with historical forecast errors, known as A/F ratios. A/F ratios are comprised of past season items and actual demand.... [tags: Future, Forecasting, Forecast error, Mathematics]
903 words (2.6 pages)
- Designing a Spreadsheet for a Company [IMAGE]I have been asked to produce a working spreadsheet of a electronic Ticket Recording System I am going to design the spreadsheet for a company called ‘The Grand Theatre’. The Grand Theatre is a musical theatre based in Montgomery Park, Belfast. The company shows two productions every month, each of them lasting two weeks. The two productions are ‘The Pirates of Portstewart’ and ‘The Marriage of Roberto’. Due to the theatre market changing rapidly I am going to implement a computerised ticketing system for all the monthly production sales.... [tags: Papers]
807 words (2.3 pages)
- i)Graph1.1 ii) The time series exhibits a fair degree of volatility or randomness.The underlying level of the series over the given time period appears to be well contained in an underlying band of 0.9250-0.9450. The level of this time series also appears constant over the entire time series and hence a horizontal data pattern is observed. Since the time series is relatively horizontal with trend and seasonality not apparent in this time series, then moving average and simple exponential smoothing would be possible predictors for future days USD/AUD exchange rates.... [tags: Forecasting]
1975 words (5.6 pages)
- Forecasting Methodology Forecasting is an integral part in planning the financial future of any business and allows the company to consider probabilities of current and future trends using existing data and facts. Forecasts are vital to every business organization and for every significant management decision. Forecasting, according to Armstrong (2001), is the basis of corporate long-run planning. Many times, this unique approach is used not only to provide a baseline, but also to offer a prediction into the corporation's future.... [tags: Business Forecasting ]
1444 words (4.1 pages)
- Analysis Memorandum Introduction This is an analysis memorandum proposing the use of Microsoft Access databases within our Security Division’s infrastructure. Many security managers are relying heavily on the use of Microsoft Excel spreadsheets in order to keep track of their personnel, security violations, inspection programs and training. While spreadsheets are effective means for complex calculations they are also limited in that they basically fall short in showing the relational qualities of security data in relationship to particular fields and queries.... [tags: Database Data Spreadsheet Access]
1479 words (4.2 pages)
- Introduction All businesses are confronted with the general problem of having to make decisions under conditions of uncertainty. Management must understand the nature of demand and competition in order to develop realistic business plans, determine a strategic vision for the organization, and determine technology and infrastructure needs. To address these challenges, forecasting is used. According to Makridakis (1989), forecasting future events can be characterized as the search for answers to one or more of the following questions: X What new economic, technical, or sociological forces is the organization likely to face in both the near and long term.... [tags: Business Analysis Forecasting]
1651 words (4.7 pages)
- Forecasting Methods Forecasting demand is not an easy task. The market is constantly changing and it makes the product demand difficult to predict. Therefore, there is not such as perfect product forecast of what customers will need in the future. However, there are several methods that help attenuating the uncertainty of forecasting demand. Since, the forecast methods or techniques differ from one another; the objective is to compare and contrast several forecasting methods, and how they are used by organizations to the best advantage under conditions of uncertainty.... [tags: Business Market Forecasting]
901 words (2.6 pages)