QUESTION 1\ Applying the Learning Curve:\ Trinity enterprises manufactures sophisticated satellite based communication systems. The company introduced a new model VX3000 in January 2023. The company can produce only one system per month. The following table provides the number of DL hours consumed for the production of VX3000 during the last year.\ \\\\table[[Month,\\\\table[[# of units],[produced]],\\\\table[[DL hours],[consumed]]],[January,1,1000],[February,1,850],[March,1,773],[April,1,723],[May,1,686],[June,1,657],[July,1,634],[August,1,614],[September,1,597],[October,1,583],[November,1,570],[December,1,558]]\ After studying the data on DL hours consumed for the production of VX3000, the production manager made a statement that an incremental unit time learning curve model is applicable for the consumption of DL hours. You have been given the above data and tasked with the job of predicting the future DL hours requirement.\ Required:\ a) Using excel, prepare a graph of cumulative # of units produced Vs Cumulative total time, cumulative average time per unit and time taken for the last unit produced. (Check the Excel file for chapter 3 for the format)\ b) Do a regression analysis to estimate the learning curve model. Your model should be "Time taken to produced the last single unit = Time taken to produce the first unit

x

(Cumulative number of units produced)

^(q)

where

q=

rate of learning expressed as a % as defined in the PowerPoint notes. You should show the regression output as well as the "fit plot" of fitted equation as in the excel file for chapter 3\ c) Based on your learning curve model, predict the DL hours expected to be consumed for the unit to be built in January of next year.

Applying the Learning Curve: 15 points Trinity enterprises manufactures sophisticated satellite based communication systems. The company introduced a new model VX3000 in January 2023 . The company can produce only one system per month. The following table provides the number of DL hours consumed for the production of VX3000 during the last year. After studying the data on DL hours consumed for the production of VX3000, the production manager made a statement that an incremental unit time learning curve model is applicable for the consumption of DL hours. You have been given the above data and tasked with the job of predicting the future DL hours requirement. Required: a) Using excel, prepare a graph of cumulative \# of units produced Vs Cumulative total time, cumulative average time per unit and time taken for the last unit produced. (Check the Excel file for chapter 3 for the format) b) Do a regression analysis to estimate the learning curve model. Your model should be "Time taken to produced the last single unit = Time taken to produce the first unit X (Cumulative number of units produced) q where q= rate of learning expressed as a \% as defined in the PowerPoint notes. You should show the regression output as well as the "fit plot" of fitted equation as in the excel file for chapter 3 c) Based on your learning curve model, predict the DL hours expected to be consumed for the unit to be built in January of next year