Andrew-Carter, Inc. (A-C) is a major Canadian producer and distributor of outdoo
ID: 448252 • Letter: A
Question
Andrew-Carter, Inc. (A-C) is a major Canadian producer and distributor of outdoor lighting fixtures. Its fixture is distributed throughout North America and has been in high demand for several years. The company operates three plants that manufacture the fixture and distribute it to five distribution centers. During the past few years, A-C has seen a major drop in demand for its fixture as the housing market has declined. Based on the forecast of interest rates, the head of operations feels that demand for housing and thus for its product will remain depressed for the foreseeable future. A-C is considering closing one of its plants, as it is now operating with a forecasted excess capacity of 34,000 units per week. The forecasted weekly demands for the coming year are 9,000 units, 13,000 units, 11,000 units, 15,000 units, and 8,000 units for warehouses 1 to 5, respectively. The regular time plant capacities (in units per week) are 27,000 units, 20,000 units, and 25,000 units for plants 1 to 3, respectively. The overtime plant capacities (in units per week) are 7,000 units, 5,000 units, and 6,000 units for plants 1 to 3, respectively. If A-C shuts down any plants, its weekly costs will change, as fixed costs are lower for a non-operating plant. Table 1 shows production costs at each plant, both variable at regular time and overtime, and fixed when operating and shut down. Table 2 shows distribution costs from each plant to each distribution center. Table 1 Fixed Cost Plant Variable Cost Operating Not Operating Plant 1, regular time 3.50 $14,000 $6,000 Plant 1, overtime 4.40 Plant 2, regular time 3.48 $12,000 $5,000 Plant 2, overtime 4.35 Plant 3, regular time 3.40 $15,000 $7,500 Plant 3, overtime 4.28 Table 2 Distribution Center From/To Wing 1 Wing 2 Wing 3 Wing 4 Wing 5 Plant 1 $0.50 $0.44 $0.49 $0.46 $0.56 Plant 2 $0.40 $0.52 $0.50 $0.56 $0.57 Plant 3 $0.56 $0.53 $0.51 $0.54 $0.35 Questions 1.) Evaluate the various configurations of operating and closed plants that will meet weekly demand. Determine which configuration minimizes total costs. 2.) Discuss the implications of closing a plant.(calculation should be in excel as well as answer the following question)
Explanation / Answer
Warehouse Weekly demand 1 9,000 2 13,000 3 11,000 4 15,000 5 8,000 56,000 Total Variable Cost Fixed Cost Total Cost With Overtime Total Cost without overtime Plant Time Production Total Production Variable Cost / unit ($) Operating ($) Non Operating ($) 1 Regular 27,000 34,000 2.8 75,600 14,000 6,000 120,240 95,600 Overtime 7,000 3.52 24,640 2 Regular 20,000 25,000 2.78 55,600 12,000 5,000 90,000 72,600 Overtime 5,000 3.48 17,400 3 Regular 25,000 31,000 2.72 68,000 15,000 75,000 178,520 158,000 Overtime 6,000 3.42 20,520 Assume to close plant 3 as it has maximum total cost Plant W1 W2 W3 W4 W5 Total 1 0.5 0.44 0.49 0.46 0.56 Units from plant 1 13,000 6,000 15,000 34000 Cost 0 5720 2940 6900 0 15560 2 0.4 0.52 0.5 0.56 0.57 Units from plant 2 9,000 5,000 8,000 22000 Cost 3600 0 2500 0 4560 10660 Total Cost 9,000 5,720 7,940 6,900 8,000 37,560 Total units 9,000 13,000 11,000 15,000 8,000 56,000 Total Cost per week 247,800