• Manufacturing planning and control for supply chain management

LEARNING ASSIGNMENT 6 Mttnen's workshop is focused on the manufacture of wardrobes used on construction sites and workplaces. Wardrobes are always manufactured individually, but they are designed in such a way that it is easy to fasten several elements together and thus form rows of wardrobes for example in the changing rooms. The company now wants to find out what effect the application of different planning techniques would have on the production plan. Make production plans for the company according to different assignments. Use the ready-made tab for each task to make plans. Starting point On hand (inventory) is 250 in the beginning. Forecasted demand is shown in the below table. Please apply the below table in tasks 6a, 6b and 6c. 1 2 3 4 6 7 8 10 11 12 13 Forecast 100 120 250 100 300 275 325 375 415 60 80 70 160 14 180 15 290 Available MPS On hand 250 Task 6a Make the MPS applying the chase sales/lot-for-lot technique. Please note that the safety stock (target) is 50 units. Task 6b Make the MPS applying the level production technique. Please note that the safety stock must not be negative at any stage. Task 6c Make the MPS applying lot sizing/fixed order quantity technique. Please note that safety stock is 50 units (minimum). The lot size is 250 units (or multiple). Task 6d Calculate both projected available inventory and available to promise (ATP) applying the below presented table. 1 2 3 4 5 6 7 8 9 10 11 Forecast 100 120 250 100 300 275 325 375 415 60 80 Orders 65 45 85 125 60 80 100 95 65 85 40 228 12 13 14 15 70 160 180 290 | 90 150 35 70 Projected available inventory Available to promise MPS 600 600 600 600 600 On hand 250 Return your task either as a spreadsheet (i.e. Excel file) calculation or as a PDF-file where you have marked formulas for each column. EVALUATION 0-10 points