GradePack

    • Home
    • Blog
Skip to content

A company is selling a perishable good. Any surplus (i.e., l…

Posted byAnonymous March 30, 2026

Questions

A cоmpаny is selling а perishаble gооd. Any surplus (i.e., leftovers) can be sold in a salvage market, but the prices in the salvage market are pretty random, so the company is uncertain about how much revenue they can get from their leftovers. The company has collected 10 data points on the demand for their product and the price from the salvage market. Use the attached spreadsheet to determine the optimal quantity of product to order from their supplier. STARTER SPREADSHEET that only has the first row of simulations. Don't forget to "freeze" the randomness in the spreadsheet before running Solver.   What is the optimal quantity of the perishable good to order from the supplier? This should be an integer.

Tags: Accounting, Basic, qmb,

Post navigation

Previous Post Previous post:
A furniture manufacturer has three production lines for manu…
Next Post Next post:
2. The vaccine for which of these pathogens is an inactivate…

GradePack

  • Privacy Policy
  • Terms of Service
Top