Excell spread sheet required for a marine inventory business spanning Australasia
Budget: $60 – $0 NZD
I require a spread sheet created that can itemize stock of boats held by respective dealers from various countries , New Zealand , Australia , Vietnam , China , Philippines, Noumea , Tahiti . Hawaii ,
The spread sheet must itemize the product , by brand ( 3 brands in total ) , and provide a local currency landed value . This value must then be displayed in a column called " FLOORPLAN VALUE " this floorplan value must count down from the respective dealers floorplan limit. Then it must show scheduled stock to follow with a date . This information needs to be extracted from a share drive. This part of the puzzle can be done as a part two project . The purpose of this is to allow me as the distributor to have full visibility over my dealers ability to fund stock and manage their floorplan limits . It would also be handy to know the age of the individual inventory item
The spread sheet must itemize the product , by brand ( 3 brands in total ) , and provide a local currency landed value . This value must then be displayed in a column called " FLOORPLAN VALUE " this floorplan value must count down from the respective dealers floorplan limit. Then it must show scheduled stock to follow with a date . This information needs to be extracted from a share drive. This part of the puzzle can be done as a part two project . The purpose of this is to allow me as the distributor to have full visibility over my dealers ability to fund stock and manage their floorplan limits . It would also be handy to know the age of the individual inventory item