Scientific methods can be used to plan, schedule, manage risk and improve productivity. It has been proved that by using scientific methods, businesses have reduced cost and investment, have improved revenue, resulting in better ROI.
Almost all business problems have many possible solutions; but the challenge is to pick the BEST solution that consumes the LEAST resource. To solve such problems just by mere gut feeling alone could result in wasted resources and cost.
The following example shows how one could save cost in a simple warehouse lease planning situation by applying scientific methods.
Ace Hardware sells household hardware products through an organized marketing campaign on FaceBook. It needs substantial warehouse space for storing its merchandize. The management is coming up with a plan to lease space for storage for the next six months. The space requirement for each month is as follows:
Discount is available for longer lease duration, as shown below. So, it is reasonable to lease the maximum needed warehouse space for the entire period of 6 months.
A lease is signed for a minimum period of one month. The cost to lease the warehouse is as follows:
|Leasing Period||Cost per square feet Leased (Rs)|
The objective is to minimize the total cost incurred for leasing the space for six months and at the same time meeting the space requirements.
Many decision makers follow the brute force method, where they lease the minimal space requirement (10,000 sq.ft – month #3 requirement) for 6 months duration and then lease the additional requirements on a monthly basis.
Brute force method may not be the best decision, as it may result in increased and unnecessary expenses.
This problem can be solved using scientific methods (aka Operation Research Models) to identify the best leasing plan for the given requirements.
The following presentation has the details of how to solve the problem using EXCEL.
Download the EXCEL file along with the solution here.
The same methodology can be extended to solve multi-location warehouse leasing problems.