## Material Requirements Planning-MRP/Capacity Requirements Planning-

MS EXCEL

### Next

• 1. Percentage Increase Between 2 Percentages
Here's a scenario: Week 1 Visits to store = 100 Purchases = 1 Purchase rate = 1% Week 2 Visits to store = 200 Purchases = 4 Purchase rate = 2% Here's the question: What is the increase in my purchase rate? Is it 1%? Is it 100%? Thanks for your help!
• 2. Custom Sort
Hi I am hoping someone will be able to help me. I have a worksheet that is based around order numbers issued to staf members. I want to sort this worksheet so that the numbers are displayed i order. My problem is that we issue straight 4 digit numbers, but als variations of these orders ie. 1234-01. I want my column to read like this; 1234 1234-01 1234-02 1235 1236 1236-01 and so forth. Any help most appreciated!
• 3. Symbol after text
Further to my last question please could you tell me if it is possible to insert a symbol after a number in the same cell and still use the number in that cell in a sum? Thank you
• 4. More equation Help
how if i want to have a cell round up the number that is put into it, to the next whole number.

### Material Requirements Planning-MRP/Capacity Requirements Planning-

```I would like to use Excel for my Material Requirements Planning (MRP) and
Capacity Requirements Planning (CRP) needs.  Any suggestions on how to get
started or a link to a site that has the formulas or VB codes needed to get
this done and working properly?
```

### Re: Material Requirements Planning-MRP/Capacity Requirements Planning-

```Tricia Young  -

One possible way to get started is to browse to Google and search for "excel
material requirements planning" (without the quotes). There are "about
1,210,000" links, and maybe one of them may be useful. But, if you've
already done the search, and none of those results are satisfactory, please
provide more details. For example, what have you tried and what has not
worked properly?

-  Mike
http://www.**--****.com/

```

```I would like to use Excel for my Material Requirements Planning (MRP) and
Capacity Requirements Planning (CRP) project.  Any suggestions?
```

```Can some one kind advise me how I can buld a Material Requiremen
Planning tool with excel. All does anyone got links to templates that
can use.
Fr

```

```I would like to use Excel for my Material Requirements Planning (MRP) and
Capacity Requirements Planning (CRP) project.  Any suggestions?
```

```HI
I'm after a template to be able to manage when materials are due to come in
based on a leadtime to manufacture, Just wondering if there are any templates
available, or if anyone has set up there own that they are willing to share
Kind Regards
Shane
```

```Hi,

I am trying to display the following information in one combined bar
diagram:

1. the value for the available total capacity: this value should be
displayed as 100% in a bar.

2. the value for capacity already reserved: this value should be
disblayed in comparison to value 1.

3. the value of the required capacity for the actual work order that
needs to be planned: this value should be visualized additive to value
2.

Value 2. and 3. should be added and displayed in comparison to value 1.

Who can help me with that one?

Thanks

Phippe

```