Free Essay

Business Data Analysis- Fennal Design

In: Business and Management

Submitted By layalhasan
Words 671
Pages 3
Module code: BSS002-6 Module Name: Business Data Analysis

Submission: 30 November, 2012

I my class I learn how to simulate data to solve a problem. I learn to use excel and some function in it these are =SUM() = RAND() =AVERAGE() =STDV() =RANDINV() =VLOOKUP() and few more . These are widely used function when I simulated data in excel.
In task 1 I find out how to calculate or forecast how much card should we print. I use a random variable with =RAND( function and use =VLOOKUP() function to find out demand from discreet variable called cumulative probabilities. This is discrete because we find out the range by frequency distribution. Then I use if function to calculate disposable cost with =IF (Demand>Production,(Demand-Production)*Disposable cost, 0). This function works with logical criteria. It says that, if demand is greater than production then disposable cost will be (Demand-Production)*Disposable cost, if not then “0”. Then I calculated profit. Then I simulated 1000 trial with 4 types demand to find out with demand will give us maximum profit and this was $40000. If we print $40000 cards then we can make profit of $57758 which is higher than other. Then we use DATA ANALYSIS add-in to simulate descriptive statistic. From here we can answer question no 2 also. If you print 20000 cards then will make profit of 46178 which is less than what can we make in 40000 printed cards. In here simulated demand is uncertain variable when is used for forecasting.

For task 2 we make a profit model, It is given in below,
Profit Model= (Selling Price –Direct Labor-Part Cost)xDemand-Fixed Cost
And I calculated profit with this model. I critically analysis base case, worst case an best is. Worst case is, when cost is higher but demand is very low. In base case everything lies in middle and the best case cost is very low but price is very high. So in the 3 type of case best case gave us best profit. So I calculate some data with each demand and make a graph to understand the break even points so that we can improve our system to generate more profit.
For task 3
I took the selling price 249 and took admin and advertising cost of total 1000000. Then we took 500 trial and simulated random variable with =RAND() function. Then I use =VLOOKUP() function to allocate labor cost to the random variable. Then I calculate part cost with low part cost-r(High-Low) equation. Where low part cost is 80 and high part cost is 100 and r=random value.
Then I use =NORMINV() function, which works with mean, probability and standard deviation to predict demand. Then I calculated profit with the profit model that we created earlier. From that 500 trial we got our average labor cost, part cost demand and profit. From that table I find out maximum profit and minimum profit. Find out the risk and probability of loss. After 500 trial I saw that only 30 trials are facing loss to I divide 30/500=6%, which is the probability of loss.

Then I was asked to find out the frequency of simulated profit. Frequency counts each item within a range to measure the tendency of centralization. We put the lowest and highest profit and create a pivot table. With that we make a continuous distribution table and find out the tendency of profit to centralized

At the end I made some graph to give a better understanding. The data simulation process is fast and reliable. If we could take more data than the chance of error could be less. We tried our best to analyze these data accurately and interpreted then effectively. I cannot say that I got a better result because we all are working with random variables so might be other results will be more good than my result. But I do it accurately how I learnt from my class room.…...

Similar Documents

Premium Essay

Data Analysis

... Data Table Analysis Brief Ashley Jones ACC/542 November 5, 2012 Anita Rodriguez, M.A., CPA Data Table Analysis Brief Kudler Fine Foods has data that must be evaluated and automated into the data systems. Before the data can be automated, it must be evaluated for completeness. One must evaluate two different items: The Access data tables and The Inventory Database. To better assist Kudler Fine Foods, one must evaluate the design elements of the Access data tables from an accounting perspective and recommend improvements to the existing tables. An entity relationship diagram and pivot table will assist with understanding the data. One can then provide an explanation of how the information in the pivot table may improve decision making. Design Elements From an accounting perspective, the design elements of the data tables lack the information needed for processing transactions on a daily basis. The data in the table provide information on the customers, inventories, items, orders, order lines, stores, suppliers, tax tables, and tenders. The tables do not provide information on the transactions to journalize and add to the general ledger. The tables lack information for the financial reports, except for a few of the tables. The inventory table will provide the basic information for the quantity on hand for cost of goods calculations with unit cost for the income statement. The tender table will provide basic information on whether the payment is cash, credit......

Words: 536 - Pages: 3

Premium Essay

Database and Data Warehousing Design

...head: DATABASE AND DATA WAREHOUSING DESIGN Database and Data Warehousing Design Yolanda McCollum Dr. Constance D. Blanson CIS499: Information Systems Capstone February 11, 2014 Database and Data Warehousing Design Why does one need data warehousing? According to Total Metrics (2013): 1. The prime purpose of a Data Warehouse is to store, in one system, data and information that originates from multiple applications within, or across, organizations. The data may be stored ‘as received’ from the source application, or it may be processed upon input to validate, translate, aggregate, or derive new data/information. 2. Most of the data load functions are processed in batch. There are few on-line data maintenance functions. The on-line functions that do exist tend to update the reference files and data translation tables. 3. A database alone does not constitute a Data Warehouse system. At a minimum, a Data Warehouse system must include the database and corresponding load functions. Data reporting functions are optional. They may, or may not be an integral part of the Data Warehouse system. 4. The prime purpose of storing the data is to support the information reporting requirements of an organization i.e. multiple users and multiple applications. 5. The Data Warehouse may, or may not, provide the required reporting functions. In some cases, external applications access the Data Warehouse files to generate their own reports and queries. 6. Data Warehouse......

Words: 880 - Pages: 4

Premium Essay

Data Analysis

...Data Table Analysis LeKane Gilling ACC/542 March 13, 2014 Brad Thompson Abstract In this brief, data tables will be analyzed because it can be critical to the accounting cycle. With accurate data that is informing, Kudler Fine Foods ought to be able to make more practical business decisions. With Kudler Fine Foods using data table to order, keep inventory, and to process their products, they can become more successful and on top of the food industry. As a company, Kudler needs to evaluate their design elements of the data tables that are needed for review from an accounting perspective. An entity relationship program would need to be developed showing the past data tables. A recommendation would need to be met for improvements or changes. With providing vital information in the pivot tables, then this will improve making decisions for every department at Kudler Fine Foods. By creating a pivot table that shows everything in a list, this will possibly help management see where items need to either increase or decrease because they're not selling. Data Table Analysis Kudler Fine Foods are a part of a broad spectrum of prestigious locations that are becoming successful. La Jolla, Del Mar, and Encinitas are the three stores that Kudler has opened, all located in California. The products range from fresh bread, harvest, meat and poultry, flavorings and packeted foods, and special milk and cheese products. Since 1998, Kudler’s goal is to supply the consumers carefully......

Words: 1218 - Pages: 5

Premium Essay

Data Analysis for Business Decisions

...Running head: Practical Application Scenarios Capella University MBA –Data Analysis for Business Decisions May 31, 2014 Practical Application Scenario 1. Input Variables -- |   | Sample Mean (x-bar) | 3.318956 | Sample standard deviation (s): | 0.281791 | Sample Size (n) | 70 | Confidence Level: | 0.95 |   |   | Intermediate Calculations -- |   | Degrees of freedom: | 69 | Standard Error of the Estimate: | 0.03 | Prob. in the tails for this Conf Level: | 0.05 | t-Multiple: | 1.995 |   |   | Confidence Interval -- |   | Lower limit: | 3.25 | Upper limit: | 3.39 | Margin of error: | 0.07 | Based on the sample data received, the confidence interval of the average price in St. Paul was calculated and found to be ($3.25, $3.39). This means that the star tribune newspaper can report with 95% confidence that the average price a random station in St. Paul will have a lower limit of $3.25 and upper limit of $3.39. There is only 5% chance that the average price is beyond the limit stated above. Practical Application Scenario 2. Dear Business Manager, We will need to brew 107 pounds of coffee to be 99% certain that the german-made brewers yield the cups per pound that the vendor claims is true. See the computation listed below. Inputs -- | | | | | | Planning Value for Sigma: | 1.2 | | Desired margin of error: | 0.3 | | Confidence Level: | 0.99 | | | | | | | | Intermediate Calculations -- | | | | | ......

Words: 456 - Pages: 2

Premium Essay

E-Business Data Analysis

...EBUS310-1401B-01 e-Business Data Analysis Contents Enterprise Marketing Management Plan (Week 1 IP) 3 Key Performance Indicators (KPIs) Process Plan (Week 2 IP) 5 Data-Driven Web Analytics Plan (Week 3 IP) 8 Business Strategic Goals Statements 8 Action Plans 9 Define the necessary benchmarks 10 Define a time frame for achieving the strategic goals. 10 Search Engine Optimization Plan (Week 4 IP) 11 Pay-Per-Click (PPC) Plan (Week 5 IP) 11 References 12 Enterprise Marketing Management Plan (Week 1 IP) Throwback is a company the focuses on sports attire from the past. They create customizable jerseys from teams or designs that are no longer used. There are sports teams that are no longer in existence such as the Houston Oilers or the Seattle Supersonics that will have several jerseys to choose from, representing their biggest stars or for an additional fee they can customize the name and number to themselves or a different player. All teams have changed their jersey design over time and nostalgic fans love to purchase jerseys from their youth. This service will also be available. Offline marketing is conducted through free catalog mailings twice a year focusing on the sports that are active at the time or starting their seasons soon. Ads to sign up for the free catalog are published in “The Sporting News”, “Sports Illustrated”, and “The USA Today”. Three of the best print selling sources for sports information in the country. In addition...

Words: 2425 - Pages: 10

Premium Essay

Business Data Analysis

...Give an interval based on your data so that you are 95% confident that the true value of the unknown proportion lies inside it. How would you explain 95% confidence to a layman? Suppose a professor of IIMA thinks that true proportion is 0.3. Are you ready to accept the professor’s perception based on your data at 99% confidence level? Solution – 1 Sample Size n = 100 (male smokers) p = 0.2 Sd (P) = √(pq / n) = .04 95% confidence interval of p = 0.2 ± 2 x 0.04 = 0.08 to 0.32 Explanation to a layman – 95% confidence means that if the sampling experiment i.e. selection of random samples of 100 male smokers in the present problem, is repeated large no of times, 95% of the times the interval will include the true value of p (0.2) or the sample proportion of smokers in present example and 5% of the times the interval may not include the true value of p (0.2) or the sample proportion of smokers in present example. 99 % confidence interval of p = 0.2 ± 2.58 x .04 = .04 to 0.35 Based on our data, as the true proportion of 0.3 thought by the IIMA professor lies in the 99% confidence interval, we can accept IIMA Professor’s perception. 2. A week before presidential election in USA, suppose a news agency wants to predict who is going to win (Democrat or Republican)? In order to predict, they collected a random sample of size 10000 individuals nationally and found 5100 of them intend to vote for Democrat. Based on the data could you claim with......

Words: 2356 - Pages: 10

Premium Essay

Data Design

...copies (VIDEO) of each movie (MOVIE). For example, the store may have 10 copies of the movie “Twist in the Wind”. “Twist in the Wind” would be one MOVIE and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime, therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. The complete ERD is provided in Figure P7.65. Figure P7.65 EliteVideo ERD [pic] 65. Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. CREATE TABLE PRICE ( PRICE_CODE INTEGER NOT NULL UNIQUE, PRICE_DESCRIPTION CHAR(15) NOT NULL, PRICE_RENTFEE VARCHAR(3) NOT NULL, PRICE_DAILYLATEFEE VARCHAR(3) NOT NULL, PRIMARY KEY (PRICE_CODE)); CREATE TABLE MOVIE ( MOVIE_NUM INTEGER NOT NULL UNIQUE, MOVIE_TITLE VARCHAR(35) NOT NULL, MOVIE_YEAR INTEGER NOT NULL, MOVIE_COST NUMBER NOT NULL, MOVIE_GENRE CHAR(6) NOT NULL, PRICE_CODE INTEGER, PRIMARY KEY (MOVIE_NUM), FOREIGN KEY......

Words: 2762 - Pages: 12

Premium Essay

Theories of Systems Analysis and Design for Integrated Business Solutions

...Theories of Systems Analysis and Design for Integrated Business Solutions Xin Tian Herzing University Theories of Systems Analysis and Design for Integrated Business Solutions Introduction The word system comes from the Greek work “systema” defined as an organized relationship among functioning components or units. Business system analysis and design breaks down the entity’s components into its basic constituents for the purpose of studying how each component works with other components in the fulfillment of the business purpose (Grady, 2007). Business system analysis and design entails identifying the goals of an enterprise. Next, the analyst develops systems that will fulfill these goals through studying the basic components of the system with the aim of fulfilling the business’ goals in an efficient way. The analysis aspect of the system deals with what the systems should do while the design part outlines how the system will fulfill its purpose. A basic system will consists of two or several interrelated constituents. Each element of the system will consist of three properties. 1) Each component affects the functioning of the entire system. 2. Each component is affected by at least one other component in the system. 3. All subsystems of the components have the first two properties. Systems analysis and design for integrated business solutions entail three levels. The first level is......

Words: 1264 - Pages: 6

Premium Essay

Data Analysis

...Data Table Analysis ACC/542 Data Table Analysis Kuder Fine Foods design elements table shows the different tables that are used to determine information. The breakout and design of the table is straight forward and provides what exactly is under each category. The customer information is very detailed and some other categories could be combined. Inventory and item could be combined since they both will provide some same information. Depending on the item that customers like can depend on the inventory amount on hand. Order and order line can also be combined in one and just add additional field where needed. The design of the access table can provide very detail information regarding inventory and items needed for each store. Combining some of the columns can help to formulize the information more and give a better results for the company to use for growth and revenue. Access Table Analysis Inventory is the key to Kudler Fine Foods business. The inventory stock has to stay stocked for the business to make profit. Having the right suppliers will make sure inventory is received in a timely manner. Cost reduction regarding how much is paid out to suppliers is important because it more cost is going to supplier, then what is sold there is an issue. Kudler Fine Foods should look into combining their stores to have one supplier. Management or owner should look into products and quantity on hand to determine their stock. Having a description of each item and supplier......

Words: 779 - Pages: 4

Premium Essay

Data Analysis

...DATA ANALYSIS TAKE-HOME EXAM Introduction This report provides an insight into the investment behavior of 50 couples. Using different statistical methods and observing the trend followed by the effect of various independent variables on a single independent variable , a conclusion will be reached. The following are the main tools used for analysis of investment behavior of 50 couples who are selected from a sample size of 194 couples. 1. Descriptive statistics 2.Histograms 3.Pivot tables 4.Multiple Regression In this model , a scrutiny of the above statistical data will give the tendency to invest in retirement plans and the type of couples who invest and take advantage of the attractive investments in order to avail tax exemption. This report also elaborates on how the different independent variables - Number of children, Salary, Mortgage and Debt- have an effect on the dependent variable, i.e. the percentage of salary invested. Consequently the below tasks will be fulfilled. Step 1-Extracting a sample of 50 couples Step 2-Constructing histograms and point estimates with given confidence intervals Step 3-Inference from pivot tables to explain the preferences of different couples on investments based on independent variables Step 4-Performing multivariate regression and conducting significance tests on beta coefficients R^2 and F-tests and hence establish a correlation of different variables and ensuing effect on investments made. Dataset We have a......

Words: 1895 - Pages: 8

Premium Essay

Data Analysis

...Data Collection Analysis: ITT Technical Institute Keller Graduate School of Management Training and Development HR592 Professor Robert Graver February 23, 2014 Table of Contents Overview of the Organization…..………………………………………………………………3 Executive Summary …………..………………………………………………………...…...…3,4 Analysis of Data Collected & Identified Training Need…………………………………..…4,5,6 Recommendations………………………………………………………………………………...7 Training or Intervention Strategy to Address the Needs…………………………………………8 Cost benefit analysis……………………………………………………………………………8,9 Conclusion……………………………………………………………………………………….10 References………………………………………………………………………………………..11 The ITT Technical Institutes is a leading private college system focused on technology-oriented programs of study. The seven schools of study at the ITT Technical Institutes [i.e., the School of Information Technology, the School of Drafting and Design, the School of Electronics Technology, the School of Business, the School of Criminal Justice, the School of Health Sciences and the Breckinridge School of Nursing] teach skills and knowledge that can be used to pursue employment opportunities in today’s world. There are over 140 ITT Technical Institutes in 38 states. ITT Technical Institutes predominantly offer career-focused, degree programs to over 70,000 students. The ITT Technical Institutes have been actively involved in the higher education community in the United States since 1969. Executive Summary ITT Technical......

Words: 2292 - Pages: 10

Premium Essay

Data Analysis

...HCS/577 – Financial Management in Health Care Financial Data Analysis Introduction To have a full understanding we need to know what an operating budget is and it can be defined as the upcoming statement of profit and loss for the different divisions and units of a company as well as the company as whole for the upcoming year. To identify the variances as well as to monitor things this operating budget is normally divided into what is usually called quarters. For a health care company these budgets are prepared for the following year and is normally discussed for some kind of approval by the upper management teams. When the year is at an end the management team that is in charge of certain areas are then asked to provide an account of the performances from the previous year. Effective financial management practices in creating and monitoring an operating budget When it comes to creating and monitoring a budget, the use of financial management should not be overemphasized. To start off, the budget construction form should be able to identify all of the relevant data that is involved. The operating budget can be best utilized as a profit and loss statement projection and to prepare the estimates of expenses and future revenues. To make it easier to monitor Finkler (2006) states that an operating budget should be presented together......

Words: 948 - Pages: 4

Premium Essay

Data Design Methods

...Data Design Methods Introduction Many organizations and companies rely on databases to run their operations and achieve competitive advantage. Database design refers to the different parts of the design of an overall database system. It can be thought of as the logical data structures used to store data, and the forms and queries used as part of the overall database application within the database management system (Wikipedia.org). The paper focuses on database design methods and steps that can be taken to achieve a good design structure that avoids redundancy, duplicate data or the absence of required data. The need to understand database models Databases are important to the organizational setting. Databases allow organizations to share data across multiple applications and systems. Organizations build several databases each one sharing data with several information systems. This is because it is almost impractical to build one database to meet an entire organization’s needs. Therefore data design is critical to the consistency, integrity and accuracy of the data in a database. A database that is improperly designed will make it difficult to retrieve certain types of information. Besides, there is the risk that searches will produce inaccurate results or information that may have potential damaging effects on a company's bottom line. Inaccurate database may also affect the daily operations of a business and its future direction. A good database addresses the......

Words: 1407 - Pages: 6

Premium Essay

Analysis of Data

... The terms "statistical analysis" and "data analysis" can be said to mean the same thing -- the study of how we describe, combine, and make inferences based on numbers. A lot of people are scared of numbers (quantiphobia), but data analysis with statistics has got less to do with numbers, and more to do with rules for arranging them. It even lets you create some of those rules yourself, so instead of looking at it like a lot of memorization, it's best to see it as an extension of the research mentality, something researchers do anyway (i.e., play with or crunch numbers).  Once you realize that YOU have complete and total power over how you want to arrange numbers, your fear of them will disappear.  It helps, of course, if you know some basic algebra and arithmetic, at a level where you might be comfortable solving the following equation There are three (3) general areas that make up the field of statistics: descriptive statistics, relational statistics, and inferential statistics.  1. Descriptive statistics fall into one of two categories: measures of central tendency (mean, median, and mode) or measures of dispersion (standard deviation and variance). Their purpose is to explore hunches that may have come up during the course of the research process, but most people compute them to look at the normality of their numbers. Examples include descriptive analysis of sex, age, race, social class, and so forth.  2. Relationalstatistics fall into one of three categories: univariate...

Words: 4590 - Pages: 19

Premium Essay

Design of Business

...The Design of Business Why Design Thinking Is the Next Competitive Advantage by Roger Martin Copyright 2009 Roger Martin Summarized by permission of Harvard Business Press 256 pages Focus Leadership & Management Strategy Sales & Marketing Finance Human Resources IT, Production & Logistics Career Development Small Business Economics & Politics Industries Intercultural Management Concepts & Trends Take-Aways • Business leaders often believe they must choose between analysis and intuition. “Design thinking” offers a third path. • Design thinkers observe the world, imagine alternatives and bring them into being. • Innovations start as intriguing “mysteries.” To unfold them, first develop workable “heuristics” and then derive predictable “algorithms.” • Think of the learning and discovery process as moving through a “knowledge funnel.” • People need analysis and creative thinking at different points in that funnel. • New firms emphasize “exploration.” As they mature, they shift to exploiting known ideas, but if they stop at that point, other innovators will surpass them. • Your organization must balance predictable or “reliable” production with “validity,” experimentation that leads to new ideas and commercial success. • To protect a company, leaders must protect the exploration that leads to its validity. However, over time, organizations tend to emphasize reliability instead. • To develop your design mind, broaden your “personal knowledge system.” • Cultivate the......

Words: 2903 - Pages: 12

2.4GHz Portable Wireless Mouse Cordless Optical Gaming Mice With USB Receiver- | Watch movie | The Issue Of Gun Control