![download analytics problem solver for excel download analytics problem solver for excel](https://i.ytimg.com/vi/RicajFzoenk/maxresdefault.jpg)
![download analytics problem solver for excel download analytics problem solver for excel](https://www.solver.com/sites/default/files/ASP-DualScreen-Broker-1620x790_0_0.png)
- Download analytics problem solver for excel software#
- Download analytics problem solver for excel trial#
In our example, we suppose that one large truck has a maximum carry volume of 110 units. To know how many trucks we need to deliver the quantity incurred from one DC to a Store, we have to divide this quantity by the maximum carry volume of our trucks and round that number up ( The ROUNDUP Function in Excel ). In our case, we only have the cost per Km traveled, and so we will use the first option.
Download analytics problem solver for excel software#
The cost per Km is $ 0.60 which is a default value in the software for large trucks. These are round trip distances provided by the SCM Globe software. The second step is to enter the distances between all sources and destinations. We can easily see we have enough capacity to cover market demand. That gives us a total capacity of 2100 units. Then enter the unit storage capacity for each distribution center. Start by entering each store’s demand that gives us a total demand of 1190 units in this case. The first step in our process is to enter the data we need from the supply chain model in an organized manner. Now that we have defined the problem and the network model, it’s time to move to Excel to enter the data and make our analysis. Shown below is an abstract network design diagram for the supply chain model in the screenshot above: Moving to Excel
Download analytics problem solver for excel trial#
We are glad to provide a free evaluation account to instructors, students and supply chain professionals interested in exploring SCM Globe simulations - click here to request an account - Get Your Free Trial Demo
![download analytics problem solver for excel download analytics problem solver for excel](https://www.solver.com/sites/default/files/panelmanufacturingsolver1.jpg)
The screenshot below shows this network of facilities. Facilities are put on the map using the SCM Globe supply chain modeling and simulation app. It’s a simple network with two stages: three Distribution Centers and the other eight facilities are Stores.
![download analytics problem solver for excel download analytics problem solver for excel](https://i.ytimg.com/vi/6xa1x_Iqjzg/maxresdefault.jpg)
By doing it right, you will be managing production and inventory effectively, speeding processes, and improving customer service. Allocating supply sources to facilities properly has a considerable impact on your supply chain’s financial and operating performance. The goal is to satisfy demand, which means being responsive, while also being efficient, which means having the lowest transportation cost. In this article, we will be exploring one of the fundamental cases of market and supply allocation it’s called the Transportation problem. Therefore, supply chain and logistics managers must take advantage of transportation’s potential in terms of opportunities for cost reduction. Transportation costs are a significant component of the overall supply chain costs.