You establish your minimum and maximum levels used in the calculation using the Min-Max Minimum Quantity and the Min-Max Maximum Quantity item attributes. You can start by setting the Inventory Planning Method item attribute to Min-max planning. To use min-max planning at the organization level you must set the item attributes used by min-max planning. When you min-max plan at the organization level, Oracle Inventory looks at inventory balances, purchase orders and WIP jobs as supply and sales order and WIP job component requirements as demand. You can then turn these requisitions into purchase orders or internal orders for the required items. Also, subinventory level planning cannot generate jobs and does not consider WIP jobs as supply or WIP components as demand.

Requisitions for the suggested replenishment quantities can be optionally created. When you min-max plan at the subinventory level, you can optionally include only open sales orders as demand in the min-max planning calculation. You can then turn these requisitions into purchase orders or internal orders and the unreleased jobs into jobs for the required items. Purchase requisitions for buy items and WIP unreleased jobs for make items for the suggested replenishment quantities can be optionally created. When you min-max plan at the organization level, you can optionally include open sales orders and work in process component requirements as demand in the min-max planning calculation. Oracle Inventory performs min-max planning for your items at either the organization level or the subinventory level. When the inventory level for an item drops below the minimum, Oracle Inventory suggests a new requisition or job to bring the balance back up to the maximum. With min-max planning, you specify minimum and maximum inventory levels for your items. I am working with Excel 2010 and very new at this.You can use min-max planning to maintain inventory levels for all your items or selected items. Even if the Max YTD does not change it still has to be carried over to the next month until end of Fiscal Year Sept.13. 13įor each month starting with (Oct – Sept) if the Max YTD is greater than (85,902) the new highest peak # has to be carried over to the next month along with the date it occurred and this keeps reapting every month. This process keeps reaping each month until end of Fiscal Year Sept. 12 current month Cell B:85,011 + date Cell C:11/13/12 max these two #s’ and two dates then input new data into Nov. I need to take the Max Oct.12 YTD Cell D: 85,902 + Max date Cell E:10/15/12 and the Nov. I need to come up with a formula that will calculate the following: This highest peak # took place during Oct. The Max YTD is a # gathered for the highest peak total (85,902) which Starts at Fiscal Year Oct. Max Date (peak occurred): – Cell E: 10/15/12 _ Author Debra Posted on JAugCategories Calculations In both the worksheet and the pivot table, the blank cell is ignored when calculating the minimum amount. With a pivot table, you can quickly see the minimum for each product that was sold, and the grand total - 8 - which matches the worksheet minimum. In the screen shot below, you can see the source data for a small pivot table, and the minimum quantity, using the worksheet’s MIN function, is 8. The result is the same as using the MIN function on the worksheet to calculate the minimum of the values. The Min summary function shows the minimum value from the underlying values in the Values area. With a pivot table, you can quickly see the maximum for each product that was sold, and the grand total - 97 - which matches the worksheet maximum. In the screen shot below, you can see the source data for a small pivot table, and the maximum quantity, using the worksheet’s MAX function, is 97. The result is the same as using the MAX function on the worksheet to calculate the maximum of the values.

The Max summary function shows the maximum value from the underlying values in the Values area.

Now we’ll look at two more functions, that are closely related - Min and Max. In recent blog posts, we’ve looked at the pivot table Count function and the Average function.

Max and min calculator