Business analytics/linear programming. needed in 2-21/12 hours

students are reminded that submitted assignments must be typed (i.e. can NOT be hand written), neat, readable, and well-organized. However, GRAPHS are ok to plot them by hand as long as they are large, legible, and properly labeled and that their calculations are typed within the rest of the assignment. Assignment marks will be adjusted for sloppiness, poor grammar, spelling, for technical errors as well as if you submit a PDF file.

Problem 1

The manager of a food processing plant that specializes in potato chips has developed an LP model to reflect processing times.

x1 = boxes of regular chips
x2 = boxes of crinkle cut chips

page1image2319913328page1image2319913664page1image2319913936

Winter 2019

Page 1

Maximize subject to

Cutting Frying Packing Crinkle Crinkle

Z = .40×1 + .30×2 (profit)

3.6×1 + .8×2 ≤ 144 minutes 3.2×1 + 1.6×2 ≤ 160 minutes 4.8×1 + 7.2×2 ≤ 576 seconds

x2 ≤ 80 boxes

x2 ≥ 20 boxes x1, x2 ≥ 0

ADM2302 Section M, N, P and Q

Assignment 1

Briefly explain or define each of these parts of the model:

  1. The .40 in the objective function.
  2. The product of the .3 and x2 in the objective function.
  3. The 144 minutes in the cutting constraint.
  4. The 4.8 in the packing constraint.
  5. x2≥20.
  6. The product of 3.2 and x1 in the frying constraint.
  7. What two key questions can be answered using this model?

The optimal solution is to produce 15 boxes of x1 and 70 boxes of x2 for a total maximal profit of $27.00. Determine each of the following:

h. The amount of each resource that will be used. i. The amount of slack for each resource.

Problem 2

The new manager of a food processing plant hopes to reduce costs by using linear programming to determine the optimal amounts in kilograms of two ingredients it uses, x1 and x2. The manager has constructed this model:

Winter 2019

Page 2

Minimize Subject to

Protein Carbohydrates

Z = .40×1 + .40×2

3×1 + 5×2 ≥ 30 grams 6×1 + 4×2 ≥ 48 grams

x1, x2 ≥ 0

  1. Graph the constraints and identify the feasible region.
  2. Determine the optimal solution and the minimum cost (Show your work).
  3. There is a single optimal solution to part b above. However, if the objective

Maximize Subject to x1+x2 ≤6 x1 -x2 ≥0 x1 +x2 ≥3 x1, x2 ≥ 0

Z = x1 + 2×2

function had been parallel to one of the constraints, there would have been two equally optimal solutions. If the cost of x2 remains at $.40, what cost of x1 would cause the objective function to be parallel to the carbohydrate constraint? Explain how you determined this.

Problem 3:

Given the linear programming problem:

ADM2302 Section M, N, P and Q Assignment 1

  1. Graph the constraints and identify the feasible region.
  2. Determine the optimal solution (Show your work).
  3. Are any constraints binding? If so, which one?

Problem 4

The Oak Works is a family-owned business that makes handcrafted dining room tables and chairs. They obtain the oak from a local farm tree farm, which ships them 2,500 pounds of oak each month. Each table uses 50 pounds of oak while each chair uses 25 pounds of oak. The family builds all the furniture itself and has 480 hours of labor available each month. Each table or chair requires six hours of labor. Each table nets Oak Works $400 in profit, while each chair nets $100 in profit. Since chairs are often sold with tables, they want to produce at least twice as many chairs as tables.

The Oak Works would like to decide how many tables and chairs to produce so as to maximize profit.

Winter 2019

Page 3

a. b.

Formulate algebraically the linear programming model of this problem.
Formulate this same linear programming problem on a spreadsheet and SOLVE using Excel solver (Provide a printout of the corresponding “Excel Spreadsheet” and the “Answer Report”).

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more