Expansion Strategy and Establishing a Re-Order Point, statistics homework help

Expansion Strategy and Establishing a Re-Order Point, statistics homework help

Assignment Steps

Resources: Microsoft Excel®, Bell Computer Company Forecasts data set, Case Study Scenarios

Use Excel File for calculations, graphs, and tables. (only Excel not word document)

Case 1: Bell Computer Company

  • Compute the expected value for the profit associated with the two expansion alternatives. Which decision is preferred for the objective of maximizing the expected profit?
  • Compute the variation for the profit associated with the two expansion alternatives. Which decision is preferred for the objective of minimizing the risk or uncertainty?

Case 2: Kyle Bits and Bytes

  • What should be the re-order point? How many HP laser printers should he have in stock when he re-orders from the manufacturer?

Note: attached files are the resurces you need for this assignemnt.