Production Schedule Methodology Example: Team Chester and Product Cake NOTE: For this example, data from a previous semesters Capstone Courier was used. The data below was after Round #1. This data will be used to determine the Production Schedule for Round 2, Product Cake. Product Cake Sold 675 Units in the Traditional Segment. Product Cake has 668 Units Currently in Inventory. About 56 units of Product Cake were sold each month (675 units / 12 months). In three months, 168 units were sold. What is the Production Schedule for Product Cake for the next round, Round #2? Sales Forecast for Next Year: Assume that Round 2 Sales will be Round 1 Unit Sales, plus Next Years Segment Growth Rate. 675 Units x 1.092 Growth Rate = 737.1 Units Production Schedule: Sales Forecast + 3 Months Buffer of Inventory Units In Inventory The Production Schedule for Product Cake is 237 Units Below is one example of how the Sales Forecast and Production Schedule could be calculated in MS Excel. Product Name Segment Units Sold Next Year's Growth Rate Number of Units Sold Each Month Unit Inventory Production Schedule Cake Traditional 675 1.092 56 668 237.1

You will upload your MS Excel spreadsheet. Grading Criteria: Correct Answer, using Cell Addresses in Formula: 100%; Attempted, but Answer Incorrect or Did Not Use Cell Addresses in Formula: 65%. For example: =C2*D2 is an example using Cells Addresses in a Formula.

Use the Production Schedule Methodology described in the previous slide. Calculate the Production Schedule for your Teams Product in the Traditional Segment. Team Andrews: Product Able; Team Baldwin: Product Baker; Team Chester: Product Cake; Team Digby: Product Daze; Team Erie: Product Eat Use the data below to determine the Production Schedule for your Teams Product in the Traditional Segment. How many units should your team schedule for Production for this product? Use MS Excel to show how you calculated the Production Schedule for this product. Submit your MS Excel spreadsheet in Brightspace. Use Cell Addresses in your calculation.

Stock Eat 14.5 Able 1,345 5.3 152 Ani 140 6,722 31.4% Ba Baker 1211 9.2% CH CES Production Schedule Methodology Example: Team Chester and Product Cake NOTE: For this example, data from a previous semester's Capstone Courier was used. The data below was after Round #1. This data will be used to determine the Production Schedule for Round 2, Product Cake. Top Products in Traditional : Traditional Market Segment Analysis Units Market Sold to Revision Pfmn Size List Name Share Seg Date Out Coord Coord Price MTBF DI 25% 1,661 3/17/2022 5.6 $27.50 16500 Traditional Statistics 20% 5/30/2022 $28.00 17500 Total Industry Unit Demand 6,722 Daze 19% 1,287 6/11/2022 6.1 $29.50 17800 Actual Industry Unit Sales 18% 7/19/2022 YES 4.8 148 $24.75 14500 Segment of Total Industry Cake 10% 675 11/21/2018 5.5 14.5 $28.00 17500 Next Year's Segment Growth Rate TIT 5/25/2017 3.0 17.0 $21.00 14000 Unit Product Cake Sold 675 Units in the Traditional Segment. Primary Units Inven Name Segment Product Cake has 668 Units Currently in Inventory. About 56 units of Product Cake were sold each month (675 units / 12 months). In three months, 168 units were sold. Trad | Acre Low What is the Production Schedule for Product Cake for the next round, Round #2? Adam High 534 100 Sales Forecast for Next Year. Assume that Round 2 Sales will be Round 1 Unit Sales, plus Next Year's Pfmn 354 21 Segment Growth Rate. Agape Size 359 675 Units x 1.092 Growth Rate - 737.1 Units Baker Trad Production Schedule: Sales Forecast + 3 Month's Buffer of Inventory - Units In Inventory Bead Low 1,871 The Production Schedule for Product Cake is 237 Units High 494 42 598 74 Below is one example of how the Sales Forecast and Production Schedule could be calculated in MS Excel. Buddy Size 65 Cake Number of Product Low 1,695 145 Production Segment Units Sold Growth Rate Unit Inventory Schedule Cid High 370 77 Traditional 675 1.0921 237.1 Coat Pfmn Cure Size Sold tory F Able 1.381 1.651 491 368 Alt 0 1 278 0 0 Bid Bold Pfmn 468 Trad 710 668 Next Year's Cedar Name Units Sold Each Month 56 Cake 868 371 296 143 142 ne Courier: Assignment #1. This is an Individual Assignment. Submit your assignment in Brightspace by 11:59 PM on September 26. You will upload IS Excel spreadsheet. Grading Criteria: Correct Answer, using Cell Addresses in Formula: 100%; Attempted, but Answer Incorrect or Did Not Use Cell ses in Formula: 65%. For example: C2*D2 is an example using Cells Addresses in a Formula. se the Production Schedule Methodology described in the previous slide. Calculate the Production Schedule for your Team's Product in the Traditional Segment. Team Andrews: Product Able; Team Baldwin: Product Baker, Team Chester: Product Cake; Team Digby: Product Daze; Team Erie: Product Eat se the data below to determine the Production Schedule for your Team's Product in the Traditional Segment. ow many units should your team schedule for Production for this product? Use MS Excel to show how you calculated the Production Schedule for this product. Submit your MS Excel spreadsheet in Brightspace. Use Cell Addresses in your calculation. Production Informatior Traditional Market Segment Analysis Primary Segment Trad Low High Pfmn 179 Traditional Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment of Total Industry Next Year's Segment Growth Rate 8 800 8 809 30.4% 244 sae 510 - Trad 300 9.29 LOW Trad 27 02 322 Trad TS Top Products in Traditional Segment Trad Unit Units inven ADO P Sold tory Revision Date Dec 31 MTBF Coord Coord Price 1,408 5/2/2021 20 16500 52 14.9 $26.99 1,451 1,176 2/9/2021 3.7 13000 18.0 920.99 593 11 4/28/2021 17 22500 88 11.2 $38.99 456 6/16/2021 18 25000 15.7 529.99 5/25/2021 1.9 19500 4.3 10.2 $33.99 1,043 5/15/2021 1.8 14000 150 $25.99 968 1,341 6/3/2021 23 14000 16.3 $20.00 4/27/2021 22 22000 6.4 13.4 $31.99 0 5/11/2021 18 25000 150 $31.90 5/20/2021 10 19000 42 125 $2799 1,075 8/31/2021 19 19000 58 140 $29.00 1.927 660 9/30/2020 3.9 15000 20 17.5 $21.00 877 9/4/2021 15 24000 92 10.5 930 25 700 85 1.9 27000 16.0 $34.25 477 9/4/2021 1.7 21000 4.7 9.6 534.25 1,242 7/21/2021 19 17500 6.4 13.5 529.00 o 5/25/2015 6.5 14000 3.0 17.0 520.00 714 0 8/10/2021 1.4 23000 10.2 $38.00 704 8/27/2021 10 27000 14,5 $34.00 784 9/13/2021 16 20000 5.2 8.8 $34.00 1,204 236 4/8/2021 21 15500 55 145 $2700 2,195 BB 1/15/2021 66 12000 30 170 $19.50 990 85 7/20/2021 1 4 15000 84 136 $27.00 35 0 B/30/2017 45 25000 15.5 $34 00 904 LOW High Pm See 97% 3/24/2021 210 Trad 2.900 LOM High Phon Units Market Sold to Name Share Seg Able 15% 1 313 Deze 14% 1225 Eat 139 1.166 Cake 124 1074 Baker 11% 567 Echo 11% 962 Fast 119 925 Buddy 519 Bid 5% 455 Bold 2% 213 AR 0% 4 Bead 0% 3 CAPSTONED COURIER Revision Stock Pim Size Date Out Coord Coord 5/2/2021 52 149 7/21/2021 6.4 136 4/8/2021 5.5 14.5 8/31/2021 5.8 140 5/15/2021 48 150 7/20/2021 6.4 136 4/22/2021 5.5 14.5 5/28/2021 YES 125 4/27/2021 64 13.4 5/11/2021 YES 150 6/16/2021 15.7 6/3/2021 27 163 Cust List Age Promo Aware Price MTBF Dec 31 Budget ness $26.99 16500 1.90 52 200 529.00 17500 1.94 $1.400 77% $27.00 15500 2.09 $1,060 63% $29.00 19000 1.85 52 000 70% 525 90 14000 1 87 $1,100 65% $27.00 16000 1.40 $1,050 57% $2900 14000 2.08 $900 59% $2799 19000 1.75 5900 49% $31.99 22000 2 19 $1.200 $31.90 25000 1.80 $900 49% $299 25000 1.80 $1.500 79% 520 60 14000 2.29 $1.000 Cust Sales Access- Budget ibly $1,700 60% $1,400 54% $1,086 54% $2,000 52% $1,000 624 $775 54% $1,236 $800 62% $1,200 62% $900 62 $1,400 60% 5900 62% Dec Cust Survey 37 40 31 38 26 29 24 24 16 10 0 0 Page 5 204 Trad Low Trad P Stock Eat 14.5 Able 1,345 5.3 152 Ani 140 6,722 31.4% Ba Baker 1211 9.2% CH CES Production Schedule Methodology Example: Team Chester and Product Cake NOTE: For this example, data from a previous semester's Capstone Courier was used. The data below was after Round #1. This data will be used to determine the Production Schedule for Round 2, Product Cake. Top Products in Traditional : Traditional Market Segment Analysis Units Market Sold to Revision Pfmn Size List Name Share Seg Date Out Coord Coord Price MTBF DI 25% 1,661 3/17/2022 5.6 $27.50 16500 Traditional Statistics 20% 5/30/2022 $28.00 17500 Total Industry Unit Demand 6,722 Daze 19% 1,287 6/11/2022 6.1 $29.50 17800 Actual Industry Unit Sales 18% 7/19/2022 YES 4.8 148 $24.75 14500 Segment of Total Industry Cake 10% 675 11/21/2018 5.5 14.5 $28.00 17500 Next Year's Segment Growth Rate TIT 5/25/2017 3.0 17.0 $21.00 14000 Unit Product Cake Sold 675 Units in the Traditional Segment. Primary Units Inven Name Segment Product Cake has 668 Units Currently in Inventory. About 56 units of Product Cake were sold each month (675 units / 12 months). In three months, 168 units were sold. Trad | Acre Low What is the Production Schedule for Product Cake for the next round, Round #2? Adam High 534 100 Sales Forecast for Next Year. Assume that Round 2 Sales will be Round 1 Unit Sales, plus Next Year's Pfmn 354 21 Segment Growth Rate. Agape Size 359 675 Units x 1.092 Growth Rate - 737.1 Units Baker Trad Production Schedule: Sales Forecast + 3 Month's Buffer of Inventory - Units In Inventory Bead Low 1,871 The Production Schedule for Product Cake is 237 Units High 494 42 598 74 Below is one example of how the Sales Forecast and Production Schedule could be calculated in MS Excel. Buddy Size 65 Cake Number of Product Low 1,695 145 Production Segment Units Sold Growth Rate Unit Inventory Schedule Cid High 370 77 Traditional 675 1.0921 237.1 Coat Pfmn Cure Size Sold tory F Able 1.381 1.651 491 368 Alt 0 1 278 0 0 Bid Bold Pfmn 468 Trad 710 668 Next Year's Cedar Name Units Sold Each Month 56 Cake 868 371 296 143 142 ne Courier: Assignment #1. This is an Individual Assignment. Submit your assignment in Brightspace by 11:59 PM on September 26. You will upload IS Excel spreadsheet. Grading Criteria: Correct Answer, using Cell Addresses in Formula: 100%; Attempted, but Answer Incorrect or Did Not Use Cell ses in Formula: 65%. For example: C2*D2 is an example using Cells Addresses in a Formula. se the Production Schedule Methodology described in the previous slide. Calculate the Production Schedule for your Team's Product in the Traditional Segment. Team Andrews: Product Able; Team Baldwin: Product Baker, Team Chester: Product Cake; Team Digby: Product Daze; Team Erie: Product Eat se the data below to determine the Production Schedule for your Team's Product in the Traditional Segment. ow many units should your team schedule for Production for this product? Use MS Excel to show how you calculated the Production Schedule for this product. Submit your MS Excel spreadsheet in Brightspace. Use Cell Addresses in your calculation. Production Informatior Traditional Market Segment Analysis Primary Segment Trad Low High Pfmn 179 Traditional Statistics Total Industry Unit Demand Actual Industry Unit Sales Segment of Total Industry Next Year's Segment Growth Rate 8 800 8 809 30.4% 244 sae 510 - Trad 300 9.29 LOW Trad 27 02 322 Trad TS Top Products in Traditional Segment Trad Unit Units inven ADO P Sold tory Revision Date Dec 31 MTBF Coord Coord Price 1,408 5/2/2021 20 16500 52 14.9 $26.99 1,451 1,176 2/9/2021 3.7 13000 18.0 920.99 593 11 4/28/2021 17 22500 88 11.2 $38.99 456 6/16/2021 18 25000 15.7 529.99 5/25/2021 1.9 19500 4.3 10.2 $33.99 1,043 5/15/2021 1.8 14000 150 $25.99 968 1,341 6/3/2021 23 14000 16.3 $20.00 4/27/2021 22 22000 6.4 13.4 $31.99 0 5/11/2021 18 25000 150 $31.90 5/20/2021 10 19000 42 125 $2799 1,075 8/31/2021 19 19000 58 140 $29.00 1.927 660 9/30/2020 3.9 15000 20 17.5 $21.00 877 9/4/2021 15 24000 92 10.5 930 25 700 85 1.9 27000 16.0 $34.25 477 9/4/2021 1.7 21000 4.7 9.6 534.25 1,242 7/21/2021 19 17500 6.4 13.5 529.00 o 5/25/2015 6.5 14000 3.0 17.0 520.00 714 0 8/10/2021 1.4 23000 10.2 $38.00 704 8/27/2021 10 27000 14,5 $34.00 784 9/13/2021 16 20000 5.2 8.8 $34.00 1,204 236 4/8/2021 21 15500 55 145 $2700 2,195 BB 1/15/2021 66 12000 30 170 $19.50 990 85 7/20/2021 1 4 15000 84 136 $27.00 35 0 B/30/2017 45 25000 15.5 $34 00 904 LOW High Pm See 97% 3/24/2021 210 Trad 2.900 LOM High Phon Units Market Sold to Name Share Seg Able 15% 1 313 Deze 14% 1225 Eat 139 1.166 Cake 124 1074 Baker 11% 567 Echo 11% 962 Fast 119 925 Buddy 519 Bid 5% 455 Bold 2% 213 AR 0% 4 Bead 0% 3 CAPSTONED COURIER Revision Stock Pim Size Date Out Coord Coord 5/2/2021 52 149 7/21/2021 6.4 136 4/8/2021 5.5 14.5 8/31/2021 5.8 140 5/15/2021 48 150 7/20/2021 6.4 136 4/22/2021 5.5 14.5 5/28/2021 YES 125 4/27/2021 64 13.4 5/11/2021 YES 150 6/16/2021 15.7 6/3/2021 27 163 Cust List Age Promo Aware Price MTBF Dec 31 Budget ness $26.99 16500 1.90 52 200 529.00 17500 1.94 $1.400 77% $27.00 15500 2.09 $1,060 63% $29.00 19000 1.85 52 000 70% 525 90 14000 1 87 $1,100 65% $27.00 16000 1.40 $1,050 57% $2900 14000 2.08 $900 59% $2799 19000 1.75 5900 49% $31.99 22000 2 19 $1.200 $31.90 25000 1.80 $900 49% $299 25000 1.80 $1.500 79% 520 60 14000 2.29 $1.000 Cust Sales Access- Budget ibly $1,700 60% $1,400 54% $1,086 54% $2,000 52% $1,000 624 $775 54% $1,236 $800 62% $1,200 62% $900 62 $1,400 60% 5900 62% Dec Cust Survey 37 40 31 38 26 29 24 24 16 10 0 0 Page 5 204 Trad Low Trad P