User Account

All Pages

Changing the optimal product mix

Assignment Help Engineering Mathematics
Reference no: EM13961824

Consider the following problem:

A supermarket store manager needs to determine how much to stock of two brands of soda: PC and CC, for Super Bowl Sunday. The store needs to tell the suppliers how many "units" are available and the suppliers then stock the store with their product. Units consist of different flavors and sizes depending on what the suppliers think will sell best. Fractions of units are OK. The store's makes a profit margin of 15 cents for each unit of PC and 10 cents for each unit of CC. In the soda aisle, there is a maximum of 36 linear feet of shelf space: each unit of PC takes up 9 linear feet of shelf space and each unit of CC takes up 4 linear feet of shelf space. In the end displays, there is a 20 linear feet of display space available: each unit of PC takes up 4 linear feet of display space and each unit of CC takes up 4 linear feet of display space. In other words, 1 unit of PC will require 9 feet in the soda aisle plus 4 feet in the end display area.

Problem 1: Set up the problem. What is the objective function? What are the decision variables? What are the constraints?

Problem 2: Solve the problem graphically. Identify all corner point (basic feasible) solutions.

Problem 3: Solve the problem again, this time using the Simplex Method. What is the optimal solution(s)?

In addition to the display area constraints, the manager must meet certain sales quotas from his district manager. The store manager gets 1 point for each unit of PC sold and 4 points for each unit of CC - he must meet a quota of 14 points.

What the district manager doesn't know is that the store manager has a side deal going with the supplier of PC. If the store sells at least half as much PC as CC, the store manager gets tickets to next year's Super Bowl.

Given these two additional constraints, how many units of each brand should the store manager stock?

Problem 4:

Solve the problem with these additional two constraints, using either the LINDO or LINGO software. Using the LINDO or LINGO output (show the output) only and without solving the problem again, answer the following two questions.

  • What is the maximum increase in the sales quota without changing the optimal product mix?
  • What is the change in the total profit if the profit per unit of PC is increased from 15 to 20

Reference no: EM13961824

Questions Cloud

Determine the breakeven output and total sales revenues : What is the meaning of economies of scope? How do they differ from economies of scale?
Categories of basis-for-pay of strategic pay systems : Describe the advantages and disadvantages of the going rate approach to international compensation and the balance sheet approach. Describe some categories of basis-for-pay of strategic pay systems
Find the maximum torsional shear stress : Find the maximum torsional shear stress in a 75 mm diameter shaft transmitting 40 KW power at 1.33 r/s if the maximum twisting moment exceeds the minimum by 40 per cent. What is the greatest twist in degrees per metre length if G =87 GPa?
Describe set of points whose distance equals to xz-plane : Describe the set of points whose distance from the y-axis equals the distance from the xz-plane. Find an equation for the set of points.
Changing the optimal product mix : What is the maximum increase in the sales quota without changing the optimal product mix? What is the change in the total profit if the profit per unit of PC is increased from 15 to 20
Find the torque required from the motor to raise the lift : The drum, which has a diameter of 600 mm, moves a lift by means of a cable wound around it. If the lift has a mass of 500 kg, find the torque required from the motor to raise the lift with an acceleration of 2 m/s2.
Describe an effective verbal communication technique : Describe one communication theory that can be applied in a health and human services setting. Describe an effective verbal communication technique in a health and human services setting and how you would use it
Show that the total induced charge is -q. : Calculate the surface charge density induced on the plate as a function of the radius r from the foot of the perpendicular drawn from the charge.
Why is it especially important to adjust hedge fund : Why is it especially important to adjust hedge fund returns data for survivorship bias in the aftermath of the 2007-2008 financial crises?

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  What equation will generate number of tile for a height of n

What equation will generate the number of tiles for a height of n? Use the diagrams (you can expand them) and the table to show how you arrived at your equation.

  1 let x1 middot middot middot xn be n ge 2 independent

1. let x1 middot middot middot xn be n ge 2 independent random variables where each xi has the exponential distribution

  Fourier series

Behaviour of the functions at their end and midpoints points to suggest features that increase the convergence and those that are bad for convergence.

  Find the inverse function of f

Explain what each of the following mathematical statements mean in regard to the graph of f(x).With your explanation, include a DIAGRAM for each part.

  What is lp and how is an lp problem defined

Our firm makes two products: Y and Z. Suppose that each unity of Y costs $10 and sells for $40. Each unit of Z costs $5 and sells for $25. If the firm's goal were to maximize profit, what is the approproiate objective function?

  Observed differences over time are important

How can you or your department decide whether or not the observed differences over time are important? How could using a mean difference test help?

  Determine structure constants relative to the standard basis

Where denotes the usual cross product of vectors. Sow that L is a Lie algebra and determine its structure constants relative to the standard basis for R3.

  Minimize total inventory cost

To minimize total inventory cost, Lila should order number 6 screws per order. (Please round to an integer and include no units.)

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Problem need to be solved numerically

Problem need to be solved Numerically (d2 x)/(dt2 )-ax+bx3=0 →x(t),where t=0:x=xo ,x ?=xo

  Initial level does the mercury rise in left arm

A simple open U-tube contains mercury. When 11.2 cm of water is poured into the right arm of the tube, how high above its initial level does the mercury rise in the left arm?

  Management in the global movement of goods

Illustrate the role of supply-chain management in the global movement of goods from one country to another, and explain its overall impact on local trade. Support your answer with examples of such an impact in action.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd