A Nut Case
Recommendation:
In this case MNC company is producing different types of Nut. The company have to
meet the market demand of different types of nuts for this company need the optimal
solution and product mix. We have used excel solver for this p

CASE ANALYSIS : 4.2
ANALYSIS
PARKET SISTERS
SOLUTIONS:
a) The weekly product mix should consists of 700 ballpoints, 133 fountain pens and no
mechanical pencils . The weekly net profit with all this mix will be $ 2766.67.
b) The optimal solution in this ca

Microsoft Excel 12.0 Answer Report
Worksheet: [dani decision model 5.xlsx]Sheet1
Report Created: 4/10/2012 10:19:27 PM
Target Cell (Max)
Cell
Name
$G$4 Max
Original Value Final Value
0 2766.666667
Adjustable Cells
Cell
Name
$D$3 Ball Point
$E$3 Mechanical

Formulation:
Q14:
Blacktop refining extract minerals of two type.in the least costly
manner.
In the given situation we have 20% copper, 20% zinc and 15% magnesium
in type 1 and 30% coper 25% zinc and 10% magnesium in type 2.
Let Type 1 = X1 and Type 2 = X

Microsoft Excel 12.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 3/20/2012 1:33:12 PM
Target Cell (Max)
Cell
Name
$E$7 profit max
Original Value
0
Final Value
32500
Adjustable Cells
Cell
Name
$C$6
$D$6
Original Value
0
0
Final Value
130
0
Const

Solution to question 4 :
Decision variables:
Let XIj be the numbers of oil barrels to be produced
i= 1, 2, 3
j = regular, supreme
X 1R be the amount of input 1 used in 1 barrel of regular gasoline
X 2R be the amount of input 2 used in 1 barrel of reg. gas

Microsoft Excel 12.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 3/20/2012 7:32:13 PM
Target Cell (Min)
Cell Name Original Value
$E$7
0
Final Value
3480
Adjustable Cells
Cell Name Original Value
$C$6
0
$D$6
0
Final Value
28
8
Constraints
Cell N

Microsoft Excel 14.0 Answer Report
Worksheet: [abdul qadeer.xlsx]Sheet3
Report Created: 3/28/2012 12:28:58 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0 Secon

L ) If the per-unit profit on ballpoint pens decreases to $2.50, what is the optimal product mix
and what is the companys total profit?
Sol .
By changing the per unit profit on ballpoint to 2.50 , the optimal product mix will
remain the same but their wil

Microsoft Excel 12.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 3/27/2012 11:33:48 AM
Target Cell (Max)
Cell
Name
$F$7 Max
Original Value Final Value
0 2766.66666667
Adjustable Cells
Cell
Name
$C$6 Ball points
$D$6 Mechanical Pencils
$E$6 Foun

Microsoft Excel 12.0 Answer Report
Worksheet: [Book1.xlsx]Sheet1
Report Created: 5/2/2012 10:08:05 AM
Target Cell (Min)
Cell
Name
$F$7 Cost Min
Original Value Final Value
0 3107.14285714
Adjustable Cells
Cell
Name
$C$6 Compound 1
$D$6 Compound 2
$E$6 Comp

Macro Economics
Case Study
Submitted to
Miss Afia Mushtaq
Submitted by
Abdul Qadir 104205045
Usman Rehan 104205028
Hera Hanif 104205019
Muhammad Ismail 104205014
BBA (H) Sec A
Case Study
The US recession of 2001
US economy experienced a slowdown in econom

Microsoft Excel 12.0 Answer Report
Worksheet: [case.xlsx]Sheet1
Report Created: 3/28/2012 9:20:30 AM
Target Cell (Max)
Cell
Name
$F$5 Max used
Original Value Final Value
0
0
Adjustable Cells
Cell
Name
$C$5 Max Ball points
$D$5 Max Mechnical penicl
$E$5 Ma

Microsoft Excel 14.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 3/20/2012 1:15:14 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.047 Seconds.
Itera

Decision Model.
Describe the example in which a well-known business, political or
military leader made a good decision that resulted in a bad outcome,
or a bad decision that resulted in a good outcome.
Chief Minister of Punjab Mian Muhammad Shahbaz Sharif

Decision Models
Recommendations:
In first question the objective function is to minimize the extract of ore. In this first I
formulate the LP model and then solve it by Excel solver to minimize the objective
function. This will give us to extract 28 ore o

Different Software used for solving LP Models.
LINDO:
LINDO is commercial grade software widely used to solve linear programs in corporate
environments. The LINDO software comes in three forms to solve linear programing
models.
Primal and Dual Simplex Sol

The case is about a small but growing pen manufacturing company,they only produce
three type of pens ballpoint pens,fountain pens and mechanical pens ,In this case
parket sisters were trying to make a production mix and an optimal solution for
maximizing

Microsoft Excel 12.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 3/20/2012 1:33:12 PM
Target Cell (Max)
Cell
Name
$E$7 profit max
Original Value
0
Final Value
32500
Adjustable Cells
Cell
Name
$C$6
$D$6
Original Value
0
0
Final Value
130
0
Const

Parket Sisters
Q.a: The weekly net profit for the production mix for the Ballpoints is 700, mechanical pencils is
0 while of fountain pens is 133.34 and the profit is $2766.666667
Q.b: No, the optimal solution of the report is not degenerate because the R

Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 10/26/2011 2:05:24 PM
Adjustable Cells
Cell
Name
$E$10 Production Ballpoint Pens
$F$10 Production Mechanical Pencils
$G$10 Production Fountain Pens
Final
Value
Reduced
Cost
O

Solution to question 4 :
Decision variables:
Let X Ij be the numbers of oil barrels to be produced
i= 1, 2, 3
j = regular, supreme
X 1R
X 1S
X 2R
X 2S
X 3R
X 3S
Objective function:
Max (profit) = cfw_21 (X 1R + X 2R + X 3R) + 25 (X 1S + X 2S + X 3S)
- cfw

A Nut Case
A) Yes because controller has given this recommendation on the basis of net profit which
shows net profit per unit of cluster and crunch is negative so company should cease the
production of these products.
B) Formulation for this problem is
De