Search

# Data Analysis for Business Decision Making - Essay Example

Comments (0) Cite this document
Summary
Data Analysis for Business Decision Making Name Institution Task one. Response to question a. The Contribution per unit for each computer peripheral device. Output Selling price per unit (?) Material cost per unit (?) Variable labor cost (?) Total cost Profit ( selling price-total cost) Internal moderm 200 40 0.83 o.25 1.5 0.6 43.18 156.82 External moderm 185 25 1.26 1.25 0.6 0.8 28.91 156.09 Circuit board 290 35 2.1 0.75 0.9 0.4 39.15 250.85 CD drive 212 40 2.52 0.50 0.9 0.2 44.12 167.88 Hard disk drive 380 85 1.68 1.25 0.9 0.4 89.23 290.77 Memory board 330 50 3.36 1.25 0.6 0.6 55.81 274.19 Response to question b…

## Extract of sample"Data Analysis for Business Decision Making"

Download file to see previous pages Table1: Time needed in minutes on electronic devices Internal modem External modem Circuit board CD drive Hard drive Memory board Available minutes per week Test device1 2 3 5 6 4 8 9000 Test device 2 1 5 3 2 5 5 7800 Test device3 5 2 3 3 3 2 6600 Test device 4 3 4 2 1 2 3 6120 Next calculation will involve determining of the mathematical relationship for describing the constraints given in the problem. One relationship that is general is the quantity of resource that is utilized should be less than or rather equal to the quantity of resource that is available. The decision variables should also be greater than zero. First constraint: Test device 1 time used Test device 1 time available 2a+3b+5c+6d+4e+8f 9000 Second constraint: Test device 2 time used Test device 2 time available a+5b+3c+2d+5e+5f 7800 Third constraint: Test device 3 time used Test device 3 time available 5a+2b+3c+3d+3e+2f 6600 Fourth constraint: Test device 4 time used Test device 4 time available 3a+4b+2c+1d+2e+3f 6120 Fifth constraint: a, b, c, d, e, f 0 All these constraints do represent the restrictions of the capacity of production, and have an effect on the total profit. The constraints display a linear programming aspect in which certain specific interactions would exist in between the given variables. Increasing the number of units produced by a company would reduce the production of other products. Response to question c. Solution. The decision variables in this problem are a, b, c, d, e, f. This problem was solved using the excel solver that is displayed the worksheet. Microsoft Excel 12.0 Answer Report Worksheet: [Book3]Sheet1 Report Created: 20/07/2012 10:52:29 Target Cell (Max) Cell Name Original Value Final Value \$B\$7 z 0 545568 Adjustable Cells Cell Name Original Value Final Value \$B\$1 a 0 168 \$B\$2 b 0 0 \$B\$3 c 0 984 \$B\$4 d 0 0 \$B\$5 e 0 936 \$B\$6 f 0 0 Constraints Cell Name Cell Value Formula Status \$B\$8 c1 9000 \$B\$8=0 Binding \$B\$5 e 936 \$B\$5>=0 Not Binding \$B\$6 f 0 \$B\$6>=0 Binding From the table, the maximum profit for Northern H-Tec E. Ltd Company is ?545,568 as displayed in the work sheet. Where c1, c2, c3, and c4 represents the constraints involved in the problem. Response to question d. Constraints that are biding are those constraints that limit the output of profit where as the non binding constraints do not always have a limitation in the overall profit. This implies that changing the non binding constraints do not affect the profit so long as the changes in this kind of constraints are within the allowable decrease and increase indicated in the sensitive report. Changing binding constrain ...Download file to see next pagesRead More
Cite this document
• APA
• MLA
• CHICAGO
(“Data Analysis for Business Decision Making Essay”, n.d.)
(Data Analysis for Business Decision Making Essay)
Click to create a comment or rate a document
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
...?Business Decision Making        Research methodology is the one of the most significant part in any of the research undertaking. Collection of the most reliable data is very much essential in order to reach the most precise conclusion and decision making. Reason for colleting the primary and secondary data for the given business problem helps to reach the authentic decision to advice the clients in Spain, France and Italy. As the manager of the company, preparation of most suitable plan for primary and secondary data collection is very much necessary....
12 Pages(3000 words)Essay
...by most employees; interquartile range indicates the difference between the hours worked by 75% of the employees and that of 25% of the employees. Standard deviation shows the disparity between the hours worked by the employees. Question 5 This chart depicts the trend of the data within the four years Raw Data trend and Adjusted Seasonal variation. Brechner (2010) agrees that the application of seasonal adjustment in the economic or financial trends helps to indicate the influence that seasons exert on a company’s business. The seasonal adjustments are used to eliminate the irregular annual variations observed in raw data. In business...
6 Pages(1500 words)Coursework
...?Business proposal Plan for the collection of primary and secondary data Secondary data on Dubai buyer market is extremely easy to find. Statistics regarding buyers such as their annual income, cost of property in Dubai, duration of the payment term, mortgage rates, availability of bank financing and the level of financing can all be gathered as it is available from the Dubai government, banks and property dealers. Facts and figures about costs, mortgage rates, deposit rates and annual expected returns are also available online. Since there are no taxes on property in Dubai, it makes finding out property costs simpler. Statistics show that a one bedroom apartment will cost around AED 700000, a two bedroom apartment from AED1100000... and a...
11 Pages(2750 words)Essay
Data Analysis for a business making
...?Task a. The contribution per margin for Northern Hi-Tec E. Ltd will be calculated as follows: Contribution per margin= Gross profit/ total revenue The actual calculations will predict how much contribution is each of the company’s products making in terms of the total profit gained by the company. b. The decision variables will be considered those which can be controlled by the managers. An objective function in the linear programming is the one that must be optimized in an optimization function. Constraints in a function are those hurdles that restrict the working of the function by limiting its operations. c. The model will be solved through the help of the objective function applied, in which the...
4 Pages(1000 words)Essay
Data Analysis for Business Decision Making
...? Topic: Data Analysis for Business Decision Making Task a. The contribution of the company will obtained from the calculations below. Contribution will be determined by subtracting total variable cost from the selling price. b) Definition of decision variables. One of the decision variables we will use will be contribution margin; contribution margin is difference between the selling price per unit and the total variable costs. The second decision variable will be the labor cost where in this case we have a limiting factor the test devices hours. The objective function will be to maximize the contribution per unit obtained from the overall production, this leads to optimization of the firm profits. Therefore, the contribution... , in the...
6 Pages(1500 words)Coursework
Decision Making Self-Analysis
...? Decision Making Self-Analysis Insert Insert Grade Insert Decision-Making Models There are several decisionmaking models, which facilitate the comprehensive task of decision-making. Basically, models play a guiding role in the vast process through setting the platform for the various phases of decision making. In essence, decision making is a process through which several courses are evaluated in the consideration of the best way forward. Hence, at the tail end of the process a definite course of action is selected. There are various models but for the...
5 Pages(1250 words)Assignment
Big Data, Business Intelligence, and Data Analytics in Decision Making
...? Big Data, Business Intelligence, and Data Analytics in Decision Making Benefits of IT Resources and Strategies toa Company In the contemporary company setting, there is a lot of information that should be noted by the management in order to make informed decision in the management of the company. This information cannot be processed manually by human beings, and it must get assistance from the devices that will make work easier through quick, efficient, and reliable analysis and reporting. In this regard, companies have to rely on the IT knowledge to realize most of their objectives in...
4 Pages(1000 words)Essay
Compensation decision making analysis
...Chapter 10 Explain why an organization must relate to a variety of labor markets when conducting a compensation survey. In setting pay, it is important that it is competitive, meaning that pay must help the organization attract and keep the employees it needs. Because of this, the organization must determine which organizations hire similar employees to perform similar jobs. Usually there are organizations in several different labor markets which are competing with us for the same type of employee. Quite diverse organizations can have the need for the same type of employee with a specific skill set. If we also have a need for such an employee to fill a job, we cannot effectively set pay for that job unless we survey... 10 Explain why an...
2 Pages(500 words)Essay
: Judicial Decision Making Analysis
...Judicial Decision Making Analysis In The Case Of Roe v. Wade (Complainant and Texas District Attorney The decision arose from a constitutional challenge to the Texas legislation banning all abortions except where the mothers’ life is clearly threatened. In 1973 the US Supreme Court decided by a majority that such a law was too broad and unjustifiably infringed on Roe’s Ninth and Fourteenth Amendment rights containing the Bill of Rights and the concept of liberty guaranteed, respectively. (US Supreme Court VIII) The Court ruled that while medical risks of late term abortions justified states...
1 Pages(250 words)Essay
Data-Driven Decision Making
...The Changing World of 26th February, The Changing World The children in the society need to be prepared for the changes in the world therefore the curriculum developers need to be able to assess the needs of the children and the youth to prepare them for the future. Oliva and Gordon II (2012) stated that the important role of the educators is to understand how to develop curriculums that address problems that students will experience in the changing community. Students need to master survival skills to become responsible and important people in the current society that is dynamic. Critical thinking, problem solving, entrepreneurism, and effective communication are few of the skills that students will need to be proficient... Changing World of ...
1 Pages(250 words)Essay
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 Essay on topic Data Analysis for Business Decision Making for FREE!
+16312120006