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 = 4Simulation Decisions:Market Forecasting: CollaborativeCurrent Markets Deleted:New Markets Opened:NY, NJ, PAAlabama, MississippiActive DCs:Detroit MITL4Philadelphia PATL4Los Angeles CATL4Baltimore MDTL4Dallas TXTL4Chicago ILTL4Denver COTL4Minneapolis 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.8New 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 1/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Plant 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 Shares70.07%0.00%29.93%Volume2,947,35301,258,662Avg Transit Time4.010.004.03Min Transit Time2.000.002.00Max Transit Time8.000.008.00Weeks of Requirements for Safety Stock 1.5Average Inventory at Plant176,151Maximum Inventory at Plant504,398Minimum Inventory at Plant0Fill Rate at the Plant99.96%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 Shares94.67%0.00%5.33%Volume1,346,221075,801Avg Transit Time5.960.006.20Min Transit Time2.000.002.00Max Transit Time12.000.0011.00Weeks of Requirements for Safety Stock 2.6Average Inventory at Plant46,459Maximum Inventory at Plant214,810Minimum Inventory at Plant0Fill Rate at the Plant84.49%3/11/2023 Page 2/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Plant 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 Shares72.87%1.71%25.42%Volume1,223,77328,785426,840Avg Transit Time4.004.164.06Min Transit Time2.003.002.00Max Transit Time7.006.008.00Weeks of Requirements for Safety Stock 1.8Average Inventory at Plant77,619Maximum Inventory at Plant190,935Minimum Inventory at Plant0Fill Rate at the Plant99.78%3/11/2023 Page 3/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Plant Location: DenverProduction Planning and ExecutionPeriodScheduledProduced11,406,8001,032,78621,065,600775,21731,145,600916,81041,241,600942,24851,467,2001,190,61861,667,2001,489,19471,589,6001,492,32581,794,4001,764,89092,021,2001,945,446101,920,0001,670,289111,648,4001,042,010121,724,8001,121,776131,770,8001,446,746________________________20,463,20016,830,354Lost Production Due to RM Shortages 3,632,846 Plant Finished Goods Warehouse StatisticsWeeks of Requirements for Safety Stock: 2Average 129,445Maximum Inventory1,339,289Minimum Inventory3Volume shipped to DCs16,825,600Fill Rate of FG38.6412%3/11/2023 Page 4/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Plant 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.98%0.00%30.02%Volume2,282,4170978,984Avg Transit Time3.000.003.01Min Transit Time2.000.002.00Max Transit Time4.000.004.00Weeks of Requirements for Safety Stock 1.5Average Inventory at Plant174,589Maximum Inventory at Plant319,165Minimum Inventory at Plant19,868Fill 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 Shares99.87%0.00%0.13%Volume1,053,22801,404Avg Transit Time4.980.005.00Min Transit Time2.000.005.00Max Transit Time8.000.005.00Weeks of Requirements for Safety Stock 2.6Average Inventory at Plant36,984Maximum Inventory at Plant181,410Minimum Inventory at Plant0Fill Rate at the Plant80.84%3/11/2023 Page 5/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Plant 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 Shares74.71%0.00%25.29%Volume974,0240329,756Avg Transit Time3.010.003.00Min Transit Time2.000.002.00Max Transit Time4.000.004.00Weeks of Requirements for Safety Stock 1.8Average Inventory at Plant77,057Maximum Inventory at Plant151,464Minimum Inventory at Plant0Fill Rate at the Plant99.94%3/11/2023 Page 6/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Plant Location: New KensingtonProduction Planning and ExecutionPeriodScheduledProduced11,304,000888,90221,089,200798,3263964,800817,7804966,400831,10851,044,400847,90961,221,600942,80371,345,6001,280,61681,377,2001,188,16691,486,4001,382,449101,500,0001,185,111111,500,000991,905121,453,600939,217131,412,800951,314__________________16,666,00013,045,606Lost Production Due to RM Shortages 3,620,394 Plant Finished Goods Warehouse StatisticsWeeks of Requirements for Safety Stock: 2Average Inventory101,506Maximum Inventory1,047,357Minimum Inventory2Volume shipped to DCs13,045,600Fill Rate of FG16.6503%3/11/2023 Page 7/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Detroit MISupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$35,160.00Throughput:5,657,408Variable Costs:$93,686.68Avg 328,864Inv Holding Costs:$92,531.88Max 688,856Freight into DC:$91,650.01Min 0Fill Rate:99.43%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,073,3611,067,203$0.94403.53 daysCleveland OH1,269,3511,262,069$0.96312.64 daysBuffalo NY1,171,2281,164,509$0.94203.62 daysDetroit MI1,515,5891,506,894$0.97352.16 daysColumbus OH660,522656,732$0.95193.16 days3/11/2023 Page 8/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Philadelphia PASupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$29,880.00Throughput:4,021,598Variable Costs:$74,077.83Avg 288,168Inv Holding Costs:$81,340.58Max 723,983Freight into DC:$77,214.68Min 0Fill Rate:99.46%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,599,8902,585,815$0.94523.25 daysAlbany NY164,505163,614$0.92724.09 daysScranto PA215,684214,517$0.93843.56 daysPhiladelphia PA875,515870,775$0.95222.92 daysSyracuse NY187,894186,877$0.92404.24 days3/11/2023 Page 9/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Los Angeles CASupplying Plant: DenverCost InformationInventory InformationFixed Costs:$31,180.00Throughput:5,227,325Variable Costs:$98,169.16Avg 353,230Inv Holding Costs:$100,897.16Max 695,927Freight into DC:$132,983.14Min 0Fill Rate:99.71%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,137,2463,128,089$0.92113.83 daysSan Francisco CA1,459,6971,455,436$0.88765.41 daysPortland OR645,683643,799$0.86336.58 days3/11/2023 Page 10/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Baltimore MDSupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$32,540.00Throughput:170,553Variable Costs:$2,868.70Avg 39,164Inv Holding Costs:$11,061.80Max 116,146Freight into DC:$3,376.94Min 0Fill Rate:99.56%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 PA171,311170,553$0.94863.13 days3/11/2023 Page 11/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Dallas TXSupplying Plant: DenverCost InformationInventory InformationFixed Costs:$33,960.00Throughput:3,530,185Variable Costs:$39,820.48Avg 254,910Inv Holding Costs:$71,785.06Max 520,411Freight into DC:$42,362.22Min 0Fill Rate:99.61%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.37Max Transit Time:4.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Birmingham AL391,500389,958$0.92304.73 daysMobile AL55,19754,979$0.92814.49 daysHouston TX607,266604,875$0.96192.90 daysDallas TX1,146,1351,141,621$1.02181.00 daysSan Antonio TX115,296114,842$0.95293.32 daysShreveport LA119,801119,330$0.97012.52 daysNew Orleans LA289,744288,603$0.93844.00 daysLittle Rock AR147,697147,116$0.95423.26 daysOklahoma City OK671,506668,861$0.96542.74 days3/11/2023 Page 12/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Chicago ILSupplying Plant: New KensingtonCost InformationInventory InformationFixed Costs:$38,000.00Throughput:3,365,774Variable Costs:$52,977.29Avg 293,083Inv Holding Costs:$82,516.90Max 1,123,374Freight into DC:$56,545.01Min 0Fill Rate:93.95%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,074,5671,009,553$1.00051.00 daysPeoria IL401,304377,025$0.97692.01 daysFort Wayne IN152,744143,502$0.97412.14 daysIndianapolis IN321,921302,444$0.96892.38 daysEvansville IN159,463149,815$0.94703.40 daysMilwaukee WI549,403516,162$0.98531.63 daysSt Louis MO378,873355,950$0.94813.35 daysCincinnati OH544,251511,323$0.95053.24 days3/11/2023 Page 13/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Denver COSupplying Plant: DenverCost InformationInventory InformationFixed Costs:$21,280.00Throughput:7,035,088Variable Costs:$56,280.71Avg 466,451Inv Holding Costs:$129,879.36Max 1,063,874Freight into DC:$10,130.53Min 0Fill Rate:99.69%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.77Max Transit Time:6.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Omaha NE619,206617,266$0.94804.20 daysKansas City MO803,020800,504$0.94104.53 daysWichita KS327,597326,571$0.95323.96 daysEl Paso TX257,847257,039$0.94114.53 daysAlbuquerque NM56,65656,478$0.96333.48 daysPhoenix AZ815,366812,811$0.89736.62 daysSalt Lake City UT767,132764,729$0.95983.65 daysSeattle WA967,588964,556$0.86568.14 daysSpokane WA242,764242,004$0.86568.14 daysButte MT302,894301,945$0.89776.60 daysDenver CO1,897,1281,891,185$0.99661.94 days3/11/2023 Page 14/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Distribution Center StatisticsDC Location: Minneapolis MNSupplying Plant: DenverCost InformationInventory InformationFixed Costs:$33,000.00Throughput:1,251,216Variable Costs:$17,266.78Avg 127,293Inv Holding Costs:$36,254.74Max 816,573Freight into DC:$28,377.59Min 0Fill Rate:94.23%Transit Time Statistics from Plant Mode Used:TL4Average Transit Time:2.37Max Transit Time:4.00Min Transit Time:2.00Customer Regions ServedMarketDemandSoldProfit Contr.Transit Time--Cust.Minneapolis MN832,327784,326$0.99151.00 daysDes Moines IA495,464466,891$0.94443.10 days3/11/2023 Page 15/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4Activity Based Costs and PerformanceTotal CostsUnit CostsAverage Time (days)Plant In-boundPurchase Costs$21,020,118.18$0.6947Freight Costs$160,979.16$0.0053In Transit to Plant$87,756.19$0.00294.13Raw Mtl. Holding$223,049.32$0.007411.84Production RelatedPlant Fixed Cost$7,900,000.00$0.2611Plant Var. Cost$5,856,967.91$0.1936WIP Holding$280,761.26$0.009310.00Plant Out-boundPlant Warehouse FixCost
$463,000.00$0.0153Plant Warehouse Var
Cost
$582,534.81$0.0193Plant Warehouse Holding
$64,054.28$0.00212.01In Transit Holding to
DC
$74,491.51$0.00252.34DistributionDC Freight In$442,640.11$0.0146DC Fixed$255,000.00$0.0084DC Var$435,147.63$0.0144DC Holding$606,267.49$0.0218.72Freight to Customer$3,009,214.75$0.0994In Transit to Customer$114,446.52$0.00383.48AdministrativeControl System Costs--Base$100,000.00$0.0033Control System Costs--DRP$40,000.00$0.0013Control System Costs--Colb$25,000.00$0.0008--------------Totals$41,741,429.12$1.37452.523/11/2023 Page 16/17 MAS SUPPLY CHAIN SIMULATION RESULTSPrinted by Simulator 1.0 Calendar Year 2023Copyright 2023 by Alan J. Stenger, all rights reservedSCENARIO YEAR = 4SUPPLY CHAIN FINANCIAL STATEMENTSSupply Chain Income Statement (does not include Marketing and G & A)Total Annual DollarsDollars / UnitTotal Sales$60,518,293.95$2.0000Total Fixed$8,783,000.00$0.2903Total Variable$31,507,602.55$1.0413Total Inventory $1,450,826.56$0.0479-----------------Profit Contribution $18,776,864.83$0.6205Supply Chain Assets EmployedPlants$21,800,000.00Plant Warehouse$1,725,000.00Distribution $2,550,000.00Inventory$4,836,088.55-----------------Total Assets Employed$30,911,088.55SUPPLY CHAIN PERFORMANCE MEASURESCustomer ServiceTargeted Fill Rate:100.00%Achieved Fill Rate98.70%Order Cycle Time to Customer (days)3.48FlexibilityAverage Time through Supply Chain (days)52.52Average Production Capacity Utilization63.84%FinancialSupply Chain Profit Margin31.03%Supply Chain Return on Assets60.74%3/11/2023 Page 17/17
