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

  Employee theft and poor inventory control are equally likely

In his report to the mall management, can he say that shoplifting is twice as likely to be the cause of the loss as compared with either employee theft or poor inventory control and that employee theft and poor inventory control are equally likely..

  Test the hypothesis regarding treatment means

Given the following sample information, test the hypothesis that the treatment means are equal at the .05 significance level.

  Median of the sample or average medians

Which is the probability of that the median of the sample or average medians be between 320 and 350 minutes?

  Estimate for the population variance

What is the mode and calculate the unbiased estimate for the population variance - estimate of the population variance of 9.2

  Drawing the histogram for the given data

Create a histogram over five class intervals.

  Brief statement of purpose of study

Write a brief statement of purpose of the study. Define the population. State the hypotheses for the study. Select an a value

  A write down the sample space for this experiment b find

suppose we watch the price of the dow jones industrial index for three days.assume there is a 6040 chance that the

  The library is to be given 3 books as a gift the books will

The library is to be given 3 books as a gift. The books will be selected from a list of 18 titles. If each book selected must have a different title, how many possible selections are there?

  Determining standard deviation of difference of scores

Determine the standard deviation of difference between Sarah's and Richard's scores?

  Identify type of error based on rejection of null hypothesis

In the real world, given null hypothesis is false; but the collected data lead to the null hypothesis being accepted.  That is, the data lead to a failure to reject null hypothesis.

  Applications of binomial and poisson probability

What are some typical applications of the Binomial and the Poisson probability distribution? Explain with examples. When is the Hypergeometric distribution used?

  Removal of taxes on dividend income

In a public opinion poll, 48% of 189 respondents favor an elimination of taxes on dividend income.

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