Problem:
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?