Formulate an integer linear program that can be used for

Assignment Help Basic Statistics

Reference no: EM13615090

Beechwood Specialty Electronics has just leased space for a store in the Crestview Hills Towne Center that will provide a storage space 20 feet long and 10 feet wide for inventory of products. They sell only IPOD%u2019s and cell phones and must determine how many of each to keep in stock to maximize their profit. Their unit cost is $47 per IPOD and $32 per cell phone and they feel they can sell all that they stock. Because of packaging and accessories, an IPOD requires dedicating .5 square feet of floor space, whereas a cell phone requires .75 square feet of floor space. An IPOD will earn Beechwood $90 in sales revenue and a cell phone will earn them $70. Marketing requirements are that at least 60% of all units in stock be IPODS. Finally, an IPOD uses up $200 in capital and a cell phone uses $50. Beechwood wants to have at most $3,000 worth of capital tied up at any time.

a. Formulate an integer linear program that can be used for Beechwoods situation.

b. Solve the problem using Excel Solver. Provide both answer and sensitivity analysis results with clear interpretation.

Reference no: EM13615090

Questions Cloud

A gold brick measuring 025 ft by 033ft by 1ft is submerged : a gold brick measuring 0.25 ft. by 0.33ft by 1ft. is submerged in water. the weight density of gold is 1200 pounds per

Check the validity of any assumptions necessary for testing : suppose five 6 oz tubes of toothpaste are randomly selected and squeezed until no more toothpaste will come out. then

On june 1st green pea inc purchased 1200 worth ofsupplies : on june 1st green pea inc. purchased 1200 worth ofsupplies on account. how does this transaction affect green

Assuming that f adequately describes the behavior of the : let x denote the length in minutes of a long-distance telephone conversation. assume that the density for x is given by

Formulate an integer linear program that can be used for : beechwood specialty electronics has just leased space for a store in the crestview hills towne center that will provide

Using the financial statementsof landrys restaurants : using the financial statementsof landrys restaurants located in appendix a back matterof the text fundamentals

Construct a 99 confidence interval for the difference : among 500 marriage license applications chosen at random in a given year there were 48 in which the woman was atleast

How significant are the result what is the best estimate of : a sample of 40 los angeles pharmacies sells the tamiflu 75mg prescription drug for about 137 for a moth supply s 30.2

Two charges q1 3x10-6 and q2 -6x10-6 c are placed along : two charges q1 3x10-6 and q2 -6x10-6 c are placed along the x axis at orgin and 1.2m respectivelya at what distance

User Account

All Pages