Use the transportation method for location problems and POM Software/Excel spread sheet to find the optimal distribution pattern and the cost of goods sold for your two locations alternatives. First solve the problem with one location as the new plant and then do the same for the second. The unit costs for each cell of the transportation matrix should be the sum of the shipping costs and the variable costs of production.

Data

The following data have been gathered for Tanner:

1. The per-unit shipping cost based on the average ton-mile rates for the most efficient carriers is $100 per mile. The average revenue per product is $3,800,000.00.

2. The company currently has the following capacity constraints:

  

¹Figures are given in thousands.

²Net book value of plant and equipment with remaining depreciable life of 10 years.

³Annual fixed costs do not include depreciation on plant and equipment.

Location Data Given

 

Other assumptions (if needed)

▪ The terminal value (in 10 years) of the new investment is 50 percent of plant, equipment, and land cost.

▪The tax rate is 19 percent.

▪Straight-line depreciation is used for all assets over a 10-year life.

▪Capacity of the new plant production for the first year will be 31 (000) units.

▪Capacity of the new plant production thereafter will be 56 (000) units.

▪Cost of goods sold (COGS) equals variable costs of production plus total transportation costs.

▪Costs to ship from a plant to its own plant are zero; however, variable production costs are applicable.

 

Table 1: Company current capacity Location Bortherton Brizzie Sacoma Capacity 25000 25000 31000