1. Chitra is looking at your ERP screen for this product and asks you why there seem to be some production orders for this material. You suddenly realize that there are some previous production orders released to the shopfloor that have already been released but have not been completed but parked because of labour issues. You cannot therefore produce them earlier, but you expect to be able to complete them as follows (at the beginning of the respective weeks). You want to factor these into the MRP calculations.

Parameter

W1

W2

W3

W4

W5

W6

W7

W8

W9

W10

W11

W12

Released production orders (open quantities only)

50

200

300

1. While drawing these up, you also see a firmed up planned order (not converted to production order due to labour issues) and a couple of firmed up purchase requests (not converted to purchase orders, but drawn up as part of a discussion to buy some quantity from an external supplier to overcome temporary issues with labour availability)

Parameter

W1

W2

W3

W4

W5

W6

W7

W8

W9

W10

W11

W12

Firm Planned orders

100

Firm Purchase requests

300

1. As you are explaining some of these to Chitra, your boss happens to overhear you and walks in to make a comment. He says that in reality while we forecast monthly and split those into weekly forecasts based on commercial input, the weekly forecasts have lower accuracies than the monthly forecasts. In reality, there can be a slight difference in the timing of the actual orders coming from customers. At the broad level, the inaccuracy extends to one week behind and one week forwards. So he wants you to tweak the assumption an order vs forecast as follows.
   1. Sales orders must first consume the forecasts for that week for which the order is requested for.
   2. If the actual orders exceed the forecasts, then one must assume it could be for the previous week and consume that forecast if available.
   3. If the actual orders exceed forecasts and there is no unconsumed forecast in either the same week or the previous week, then it should be assumed to be for the next week.
   4. All the sales orders come in chronological order, so the orders requested for W1 come in before the orders requested for W2.

1. You introduce Chitra to your colleague from manufacturing who decides to sit in on the training session. He points out that while the min and max lot sizes for production are ok, the input materials cannot be drawn in unit increments since the machine has multiples of ten attachments to process at the same time. So if we produce 11 units, 9 attachments will run empty. He suggests that you add a value of 10 units to round the production orders to the nearest 10 units to make it more efficient for manufacturing.
2. While you take on board his suggestions, he brings in a further complication. He says while the 10 unit increments used to work in the past because they had the same make/ type of machines, their machine park had undergone significant changes so to get the most efficiency, they had to produce in lot sizes that were not increments of the same size. You asked for data and he provided the table below.

50

60

80

100

150

180

240

260

300

1. Finally, you want to also take into account the fact that production takes a week and is not instantaneous as you had assumed. So you want to give a plan to manufacturing to start production. While supply chain is focused on completion of orders to service a customer, manufacturing needs to know when to start production.
2. Procurement are interested in the production plan to know how to service the requirement for a key raw material that is purchased. The Procurement manager tells you that his department does not want to do these calculations on a spreadsheet but would rather have them from you through the state-of-the-art ERP system. Manufacturing and Procurement provide you with the following data of the key raw material as per the BOM for the finished goods SKU AAA001

BOM for SKU AAA001
BOM Base quantity	100 units of SKU AAA001
BOM Element	Component	BOM quantity
BOM Element 1	Raw Material RM001	50
BOM Element 2	Raw Material RM002	100

For Raw Material RM001,

Current stock = 0, Min lot size = 20, Max lot size = 1000, Increments for ordering = 20 units,

Procurement leadtime (all inclusive including goods receipt, quality inspection, etc.) = 2 weeks

Based on this, can you draw up a Procurement plan that gives a view of both when the goods are required in-house as well as when the purchase orders need to be placed.

RM002 is not critical since it is just a label that is printed at need inhouse and therefore decide to not worry about it for now.

1. You want to now consider the current stocks available for both the FG and the key raw material RM001. Add current stock = 200 units for FG AAA001 and Current stock = 100 units for RM001.
2. Strategically, you are running out of space for manufacturing expansion at your current factory. Furthermore, your customers want to get goods from the state in which they are located to claim some local tax benefits. You are therefore working on an idea to move the warehouse closer to your customers. However, this means that the warehouse would not be co-located with your plant and there would be an additional leadtime of movement to the warehouse before the goods can be invoiced and sent to customers. Your factory is in East India and the warehouse location could move to Bhiwandi in West India, adding 7 days to the leadtime. The customers would then place orders on the Bhiwandi warehouse from where the goods need to be invoiced and shipped to the customers. Please remodel the entire supply chain to take this into account. You will have to show the MRP split for the two plants and show dependent requirements flowing from one to the other.
3. You have been asked to check if it would be cheaper to purchase the finished goods as opposed to producing it inhouse. You have a vendor in Pune (close to Bhiwandi) who can make the FG material for you and supply it. Procurement is working on the pricing from the vendor but you want to see how the picture of supply and inventory would change if you moved this to procurement. The key details that you have available with you are:

Procurement leadtime = 2 weeks

Min lot size Procurement wants you to work out two scenarios since a larger min lot size has savings on costs through a lower price. (1) Min lot size of 100 and increments of 100 (2) Min lot sizes of 250 and increments of 250