ITM333
IT Applications for Retail Supply Chain Management
Assignment - I
Assignment Code: 2015ITM333A1 Last Date of Submission: 15th April 2015
Maximum Marks:100
Attempt all the questions. All the questions are compulsory and carry equal marks.
Section-A
Ques. 1 Describe the supply chain involved in making the bottle of Coke that you have just
picked up from your neighbourhood retail store.
Ques. 2 How do transport companies benefit from technology like Global Positioning System
(GPS)? With the help of GPS, can transport companies track their trucks on real time
basis.
Ques. 3 Given the information below, what are the EOQ and reorder point?
Annual Demand = 1,000 units
Days per year considered in average daily demand = 365
Cost to place an order = Rs. 10
Holding cost per unit per year = Rs. 2.50
Lead time = 7 days
Cost per unit = Rs. 15
Ques. 4 Suppose a retail company’s new annual report claims their costs of goods sold for the
year is Rs. 160 million and their total average inventory (production materials + work-
in-process) is worth Rs. 35 million. This company normally has an inventory turnover
ratio of 10. What is this year’s Inventory Turnover ratio? What does it mean?
Section-B
Consider the monthly demand for a company XYZ Ltd.
Sales 2006 2007 2008
January 2000 5000 5000
February 5000 4000 2000
March 5000 4000 3000
April 3000 2000 2000
May 4000 5000 7000
June 6000 7000 6000
July 7000 10000 8000
August 10000 14000 10000
September 15000 16000 20000
October 15000 16000 20000
November 18000 20000 22000
December 8000 12000 8000
5. Use 6-month, 12 month moving average, exponential smoothing with coefficient with alpha of 0.1, 0.2 to derive the forecast for 2009 Jan to December. For each of the method calculate the MAD and Bias and discuss which among these models would be appropriate for forecasting the demand.
ITM333
IT Applications for Retail Supply Chain Management
Assignment - II
Assignment Code: 2015ITM333A2 Last Date of Submission: 15th May 2015
Maximum Marks:100
Attempt all the questions. All the questions are compulsory and carry equal marks.
Section-A
Ques. 1 Write short notes on the following.
a) Bar Coding System
b) ERP systems in use in Retail sector
c) RFID and its use in Retail business.
d) Application of GIS in retail
Ques. 2 How do transport companies benefit from technology like Global Positioning System
(GPS)? With the help of GPS, can transport companies track their trucks on real time
basis.
Ques. 3 Write short notes on:
a)Continuous Replenishment Program (CRP)
b)Collaborative Planning, Forecasting and Replenishment (CPFR)
c)Electronic Data Interchange (EDI)
d)Vendor Managed Inventory (VMI)
Ques. 4 What are the major obstacles to achieving strategic fit?
Section-B
Design the vehicle route for a retail chain which has 10 stores. Capacity of the vehicle is 25 units and other relevant data are as follows:
Distance and load related data for a retail chain
Dealer 1 2 3 4 5 6 7 8 9 10
Distance from Store 16 18 10 17 26 18 7 12 15 21
Average Demand (Kgs.) 8 4 6 6 4 8 8 6 8 4
Distance Matrix in Kilometres.
1 2 3 4 5 6 7 8 9 10
1
2 34
3 7 27
4 33 12 27
5 41 8 35 19
6 31 13 24 23 14
7 19 20 14 15 28 24
8 24 20 19 12 28 27 6
9 12 32 12 26 40 33 12 15
10 32 23 28 12 31 33 15 9 22
IT Applications for Retail Supply Chain Management
Assignment - I
Assignment Code: 2015ITM333A1 Last Date of Submission: 15th April 2015
Maximum Marks:100
Attempt all the questions. All the questions are compulsory and carry equal marks.
Section-A
Ques. 1 Describe the supply chain involved in making the bottle of Coke that you have just
picked up from your neighbourhood retail store.
Ques. 2 How do transport companies benefit from technology like Global Positioning System
(GPS)? With the help of GPS, can transport companies track their trucks on real time
basis.
Ques. 3 Given the information below, what are the EOQ and reorder point?
Annual Demand = 1,000 units
Days per year considered in average daily demand = 365
Cost to place an order = Rs. 10
Holding cost per unit per year = Rs. 2.50
Lead time = 7 days
Cost per unit = Rs. 15
Ques. 4 Suppose a retail company’s new annual report claims their costs of goods sold for the
year is Rs. 160 million and their total average inventory (production materials + work-
in-process) is worth Rs. 35 million. This company normally has an inventory turnover
ratio of 10. What is this year’s Inventory Turnover ratio? What does it mean?
Section-B
Consider the monthly demand for a company XYZ Ltd.
Sales 2006 2007 2008
January 2000 5000 5000
February 5000 4000 2000
March 5000 4000 3000
April 3000 2000 2000
May 4000 5000 7000
June 6000 7000 6000
July 7000 10000 8000
August 10000 14000 10000
September 15000 16000 20000
October 15000 16000 20000
November 18000 20000 22000
December 8000 12000 8000
5. Use 6-month, 12 month moving average, exponential smoothing with coefficient with alpha of 0.1, 0.2 to derive the forecast for 2009 Jan to December. For each of the method calculate the MAD and Bias and discuss which among these models would be appropriate for forecasting the demand.
ITM333
IT Applications for Retail Supply Chain Management
Assignment - II
Assignment Code: 2015ITM333A2 Last Date of Submission: 15th May 2015
Maximum Marks:100
Attempt all the questions. All the questions are compulsory and carry equal marks.
Section-A
Ques. 1 Write short notes on the following.
a) Bar Coding System
b) ERP systems in use in Retail sector
c) RFID and its use in Retail business.
d) Application of GIS in retail
Ques. 2 How do transport companies benefit from technology like Global Positioning System
(GPS)? With the help of GPS, can transport companies track their trucks on real time
basis.
Ques. 3 Write short notes on:
a)Continuous Replenishment Program (CRP)
b)Collaborative Planning, Forecasting and Replenishment (CPFR)
c)Electronic Data Interchange (EDI)
d)Vendor Managed Inventory (VMI)
Ques. 4 What are the major obstacles to achieving strategic fit?
Section-B
Design the vehicle route for a retail chain which has 10 stores. Capacity of the vehicle is 25 units and other relevant data are as follows:
Distance and load related data for a retail chain
Dealer 1 2 3 4 5 6 7 8 9 10
Distance from Store 16 18 10 17 26 18 7 12 15 21
Average Demand (Kgs.) 8 4 6 6 4 8 8 6 8 4
Distance Matrix in Kilometres.
1 2 3 4 5 6 7 8 9 10
1
2 34
3 7 27
4 33 12 27
5 41 8 35 19
6 31 13 24 23 14
7 19 20 14 15 28 24
8 24 20 19 12 28 27 6
9 12 32 12 26 40 33 12 15
10 32 23 28 12 31 33 15 9 22