Eastern MAS Expansion Part 2: The Project In your PowerPoint presentation, please focus on the following: a. SWOT analysis b. Supplier evaluation c. Gant diagrams d. Activities chart plus crashing act
MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Simulation Decisions:Market Forecasting: CollaborativeCurrent Markets Deleted:New Markets Opened:NY, NJ, PAMD, VA, WV, DEKentucky,TenneseeAlabama, MississippiFloridaActive DCs:Detroit MITL4San Francisco CATL4Philadelphia PATL4Los Angeles CATL4Baltimore MDTL4Dallas TXTL4Chicago ILTL4Denver COTL4Miami FLTL4Kansas City MOTL4Minneapolis MNTL4DC Replenishment Planning:DC Replenishment Planning:Planning Method:DRPTarget DC Fill Rate:100%Time Fence:1 Month(s)Denver Plant:Denver Plant:Operating Capacity:2.1 (in millions)Use Plant Warehouse:TrueWeeks Safety Stock:2Cans/BottlesChemicalsCorrugatedHouston:0.70.70.7Baton Rouge:00.10.1Los Angeles:0.30.20.2Regular Resupply:TL4CL9TL4Weeks Safety Stock:1.52.61.83/11/2023 Page 1/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5New Plant: New KensingtonNew Plant: New KensingtonOperating Capacity:1.5 (in millions)Use Plant Warehouse:TrueWeeks Safety Stock:2Cans/BottlesChemicalsCorrugatedPittsburgh:0.70.70.7Baton Rouge:00.10.1Baltimore:0.30.20.2Regular Resupply:TL4CL9TL4Weeks Safety Stock:1.52.61.83/11/2023 Page 2/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Plant Location: DenverRaw Material Statistics for: Cans/BottlesMode of Transport: TL4HoustonBaton RougeLos AngelesOrigin Price$1.16$1.19$1.17Freight to Plant0.01440.01940.021Planned Purchase Shares70.00%0.00%30.00%Actual Purchase Shares69.88%0.00%30.12%Volume3,354,24901,445,811Avg Transit Time4.010.004.04Min Transit Time2.000.002.00Max Transit Time8.000.008.00Weeks of Requirements for Safety Stock 1.5Average Inventory at Plant174,982Maximum Inventory at Plant480,115Minimum Inventory at Plant0Fill Rate at the Plant99.97%Raw Material Statistics for: ChemicalsMode of Transport: CL9HoustonBaton RougeLos AngelesOrigin Price$4.05$4.05$4.10Freight to Plant0.0150.01820.0193Planned Purchase Shares70.00%10.00%20.00%Actual Purchase Shares88.86%0.00%11.14%Volume1,526,2990191,371Avg Transit Time5.950.006.32Min Transit Time2.000.002.00Max Transit Time12.000.0012.00Weeks of Requirements for Safety Stock 2.6Average Inventory at Plant59,961Maximum Inventory at Plant217,860Minimum Inventory at Plant0Fill Rate at the Plant89.44%3/11/2023 Page 3/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Plant Location: DenverRaw Material Statistics for: CorrugatedMode of Transport: TL4HoustonBaton RougeLos AngelesOrigin Price$0.72$0.73$0.75Freight to Plant0.01440.01940.021Planned Purchase Shares70.00%10.00%20.00%Actual Purchase Shares71.62%3.62%24.75%Volume1,372,05469,431474,183Avg Transit Time4.004.084.08Min Transit Time2.002.002.00Max Transit Time7.006.009.00Weeks of Requirements for Safety Stock 1.8Average Inventory at Plant75,997Maximum Inventory at Plant182,774Minimum Inventory at Plant0Fill Rate at the Plant99.75%3/11/2023 Page 4/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Plant Location: DenverProduction Planning and ExecutionPeriodScheduledProduced11,508,8001,272,07121,182,400906,33331,252,800922,88341,529,6001,372,14751,493,6001,303,03361,760,0001,717,26071,690,4001,620,29282,057,6002,012,13592,060,0001,991,891102,097,2001,893,332111,904,8001,519,689121,717,2001,425,203131,577,2001,249,054________________________21,831,60019,205,323Lost Production Due to RM Shortages 2,626,277 Plant Finished Goods Warehouse StatisticsWeeks of Requirements for Safety Stock: 2Average 205,108Maximum Inventory1,511,293Minimum Inventory2Volume shipped to DCs19,200,800Fill Rate of FG67.8685%3/11/2023 Page 5/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Plant Location: New KensingtonRaw Material Statistics for: Cans/BottlesMode of Transport: TL4PittsburghBaton RougeBaltimoreOrigin Price$1.20$1.19$1.19Freight to Plant0.00730.02840.0103Planned Purchase Shares70.00%0.00%30.00%Actual Purchase Shares69.99%0.00%30.01%Volume3,001,44901,286,784Avg Transit Time3.000.003.00Min Transit Time2.000.002.00Max Transit Time4.000.004.00Weeks of Requirements for Safety Stock 1.5Average Inventory at Plant158,130Maximum Inventory at Plant344,200Minimum Inventory at Plant34,355Fill Rate at the Plant100.00%Raw Material Statistics for: ChemicalsMode of Transport: CL9PittsburghBaton RougeBaltimoreOrigin Price$4.05$4.05$4.10Freight to Plant0.0060.02340.0085Planned Purchase Shares70.00%10.00%20.00%Actual Purchase Shares91.86%0.00%8.14%Volume1,418,5760125,716Avg Transit Time4.980.004.87Min Transit Time2.000.002.00Max Transit Time8.000.008.00Weeks of Requirements for Safety Stock 2.6Average Inventory at Plant62,258Maximum Inventory at Plant218,910Minimum Inventory at Plant0Fill Rate at the Plant90.03%3/11/2023 Page 6/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Plant Location: New KensingtonRaw Material Statistics for: CorrugatedMode of Transport: TL4PittsburghBaton RougeBaltimoreOrigin Price$0.74$0.73$0.75Freight to Plant0.00730.02840.0103Planned Purchase Shares70.00%10.00%20.00%Actual Purchase Shares71.23%0.00%28.77%Volume1,221,7020493,546Avg Transit Time3.010.003.01Min Transit Time2.000.002.00Max Transit Time4.000.004.00Weeks of Requirements for Safety Stock 1.8Average Inventory at Plant77,047Maximum Inventory at Plant145,251Minimum Inventory at Plant0Fill Rate at the Plant100.00%3/11/2023 Page 7/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Plant Location: New KensingtonProduction Planning and ExecutionPeriodScheduledProduced11,465,6001,304,59221,491,2001,357,21731,417,6001,167,23241,492,4001,427,65251,480,0001,327,77961,492,8001,390,63971,496,0001,333,50581,500,0001,296,33991,500,0001,428,062101,500,0001,365,175111,500,0001,308,244121,492,0001,114,406131,488,4001,332,088__________________19,316,00017,152,930Lost Production Due to RM Shortages 2,163,070 Plant Finished Goods Warehouse StatisticsWeeks of Requirements for Safety Stock: 2Average Inventory348,870Maximum Inventory2,612,026Minimum Inventory5Volume shipped to DCs17,152,800Fill Rate of FG20.0743%3/11/2023 Page 8/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Detroit MISupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$35,160.00Throughput:5,895,160Variable Costs:$97,623.85Avg 283,189Inv Holding Costs:$82,882.85Max 843,104Freight into DC:$95,501.59Min 0Fill Rate:94.74%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.00Max Transit Time:3.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Pittsburgh PA1,104,4991,046,452$0.90633.53 daysCleveland OH1,298,5961,230,349$0.92552.64 daysBuffalo NY1,198,2121,135,241$0.90433.62 daysHuntington WVA355,922337,217$0.89544.04 daysDetroit MI1,550,5071,469,021$0.93582.16 daysBristol TN27,51326,067$0.87584.97 daysColumbus OH686,914650,814$0.91423.16 days3/11/2023 Page 9/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: San Francisco CASupplying Plant: DenverCost InformationInventory InformationFixed Costs:$34,440.00Throughput:3,502,187Variable Costs:$68,292.64Avg 268,081Inv Holding Costs:$78,390.24Max 513,737Freight into DC:$104,225.08Min 0Fill Rate:99.82%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.76Max Transit Time:6.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.San Francisco CA1,557,1211,554,344$0.89783.83 daysSeattle WA1,014,9681,013,157$0.84836.18 daysPortland OR681,704680,488$0.85515.85 daysSpokane WA254,652254,197$0.84616.29 days3/11/2023 Page 10/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Philadelphia PASupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$29,880.00Throughput:4,014,236Variable Costs:$73,942.24Avg 234,055Inv Holding Costs:$68,713.35Max 688,333Freight into DC:$77,073.34Min 0Fill Rate:96.60%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.02Max Transit Time:3.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.New York City2,671,9112,581,081$0.90753.25 daysAlbany NY169,062163,315$0.88954.09 daysScranto PA221,659214,124$0.90073.56 daysPhiladelphia PA899,768869,181$0.91452.92 daysSyracuse NY193,099186,535$0.88634.24 days3/11/2023 Page 11/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Los Angeles CASupplying Plant: DenverCost InformationInventory InformationFixed Costs:$31,180.00Throughput:3,327,938Variable Costs:$62,498.68Avg 253,671Inv Holding Costs:$73,847.82Max 458,115Freight into DC:$84,662.74Min 0Fill Rate:99.84%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.38Max Transit Time:5.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Los Angeles CA3,333,1873,327,938$0.90283.83 days3/11/2023 Page 12/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Baltimore MDSupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$32,540.00Throughput:1,962,293Variable Costs:$33,005.77Avg 137,060Inv Holding Costs:$40,262.30Max 465,350Freight into DC:$38,853.40Min 0Fill Rate:96.17%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.00Max Transit Time:3.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Harrisburg PA180,569173,654$0.91093.13 daysRichmond VA241,875232,613$0.90103.60 daysNorfolk VA161,810155,614$0.89503.88 daysRoanoke VA141,595136,172$0.88584.31 daysBaltimore MD1,092,1661,050,342$0.91552.92 daysKnoxville TN170,209163,691$0.89004.11 daysChattanooga TN52,20650,207$0.87924.62 days3/11/2023 Page 13/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Dallas TXSupplying Plant: DenverCost InformationInventory InformationFixed Costs:$33,960.00Throughput:4,480,809Variable Costs:$50,543.52Avg 321,159Inv Holding Costs:$92,199.94Max 683,063Freight into DC:$53,769.71Min 0Fill Rate:99.84%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.37Max Transit Time:5.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Birmingham AL411,482410,843$0.90484.73 daysMobile AL57,90557,815$0.90994.49 daysHouston TX643,671642,670$0.94362.90 daysDallas TX1,212,5741,210,689$1.00361.00 daysSan Antonio TX122,208122,018$0.93473.32 daysShreveport LA124,493124,300$0.95192.52 daysNew Orleans LA303,959303,487$0.92024.00 daysLittle Rock AR154,651154,411$0.93603.26 daysMemphis TN423,138422,481$0.92223.90 daysNashville TN330,582330,068$0.90084.91 daysOklahoma City OK703,122702,029$0.94712.74 days3/11/2023 Page 14/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Chicago ILSupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$38,000.00Throughput:3,398,406Variable Costs:$53,490.91Avg 281,398Inv Holding Costs:$82,409.53Max 1,302,827Freight into DC:$57,093.22Min 0Fill Rate:95.24%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.00Max Transit Time:3.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Chicago IL1,098,7621,046,458$0.96281.00 daysPeoria IL410,340390,807$0.93922.01 daysFort Wayne IN156,183148,748$0.93642.14 daysIndianapolis IN329,169313,500$0.93122.38 daysEvansville IN163,054155,292$0.90933.40 daysMilwaukee WI568,877541,797$0.94761.63 daysLouisville KY276,171263,024$0.90893.42 daysCincinnati OH565,709538,779$0.91283.24 days3/11/2023 Page 15/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Denver COSupplying Plant: DenverCost InformationInventory InformationFixed Costs:$21,280.00Throughput:4,445,346Variable Costs:$35,562.76Avg 307,342Inv Holding Costs:$87,259.46Max 689,700Freight into DC:$6,401.30Min 0Fill Rate:99.71%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.78Max Transit Time:5.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.El Paso TX284,278283,464$0.92284.53 daysAlbuquerque NM62,46362,284$0.94503.48 daysPhoenix AZ898,945896,372$0.87906.62 daysSalt Lake City UT845,767843,346$0.94153.65 daysButte MT325,836324,903$0.87946.60 daysDenver CO2,040,8182,034,976$0.97841.94 days3/11/2023 Page 16/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Miami FLSupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$37,720.00Throughput:1,253,982Variable Costs:$19,637.35Avg 235,816Inv Holding Costs:$69,569.72Max 1,089,158Freight into DC:$30,095.56Min 0Fill Rate:81.90%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.01Max Transit Time:3.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Jacksonville FL344,645282,249$0.90123.44 daysTampa FL610,794500,214$0.91492.81 daysMiami FL575,753471,518$0.97271.00 days3/11/2023 Page 17/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Kansas City MOSupplying Plant: DenverCost InformationInventory InformationFixed Costs:$34,000.00Throughput:2,795,067Variable Costs:$39,689.94Avg 209,782Inv Holding Costs:$60,693.30Max 523,670Freight into DC:$54,336.09Min 0Fill Rate:99.33%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.38Max Transit Time:5.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.St Louis MO408,661405,930$0.92893.10 daysDes Moines IA509,175505,773$0.94082.55 daysOmaha NE671,897667,407$0.94302.45 daysKansas City MO871,352865,529$0.97611.00 daysWichita KS352,786350,428$0.94132.53 days3/11/2023 Page 18/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Distribution Center StatisticsDC Location: Minneapolis MNSupplying Plant: DenverCost InformationInventory InformationFixed Costs:$33,000.00Throughput:813,742Variable Costs:$11,229.64Avg 90,533Inv Holding Costs:$26,280.79Max 357,155Freight into DC:$18,455.67Min 0Fill Rate:98.17%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.38Max Transit Time:4.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Minneapolis MN828,936813,742$0.97331.00 days3/11/2023 Page 19/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5Activity Based Costs and PerformanceTotal CostsUnit CostsAverage Time (days)Plant In-boundPurchase Costs$26,610,757.58$0.7415Freight Costs$194,010.16$0.0054In Transit to Plant$114,761.61$0.00324.16Raw Mtl. Holding$272,941.60$0.00769.90Production RelatedPlant Fixed Cost$7,900,000.00$0.2201Plant Var. Cost$7,090,608.14$0.1976WIP Holding$353,342.58$0.009810.00Plant Out-boundPlant Warehouse FixCost
$463,000.00$0.0129Plant Warehouse Var
Cost
$708,940.57$0.0198Plant Warehouse Holding
$158,555.84$0.00443.96In Transit Holding to
DC
$90,245.58$0.00252.31DistributionDC Freight In$620,467.71$0.0173DC Fixed$361,160.00$0.0101DC Var$545,517.31$0.0152DC Holding$762,509.31$0.021219.16Freight to Customer$3,332,206.12$0.0928In Transit to Customer$131,157.07$0.00373.18AdministrativeControl System Costs--Base$100,000.00$0.0028Control System Costs--DRP$40,000.00$0.0011Control System Costs--Colb$25,000.00$0.0007--------------Totals$49,875,181.18$1.385152.673/11/2023 Page 20/21 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 5SUPPLY CHAIN FINANCIAL STATEMENTSSupply Chain Income Statement (does not include Marketing and G & A)Total Annual DollarsDollars / UnitTotal Sales$71,778,330.06$2.0000Total Fixed$8,889,160.00$0.2477Total Variable$39,102,507.59$1.0895Total Inventory $1,883,513.59$0.0525-----------------Profit Contribution $21,903,148.88$0.6103Supply Chain Assets EmployedPlants$21,800,000.00Plant Warehouse$1,725,000.00Distribution $3,611,600.00Inventory$6,278,378.64-----------------Total Assets Employed$33,414,978.64SUPPLY CHAIN PERFORMANCE MEASURESCustomer ServiceTargeted Fill Rate:100.00%Achieved Fill Rate97.13%Order Cycle Time to Customer (days)3.18FlexibilityAverage Time through Supply Chain (days)52.67Average Production Capacity Utilization77.69%FinancialSupply Chain Profit Margin30.52%Supply Chain Return on Assets65.55%3/11/2023 Page 21/21
