To fully answer the questions requiring discussion, I would expect a minimum of 3.4 sentences for each topic. 1. I have provided you with four videos (Aggregate Plan Part 1 - 4 in the same folder as this document) that show you step by step how to build the DEMO worisheet. After completing the Agregate Planning Template for the data provided in the template (name the worksheet DEMOI, make a copy of that worksheet (in the same excel file) and name that worksheet ASSIGNMENT, and use the following information to create another Aggregate Plan. - Copy and paste the daily and average demand graph into the document (as a picture not an excel object). Interpret the graph, In which months are you beilding inventory and in which months you buming off inventory? - Copy and paste the summary cost table into the document (as a picture not an excel object). Which plan would you suggest the operations manager use? Explain. - Compare your Plan 1 tables between the DEMO and the ASSIGNMENT worluheets. What differences do you notice (aside from the actual numbers)? Focus on the Ending inventory column. How does this impact the validity of you inventory carryine costs? What is occurring? 1 - What would the Average Demand per day need to be changed to (integer value only) so that the ending inventory in any month would not be negative? Would this change the plan that you would suggest to the Operations manager? Copy and paste the Ntw summary cost table into the document (as a picture not an excel object). - What would the subcontracting cost have to be increased to make the cost of Plan 2 be the same as Plan 3 ? Copy and paste the NEW Plan 3 table into the document (as a picture not an excel object)- * You need to submit the Aggregate Planning Worksheet Excel file with the DEMO and ASSIGNMENT worksheets included, No credit for this problem if the completed Excel file is not submitted. - What would the Average Demand per day need to be changed to (integer value only) so that the ending inventory in any month would not be negative? Would this change the plan that you would suggest to the Operations manager? Copy and paste the NEW summary cost table into the document (as a picture not an excel object). - What would the subcontracting cost have to be increased to make the cost of Plan 2 be the same as Plan 3 ? Copy and paste the NEW Plan 3 table into the document (as a picture not an excel object). *+You need to submit the Aggregate Planning Worksheet Excel file with the DEMO and ASSIGNMENT worksheets included. No credit for this problem if the completed Excel file is not submitted. 2. Watch the "Dynamic Pricing in Airline Industry" and "Revenue Management in the NBA" videos (in the same folder as this document) and answer the following questions: (there is additional information about the NBA team's dynamic pricing approach on pp. 562). - What is the difference between leisure and business travelers for the airlines' pricing models? - How do airlines use advance purchase discounts and fare buckets in their pricing models? - Explain two additional factors, in addition to advance purchase discounts and fare buckets, that impact the airline's ticket prices. - Explain how the NBA's revenue management model is different from the airline industry. - What is the major type of statistical technique that is used in the NBA's Dynamic Pricing Model? What are the dependent and independent variables used in their model? - The video discusses a specific data analytics technique, a heat map. How is the heat map used to change ticket pricing? 3. A major airline flies between Asheville and Atlanta. The airplanes they use have a capacity to carry 90 passengers. In the past all seats were priced at $125. An average of 78 passengers are on every flight. The variable cost of a filled seat is $18. A new approach is to use a yield revenue approach with three price points. Early booked seats are priced at $90, seats booked between one and two weeks before the flight are priced at $135, and seats booked within one week are priced at $165. The estimate is that 60% of the seats will be priced at early booking rates, 25% will be priced at between one and two weeks before the flight, and the last 15% will be priced at the highest price. Variable costs will not change. - What are the expected sales for a flight using the old method and using the new yield revenue approach? Which approach would you suggest being implemented? Are there any concerns (e.g, non-price related factors)? - You should have come up with the expected sales from the yield management approach was less than the old method. The operations manager is very interested in the yield revenue approach but want to make sure it will generate at least the same amount of revenue as the old method. The only variable that can be changed is the pricing for early booked seats. The two other prices remain unchanged. What would the pricing for early booked seats need to be increased to cause the yield revenue method to generate the same value of expected sales as the old method. Explain how you determined this value. (You will need to do some calculations) \#1. Aggregate Planning Template Copy and paste the daily and average demand graph into the document (as a picture not an excel object). Interpret the graph. In which months are you building inventory and in which months you burning off inventory? Copy and paste the summary cost table into the document (as a picture not an excel object). Which plan would you suggest the operations manager use? Explain. Compare your Plan 1 tables between the DEMO and the ASSIGNMENT worksheets. What differences do you notice (aside from the actual numbers)? Focus on the Ending Inventory column. How does this impact the validity of you inventory carrying costs? What is occurring? What would the Average Demand per day need to be changed to (integer value only) so that the ending inventory in any month would not be negative? Would this change the plan that you would suggest to the Operations manager? Copy and paste the NEW summary cost table into the document (as a picture not an excel object). What is the major type of statistical technique that is used in the NBA's Dynamic Pricing Model? What are the dependent and independent variables used in their model? The video discusses a specific data analytics technique, a heat map. How is the heat map used to change ticket pricing? \#3. Airline's Yield Management Calculations What are the expected sales for a flight using the old method and using the new yield revenue approach? Which approach would you suggest being implemented? Are there any concerns (e.g., non-price related factors)? What would the pricing for early booked seats need to be increased to cause the yield revenue method to generate the same value of expected sales as the old method. Explain how you determined this value. \begin{tabular}{|l|c|c|} \hline \multicolumn{3}{|c|}{ Bemand data (tiven): } \\ \hline Menth & Expected Demand & Prodection Days \\ \hline Jan & 900 & 22 \\ \hline Feb & 700 & 18 \\ \hline Mar & 500 & 21 \\ \hline Apr & 1200 & 21 \\ \hline May & 1500 & 22 \\ \hline Jun & 1100 & 20 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Cost and Demand Infermation (calculated): } \\ \hline Demand (Total) & \\ \hline Production Days (Total) & \\ \hline Averare Demand Fer Day & \\ \hline Workforee Required io Froduce Average Demand aly & \\ \hline Minimum Demand per Mooth & \\ \hline Wotkforer Required io Foduce Mlinimum Deniand & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline \multicolumn{3}{|c|}{ Demand data (given): } \\ \hline Month & Expected Demand & Productien Days \\ \hline Jam & 900 & 22 \\ \hline Fcb & 700 & 18 \\ \hline Mar & 800 & 21 \\ \hline Apr & 1200 & 21 \\ \hline May & 1500 & 22 \\ \hline J & 1100 & 20 \\ \hline \end{tabular} mect by subcontracting) coatracted tiaits Subeontractiong Cost \begin{tabular}{l|l|l|} benthly demand & (Dliring Cent) & (L.ayefr Cost) \end{tabular} To fully answer the questions requiring discussion, I would expect a minimum of 3.4 sentences for each topic. 1. I have provided you with four videos (Aggregate Plan Part 1 - 4 in the same folder as this document) that show you step by step how to build the DEMO worisheet. After completing the Agregate Planning Template for the data provided in the template (name the worksheet DEMOI, make a copy of that worksheet (in the same excel file) and name that worksheet ASSIGNMENT, and use the following information to create another Aggregate Plan. - Copy and paste the daily and average demand graph into the document (as a picture not an excel object). Interpret the graph, In which months are you beilding inventory and in which months you buming off inventory? - Copy and paste the summary cost table into the document (as a picture not an excel object). Which plan would you suggest the operations manager use? Explain. - Compare your Plan 1 tables between the DEMO and the ASSIGNMENT worluheets. What differences do you notice (aside from the actual numbers)? Focus on the Ending inventory column. How does this impact the validity of you inventory carryine costs? What is occurring? 1 - What would the Average Demand per day need to be changed to (integer value only) so that the ending inventory in any month would not be negative? Would this change the plan that you would suggest to the Operations manager? Copy and paste the Ntw summary cost table into the document (as a picture not an excel object). - What would the subcontracting cost have to be increased to make the cost of Plan 2 be the same as Plan 3 ? Copy and paste the NEW Plan 3 table into the document (as a picture not an excel object)- * You need to submit the Aggregate Planning Worksheet Excel file with the DEMO and ASSIGNMENT worksheets included, No credit for this problem if the completed Excel file is not submitted. - What would the Average Demand per day need to be changed to (integer value only) so that the ending inventory in any month would not be negative? Would this change the plan that you would suggest to the Operations manager? Copy and paste the NEW summary cost table into the document (as a picture not an excel object). - What would the subcontracting cost have to be increased to make the cost of Plan 2 be the same as Plan 3 ? Copy and paste the NEW Plan 3 table into the document (as a picture not an excel object). *+You need to submit the Aggregate Planning Worksheet Excel file with the DEMO and ASSIGNMENT worksheets included. No credit for this problem if the completed Excel file is not submitted. 2. Watch the "Dynamic Pricing in Airline Industry" and "Revenue Management in the NBA" videos (in the same folder as this document) and answer the following questions: (there is additional information about the NBA team's dynamic pricing approach on pp. 562). - What is the difference between leisure and business travelers for the airlines' pricing models? - How do airlines use advance purchase discounts and fare buckets in their pricing models? - Explain two additional factors, in addition to advance purchase discounts and fare buckets, that impact the airline's ticket prices. - Explain how the NBA's revenue management model is different from the airline industry. - What is the major type of statistical technique that is used in the NBA's Dynamic Pricing Model? What are the dependent and independent variables used in their model? - The video discusses a specific data analytics technique, a heat map. How is the heat map used to change ticket pricing? 3. A major airline flies between Asheville and Atlanta. The airplanes they use have a capacity to carry 90 passengers. In the past all seats were priced at $125. An average of 78 passengers are on every flight. The variable cost of a filled seat is $18. A new approach is to use a yield revenue approach with three price points. Early booked seats are priced at $90, seats booked between one and two weeks before the flight are priced at $135, and seats booked within one week are priced at $165. The estimate is that 60% of the seats will be priced at early booking rates, 25% will be priced at between one and two weeks before the flight, and the last 15% will be priced at the highest price. Variable costs will not change. - What are the expected sales for a flight using the old method and using the new yield revenue approach? Which approach would you suggest being implemented? Are there any concerns (e.g, non-price related factors)? - You should have come up with the expected sales from the yield management approach was less than the old method. The operations manager is very interested in the yield revenue approach but want to make sure it will generate at least the same amount of revenue as the old method. The only variable that can be changed is the pricing for early booked seats. The two other prices remain unchanged. What would the pricing for early booked seats need to be increased to cause the yield revenue method to generate the same value of expected sales as the old method. Explain how you determined this value. (You will need to do some calculations) \#1. Aggregate Planning Template Copy and paste the daily and average demand graph into the document (as a picture not an excel object). Interpret the graph. In which months are you building inventory and in which months you burning off inventory? Copy and paste the summary cost table into the document (as a picture not an excel object). Which plan would you suggest the operations manager use? Explain. Compare your Plan 1 tables between the DEMO and the ASSIGNMENT worksheets. What differences do you notice (aside from the actual numbers)? Focus on the Ending Inventory column. How does this impact the validity of you inventory carrying costs? What is occurring? What would the Average Demand per day need to be changed to (integer value only) so that the ending inventory in any month would not be negative? Would this change the plan that you would suggest to the Operations manager? Copy and paste the NEW summary cost table into the document (as a picture not an excel object). What is the major type of statistical technique that is used in the NBA's Dynamic Pricing Model? What are the dependent and independent variables used in their model? The video discusses a specific data analytics technique, a heat map. How is the heat map used to change ticket pricing? \#3. Airline's Yield Management Calculations What are the expected sales for a flight using the old method and using the new yield revenue approach? Which approach would you suggest being implemented? Are there any concerns (e.g., non-price related factors)? What would the pricing for early booked seats need to be increased to cause the yield revenue method to generate the same value of expected sales as the old method. Explain how you determined this value. \begin{tabular}{|l|c|c|} \hline \multicolumn{3}{|c|}{ Bemand data (tiven): } \\ \hline Menth & Expected Demand & Prodection Days \\ \hline Jan & 900 & 22 \\ \hline Feb & 700 & 18 \\ \hline Mar & 500 & 21 \\ \hline Apr & 1200 & 21 \\ \hline May & 1500 & 22 \\ \hline Jun & 1100 & 20 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Cost and Demand Infermation (calculated): } \\ \hline Demand (Total) & \\ \hline Production Days (Total) & \\ \hline Averare Demand Fer Day & \\ \hline Workforee Required io Froduce Average Demand aly & \\ \hline Minimum Demand per Mooth & \\ \hline Wotkforer Required io Foduce Mlinimum Deniand & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline \multicolumn{3}{|c|}{ Demand data (given): } \\ \hline Month & Expected Demand & Productien Days \\ \hline Jam & 900 & 22 \\ \hline Fcb & 700 & 18 \\ \hline Mar & 800 & 21 \\ \hline Apr & 1200 & 21 \\ \hline May & 1500 & 22 \\ \hline J & 1100 & 20 \\ \hline \end{tabular} mect by subcontracting) coatracted tiaits Subeontractiong Cost \begin{tabular}{l|l|l|} benthly demand & (Dliring Cent) & (L.ayefr Cost) \end{tabular}