Closed

Create Spreadsheet template

Hello,

I need to create an excel template for my manager to fill in.

My concept is below.

I have 150 x items (maybe more to add later on). ITEM-1 to ITEM-150

These items are imported to my warehouse in parcels that contain various combinations of ITEM-1 through to ITEM-150.

For example:

Parcel 1, Tracking number #0001

May contain:

25 x ITEM-2

20 x ITEM-7

10 x ITEM-120

———-

I need to be able to enable a macro that automatically updates my warehouse stock once that parcel has arrived with one click, so that my local inventory is updated.

———-

Once items are arrived to my warehouse, I sort them and store them until customers order. All my customers have the same flat rate per item, however I need to be able to add a function where I can discount their total order by whatever % I wish if I feel it is applicable.

Some customers purchase products in full,

Other customers purchase products on consignment

And some customers purchase items with a % deposit and the rest on consignment

I have up to 50 x customers (need to be able to add more later)

——-

As for staff, they are paid by commission.

Staff receives X% commission for every item sold.

Each item the staff has different commission X% for.

I need a function to be able to give staff bonuses.

———

I also have overheads. I need a function for this.

——

I need to be able track profit. I have a cost price per item, and customers have a price per item.

I need to be able to track staffs weekly commission, weekly profit/loss and overall profit/loss/expenses/staff.

——-

I need to be alerted by a colour when items reach a low point of 25 x items each, or whatever low point I delegate.

——-

I have multiple suppliers who supply different items to me within my inventory. I need to be able to track what I owe/pay each supplier. At current, I have 5 suppliers.

My suppliers list items to me on consignment also and sometimes I pay up front.

———-

For my template, I have the following scenario I would like entered so that we can create the sheet:

I have $10,000 AUD in my business account

I currently owe no suppliers any money and my customers currently owe me no money either.

I order the following items from Supplier 1 on 1/12/2017 on consignment

10 x ITEM-1

10 x ITEM-2

I order the following items from Supplier 2 3/12/2017 up front payment

10 x ITEM-3

10 x ITEM-4

Supplier 1 sends the following parcels on the 2/12/3017

Parcel 1, tracking #001

- 5 x ITEM-1

- 5 x ITEM-2

Parcel 2, tracking #002

- 5 x ITEM-1

- 5 x ITEM-2

Supplier 2 sends the following parcels 4/12/2017

-10 x ITEM-3

-10 x ITEM-4

—————-

All three parcels then arrive to my warehouse on the same date, the 10/12/2017 and are updated on my local

Inventory

—————-

Week 1 of business 10/12/2017-17/12/2017:

Customer-A places an order of

2 x ITEM-1

2 x ITEM-2

He pays for all the items up front. I discount him 10%

—————

Customer-B places an order of

2 x ITEM-1

2 x ITEM-2

He pays for 50% of the items up front, and 50% he has a consignment owing.

———-

Customer-C places an order of

9 x ITEM-4

He accepts the entire order on consignment.

———-

My cost price for items:

ITEM-1 $10

ITEM-2 $10

ITEM-3 $20

ITEM-4 $50

———-

Customers cost price for items:

ITEM-1 $20

ITEM-2 $20

ITEM-3 $40

ITEM-4 $100

————

Staff is paid 5% commission per item

I give staff a bonus of $10

————

Overheads for the week cost $20

————

Low points to be alerted are when an item only has 1 item left on local stock.

————

What is my weekly profit/loss?

What was overall weekly staff costs?

What was overall weekly overheads?

Do I need to order any products from suppliers ASAP?

What do I owe suppliers?

Skills: Data Entry

See more: excel macro create spreadsheet template list data, create simple excel spreadsheet template macros, create report template via vba access database, create typo3 template dreamweaver, create wordpress template psd, create xhtml template constant contact, create pligg template, create dreamweaver template, create css template php, create cart template, create dynamic template web gmail, create xhtml template, create email template graphics, create zencart template, create joomla template

About the Employer:
( 0 reviews ) Parramatta, Australia

Project ID: #15661141

48 freelancers are bidding on average $455 for this job

schoudhary1553

Greeting, I have understood your create spreadsheet template task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience More

$250 AUD in 3 days
(136 Reviews)
7.0
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Looking forward to work with you. Thanks & Regards Khushi India Relevant Skills and Experience Data Entry Proposed Milestones $526 More

$526 AUD in 10 days
(208 Reviews)
6.8
viya89809

Hi there, I am Mohana. Certified Expert in Excel with 7 years of experience. I know in and out of it and I know how to make the perfect template for your business. Relevant Skills and Experience I have worked on many More

$555 AUD in 10 days
(59 Reviews)
6.1
sonarkaushik

I am very able to create this inventory tempkate ib excel and ready to start

$333 AUD in 7 days
(78 Reviews)
6.0
helalru

I have read your project details and i understand that i have available experience to complete your project with 100% error less. Relevant Skills and Experience As an experienced freelancer i know how to complete your More

$277 AUD in 10 days
(34 Reviews)
5.5
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, MOHIUDDIN.

$399 AUD in 5 days
(83 Reviews)
5.9
skgtechnologies

Dear Client, I have gone through the project description and I would like to offer my services for the same. I have worked on several similar projects. Relevant Skills and Experience I work as full time freelancer a More

$333 AUD in 15 days
(19 Reviews)
5.1
tiaratechies

Hello, we own an accounting firm in India, a registered company and a software company, Personally I myself is an excel expert with more than 5 certified microsoft excel experts. Relevant Skills and Experience Excel More

$750 AUD in 1 day
(30 Reviews)
5.0
$555 AUD in 5 days
(24 Reviews)
4.9
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $25 More

$250 AUD in 3 days
(26 Reviews)
4.1
mhfsha

I just check the description would be a pleasure to assist you on your project. looking forward to discuss in the chat. I have team.

$250 AUD in 1 day
(16 Reviews)
3.5
Ashisjena2015

A proposal has not yet been provided

$250 AUD in 3 days
(5 Reviews)
2.2
WebSEOMax

Hi, We would require to create custom formulas for this template to work properly. Furthermore we will provide macros with buttons to make it more user friendly. Looking forward to work with you. Relevant Skills and More

$750 AUD in 20 days
(2 Reviews)
2.0
chintuag

I am an Excel VBA expert have read the project description. I am available to start work on it immediately. Relevant Skills and Experience I have worked on similar projects in Excel and recently closed a project for More

$334 AUD in 5 days
(1 Review)
2.1
Nicecreator

Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me Relevant Skills and Experience I have complited many data analytical work high quality and accuracy las More

$250 AUD in 0 days
(1 Review)
1.4
insidenetsoft

Hello, This project looks very challenging and I would be interested to collaborate in this implementation. I did before different dashboards and automation on different processes. Relevant Skills and Experien More

$250 AUD in 4 days
(1 Review)
1.3
HarleyJohnson

As a specialist in Data entry,Powerpoint, PDF Conversion, Excel Works, searching the web for emails, phone numbers, address, contact person ... Web Development, Internet research, domain name creation etc the multitud More

$555 AUD in 10 days
(1 Review)
0.8
GulzarA

Excel guru Relevant Skills and Experience Data Entry Proposed Milestones $555 AUD - complete

$555 AUD in 10 days
(1 Review)
0.3
XcelSolution

I have been working every day with Excel: formulas, databases, reports, and VBA for the past 10 years. Relevant Skills and Experience Excel: formulas, databases, reports, and VBA Proposed Milestones $270 AUD - Excel More

$270 AUD in 5 days
(1 Review)
0.4
$555 AUD in 5 days
(0 Reviews)
0.0