Laserfiche WebLink
8-0 Automatic Fuel OrWring With <br />.` Products Ordering <br />Worksheet" <br />An automatic fuel ordering program called the "Light <br />Products Ordering Worksheet" has been incorporated <br />into the EMS. <br />This Light Products Ordering Worksheet will be printed <br />- automatically with no operator involvement at a preset <br />time each day (See Figure 10). In calculating this Light <br />Products Ordering Worksheet, the EMS tracks the <br />--average daily sales for each product. This calculated <br />sales information, in conjunction with the current <br />inventory levels, is used by the system to predict the <br />"number of days supply" remaining for each product. <br />The EMS is capable of generating fuel orders if the <br />-"number of days supply" for any grade of fuel drops <br />below 2.5 days supply on Monday through Thursday or <br />4.5 days supply on Friday. If an order is generated and <br />Lhere are one (1) or more previous orders still pending, <br />then the previous order(s) will appear as <br />_"SCHEDULED DELIVERIES". There can be as <br />many as twenty (20) orders scheduled at any one time. <br />After generating an order, the EMS will automatically <br />determine if additional deliveries are required and will <br />generate up to a maximum of three (3) orders each day, <br />if needed. <br />The Fuel Ordering Flow Chart on page 22 shows you <br />how to: <br />1. Obtain a Printed List of Current Scheduled <br />Orders <br />2. Activate the Change Order Menu <br />3. Change Information on a Scheduled Order: <br />a. Change Delivery Day <br />b. Change Delivery Month <br />c. Change Delivery Year <br />d. Change Delivery Shift <br />e. Change Delivery Quantity <br />4. Delete a Scheduled Order <br />5. Override the Sales History <br />21 <br />NOTE: The E*utomatically assunus that you <br />placed, and will receive, the "ACTUAL <br />ORDER" quantities that appear on the <br />bottom of the "Light Products Ordering <br />Worksheet". It is important that you place <br />these numbers as they appear. If you <br />modify the order, you will need to make the <br />necessary changes in the EMS stored <br />orders. <br />Figure 10 <br />ID t 02579 <br />Store ID Nwnber <br />DATE PREPARED <br />Date and Time WorkaheetWas <br />05/11M - 6:00 a.m. <br />Prepared <br />DAY= 6 <br />SUL UNL SPC <br />Fuel GradesforTanks 1- 3 <br />DAILY SALES <br />504 1.005 423 <br />Current Average Daily Sales <br />SALES RATIO <br />Sales Ratio based on Average <br />26% 52% 22% <br />Doily Sales <br />CURRENT INVENTORY <br />Fuel Inventory atTuneof <br />2,865 2.094 3,157 <br />Worksheet <br />QUANTITIES ON ORDER <br />Fuel Quantities Already on <br />2,400 2,500 4,400 <br />Order <br />SCHEDULED DELIVERIES <br />Date and Shift this Order will <br />05/13MO - N <br />be Delivered <br />PROJECTED SALES <br />UNTIL NEXT DELIVERY <br />Fuel Quantity that will be Sold <br />378 753 317 <br />by the Tune this ThickArrives <br />INVENTORY <br />Fuel Inventory after dds <br />AFTER DELIVERY <br />Delivery (Test is Made at this <br />4,886 3,840 7,240 <br />Point to Determine ff Order <br />Will Pit) <br />NUMBER DAYS SUPPLY <br />Number of Day's Supply <br />8.50 3.10 15.74 <br />(Taking into Account the Order <br />than is on the way) <br />PROJECTED INVENTORY <br />AT TIME OF DELIVERY <br />Fuel Inventory at Delivery Tune <br />3,750 1,578 6,287 <br />of Order <br />TOTAL INVENTORY <br />AFTER DELIVERY <br />Peak Inventory after Delivery of <br />20,916 <br />Order (Sum of all Tanks) <br />DESIRED INVENTORY <br />Optimal Peak brventory (Based <br />BY PRODUCT <br />on Week -Long Average of Daily <br />5,086 7,485 5,356 <br />Sales and Peak Inventory) <br />AVAILABLE TANKAGE <br />Space Available When Order <br />5,549 7,721 3,012 <br />Arrives <br />ORDER QUANTITY TO <br />Amount of Fuel Needed to <br />ACHIEVE DESIRED <br />Satisfy Optimal Peak <br />INVENTORY <br />Inventory <br />1,336 5,906 0 <br />Actual Order Values (Sorted to <br />ACTUAL ORDER <br />Fit Tank Truck Canpasfinenta) <br />2,400 6,900 0 <br />05/16J90 - D <br />Date and shift fiat the Neat <br />Order Should Be SeAeduled <br />