Formulate an lp problem for store budgets a total value

Reference no: EM13145013

The I. Kruger Paint and Wallpaper Store is a large retain distributor of the Supertrex brand of vinyl wallcoverings. Kruger will enhance its citywide image in Miami if it can outsell other local stores in total number of rolls of Supertrex next year. It is able to estimate the demand function as follows:

Number of rolls of Supertrex sold = (20 x Dollars Spent on Advertising) + (6.8 X Dollars spent on in-store displays) + (12 x Dollars invested in on-hand wallpaer inventory) - (65,000 x Percentage markup taken above wholesale cost of roll).

The store budgets a total of $17,000 for advertising, in-store displays, and on-hand inventory of Supertrex for next year. It decides it must spend at least $3,000 on advertising; in addition, at least 5% of the amount invested in on-hand inventory should be devoted to displays. Markups on Supertrex seen at other local stores range from 20% to 45%, Kruger decides that its markup had best be in this range as well.

(a) Formulate as an LP Problem.
(b) Solve the Problem. (Can use Excel Solver or QM)
(c) What is the difficulty with the answer?
(d) What constraint would you add?

Reference no: EM13145013

Questions Cloud

Find standard deviation for cholesterol level : A standard deviation of mg/dL. What is Mrs. Brown's cholesterol level? Carry your intermediate computations to at least four decimal places. Round your answer to at least one decimal place.

What is maximum amount kewco would be willing to pay : What is maximum amount KewCo would be willing to pay for this new product line today?

What is the charge on the inner cavity surface : A solid spherical conductor of radius 1.50 m has a small spherical cavity of radius 0.50 m with the same center. The net charge of the conductor is zero.

Equivalent units for the conversion costs : During September 50,000 units were started; 5,000 of these were still in process at the end of September and were 3/5 finished. The equivalent units for the conversion costs in September were:

Formulate an lp problem for store budgets a total value : Markups on Supertrex seen at other local stores range from 20% to 45%, Kruger decides that its markup had best be in this range as well. Formulate as an LP Problem.

Calculate the hardness of the water in ppm : 5.00 ml of a water sample was titrated for hardness with 4.15mL of 0.0200M EDTA. Write an equation for the reaction and calculate the hardness of the water in ppm

Income statement and supporting schedule of cost : Prepare an income statement and a supporting schedule of cost of goods manufactured for the year ended December 31, 2009.

What is the molarity of the sodium carbonate : Assume you dissolve 6.73 grams Na2CO3 in enough water to make 250 mL of solution. What is the molarity of the sodium carbonate?

Define comparision of net present values : Either bulb will be used for 2,000 hours per year at an electricity cost of $0.14/kwh (kilowatt-hour). If the interest rate is 6%, which bulb is more cost effective over 8,000 hours of use based upon a comparision of Net Present Values?

User Account

All Pages