Практическая часть включает:
1) Обоснование выбора поставщика и объемов поставки
2) АВС-анализ запасов
3) XYZ-анализ запасов
4) Системы управления запасами: с фиксированным размером заказа
5) Системы управления запасами: с фиксированным интервалом
6) Системы управления запасами: с установленной периодичностью пополнения запаса до постоянного уровня
7) Системы управления запасами: "минимум-максимум"
2.1. Обоснование выбора поставщиков и объемов поставки. Предприятие сотрудничает с четырьмя поставщиками – F1, F2, F3, F4. Необходимо определить их оптимальный состав при закупке 1, 2, 3, 4, 5, 6, 7, 8, 9 и 10 единиц материальных ресурсов соответственно, если известны затраты на закупку ресурсов (табл. 1.1).
В1 | F1 | F2 | F3 | F4 |
| В2 | F1 | F2 | F3 | F4 |
| В3 | F1 | F2 | F3 | F4 | ||
1 | 12 | 5 | 16 | 19 |
| 1 | 5 | 16 | 19 | 18 |
| 1 | 37 | 12 | 15 | 16 | ||
2 | 29 | 19 | 30 | 41 |
| 2 | 19 | 30 | 41 | 28 |
| 2 | 50 | 29 | 35 | 30 | ||
3 | 45 | 32 | 42 | 55 |
| 3 | 32 | 42 | 55 | 45 |
| 3 | 62 | 45 | 48 | 42 | ||
4 | 56 | 43 | 49 | 62 |
| 4 | 43 | 49 | 62 | 63
|
| 4 | 66 | 56 | 56 | 49 | ||
5 | 63 | 48 | 54 | 66 |
| 5 | 48 | 54 | 66 | 82 |
| 5 | 71 | 63 | 63 | 54 | ||
6 | 70 | 57 | 57 | 71 |
| 6 | 57 | 57 | 71 | 93 |
| 6 | 74 | 70 | 70 | 57 | ||
7 | 74 | 67 | 59 | 74 |
| 7 | 67 | 59 | 74 | 95 |
| 7 | 76 | 74 | 74 | 59 | ||
8 | 78 | 80 | 62 | 77 |
| 8 | 80 | 62 | 77 | 97 |
| 8 | 79 | 78 | 76 | 63 | ||
9 | 82 | 95 | 66 | 84 |
| 9 | 95 | 66 | 84 | 101 |
| 9 | 82 | 82 | 77 | 66 | ||
10 | 84 | 108 | 72 | 89 |
| 10 | 108 | 72 | 89 | 105 |
| 10 | 86 | 84 | 78 | 79 | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
В4 | F1 | F2 | F3 | F4 |
| В5 | F1 | F2 | F3 | F4 |
| В6 | F1 | F2 | F3 | F4 | ||
1 | 18 | 15 | 16 | 19 |
| 1 | 16 | 18 | 37 | 5 |
| 1 | 37 | 15 | 16 | 19 | ||
2 | 28 | 35 | 30 | 41 |
| 2 | 30 | 28 | 50 | 19 |
| 2 | 50 | 35 | 30 | 41 | ||
3 | 45 | 48 | 42 | 55 |
| 3 | 42 | 45 | 62 | 32 |
| 3 | 62 | 48 | 42 | 55 | ||
4 | 63 | 56 | 49 | 62 |
| 4 | 49 | 63 | 66 | 43 |
| 4 | 66 | 56 | 49 | 62 | ||
5 | 82 | 63 | 54 | 66 |
| 5 | 54 | 82 | 71 | 48 |
| 5 | 71 | 63 | 54 | 66 | ||
6 | 93 | 70 | 57 | 71 |
| 6 | 57 | 93 | 74 | 57 |
| 6 | 74 | 70 | 57 | 71 | ||
7 | 95 | 74 | 59 | 74 |
| 7 | 59 | 95 | 76 | 67 |
| 7 | 76 | 74 | 59 | 74 | ||
8 | 97 | 76 | 63 | 77 |
| 8 | 62 | 97 | 79 | 80 |
| 8 | 79 | 76 | 63 | 77 | ||
9 | 101 | 77 | 66 | 84 |
| 9 | 66 | 101 | 82 | 95 |
| 9 | 82 | 77 | 66 | 84 | ||
10 | 105 | 78 | 79 | 89 |
| 10 | 72 | 105 | 86 | 108 |
| 10 | 86 | 78 | 79 | 89 | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
В7 | F1 | F2 | F3 | F4 |
| В8 | F1 | F2 | F3 | F4 |
| В9 | F1 | F2 | F3 | F4 | ||
1 | 15 | 5 | 6 | 25 |
| 1 | 20 | 21 | 15 | 4 |
| 1 | 15 | 19 | 6 | 4 | ||
2 | 17 | 15 | 10 | 40 |
| 2 | 25 | 25 | 35 | 6 |
| 2 | 35 | 41 | 12 | 9 | ||
3 | 23 | 25 | 20 | 54 |
| 3 | 30 | 30 | 48 | 8 |
| 3 | 48 | 55 | 16 | 16 | ||
4 | 25 | 30 | 35 | 73 |
| 4 | 32 | 42 | 56 | 24 |
| 4 | 56 | 62 | 20 | 25 | ||
5 | 30 | 34 | 45 | 78 |
| 5 | 34 | 45 | 63 | 35 |
| 5 | 63 | 66 | 25 | 36 | ||
6 | 40 | 42 | 60 | 82 |
| 6 | 40 | 54 | 70 | 48 |
| 6 | 70 | 71 | 30 | 49 | ||
7 | 44 | 50 | 80 | 86 |
| 7 | 48 | 60 | 74 | 63 |
| 7 | 74 | 74 | 36 | 64 | ||
8 | 56 | 65 | 95 | 89 |
| 8 | 55 | 68 | 76 | 72 |
| 8 | 76 | 77 | 42 | 72 | ||
9 | 62 | 74 | 110 | 95 |
| 9 | 70 | 72 | 77 | 81 |
| 9 | 77 | 84 | 56 | 81 | ||
10 | 80 | 86 | 120 | 100 |
| 10 | 72 | 85 | 78 | 90 |
| 10 | 78 | 89 | 72 | 89 | ||
В10 | F1 | F2 | F3 | F4 |
| В11 | F1 | F2 | F3 | F4 |
| В12 | F1 | F2 | F3 | F4 | ||
1 | 4 | 6 | 15 | 2 |
| 1 | 4 | 15 | 19 | 16 |
| 1 | 15 | 9 | 40 | 3 | ||
2 | 6 | 9 | 35 | 5 |
| 2 | 9 | 35 | 41 | 30 |
| 2 | 25 | 41 | 54 | 6 | ||
3 | 8 | 11 | 48 | 8 |
| 3 | 16 | 48 | 55 | 42 |
| 3 | 30 | 55 | 73 | 12 | ||
4 | 24 | 14 | 56 | 15 |
| 4 | 25 | 56 | 62 | 49 |
| 4 | 35 | 62 | 78 | 23 | ||
5 | 35 | 19 | 63 | 25 |
| 5 | 36 | 63 | 66 | 54 |
| 5 | 40 | 66 | 82 | 35 | ||
6 | 48 | 30 | 70 | 38 |
| 6 | 49 | 70 | 71 | 57 |
| 6 | 50 | 71 | 86 | 40 | ||
7 | 63 | 45 | 74 | 50 |
| 7 | 64 | 74 | 74 | 59 |
| 7 | 60 | 74 | 89 | 48 | ||
8 | 72 | 65 | 76 | 68 |
| 8 | 72 | 76 | 77 | 62 |
| 8 | 82 | 77 | 95 | 59 | ||
9 | 81 | 82 | 77 | 80 |
| 9 | 81 | 77 | 84 | 66 |
| 9 | 98 | 84 | 100 | 75 | ||
10 | 90 | 95 | 78 | 82 |
| 10 | 89 | 78 | 89 | 79 |
| 10 | 100 | 89 | 108 | 88 | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
В13 | F1 | F2 | F3 | F4 |
| В14 | F1 | F2 | F3 | F4 |
| В15 | F1 | F2 | F3 | F4 | ||
1 | 16 | 4 | 6 | 2 |
| 1 | 9 | 6 | 16 | 15 |
| 1 | 10 | 16 | 22 | 21 | ||
2 | 30 | 6 | 9 | 5 |
| 2 | 17 | 12 | 30 | 35 |
| 2 | 15 | 30 | 44 | 25 | ||
3 | 42 | 8 | 11 | 8 |
| 3 | 29 | 16 | 42 | 48 |
| 3 | 25 | 42 | 55 | 30 | ||
4 | 49 | 24 | 14 | 15 |
| 4 | 45 | 20 | 49 | 56 |
| 4 | 38 | 49 | 62 | 42 | ||
5 | 54 | 35 | 19 | 25 |
| 5 | 62 | 25 | 54 | 63 |
| 5 | 50 | 54 | 66 | 45 | ||
6 | 57 | 48 | 30 | 38 |
| 6 | 71 | 30 | 57 | 70 |
| 6 | 70 | 57 | 71 | 54 | ||
7 | 59 | 63 | 45 | 50 |
| 7 | 77 | 36 | 59 | 74 |
| 7 | 86 | 59 | 74 | 60 | ||
8 | 62 | 72 | 65 | 68 |
| 8 | 82 | 42 | 62 | 76 |
| 8 | 93 | 62 | 77 | 68 | ||
9 | 66 | 81 | 82 | 80 |
| 9 | 85 | 56 | 66 | 77 |
| 9 | 95 | 66 | 84 | 72 | ||
10 | 79 | 90 | 95 | 82 |
| 10 | 87 | 72 | 72 | 78 |
| 10 | 98 | 72 | 89 | 85 | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
В16 | F1 | F2 | F3 | F4 |
| В17 | F1 | F2 | F3 | F4 |
| В18 | F1 | F2 | F3 | F4 | ||
1 | 16 | 5 | 12 | 25 |
| 1 | 15 | 15 | 3 | 15 |
| 1 | 16 | 22 | 20 | 12 | ||
2 | 30 | 15 | 29 | 40 |
| 2 | 35 | 25 | 6 | 17 |
| 2 | 30 | 44 | 25 | 29 | ||
3 | 42 | 25 | 45 | 54 |
| 3 | 48 | 30 | 9 | 23 |
| 3 | 42 | 55 | 30 | 45 | ||
4 | 49 | 30 | 62 | 73 |
| 4 | 56 | 35 | 26 | 25 |
| 4 | 49 | 62 | 32 | 56 | ||
5 | 54 | 34 | 71 | 78 |
| 5 | 63 | 40 | 35 | 30 |
| 5 | 54 | 66 | 34 | 63 | ||
6 | 57 | 42 | 77 | 82 |
| 6 | 70 | 50 | 41 | 40 |
| 6 | 57 | 71 | 40 | 70 | ||
7 | 59 | 50 | 82 | 86 |
| 7 | 74 | 60 | 45 | 44 |
| 7 | 59 | 74 | 48 | 74 | ||
8 | 62 | 65 | 85 | 89 |
| 8 | 76 | 82 | 57 | 56 |
| 8 | 62 | 77 | 55 | 78 | ||
9 | 66 | 74 | 87 | 95 |
| 9 | 77 | 98 | 80 | 62 |
| 9 | 66 | 84 | 70 | 82 | ||
10 | 72 | 86 | 89 | 100 |
| 10 | 78 | 100 | 94 | 80 |
| 10 | 72 | 89 | 72 | 84 |
В19 | F1 | F2 | F3 | F4 |
| В20 | F1 | F2 | F3 | F4 |
| В21 | F1 | F2 | F3 | F4 | ||
1 | 6 | 12 | 16 | 3 |
| 1 | 22 | 3 | 16 | 12 |
| 1 | 5 | 12 | 5 | 15 | ||
2 | 10 | 29 | 30 | 6 |
| 2 | 44 | 6 | 30 | 29 |
| 2 | 19 | 29 | 19 | 35 | ||
3 | 20 | 45 | 42 | 9 |
| 3 | 55 | 9 | 42 | 45 |
| 3 | 32 | 45 | 32 | 48 | ||
4 | 35 | 62 | 49 | 26 |
| 4 | 62 | 26 | 49 | 62 |
| 4 | 43 | 62 | 43 | 56 | ||
5 | 45 | 71 | 54 | 35 |
| 5 | 66 | 35 | 54 | 71 |
| 5 | 48 | 71 | 48 | 63 | ||
6 | 60 | 77 | 57 | 41 |
| 6 | 71 | 41 | 57 | 77 |
| 6 | 57 | 77 | 57 | 70 | ||
7 | 80 | 82 | 59 | 45 |
| 7 | 74 | 45 | 59 | 82 |
| 7 | 67 | 82 | 67 | 74 | ||
8 | 95 | 85 | 62 | 57 |
| 8 | 77 | 57 | 62 | 85 |
| 8 | 80 | 85 | 80 | 76 | ||
9 | 110 | 87 | 66 | 80 |
| 9 | 84 | 80 | 66 | 87 |
| 9 | 95 | 87 | 95 | 77 | ||
10 | 120 | 89 | 72 | 94 |
| 10 | 89 | 94 | 72 | 89 |
| 10 | 108 | 89 | 108 | 78 | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
В22 | F1 | F2 | F3 | F4 |
| В23 | F1 | F2 | F3 | F4 |
| В24 | F1 | F2 | F3 | F4 | ||
1 | 15 | 16 | 12 | 6 |
| 1 | 16 | 40 | 4 | 3 |
| 1 | 9 | 17 | 29 | 45 | ||
2 | 35 | 30 | 29 | 12 |
| 2 | 30 | 54 | 6 | 6 |
| 2 | 6 | 12 | 16 | 20 | ||
3 | 48 | 42 | 45 | 16 |
| 3 | 42 | 73 | 8 | 9 |
| 3 | 16 | 30 | 42 | 49 | ||
4 | 56 | 49 | 62 | 20 |
| 4 | 49 | 78 | 24 | 26 |
| 4 | 15 | 35 | 48 | 56 | ||
5 | 63 | 54 | 71 | 25 |
| 5 | 54 | 80 | 35 | 35 |
| 5 | 62 | 71 | 77 | 82 | ||
6 | 70 | 57 | 77 | 30 |
| 6 | 57 | 86 | 48 | 41 |
| 6
| 25 | 30 | 36 | 42 | ||
7 | 74 | 59 | 82 | 36 |
| 7 | 59 | 89 | 63 | 45 |
| 7 | 54 | 57 | 59 | 62 | ||
8 | 76 | 63 | 85 | 42 |
| 8 | 62 | 95 | 72 | 57 |
| 8 | 63 | 70 | 74 | 76 | ||
9 | 77 | 66 | 87 | 56 |
| 9 | 66 | 100 | 81 | 80 |
| 9 | 85 | 56 | 66 | 77 | ||
10 | 78 | 79 | 89 | 72 |
| 10 | 79 | 108 | 90 | 94 |
| 10 | 87 | 72 | 72 | 78 | ||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
В25 | F1 | F2 | F3 | F4 |
| В26 | F1 | F2 | F3 | F4 |
| В27 | F1 | F2 | F3 | F4 | ||
1 | 1 | 2 | 1 | 15 |
| 1 | 15 | 3 | 12 | 22 |
| 1 | 15 | 22 | 15 | 2 | ||
2 | 19 | 25 | 45 | 40 |
| 2 | 25 | 6 | 29 | 44 |
| 2 | 35 | 44 | 35 | 5 | ||
3 | 20 | 30 | 49 | 59 |
| 3 | 30 | 9 | 45 | 55 |
| 3 | 48 | 55 | 48 | 8 | ||
4 | 25 | 38 | 50 | 70 |
| 4 | 35 | 26 | 56 | 62 |
| 4 | 56 | 62 | 56 | 15 | ||
5 | 42 | 49 | 54 | 57 |
| 5 | 40 | 35 | 63 | 66 |
| 5 | 63 | 66 | 63 | 25 | ||
6 | 55 | 62 | 66 | 71 |
| 6 | 50 | 41 | 70 | 71 |
| 6 | 70 | 71 | 70 | 38 | ||
7 | 30 | 42 | 45 | 54 |
| 7 | 60 | 45 | 74 | 74 |
| 7 | 74 | 74 | 74 | 50 | ||
8 | 86 | 59 | 74 | 60 |
| 8 | 82 | 57 | 78 | 77 |
| 8 | 76 | 77 | 76 | 68 | ||
9 | 93 | 62 | 77 | 68 |
| 9 | 98 | 80 | 82 | 84 |
| 9 | 77 | 84 | 77 | 80 | ||
10 | 95 | 66 | 84 | 72 |
| 10 | 100 | 94 | 84 | 89 |
| 10 | 78 | 89 | 78 | 82 |
В28 | F1 | F2 | F3 | F4 |
| В29 | F1 | F2 | F3 | F4 |
| В30 | F1 | F2 | F3 | F4 |
1 | 5 | 12 | 1 | 21 |
| 1 | 18 | 6 | 25 | 15 |
| 1 | 16 | 19 | 5 | 15 |
2 | 15 | 29 | 2 | 25 |
| 2 | 28 | 10 | 40 | 35 |
| 2 | 30 | 41 | 15 | 35 |
3 | 25 | 45 | 4 | 30 |
| 3 | 45 | 20 | 54 | 48 |
| 3 | 42 | 55 | 25 | 48 |
4 | 30 | 62 | 6 | 42 |
| 4 | 63 | 35 | 73 | 56 |
| 4 | 49 | 62 | 30 | 56 |
5 | 34 | 71 | 9 | 45 |
| 5 | 82 | 45 | 78 | 63 |
| 5 | 54 | 66 | 34 | 63 |
6 | 42 | 77 | 12 | 54 |
| 6 | 93 | 60 | 82 | 70 |
| 6 | 57 | 71 | 42 | 70 |
7 | 50 | 82 | 16 | 60 |
| 7 | 95 | 80 | 86 | 74 |
| 7 | 59 | 74 | 50 | 74 |
8 | 65 | 85 | 24 | 68 |
| 8 | 97 | 95 | 89 | 76 |
| 8 | 63 | 77 | 65 | 76 |
9 | 74 | 87 | 48 | 72 |
| 9 | 101 | 110 | 95 | 77 |
| 9 | 66 | 84 | 74 | 77 |
10 | 86 | 89 | 125 | 85 |
| 10 | 105 | 120 | 100 | 78 |
| 10 | 79 | 89 | 86 | 78 |
2.2. АВС-анализ. Выполнить классификацию деталей на группы АВС на основе данных табл. 2.1 и 2.2.
Таблица 2.1 – Объемы потребления и цены запасных частей
№ п/п | Наименования запасных частей | Цена запасной части, д.ед. | Потребление запасной части, шт. | |||||||
Ц1 | Ц2 | Ц3 | Р1 | Р2 | Р3 | |||||
1 | 2 | 3
<
Понравилась статья? Добавь ее в закладку (CTRL+D) и не забудь поделиться с друзьями:
Сейчас читают про:
|