MWR Japan

help | dashboard | my tickets | contact us | login

Help Center

Q&A Directory
Foodtrak

	Birite Ordering Procedure (MWR YOKOSUKA ONLY)
	"How do I" Logon to MWR Server (MWR ATSUGI ONLY)
	"How do I" Enter End of Month Inventory Entry (Profit Center)
	"How do I" Unlink Inventory Forms (Accounting Only)
	"How Do I" See on-hand amounts in the database
	"How do I" Enter Purchase Orders in Foodtrak (MWR YOKOSUKA ONLY)
	"How do I" Add items to inventory template
	"How do I" Enter waste into Foodtrak
	Recommended Foodtrak Reports for EOM
	"How do I" Run the Item Usage Report for My Profit Center
	"How Do I" Run the Transfer Activity Report
	"How Do I" run the Profit Center Summary Report
	"How Do I" Run the Price Exception Report
	"How Do I" Run the Profit Center Transfer by G/L Report

"How Do I" Run the Price Exception Report

Price Exception Description The Price Exception Report identifies price changes that you consider significant enough to affect profit margins. This report allows you to enter any percentage, and then prints all items that have experienced price changes exceeding that percentage. Depending on the percentage you select, it is easy to isolate variations from bid pricing, invoice errors, key-punching errors and items in need of special attention. Wizard Options 1. The starting cost of an item included on this report is established by the last purchase that occurred before the Beginning Date you signify on the first wizard window. If there have been no purchases prior to the Beginning Date, FOOD-TRAK uses the cost amount defined on the Item Editor? s Purchasing tab. 2. Enter a date for the beginning of the period under examination, and, if the ending date for the report is not today?s date, change that field as you desire. 3. Select the way you wish to have this report sorted. A sort by Report Group is convenient for reports with long lists, while a sort by Item Name or Vendor is suitable for shorter lists. 4. If, in wizard option 2 you selected a sort by Report Group or by Vendor, the wizard now gives you the option of including data from all Report Groups or Vendors in the report, or a data from a single Report Group or Vendor. The drop-down list activates if you choose to select a single Report Group or Vendor. 5. The final wizard option allows you to specify exactly how much of a percentage variance in item cost you wish to establish for the cost to be designated an exception. 6. Entering a high percentage rate in this field will help narrow down the list and eliminate price increases due to, say, inflation. Leaving this figure at 0.0% will cause all price changes per item to appear on the report. Results The report presents the date range and variance in the header. In the body of the report, the data is presented in the sort order you selected, and includes the Items? purchase unit, starting cost, (latest) purchase cost, and the percentage price change between the two. The report also contains the date of the latest purchase, the vendor from whom it was purchased and the invoice number.