Validating profile... 0% complete

What is your current level of experience in freelance work?

 

 

Inventory Data Excel Spreadsheet with Pivot Tables

I'm looking for a freelancer who can create a detailed Excel spreadsheet for my inventory and production data for a screen printing/embroidery business. The sheet should have data of item number, description, count, cost per item, total cost, Then I need to take the item cost add markup to get price, then production area to add price then job (screen), then have sale price. The pivot table will combine then to get a good picture of the inventory. The spreadsheet should include pivot tables that provide specific views on: - Current stock levels - Sales and restocks - Inventory cost and profit margin - How long in stock Furthermore, the pivot tables should also assist in calculating or analyzing: - Cost - Profit margin - Restock frequency Ideal skills and experience for this job inc...