Search
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.

# Data Analysis for Business Decision Making - Essay Example

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 sampleData 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
Click to create a comment
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.
12 Pages(3000 words)Essay
This descriptive essay shows the business decision management model. The author discusses business objective of Manheim Publications Ltd, describes the effectiveness of decision-making structure, makes relevant calculations and draws a decision tree. In the end, the author makes a conclusion and gives his recommendations for MPL.
4 Pages(1000 words)Essay
Data Analysis for Business Decision Making
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.
6 Pages(1500 words)Coursework
Big Data, Business Intelligence, and Data Analytics in Decision Making
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 the company (Madden, n.d.).
4 Pages(1000 words)Essay
349,999, ?370,000, ?375,000 ?370,000 3 bedroom terrace house ?395,000 ?395,000 ?395,000 3 bedroom semi-detached house ?466,212.5 ?444,950, ?450,000, ?469,950, ?499,950 ?459,975 2.2 In this section, the point is based on the above results to draw valid conclusions as to how much should be budgeted to buy a 4 bedroom terrace house with 4 toilets.
6 Pages(1500 words)Essay
as only 0.98 in favor of Chicago; therefore a standard advertisement content strategy will have fairly equal reception and understanding across the USA. The representation in race and ethnicity also had a 1% variance between Chicago and USA general, hence the snack products
4 Pages(1000 words)Essay
Business Decision Making Process
However, this systematic process of decision making involves complex web of activities and processes which one must need to undertake in order to make effective decision making. The effectiveness of an organization’s
10 Pages(2500 words)Essay
Data-Driven Decision Making
Students need to master survival skills to become responsible and important people in the current society that is dynamic. Critical thinking, problem
1 Pages(250 words)Essay
The report details the market research describing every feature of the study. The researcher uses the random sampling technique in selecting a sample. Additionally, the researcher
8 Pages(2000 words)Essay
However, the methods of data analysis may be similar depending on the relationship between the decision elements (Sharma, 2010). In this study, primary data will be used to identify the challenges and possible solutions
2 Pages(500 words)Essay
Let us find you another Essay on topic Data Analysis for Business Decision Making for FREE!
+16312120006