0% found this document useful (0 votes)
84 views5 pagesLa Task
The document contains 4 exercises related to demand forecasting and inventory management:
1. Prepare a demand requirements planning (DRP) table for 4 peripheral warehouses and 1 central warehouse based on given forecasted demand and stock data.
2. Determine the optimal purchase lot size and time between orders for a product based on given cost, price, demand, and inventory holding cost data.
3. Determine the safety stock level and reorder point for a product based on given average daily demand, demand variation, and delivery time data with a 90% service level.
4. Prepare a stock card showing beginning inventory levels and adjustments from purchases and sales over time for a product based on given transaction data.
Uploaded by
ScribdTranslationsCopyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
84 views5 pagesLa Task
The document contains 4 exercises related to demand forecasting and inventory management:
1. Prepare a demand requirements planning (DRP) table for 4 peripheral warehouses and 1 central warehouse based on given forecasted demand and stock data.
2. Determine the optimal purchase lot size and time between orders for a product based on given cost, price, demand, and inventory holding cost data.
3. Determine the safety stock level and reorder point for a product based on given average daily demand, demand variation, and delivery time data with a 90% service level.
4. Prepare a stock card showing beginning inventory levels and adjustments from purchases and sales over time for a product based on given transaction data.
Uploaded by
ScribdTranslationsCopyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
/ 5
Task for LAL04
Exercise 1.
A central warehouse must supply product Z to 4 peripheral warehouses.
Deliveries are daily, Monday through Saturday, in lots of 100 units. The
forecasted requirements, initial stock and safety stock are as follows:
List of demand forecasts for a product in four warehouses.
Weather Stoc Planned requirements (units)
Wareho from Stock
k
Security
use Supply starts Lune Mars Wed Wed Wed Wed Wed Sat
o (days) l d Wed Fri
s s s s s o
1 1 100 10 80 50 50 50 50 80
2 1 150 10 100 30 50 50 100 150
3 2 100 10 100 100 100 150 150 100
4 2 150 10 50 50 50 150 100 100
The central warehouse has an initial stock of 500 units, with a safety stock
of 50. Factory delivers goods within 24 hours.
Requested:
Prepare a DRP table for the four peripheral warehouses and the central
warehouse.
Storage 1
Warehouse 2
and 3
Storage 4
Exercise 2.
In a company we find the following data relating to purchases:
• Order preparation cost: 250 €.
• Purchase price: 8,5 €.
• Annual product sales: 45,000 units.
• Unit storage costs: €1.25.
• Interest rate: 3.5%.
• Supply 365 days a year.
Requested:
Determine the optimal purchase lot and time between orders.
Year: 365 days
Cost of preparation: 250 euros
Unit price: 8.5 euros
Sales per year: 45,000 units
G= (P*I) + A
Therefore, we have that:
• Optimum purchase lot (Q0) = 3822.35
• Number of orders = 11774
• Time between orders = 31.06
Exercise 3.
In a company we have the following data on the consumption and supply of a
product:
• Average daily consumption: 150 units.
• Standard deviation: 20 units.
• Delivery time: 5 days.
Requested:
For a service level of 90% determine the safety stock and reorder point.
Taking into account:
Annual period:365 days
Service level: 90%.
SS= z * sd * pe
PP= (d * pe) + SS
Z value = 1.28
Safety stock = 57.31 if rounded to 58
Ordering point= 808
Exercise 4.
Prepare the stock card of the RJ45 cable article of reference S2221 based on the
following data:
List of purchase and sale transactions of merchandise, with dates, quantities and
prices.