Purchase Solution

Minimum sum of abssolute values & Min max of abssolute values

Not what you're looking for?

Ask Custom Question

Hi,

I need help with the following problem linear programming question that asks for two linear programming solutions for a timer series that Min sum of abs values & Min max of abs values. I have attached the detailed questions in the attached Word document. I have already solved question 1, which is attached in an Excel file, so I need assistance with questions 2 through 4. Please note that you cannot use the "abs" function in Excel to solve.

I have also attached a snapshot of an US Naval Academy paper that addresses linear methods to solve Min sum of abs values & Min max of abs values. Unfortunately, I am still not able to decipher solutions.

Can you please help?

Thanks,
Sunny

-------------------------------------------------------------------------------------
Week(t) Sales(t)
1 17
2 21
3 19
4 23
5 18
6 16
7 20
8 18
9 22
10 20
11 15
12 22

**** I already completed question 1 *****
1) Use ordinary least squares for forecasting. Generate the regression equations: sales(t) = a +bt by using the data analysis add-in in Excel. You will generate values for a and b such that the sum of squared errors is a minimum. That is, the sum from t=1,â?¦..12 of (sales(t)-sales(t))^2 is a minimum. The least squares formula that is used is derived from differential calculus and the a,b found are such that the sum of squared errors can be no smaller with any other values for a and b.
****************************************************************************************

*** I need help with the below 3 questions. ***

2) Find values for a and b for the same time series such that you minimize the sum from t=1,â?¦..12 of |sales(t)-sales(t)|. To do this you must formulate a linear program. Thus you may not use the â??absâ? function in Excel. Create/solve the model in Excel and also write down the linear program in algebraic form.

3) Find values for a and b for the same time series such that you minimize the maximum (overall t=1,â?¦..12) |sales(t) â?" sales(t)|. To do this you must formulate a linear program. Thus you may not use the â??absâ? function in Excel. Create/solve the model in Excel and also write down the linear program in algebraic form.

4) Comment on the use of these three different objectives in questions 1,2, and 3 and why a company might use each of the three objectives.

Purchase this Solution

Solution Summary

Minimum sums of absolute values and minimum maximum of absolute values are examined.

Purchase this Solution


Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Probability Quiz

Some questions on probability