Answered You can hire a professional tutor to get the answer.
Write 13 pages thesis on the topic warehouse and inventory management. On the outset, here’s the report.Given were customer and supplier locations and annual weights shipped and grid map of Australia.
Write 13 pages thesis on the topic warehouse and inventory management. On the outset, here’s the report.
Given were customer and supplier locations and annual weights shipped and grid map of Australia. A general geographical area for distribution center was identified based on the Centre of Gravity principle, taking into consideration socio-economic and other factors. Following was also taken into consideration:
Taken and measured from the grid map were the X and Y distances (please see appendices and grid map), for the customer and supplier locations and the four potential distribution centers: Port Hedland, Minilya, Gladstone and Bundaberg. Measured were the grid map coordinates, then calculating the center of gravity using Microsoft Excel resulted in the different data for the various distribution sites.
In calculating the center of gravity, we had the following approach: locate a facility concerning the center of geographic area, based on weight & distance traveled, establish a grid-map area, identify coordinates & weights shipped for each location.
The distances from zero point were individually measured using the map’s scale in kilometers. Each was solved using Microsoft Excel, finding the sums and square roots concerning the four potential sites.
In locating the center of gravity, we have X, Y = coordinates of the new facility at the center of gravity. X1, Y1 = coordinates of existing facility i, W1 = annual weight shipped from facility i. We get the calculation from Excel: by multiplying each of the distance by the annual weight, add all of the sums of the multiplied weight and distance of all the customer suppliers, and all over the added weights in kilograms of all the suppliers, the result is the center of gravity. This can be expressed in simplified formula, such as x = (weight x distance) + (weight x distance) + (weight x distance) and so on, all over the added weights.
The Load-distance technique was computed for each of the different sites. . Having determined the distances for the customer and supplier locations in the grid map using straight lines in Microsoft Excel, this was calculated.
