Closed

Inventory Spreadsheet

I am a small manufacturing company producing a product for carrying babies called a Ring Sling, or sling for short ([url removed, login to view] - it is in german but I am american, so english is preferred).

I need a relatively simple 'supply chain management' set of spreadsheets, and by this I mean a set of spreadsheets that will tell me the following: (you can also look at the attached documents)

1) given my current inventory of materials, how many slings can I produce today

2) what is my current inventory of completed slings, based on the previous month's inventory, production and sales, so I can better forecast what model slings I will need in the next three months

3) given my forecast and current inventory of both materials and completed slings, how much of each material do I need to order to meet the forecasted demand over the next three months

I had someone create the attached spreadsheets for me, and all the formulas worked perfectly, however, as I have limited Excel skills, I need new ones that has the following capabilities:

- the ability to add new fabrics and fabric combinations

- the ability to delete old fabrics and fabric combinations

- the ability to make it ongoing - it is a monthly spreadsheet and the creator created it only through April, so now I am stuck

- the ability to, or maybe just instructions on, save the spreadsheets under different names as I update them. I have the impression from the person who created them that I cannot rename any of the spreadsheets as they are interconnected based on names. So for example I cannot save a worksheet as 'April 2013'; this is important because sometimes I want to make a manual adjustment, let's say in May, then want to go back and see what it had looked like in April before I made the adjustment. Right now I can same them in different folders, but can't then open them at the same time, because they have the same name. I also work with the head of our production who is physically located somewhere else, but the Inventory is kept both where she is and where I am; and some of the sheets are filled in by her, and some by me. So in a given month I might want to look at her spreadsheets and mine at the same time, but as they have the same name, I cannot open them at the same time. Or I could be completely wrong and they could be renamed with out confusion. That's where you come in.

Here is what needs to be in each spreadsheet:

Each Sling has the following components:

- two different fabrics - one color for the main part of the sling; a second color for the edges. I have at any given time approximately 15 different fabrics, which I combine to make approximately 20 different sling model numbers.

- a pair of rings

- material for the shoulder pad

- material for the side padding

The material is delivered in the following measurements

- fabric is delivered in meters; it is then cut into smaller pieces before it can be used for a sling. Each sling needs two pieces of fabric. Each piece needs to be the same size, regardless if it is used for the middle of the sling or for the sides. Each piece needs to be a 3 meter length of fabric, but only 1/3 or 1/2 of the width, depending on how wide the fabric is

- rings are delivered in pairs, at the moment is a choice of only two colors, black or white

- The padding is currently delivered in rolls; we use the same material for the shoulder pad and the side padding, but they are cut into different sizes

As mentioned above, both I and another person are filling in the spreadsheet, not sure what the best way to manage this is.

Hope between the above description and the attached sheets this gives you a good idea of the scope of the project. Also, the language may be a mixture of German and English, but I prefer all English.

Best Regards,

Kathryn McDaniel

BabySling Austria

Skills: Excel

See more: excel sling ring, inventory excel fabric, inventory delete sheets, slings, Inventory spreadsheet, fabric inventory spreadsheet, sling inventory sheets, example spreadsheet inventory manufacturing company, sling spreadsheet, inventory spreadsheets excel, what's new in manufacturing, set of pairs, production spreadsheet, production company names, names of manufacturing company, manufacturing spreadsheet, manufacturing company names, i need to make production create, best excel spreadsheets, fabrics inventory months, sales forecast, it skills in demand, inventory management spreadsheet, new product manufacturing, Supply chain management

About the Employer:
( 0 reviews ) Vienna, Austria

Project ID: #4182457

9 freelancers are bidding on average $349 for this job

nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More

$500 USD in 30 days
(39 Reviews)
5.4
ethicalboy

Please see what I said.

$250 USD in 21 days
(20 Reviews)
4.3
cosconeaionut

Hi, I am experienced with excel vba and I can do what you need. Also I implemented projects like your in a simple way for easy using. Trust me and you will not regret! I will make an excel applicationwith bittons form More

$400 USD in 10 days
(6 Reviews)
3.6
waqar21081974

I can complete this task for you.

$400 USD in 7 days
(5 Reviews)
3.3
FLinCanada

Yes, I can do this for you. I can also cover your other project at the same time (as part of this work at no additional cost). There are some considerations though, which I have put in the attached PM. Please confirm More

$325 USD in 10 days
(7 Reviews)
2.5
epdailo

I am qualified to work on this project. I quoted 20 days, but it can take less or more time, depending on your satisfaction. I can keep working on this until you are completely satisfied. I also will guarantee unlimite More

$250 USD in 20 days
(2 Reviews)
2.2
JScottArnold

Good evening! I am a statistical and analytical consultant with years of experience doing projects like this. I've made other sheets for example for distribution of toiletry kits that go on airplanes, and other supply More

$300 USD in 10 days
(0 Reviews)
0.0
vyastik

Dear madan, I'm an experienced Inventory manager and Excel/VBA developer and am eager to complete this job properly and in time.

$280 USD in 9 days
(0 Reviews)
0.0
Midlander

Kat, The spreadsheet and database attached to the Private Message Board uses your data from the previous project. It will enable you to judge for yourself whether I have the Excel skillset to deliver your solution. More

$432 USD in 14 days
(1 Review)
0.0