module 4 case study

profileechidester
Module4_Case1Data7_2021.xlsx

Sheet1

Higher-Up Beverages
Budget Estimate for 6/1/2022
Cannibis Expansion Project
Week 8/2/21 8/9/21 8/16/21 8/23/21 8/30/21 9/6/21 9/13/21 9/20/21 9/27/21 10/4/21 10/11/21 10/18/21 10/25/21 11/1/21 11/8/21 11/15/21 11/22/21 11/29/21 12/6/21 12/13/21 12/20/21 12/27/21 1/3/22 1/10/22 1/17/22 1/24/22 1/31/22 2/7/22 2/14/22 2/21/22 2/28/22 3/7/22 3/14/22 3/21/22 3/28/22 4/4/22 4/11/22 4/18/22 4/25/22 5/2/22 5/9/22 5/16/22 5/23/22 5/30/22
Project Workstream Cost Center/Vendor Original Duration in Weeks Cost to Improve Cost to Improve Time (cost applies to all original duration weeks) Week # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
Build New Cannibis Growing Center New Heights Construction In Process - 4 Weeks Remaining $50,000 Per Week Improve Time 25% with additional $10,000 Per Week
Setup Cannibis Growing Operations Internal - Grow Dept 14 Weeks $20,000 Per Week Improve Time 50% with additional $20,000 Per Week
Setup Cannibis Harvesting Center Internal - Harvesting Dept 3 Weeks No Way to improve. No Way to improve.
Setup Cannibis Conversion Center Internal - Conversion Dept 4 Weeks $5,000 Per Week Improve Time 10% Per Week for additional $5,000
Build Beverage Filling Line expansion Ace Beverage Equipment Co. 6 Weeks $80,000 Per Week Improve Time 33% Per Week for $40,000
Build Beverage Packaging Center Grand Packaging Equipment Co. 7 Weeks $100,000 Per Week Improve 1 week for additional $10,000
Build Beverage Ispection/Quality Control Center Anderson Inspection Equipment Co. 3 Weeks No Way to improve. No Way to improve.
Build Warehouse Expansion New Heights Construction In Process - 11 Weeks Remaining $200,000 Per Week Improve Time by 3 weeks, $50,000 Per Week
Upgrated Inventory System with Track & Tracing 50% Internal IT / 50% Outsources to Super IT Group, LLC 8 Weeks Internal IT needs 6 Weeks, Outsourcing of $20,000 per week Will improve by 2 weeks for additional $10,000 per Week
Implement Marketing Program 100% Oursource - New Age Marketing Co. 10 Weeks $1,000,000 Will improve by 50% with no additional charge
Setup Distribution Partnership Alliance with Ace Nationwide Beverage Distributors, Inc. 4 Weeks Can do anytime, no additional charge. Can do anytime, no additional charge.