Long description

The data table is divided into two sections. Section 1 asks for the following pieces of data:

  • Demand rate, D

  • Setup cost, D

  • Holding cost percent, I

A tip box instructs you to enter the demand rate, setup cost, and holding cost. These inputs are as follows:

  • 5000

  • 49

  • 0.2

Section 2 of the data table asks for the following pieces of data:

  • Minimum quantity Range 1

  • Minimum quantity Range 2

  • Minimum quantity Range 3

  • Unit price, P for Range 1

  • Unit price, P for Range 2

  • Unit price, P for Range 3

A tip box instructs you to enter the quantity discount schedule with the quantity and unit price for each price break. These inputs are as follows:

  • Zero

  • 1000

  • 2000

  • 5

  • 4.8

  • 4.75

The Results table of formulas is made up of 4 columns. Each column, descending, ...

Get Quantitative Analysis for Management, 13/e now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.