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

Reviews

Write a Review

Basic Statistics Questions & Answers

  What is the difference between a population standard

Apply the problem discovery sample size formula to several finite populations. How should I integrate the finite population correction factor (FPC) into this formula?

  Standard deviation and standard error for each group

Compute the mean, standard deviation, median, and standard error for each group.

  Ethics in professiional decsiion-mkaing

What is ethics? Ethics is basically concerned with the Moral obligations, responsibilities and social justice of the world. It invokes the idea of "how people should act".

  Whether each of the following statements is true or false

If we repeated this procedure many, many times, only 5 percent of the 95 percent confidence intervals would fail to include the mean Math SAT score of the population of all students at this college.

  1according to a recent survey 275 of 400 middle-aged

1.according to a recent survey 275 of 400 middle-aged americans said they used the internet regularly. 140 of 400

  Confidence interval for difference in patients hypertension

Generate a 95% confidence interval for the difference in proportions of patients with hypertension between groups. Experimental (n=100) =14%

  Suppose you were given the task of estimating the

suppose you were given the task of estimating the proportion of drivers in troy al who text while they drive. discuss

  What proportion of plan recipients receive payment

A normal distribution with a mean of 68 years and a standard deviation of 3.5 years. What proportion of the plan recipients would receive payments beyond age 75?

  Determine a 4-year weighted moving average forecast for

the following sales data are available for 2003-2008.year demand2003 72004 122005 142006 202007 162008 25determine a

  1i have three groups for which i want to perform an anova

1.i have three groups for which i want to perform an anova. they have standard deviations s1 2.5 s2 3.4 s3 6.4 and

  Understanding probability distributions

Is the bottled water you're drinking really purified water? A four year study of bottled water brands conducted by the natural resources found that 25% if bottled water is just tap water. Consider a sample of five bottled water brands, and let x e..

  Overhead spending variance-volume variance

From the following information for Alfred Industries compute the overhead spending variance and the volume variance:

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!

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