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.

Reviews

Write a Review

Operation Management Questions & Answers

  Target market in the united states

Describe the target market in the United States, including customer demographics and income levels. Describe the competition the product would face in the United States and how you would create a competitive advantage. Name at least two competitors..

  Determination of the economic order quantity

A large bakery buys flour in 25-pound bags. The bakery uses an average of 4,500 bags a year. Preparing an order and receiving a shipment of flour involves a cost of $10 per order.

  Compare the result to the probability that a fatality

Compare the result in (a) to the probability that a fatality involved a rollover and comment on whether SUVs, Vans, and pickups are generally more prone to rollover accidents that other vehicles.

  Waiting time distributed with an average of seconds

In a call center, the waiting time for a customer is normally distributed with an average of 65 seconds and a variance of 25 seconds

  Problem on inventory control

Carmin's Boutique sells a large number of black dress shirts. The shirts, which bear the store label, are shipped from a manufacturer in Paris. Carmin's purchasing department manager says, "I want to be sure that I never run out of dress shirts.

  Discuss how supply and demand would be affected

Discuss how supply and demand would be affected under each of the four degrees of competition (pure competition, monopolistic competition, oligopoly, and monopoly)

  Describe in detail how the ethical culture of goodwill

Describe in detail how the ethical culture of Goodwill of San Franciso contributes to its organizational strategy.

  Susan has a part-time cottage industry producing

Susan has a part-time "cottage industry" producing seasonal plywood yard ornaments for resale at local craft fairs and bazaars.

  Compare and contrast project management

Compare and contrast project management and scenario planning techniques with particular emphasis on the implications of the techniques for the manager and the organization

  Managers must have the flexibility to change plans

Managers must have the flexibility to change plans since the future is so uncertain. If the statement is correct

  By explain how much would the accuracy rate improve

By explain how much would the accuracy rate improve if an additional (a second), equally accurate verifier were used.

  What estimating techniques should be used for a mission

Was top management acting correctly in developing an estimate? What estimating techniques should be used for a mission critical project such as this?

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