Spreadsheet model to find the best order quantity

Assignment Help Operation Management

Reference no: EM13108911

The circulation manager of The New York Times in State College, PA is trying to decide how many copies of the upcoming Sunday edition of the paper to order so as to meet the demand of local customers. Each copy of the newspaper costs $2.00 and is sold for $3.00. On Tuesday (following the weekend the newspapers are printed), all unsold copies will be returned to the distributor for a refund of $1.80 per copy. The owner believes that the number of papers she can sell on a typical Sunday is 21,100. She wants to decide how many copies of The New York Times to order so as to maximize expected profit from the sale of this particular newspaper. Develop a spreadsheet model and a corresponding data table to find the best order quantity among the given alternatives.

Reference no: EM13108911

Questions Cloud

Determining one-tailed and two-tailed tests : What is a one-tailed test? What is a two-tailed test? Explain at least three differences between one- and two-tailed tests. State a hypothesis related to this study that would cause you to conduct a one-tailed test. State a hypothesis related to th..

Compute the lowest-cost source of funding for glenwood : Compute the lowest-cost source of funding for Glenwood National Bank and the next cheapest source for borrowing over the next three days (today, tomorrow and the next day). Illustrate what are the relative advantages and disadvantages of each of t..

Find out the dh for the given reaction : find out the ΔH rxn for the given reaction as C 3 H 4 (g) + 2 H 2 (g) → C 3 H 8 (g)

Testing assumptions : For its validity, all hypothesis testing depends heavily on the assumption that the sample that is used was drawn using probability sampling techniques.

Spreadsheet model to find the best order quantity : The circulation manager of The New York Times in State College, PA is trying to decide how many copies of the upcoming Sunday edition of the paper to order so as to meet the demand of local customers.

Find adequate evidence to mean annual wage of people : Suppose that = $7600, is there adequate evidence to conclude that mean annual wage of people from this county is signicantly dierent than state mean?

Illustrate what happens if the data entered is wrong : Illustrate what happens if the data entered is wrong? Analytical tools suffer from the GIGO (garbage in, garbage out) weaknesses and thus an analysis based on these numbers can be flawed.

Compute the molarity of the solution : Compute the a)molarity of the solution, b)molality of the solution, c) mole fraction of Ammonia.

Errors and their implications : It has been said that from the point of view of the general population, Type I errors are particularly undesirable. This has been used as a justification for setting alpha at such low levels as .05 and .01.

User Account

All Pages