Free Essay

Business Computing Excel Spreadsheet

In:

Submitted By sheereen
Words 1137
Pages 5
Business Computing 1
ISYS2059

Sheereen Teo Su-Lin (S3304205) presents

Workshop Lecturer: Dr Lawrence Sim

Software Used:

* Microsoft Excel 2007 (Home edition) * Microsoft Word 2008: (License No: 92464-513-2506215-12994) * Microsoft Expression Web (Student version)

Attached Files: * Business Report.docx * Spreadsheet Assignment.xlsm * Website files * home.html * about.html * sit.html * work.html * registration.html * locate.html * contact.html * Formulae sheets

Attempted the High Distinction Level

Table of Contents 1.0 Executive Summary 3 2.0 Business Problem Opportunity 4 3.0 Recommendations (based on ‘What-if’ analysis) 5 3.1 Production targets 5 3.2 Fixed costs 5 3.3 Sales 6 4.0 Appendices 7 4.1 User instructions 7

1.0 Executive Summary

Classic Offices is a company that manufactures and sells chairs. The recent recession of 2009 had a negative global effect on markets all over the world and Classic Offices was adversely affected too.

Along with vital information such as income and commission figures, the increment of fixed costs and reduction of profits have been captured in the form of this user-friendly spreadsheet. This spreadsheet has been designed with the consideration of Classic Offices’ internal users in mind.

To make interpretation of the spreadsheet easier: * Different years have been colour coded * Appropriate command buttons (e.g. ‘Home’, ‘Print’) are accompanied with icons

Internal users of Classic Offices (mainly employees) will be able to view this data for work purposes. This data will also help to influence decision-making for internal users based on ‘What-If’ analysis. Essentially, the ‘What-if’ analysis serves as a prediction function.

For instance, if fixed costs were to increase, profits would be negatively affected and decrease as a result. Hence, with ‘What-if’ analysis, internal users will be able to view these predictions instantly.

Besides the spreadsheet, a prototype website has been created for Classic Offices. The site has a variety of information, from information about Classic Offices and the range of products available, to purchasing methods.

Like the spreadsheet, the website aims to be user-friendly by incorporating icons into the navigation bar and using more graphics instead of text.
2.0 Business Problem Opportunity

The economy is volatile and unpredictable. In 2009, the world was hit with yet another financial recession. As a result, markets all over the world were affected, and Classic Offices was no exception.

For the year ending 31 December 2009, production amount for Classic Offices was expected to be 60,000 chairs. However, because of the recession, the company decided to produce 55,000. Eventually, they sold only 50,000 out of the 55,000 chairs.

Economists forewarn that the economy may still be sluggish into 2011. As such, we have to make cautious predictions to protect Classic Offices during the recession period as sales are expected to drop by 5%, while fixed costs will increase by 3%.

3.0 Recommendations (based on ‘What-if’ analysis)

Essentially, the ‘What-if’ analysis allows for exploring all the various results using several different sets of values.

In this context, ‘What-if’ analysis has been used to predict possible figures under the scenarios of possible fixed costs increments/reduction and its impact on sales figures and profits.

3.1 Production targets

Based on the assumption that as 2010 transitions into 2011, the economy is still experiencing a slow-down, the figures for sales and profits will decrease linearly.

As such, the amount of chairs sold and chairs produced will remain at 50,000 and 55,000 respectively for all three years.

However, in the event that the economy picks up in 2011, Classic Offices would benefit by producing more chairs since consumers would be more willing to buy.

3.2 Fixed costs

It is predicted that fixed costs will increase by 3% in 2010 and this increment is also expected to negatively impact profits in the very same year.

Based on this prediction, and on the assumption that the economy in 2011 will still be sluggish, it is estimated that fixed costs will have increased linearly.

Alternatively, to consider the optimistic but cautious approach, there may be hope that while the market will still be slow, fixed costs will increase by only a little bit (1 or 2% instead of 3% or more).

Since inflation is inevitable, we may want to consider raising the selling cost of chairs in order to counter rising fixed costs. In turn, this would help Classic Offices to meet the profit targets achieved in 2009.

If we are unable to absorb rising fixed costs, then we are faced with two decisions: Either we source for more affordable alternatives or we sell more products in order to meet our profit targets.

3.3 Sales

Sales are generated from multiplying the number of chairs sold by the selling cost of one chair.

In 2009, the sales figure was $3,500,000. However, due to a 3% increase in fixed costs in 2010, sales dropped by 5% and net profit fell from $425,000 to $258.540.

Some economists also predict a gloomy outlook for 2011 as well. As such, net profit dropped further and fell from $258,540 in 2010 to $100,810 in 2011.

However, there are also optimists that believe the market may pick up slightly in 2011. If this were the case, fixed costs may only have increased slightly by 1% (as opposed to 3% in 2010). The net profit would then have been higher than $258,680 (as opposed to $258,540 in 2010).

Ultimately, sales should always be on the rise instead of going down.
4.0 Appendices

4.1 User instructions

Guide to accessing and navigating the spreadsheet:
Step 1: Log onto personal work account
Step 2: Search for the file ‘Classic Offices Spreadsheet Report’
Step 3: Double click the file ‘Classic Offices Spreadsheet Report’
Step 4: Once you are on ‘Main Menu’, navigate using the icons. There will always be a ‘Home’ button (shape of a house) to bring you back to the ‘Main Menu’.

Guide to accessing and navigating the website:
Step 1: Launch Classic Offices website
Step 3: Navigate using navigation bar at the top of the page. There are seven buttons in total – ‘Home’, ‘About’, ‘Chairs’, ‘Desks’, ‘Registration’, ‘Locate’ and ‘Contact’.

The spreadsheet was designed with both a layman user and an expert user in mind. Upon accessing the spreadsheet, the user is brought to the main page. From there, directions are straightforward because icons with the indicative words labeled beneath them serve as navigation.

For instance, a button labeled ‘home’ accompanies the ‘home’ icon, and a button labeled ‘calculation’ accompanies the ‘calculator’ icon.

Important notes are indicated with permanent comments so as to provide the user with additional information. Also, the figures for all three years (2009, 2010 and 2011) have been colour coded for easy reference.

Similar Documents

Premium Essay

Excel

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time consuming...

Words: 377 - Pages: 2

Premium Essay

Spreadsheet Modelling

...Word Count: 587 This is my own unaided work . SPREADSHEET mODELLING Word Count: 587 . SPREADSHEET mODELLING Spreadsheet modelling As a future financial analyst my work will be based on analysing data from company’s gathered data spreadsheets. Hence it is crucial for my own career success to understand the importance of spreadsheet modelling and its implementation. As according to (Susan Coles, Jennifer Rowley, 1996) “The decision maker’s judgement must be exercised in the interpretation of the data and the final decision making.” There is no better way of benefiting my future career than developing advanced skills in modelling Excel. As I have learned from few articles I read about this subject, there are many advantages of excelling my skills so as problems I should look out for. Firstly, studying advanced Excel modelling not only helps students to build technological knowledge but “also largely improve their practical analytical skills and abilities.”(Junying, 2010). By studying how to model spreadsheets students get a real chance to see how actual data is analysed by spreadsheet build in models and help them to further their own analytical knowledge and see how it works in real life. I think it is hugely beneficial for students in their further real...

Words: 715 - Pages: 3

Premium Essay

Google Drive

...HKU SPACE Po Leung Kuk Community College Higher Diploma Programme Business Information System Group Project Topic 1 - Google Drive Table of content: Content Introduction3 Introduction to Google Drive3 Functions4 1. Synchronizing files in your computer with Google Drive4 2. Share files with Google users5 3. Several Google Drive users can edit the same file at the same time in different places6 4. Google Drive viewer allows users to preview over thirty file formats8 5. Document offline editing10 6. Revision History11 7. Web app13 The area (other than Microsoft Office) that can assist users15 Conclusion17 Introduction Nowadays, cloud computing become more and more popular. The most famous tools providing all-round cloud computing service are Google Drive and Dropbox. Cloud computing refers to a model of computing that provides access to a shared pool of computing resources (storages, application, and services, over a network, often the Internet. End users can access cloud-based applications through a web browser or a light-weight desktop or mobile app while the business software and user's data are stored on servers at a remote location. One of the advantages of using cloud computing is the location independent resources. Introduction to Google Drive Google Drive provides Google users a 5GB free of cloud computing storage. It accompanies with Google Doc, offering web-based office suite and data storage service. It allows...

Words: 2677 - Pages: 11

Premium Essay

E&C Proposal

...E&C PROPOSAL Converting data currently held in Microsoft® Excel® spreadsheets into a rational database using Microsoft® Access® can be useful in creating reports. These reports can be run at any time by users. “With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information” (Microsoft Office Access benefits). Access can be used by multiple users working on the data at the same time; even several users can work on the same data at the same time. Access locks in a record only while the user changes it; when users use Excel workbook it can be shared, but users should change data in Excel at separate times for the process to work best. “If you need to connect to several data sources and edit the data directly in those sources, then Access is your choice. You can view external data with Excel, but you can't change that data” (Office Microsoft). Wireless to IT uses The benefits of using Microsoft Access in the work place for the company would be one of the easier ways to create contacts, assets tracking, issue tracking, project tracking. With the program it would keep up with current customers, and their previous order. The company with and using this program can also share or forecast their...

Words: 813 - Pages: 4

Premium Essay

Cloud Computing

...Cloud Computing and Accounting Information Systems Technology is a powerful tool that is revolutionizing and impacting the world in ways that were once never thought to be possible. Businesses thrive by investing time and money into modern technologies that redefine that way that these firms do businesses .One particular technology on the horizon in today’s society is cloud computing. Cloud computing is use of a network hosted on the Internet to store and access data and programs. After reviewing an article that discussing cloud computing and its effects on business, relating the idea of cloud computing to accounting information systems, and discussing opinions and issues concerning cloud computing, there will be a greater understanding about the impacts of cloud computing on the AIS system. The article chosen, which written by Ian Stone and published by The Guardian on April 15, 2014, is called “Cloud Computing Enables Businesses to Discover Their Entrepreneurial Spirit”. This article begins by stating that cloud computing is a game changer in the world of business. Cloud computing is stated as the storing and accessing of data and programs over the Internet instead of your computer's hard drive. This article says that one of the key benefits of cloud computing can be seen by the way it “levels the playing field”. Small business can have a better chance to compete with bigger firms because the initial cost of cloud computing is much less than the large expensive infrastructures...

Words: 1223 - Pages: 5

Premium Essay

Unabomber

...Cloud Computing and Accounting Information Systems Technology is a powerful tool that is revolutionizing and impacting the world in ways that were once never thought to be possible. Businesses thrive by investing time and money into modern technologies that redefine that way that these firms do businesses .One particular technology on the horizon in today’s society is cloud computing. Cloud computing is use of a network hosted on the Internet to store and access data and programs. After reviewing an article that discussing cloud computing and its effects on business, relating the idea of cloud computing to accounting information systems, and discussing opinions and issues concerning cloud computing, there will be a greater understanding about the impacts of cloud computing on the AIS system. The article chosen, which written by Ian Stone and published by The Guardian on April 15, 2014, is called “Cloud Computing Enables Businesses to Discover Their Entrepreneurial Spirit”. This article begins by stating that cloud computing is a game changer in the world of business. Cloud computing is stated as the storing and accessing of data and programs over the Internet instead of your computer's hard drive. This article says that one of the key benefits of cloud computing can be seen by the way it “levels the playing field”. Small business can have a better chance to compete with bigger firms because the initial cost of cloud computing is much less than the large expensive infrastructures...

Words: 1223 - Pages: 5

Premium Essay

Microsoft Office Program: Helpful to Student's Studies

...Microsoft Office Program: Helpful to Student’s Studies I. INTRODUCTION In this fast reaching world, the studies of every individual become more complicated. We have now going beyond the imagination of each human being and applying this through technology. Merely fact, technology is a very big help in the lives of each learners specifically to the highschool students here in Gonzalo Aler National High School. The school adapted technology as one of the most important tools in learning and computer is one of the best examples. Computer is one of the best systematic knowledge that can be used. Using this product of technology, learners challenged to be maximized in their learning by being more creative and become more interested in studying. Today, computer does not just help to the student but it is an essential one to give courage and help improves the skills of individual. With the ever increasing population of computer technology, it is almost impossible to find an educational establishment that does not use it. Computers are becoming a more and more important within education as both a learning tool for students and for keeping records of all individuals at the school. Computers allow students to access more information more easily and the introduction of the internet means that this information is available to hand 24/7. Whether this is a good prospect or not is something that is debated frequently. For every factual and accurate piece of information that can...

Words: 3073 - Pages: 13

Premium Essay

Ceis100 Entire Course

...network. • How will networking impact you in your professional life? CEIS 100 Week 2 iLab Report Laboratory Title: Determining what will make the Raspberry PI computer a functioning piece of equipment and obtain the necessary components. • Objectives: (What was the purpose of this lab? What did you expect to find?) • Results: (What did you find?) • Conclusions: (What does this mean? How can this be used? What implications can I draw from this?) CEIS 100 Week 3 Course Project Excel uses and Gaming • Give an example of a situation for which would need a spreadsheet. How would functions be useful in your spreadsheet? • Describe your favorite game and discuss the ways in which the game presents challenges to the player and the ways in which the player is able to solve those challenges. Provide two examples of how you would improve the game. • How does communication and ethics impact your professional life? CEIS 100 Week 3 iLab Report Laboratory Title: Using Excel to Solve a Business Problem CEIS 100 Week 4 Course Project...

Words: 569 - Pages: 3

Premium Essay

The Future of Corporate Performance Management

...Management Abstract Adaptive Planning is a Corporate Performance Management system that has foreseen the future of IT. They have adapted a full service CPM system which can accommodate customers from beginning to end. The “cloud” has become a vital asset to the selling point which will forever change IT as we know it. This new system has allowed companies to “Dramatically reduce budgeting and forecasting cycle times by up to 90%” (Product Overview). “Allowing them to make faster, more informed and better decisions” (Product Overview). This paper will discuss the alternative of cloud computing and many of the other assets to automating the CPM cycle. We will discuss Bridon American Corporation’s (BAC’s) process of forecasting, budgeting and financial reporting prior to implementation and after implementation of Adaptive Planning. Keywords: forecasting, budgeting, financial reporting, cloud computing The Future of Corporate Performance Management “Corporate Performance Management is a cycle that begins with budgeting and continues to comparison of actual performance against the plan” (Product Overview). “Reports and dashboards are used to analyze real-time data, and compare it to what was planned. Based on this analysis, the cycle begins again, with what-if analysis and re-forecasting” (Product Overview). “A truly integrated and automated cycle has tight collaboration among managers throughout the organization, as well as tight integration between systems- the GL and other...

Words: 2174 - Pages: 9

Premium Essay

Chapter 4 Review Questions 1-5

...technology, and technology services. 2. What are the major computer hardware, data storage, input, and output technologies used in business? * Computer Hardware: Mainframes, midrange computers, PC’s, workstations, and supercomputers. * Data Storage: Magnetic disk, optical disc, magnetic tape and storage networks. * Input devices: Keyboards, computer mice, touch screens (including those with multitouch), magnetic ink and optical character recognition devices, pen-based instruments, digital scanners, sensors, audio input devices, and radio-frequency identification devices. * Output devices: Display monitors, printers, and audio output devices. • List and describes the various type of computers available to businesses today. * Mainframes are a large-capacity, high-performance computer that can process large amounts of data very rapidly. * Midrange computers are servers computers are specifically optimized to support a computer network, enabling users to share files, software, peripheral devices (such as printers), or other network resources. * PC’s are desktop or laptop machines. * Workstations are desktop machines with powerful mathematical and graphic capabilities. * Supercomputers are sophisticated, powerful computers that can perform massive and complex computations rapidly. • Define the client/server model of computing, and describe the...

Words: 3229 - Pages: 13

Free Essay

Constructing Formulas for Mathematical Operations in Excel (Basic Tips and Techniques)

...Constructing Formulas for Mathematical Operations in Excel (Basic Tips and Techniques) Michelle A. Applequist Computer Information Systems (CIS105) Professor Hari Dhungana Strayer University September 1, 2009 Constructing Formulas for Mathematical Operations in Excel Microsoft Excel uses formulas to construct mathematical operations in a worksheet. After data have been entered into the worksheet, you can perform calculations, analyze data, and create charts. An Excel formula (calculations you create) and functions (formulas pre-existing in Excel) calculates the data entered in the worksheet. Formulas calculate numbers in a particular order. “Excel has one of the most comprehensive set of formulas, not only to perform calculations but also to manage data and records. It also has the ability to instantaneously re-calculate the results as the raw data changes” (Khoo, 2006-9, para. 2). To construct a formula after you have entered data, you must click in the cell that you want the results to appear in, and then type the formula. You can construct formulas by using the sum function, and editing numbers in a cell. It is stated that: Sum is an Excel function—a prewritten formula. Sum indicates the type of calculation that will take place (addition). When the sum function is activated, Excel looks above the active cell for a range of cells to sum. If there is no range above the cell, Excel will look to the left for a range of cells to sum...

Words: 694 - Pages: 3

Free Essay

Interpretation of Modeling and Simulation

...out there that uses Microsoft Excel to conduct modeling to simulate their business growth other than Microsoft itself? Microsoft has made billions of dollars selling their Microsoft Office Suites and their home computer operating systems around the world. They have become one of the largest and well known companies in the world. The way that I see it, is that Microsoft’s business model, in a nutshell, is to provide goods and services in the form of software and support to paying customers. One question that may be asked in this day an age is with the advances in cloud computing and Google’s “free” gadgets, will the traditional Microsoft’s business model come to an end? What will Microsoft’s business analysts do in order to change their business model? One can only imagine that it will need to be modeled and simulated first to avoid potentially expensive mistakes. I must start off by saying that before I started my Systems Modeling Theory online class through Strayer, I thought that it may just be one of the hardest classes to understand that I’ve ever taken throughout the course of my college career. I can say now after having completed the last nine weeks of class that I was correct. What’s hard, is not understanding the concepts of why businesses would use Excel models for their business growth but rather the actual use of Excel itself. With all of the bells and whistles an who’s-its and what’s-its that Excel provides for the Business Analyst professional, it’s...

Words: 1781 - Pages: 8

Free Essay

Mat540 Jet Copies

...a company designed to alleviate a longer commute and longer wait time, and possibly have a more cost efficient method for the college students to make copies. The three students James, Ernie, and Terri decided to go into business together with a copying business initiative. Considering what was ahead of the new business, for example, possible machine downtime and days to repair the copier, they had to determine the average number of days that it would take for them to acquire a repair team to fix the machine in the event that it broke down. As discovered, the average time for repair was between one and four days. In order to calculate the average, a probability distribution was developed using Microsoft Excel. From there, the cumulative probability was obtained by adding the probability, P(x), from the previously itemized probabilities where the cumulative summation of a probability is always equal to one (1) or 100%. A random number formula, =RAND(), was plugged into the Microsoft Excel desired cell, in this situation, (H4), which generated a random range of numbers that are greater than or equal to zero and less than one. The interim time between breakdowns were achieved simply by soliciting the experience several staff members in the college of business who were familiar with frequency of the copier’s inconsistent behavior. It was estimated that the time between breakdowns was probably between zero and six weeks. Using the continuous probability distribution formula, x=6√r1...

Words: 679 - Pages: 3

Premium Essay

It Consultation for Mr Green

...Microsoft for use on the personal computers including business desktops. Windows 7 is compatible with many applications and hardware with which its predecessor Windows Vista was already compatible with. Windows 7 includes a lot of features which include in touch and handwriting recognition that support virtual hard disks for performance improvement on multi-core processors which Mr. Green already has. With these feature Mr. Green can be able to run his business more efficient and effective with little labor force (Ahdieh, 2004). IT Consultation Windows 7 has an improved boot performance with direct access and kernel improved to support the systems with multiple heterogeneous graphic cards for better performance (Brenner, 2010). It is designed with a calculator which has multiple functions that can enable Mr. Green to be more accurate in the accounting functions of the business. The Windows 7 blog has the tracing tools that can be used to ensure the performance in many areas on the operating system and help to locate inefficient code path and control performance regressions that might occur on the process (Armstrong, 2002). The windows 7 ultimate has higher resolution with high settings that will enable Mr. Green to perform multiple tasks at the same time. With the high resolution he is able to serve several customers within a very short time and this will enable his customer remain satisfied and maintained in his business. Windows 7 Ultimate is able to have shortcuts on my desktop...

Words: 814 - Pages: 4

Free Essay

Phar-Mor

...quantity, but do not shortchange your answers) * TO GET CREDIT YOUR ANALYSIS MUST FOLLOW CONCEPTS IN THE BOOK & READINGS. * DO NOT GO OFF ON generic TANGENTS. * MAKE reasonable ASSUMPTIONS IF YOU NEED TO and list them READ CAREFULLY AND ALLOCATE YOUR TIME WISELY!!!!! TO BE SUBMITTED: Create a zip file and include the following: * This Exam with answers (including Evidence FORM) * Excel spreadsheet related to Q7 Q#1 Multiple Choice: (3 points) 1. A supervisor having to decide when to reorder supplies or how best to allocate personnel for the completion of the project is an example of a _________ decision. a. structured b. unstructured c. semi-structured d. none of the above 2. Each team has only one home stadium and each stadium can have many home teams. This is an example of what kind of relationship between TEAM and STADIUM? a. 1:1 b. 1:m c. m:n d. m:1 3 Amazing electronic ( a fictious company), an electronic retailer, recently declared bankruptcy and went out of business. This would, typically, A) increase Buyer’s power B) increase Supplier’s power C) make it easy for others to enter the electronic market D) None of the above Q2. Wendy’s International, a...

Words: 2938 - Pages: 12