Open Report
Open the Unit Sales Enquiry report in Unleashed.
Select Date
In the 'Date From' box, select the month prior but over a year ago.
For 'Date From' select the month prior but over a year previous. For example, if we are currently in the month of February 2026, I would select January 2025.
Double Check 'Date To'
'Date To' will automatically select 12 months. Double check that this has happened.
Double Check 'Include Credits'
Ensure the 'Include Credits' tick box is checked.
Add Supplier
Enter 'KIWI Truck Tyres' for the ‘Supplier Name’.
Run the Program
Select ‘Run’ to run the program.
Open Spreadsheet
Open the excel spreadsheet named ‘KIWI proposed container orders’ found in our main G&T folder.
'Gas and Tyre Limited Team Site > Documents > G&T > G&T Sales > Kiwi Truck Tyre > KIWI proposed container orders.xlsx'
Open New Excel Sheet
Open a new sheet by clicking the + symbol down the bottom. Rename the new sheet the month & year you are placing the order.
Copy Previous Order Sheet
Click on the previous order sheet and select the entire sheet by clicking in the top cell above the row numbers and then copy the entire sheet contents by clicking ‘Control + C’.
Paste Information
Click back into the current order sheet, then click in the same top cell above the row numbers to highlight the entire sheet, and click 'Control + V' to paste the information in.
Delete Rows
Highlight rows 2 – 17 in column B, and press delete.
Delete Columns
Repeat this same step for Columns E & G.
These are all the columns with a light-blue highlight.
Enter Total Number
Go back into Unleashed and note down the 'Total' number from a KIWI product.
Then, enter the number from the ‘Total’ column in Unleashed into column B in the order sheet adjacent to the same KIWI product.
Enter 'Stock On Hand' Number
Enter the number from the ‘Stock On Hand’ column in Unleashed into column E in the order sheet for that same product.
The sheet will then project how many months of stock we are projected to have in column F. If we are projected to have below 2 months of stock on hand, the cell will highlight red.
Calculate Product Units to Purchase
Go through each product and work out how many additional months of stock are required so that we end up with New SOH of 4 month.
For example:
Column F shows 2 months of projected stock.
You need 4 months total.
Therefore, you need 2 more months of stock.
Next, convert the months needed into units. To do this, multiply the monthly usage (Column C) by the number of months you need to add.
For example:
Monthly usage (Column C): 150 units
Months needed: 2 months
Units to order: 150 × 2 = 300 units
Enter the calculated units into the 'New Order' cell (Column G).
Check Column H and see if it now shows at least 4 months of projected stock.
Adjust the order quantity if needed until Column H reaches or exceeds 4 months.
Delete Rows
Once this has been done for all products, click on the sheet called ‘Container Order Planner’, select rows 2 – 19 and select 'Delete'.
Transfer Order Quantity
Next, copy the number of units that you need to order (Column G ‘New Order’), from your order sheet, into column E ‘Quantity’, in the 'Container Order Planner' sheet.
Make sure that you copy the quantity into the the correct cell that is adjacent the product.
Container Limit
Keep your eye on row 20 of column G as this will tell you when you have reached the limit for a 40ft container m3. (62m3)
New Purchase Order
Open a new Purchase Order in Unleashed to KIWI Truck Tyres.
See
Double Check Warehouse Location
Ensure the Warehouse is changed to ‘Kiwi Truck Tyres’ warehouse location.
Delivery Date
Change the delivery date to roughly 4 weeks from date of purchase.
Enter Required Number
Enter the required number for each product line as per the final count from the Container Order Planner sheet.
Communicate with Josh
Run the final purchase order past Josh for cashflow approval.
Send Purchase Order
Send purchase order to KIWI Tyres.
Do this by downloading a PDF version of the purchase order once it has been placed. Attach the PDF to an email and send it to Nigel Smethurst.
Email Address: nigel@kiwityres.co.nz
Thank you for viewing these instructions on how to order a KIWI container. You should now have a greater understanding on this topic.