Work Order Decisions

The goal of Order Decisions is to help you order books from the Publishers. Order decisions gives you tools to adjust how many books you are buying from the publisher and to make informed decisions based on the SOH, Buyback, On Order, and historical data.

In the Order Decisions home page, there are filters provided to narrow down the results on page, making it easier to search for and work order decisions.

Work Order Decisions for the Term

  1. Use the filters to select the Term you want to work on and select Work Order Decisions to have the ability to page through through all selected Order Decisions.

    You can filter it further by work status to “Not Worked” for all order decisions not in a worked status.

Work on a single title

  1. IF you are wanting to look at one title, Locate the Title using one of the search methods. (Note: If the title is on more than one term, you may want to filter it to the desired term)

  2. Select Edit on the Title.

  3. Review/work the title in Edit Order Decision. Select Save.

 

Note:

If you have a title adopted for more than one active/open term you will see the title displayed twice and will need to filter by term, along the right side, to isolate the record to select.

Note

On the Order Decision screen, there are fields you can edit and fields that provide information from other parts of the software. 
As the header portion of the screen is simply product information from Product Maintenance, we will not cover it in this document.

Order Decision Record

The goal of order decisions is to move the Status to Worked either manually or by changing a quantity field.

  1. After selecting Edit or Work Order Decisions, the Order Decision for the title displays.

  2. Make desired changes to Quantity to Provide, Allocated, Order Short, Auto Order Tolerance, Max/Estimated Buyback.

  3. Check or uncheck Want List and/or Buyback Title checkbox.
    These boxes must be checked for the title to appear on a Want List or Buyback List.

  4. If you are not making any changes and everything looks good, select Status drop down and change to Worked.

  5. Select Save or use the next arrow at the top of your screen to work your next order decision. It will save between records.

Note: Worked status is required for Autogen POs, Want Lists, and Buyback.

 

You are able to see the history of the title if there is any by selecting the # of Previous Terms to Display.

 

 

 

Order Decision Record Terminology

Order Equation

 

(Requested)

 

Quantity to Provide (QTP)

-

Allocated

-

Order Short (if set on term)

-

Estimated Buyback (EBB)

 

or Actual Buyback (ABB)

 

   or No Buyback

-

On Order

-

Received

=

Open to Buy (OTB)

  • Underlying equation to calculate Open to Buy (OTB).

  • OTB used for Autogen Purchase Orders, Want Lists, and optionally for Buyback Lists.

  • Buyback Lists can also be created using Estimated Buyback, Max Buyback, or a percentage of Quantity to Provide (QTP)

Term

Definition

Term

Definition

Requested

Cumulative total from the requested field in all course requests using that title for the term. This informs the initial QTP.

Open to Buy

Quantity still needed to buy to meet QTP.

New/Used SOH

Current SOH from Product Maintenance.

Status

Begins in Work, goal is to move to Worked. Changes to Requested and/or QTP can move it from Work to Worked. Later changes can flip the status to Rework. Other statuses can be used as desired. In order to be eligible to appear on a want list, buyback list, or auto-generated PO, the title must be in a Worked status.

Quantity to Provide

The number of this book the store is going to provide to its customers. It starts as the same as Requested but can be edited manually.

Allocated

You can opt to Allocate some or all of your existing SOH to the term. This will update your open to buy.

Order Short

Order Short is an optional factor. If you know you will order less than the QTP, it subtracts the amount entered here from the QTP. It is only subtracted IF you have checked the Subtract Order Short box on the Term. 

Auto Order Tolerance

Enter a quantity at or below which you do not want a proposed order generated by the system. This optional field is a way to prevent ordering small quantities of a title. If your QTP is less than or equal to the auto order tolerance, the item will not be added to a proposed autogen order.

Want List Title

Defaults to checked. If checked, the title will be eligible for a want list.  Uncheck if you don’t want it to be added to a want list.

Buyback Title

Defaults to checked. If checked, the title will be eligible for a Buyback list.  Uncheck if you don’t want it to be added to a buyback list.

Max Buyback

Used to help control how many are purchased at buyback. Does not impact the order equation.

Estimated Buyback

Enter the amount, if any, you think you will get at buyback.  If the term is set to subtract estimated buyback, this field will be used in the order equation. The setting on the term can be changed as you move through your term cycle.

Actual Buyback

Records the amount actually bought during buyback. If the term is set to subtract actual buyback, this field will be used in the order equation. The setting on the term can be changed as you move through your term cycle.

On Order

Quantities on proposed or open POs, for the term display here.  Impacts OTB.

Received

As quantities are received they move from On Order to Received. Impacts OTB.

Returned

Tracks returns done for the term.

Sales New/Used

Tracks sales posted to the term. The term must be active in the Post Sales section of the term settings. If the book is used in more than one active term, sales will post to this field according to posting order.

Estimated Enrollment

Cumulative estimated enrollments entered at course requests for the term.

Actual Enrollment

Cumulative actual enrollments entered at course requests for the term.

Ending Inventory

SOH at the time the term is closed.

Sale New/Used Rental

Tracks books rented for the term.

Estimated Rental Return

Optional field to enter an estimate of how many rented books you will get back. Not used in the order equation.

Actual Rental Return

Tracks rented books returned.

 

First Published 03/18/2021

Edited 05/15/2023

© 2021 PrismRBS All rights reserved.