...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...
Words: 1137 - Pages: 5
...Use of Spreadsheets in Business and Technology Marty Montgomery August 25, 2013 Many corporations depend on spreadsheets as a fundamental (Institute of Corporate Auditors, 2006) device in their financial reporting and operational processes. As a result, the use of spreadsheets is an essential part of the information and decision-making structure for these organizations. In developing and using spreadsheets, organizations need to balance their ease and flexibility against the value of reliable information for management’s application. As users of spreadsheet applications such as Microsoft Excel® or Lotus 1-2-3® have become more sophisticated, so have spreadsheets. Once used to support simple functions such as logging, tracking and totaling information, spreadsheets with enhanced formulas and built-in advanced features are now used to support such business functions as complex valuation models. The use of macros and multiple spreadsheets which are linked together allows users to build very complicated—and sometimes convoluted—models and other business functions with minimal or no documentation. In addition, these complex spreadsheets are not usually supported by the same control environment as formally-developed, purchased applications. For example, the developers and users of spreadsheets are usually not trained in structured programming, testing, version control or systems development life cycles, and spreadsheets are rarely restricted from unauthorized access by security...
Words: 949 - Pages: 4
...Data Analysis and Business Decision Making Session – IV Chapter 11: Linear Programming Chapter 12: Transportation, Transshipment, and Assignment Problems Chapter 13: Decision Analysis Faculty Pankaj Dutta Chapter – 11 Linear Programming LPP solution through Excel Solver: The Steps in Implementing an LP Model in a Spreadsheet: 1. 2. 3. 4. Organize the data for the model on the spreadsheet. Reserve separate cells in the spreadsheet for each decision variable in the model. Create a formula in a cell in the spreadsheet that corresponds to the objective function. For each constraint, create a formula in a separate cell in the spreadsheet that corresponds to the left-hand side (LHS) of the constraint. PANKAJ DUTTA IMTCDL Chapter – 11 Linear Programming LPP solution through Excel Solver: Max Z = 350X1 + 300X2 Subject To 1X1 + 1X2 ≤ 200 9X1 + 6X2 ≤ 1566 12X1+16X2 ≤ 2880 X1 , X 2 ≥ 0 1. Organize the data for the model on the spreadsheet. PANKAJ DUTTA IMTCDL Chapter – 11 Linear Programming LPP solution through Excel Solver: Max Z = 350X1 + 300X2 Subject To 1X1 + 1X2 ≤ 200 9X1 + 6X2 ≤ 1566 12X1+16X2 ≤ 2880 X1 , X 2 ≥ 0 1. Organize the data for the model on the spreadsheet. Changing cells Target cell PANKAJ DUTTA IMTCDL Constraint cells Chapter – 11 Linear Programming Max Z = 350X1 + 300X2 Subject To 1X1 + 1X2 ≤ 200 9X1 + 6X2 ≤ 1566 12X1+16X2 ≤ 2880 X1 , X 2 ≥ 0 LPP solution through Excel Solver: ...
Words: 798 - Pages: 4
...improve its business intelligence (BI) capabilities and operational efficiency. So Volvo decided to prototype a Microsoft data management solution that simplifies its IT environment, provides graphical self-service reporting capabilities, and improves collaboration. Business Needs By the time that Zhejiang Geely Holding Group completed its acquisition of Volvo Car Corporation in 2010, the IT environment at Volvo had become complex, difficult to manage, and expensive. Over the years, a variety of data management and business intelligence products had been deployed. Volvo wanted to reduce the number of these products to make the overall system easier to manage and to reduce licensing and other costs. “All the products out there have been purchased by some department at some time in history, and we’re trying to consolidate and simplify our BI infrastructure,” says a Volvo IT architect. Volvo also wanted to improve its business intelligence capabilities to achieve greater insights into such things as assembly and product development costs and to help employees produce reports more quickly and easily. “With the old systems, users had to sample their own data from various sources, integrate the data, and produce the reports—and that cost a lot of time,” says a senior business analyst for business demand and strategy at Volvo. In addition, Volvo needed reports that are easier to understand so that Volvo analysts and managers could build more persuasive and effective business cases for...
Words: 372 - Pages: 2
...DeVry University Keller Graduate School of Management Creating a Database for Storing and Managing Church Members’ Record for R.C.C.G. Heaven’s Gate Gbolade O. Soneyin gsoneyin@my.keller.edu (770) 598-5006 MIS-535-18371 Managerial Applications of Information Technology Professor Tanya Cannon Thursday, February 12, 2015 Table of Contents Subject of Course Project 3 Business Problem Stated 3 Name of the Organization 3 Proposed Solution 3 General Benefits 4 Audience 4 References 5 Abstract To help Heaven’s Gate move away from tracking its members on spreadsheets and paper, move to a database application that will not only track members, but also track department activities, members contributions, and do it all via the least economically, but yet effective, easily accessible and requiring limited technical or IT expertise to maintain. Keywords: RCCG, Database, Church, Heaven’s Gate, Application, Church Management Company Background Heaven’s Gate is one of many parishes of the Redeemed Christian Church of God (RCCG), headquartered in Lagos, Nigeria; finding out exactly how many parishes of the church existed was next to impossible. In her well-detailed article on the church, Olufunke Adeboye wrote about the church from 1952-2005. Founded by Josiah Olufemi Akindayomi in 1952, after receiving vision to write down the church’s name on a wooden board, this despite the fact the man was unschooled at the time; he cannot read nor know how to write. After writing...
Words: 1607 - Pages: 7
...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
...Alternative “C” Economic Analysis * Contains: 1. Tangible Benefits Worksheet 2. One Time Cost Worksheet 3. Recurring Cost Worksheet 4. Discount rates * Used to create Cost/Benefit Analysis Spreadsheets for possible alternative solutions. Cost/Benefit Analysis spreadsheet is located in doc sharing. * Description of Alternative C – Nova Corporation. (see page 151 in the book) 1. Industry Leader in CRM solutions 2. Large and complex 3. Pricing only based on modules purchased 4. License for the use of the system is middle of the row 1. Tangible Benefits Worksheet - Nova Nova - Alternative “C” Tangible Benefits Worksheet | A. | Cost reduction or avoidance | $12,500 | B. | Error reduction | $ 3,500 | C. | Increased Flexibility | $ 5,500 | D. | Increased speed of activity | $ 7,500 | E. | Improvement management/planning control | $15,000 | F. | Ease of interfacing with business partners | $16,000 | Total Tangible Benefits | $60,000 | 2. One Time Cost Worksheet – Nova Nova - Alternative “C” One Time Costs Worksheet | A. | Development Costs | $ 2,000 | B. | New Hardware | $ 1,000 | C. | Software License or Purchase cost | $19,500 | D. | User Training | $ 3,500 | E. | Site Preparation | $ 4,000 | Total One Time Costs | $30,000 | 3. Recurring Cost Worksheet – Nova Nova – Alternative “ C” Recurring Cost Costs Worksheet | A. | Software Maintenance | $ 2,500 | B. | Incremental Data Storage...
Words: 265 - Pages: 2
...In the beginning of this term I was told that I would have to be playing a simulation game called Mogul. From other students who had previously took the class told me that this game was one of the most difficult games to understand. This began to worry me because I thought that if they had hard time it was going to be impossible for me. Mogul allows students to maintain the operations for a small manufacturing company that produces two different products. There are various decisions that have to such as operations, marketing and financial. In time Professor Mullen had given us a excel spreadsheet to follow when trying to make decisions for Mogul. However, it was confusing to me because the game was not at all like the spreadsheet so I went into the game a little blind because I had no clue on how to apply the spreadsheet to the actual game. So to make up for the confusion I just made notes from class on what could possibly be beneficial to me for the game. My main goal for this game was to just stay a float and keep a steady cash flow to keep up with my other competitors. However, the major mistake that I had made was that I did not establish a specific strategy to play the game. The first time that I enter into the game I was unable to play. At first I was a little concerned but I spoke with my professor and he told me that if you did not input any decisions it would just carry the same information into the next round. So after that miss fortune I though that it would...
Words: 1028 - Pages: 5
...Efficiency & Collaboration Proposal Converting from Microsoft Excel to Microsoft Access would be very beneficial as with Party Plates Company it is great for data management. As they both preform similar functions they still offer different things in the program. Access works both independently and interdependently allowing users to combine data and information from several sources. As access is a data management system it is used best with storing large amounts of data. This will help the party plates company as it can hold information such as: item numbers, quantity, description, and etc. This function is great for a business rather than Excel utilizing tables, as this program is more for calculations and functions in a spreadsheet style. When using Excel it is mainly numerical, non-relational, and used with calculations. If you wanted to share your spreadsheet to a different coworker then it may be more of a hassle if they do not have the same version of Excel as you. Access allows the company to group different thing in access better like colors of plates, size of plates, what customer orders what and their information. As for collaboration software, if the company is already using Microsoft, one might really like using Lync. It can be used an instant message function, as well as share your screen, share documents, video chat, and take notes. All that has to done is be logged in to the account and Lync can automatically load, and connect companies to other companies. Plus...
Words: 415 - Pages: 2
...Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. Insert Tab This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers. Page Layout Tab This tab has commands to adjust page such as margins, orientation and themes. Created By: Amy Beauchemin Source: office.microsoft.com 1/13/11 2 Formulas Tab This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or function in your spreadsheet. Data Tab...
Words: 7496 - Pages: 30
...submitted file as such: COMM491-VSP_Summer2015_IndustryAnalysis_Cohort#_Team# , where Cohort# is either Cohort4 or Cohort 5; and Team# is your team number, such as Team2. Topic: Each team must perform an industry analysis on one of the following industries: * Craft or micro-breweries in B.C. * Food trucks in Vancouver * The cleantech industry in Canada * Private tourism agencies in Canada catering to Chinese tourists. Thus you have different geographic areas to also consider; you must choose your topic and post it on the discussion forum on Connect no later than 1700hrs on Sunday, July 26. No more than three teams in each cohort may choose the same topic. Assignment: Suppose that your team is thinking of starting a new business in the industry chosen. Using Porter’s Five Forces: 1. Existing Industry Rivalry 2. Threat of New Entries 3. Bargaining Power of Suppliers 4. Bargaining Power of Customers 5. Threat of Substitutes 6. plus the sixth force of Complements if it is applicable Analyze factors which apply to the industry, and categorize them as either (+) increasing that factor (e.g., makes the threat of new entry greater) or ()...
Words: 1010 - Pages: 5
...Spreadsheet Modeling Assignment 1. Objectives The purpose of this assignment is to use some of the more advanced tools that Excel provides to develop a model of a complex business problem. In particular, you will use the following Excel features: 1. Importing data from text files 2. Sorting data 3. Database functions 4. Pivot Tables 5. Data Tables 6. Goal Seeking 2. What You Will Need 1. Access to a computer with a printer and Excel 2007. 2. Note that the instructions in this handout are written for Excel 2007. There are significant differences in user interface between Excel 2007 and 2003. 3. Download the following three files: Mymodel.xls, labor.txt, and demand.txt. 3. What You Will Hand In 1. a CD containing the model your group develops - on the outer label, write the course number, group number, the name of each group member 2. two full-page charts (with your course number and group number as a footer) 3. four worksheet printouts (with your course number and group number as a footer) 4. Make sure your CD is free of any computer virus. A contaminated CD will result in a 50% penalty in grade! 4. Due Date Check the course syllabus for assignment due date. A penalty will be assessed against assignments handed in late (including during class). 5. Background You work for the NOVA Corporation, a mid-tier supplier of hoses and hose assemblies...
Words: 4251 - Pages: 18
...SIMPLE LINEAR REGRESSION EXAMPLE Butler’s Trucking Company is an independent trucking Company in southern California. A major portion of Butler’s business involves deliveries throughout its local area. To develop better work schedules, the managers want to estimate the total daily travel time for their drivers. Initially the managers believed that the total daily travel time would be closely related to the number of miles traveled in making the daily deliveries. A simple random sample of 10 driving assignments is provided in Table 1. Use Excel to make a scatter diagram of these deliveries (to verify that a linear relationship does exist) and develop a regression equation expressing this relationship. |Table 1 | | | | | |Driving Assignment |X1=Miles Traveled |Y=Travel Time (hrs.) | | |1 |100 |9.3 | | |2 |50 |4.8 | | |3 |100 |8.9 | | |4 |100 |6.5 | | |5 ...
Words: 300 - Pages: 2
...Introduction to Computer CS140 03 May 2005 My First Computer Introduction I began working with computers about 3 years ago. Needless to say it was a shocking experience sitting in front of a picture tube and not knowing how it worked or where to begin. I began by hitting buttons and asking question at the same time. The first computer that I bought was a new Packard Bell 486 with windows 3.1 and a Cannon bubble jet. It was more troublesome to use and I was not computer literate and I had no ideal what I had but I had a computer in my home. I was asked prior to buying the computer what I wanted put on it my answer was whatever it comes with and I had no idea what to use so the guy put some programs on it and I took it home and was in business. I would do little things at first just to try and get a feel for this thing but it would amaze me or frustrate me. I had this thing and did not know what to do with it at times I felt like throwing it out the window. The more I tried reading the book the more I got confused and I had no patience with this technology. I looked through several different computer books and that did not help. So I finally gave up on computers and left them alone for several years. After five years I found myself in the need of a computer because I had moved up in position and it required the use of a computer and everything was becoming electronic including the forms. I when out and brought a new up to date computer for that time. It came with all this fancy...
Words: 389 - Pages: 2
...12345 Sandwedge Lane Houston, TX 77577 October 27, 2014 Mr. David M. Ambrose, MAI, President Address Dear Mr. Ambrose: The Ambrose Appraisal Company is well known for high level concluded opinions that are well support by the most current market data. I would like to contribute to this high standing performance by offering quality reports with timely completion. I am interested in the entry level/trainee position of a Commercial Real Estate Appraiser announced September 29 on the professional networking site LinkedIn. I will receive a Bachelor of Business Administration degree in Finance from University of Houston - Victoria in May 2015. I have one year experience as a real estate appraiser trainee with First Choice Appraisal compiling and analyzing data, inspection of properties, and report writing. My degree in Finance has given me the opportunity to apply financing strategies to the cost figures of an appraisal report. The financial fundamental and real estate investment classes have taught me to evaluate interest rates, asset prices and, cash flows that are essential in appraisal reports to determine the highest and best use of the property. The classes also allowed a “hands-on” experience with Microsoft Office Word and Excel which are commonly used in this industry to create reports and charts. These skills have allowed me to create professional formatting and charts to help banks and clients understand the determined market value...
Words: 402 - Pages: 2
