all information is here and all drop downs included, solve for (D29) thanks

D G 7% 5% 2% 9% 20% $2.00 billions $2.40 billions $2.10 billions 100 thousand 1 Input Parameter 2 Production Adjustment 3 Inflation 4 Discount Rate 5 Surplus Discount 6 7 Initial investment 8 At least 9 At most 10 Most likely 11 12 Initial Production 13 Demand 14 Initial Mean 15 Std. Dev. 16 17 Sales Price 18 Cost 19 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 95 thousand 7 thousand $13.00 thousand $9.50 thousand Year 2 Year 3 Year 4 Year 5 Year 2 Year 3 Year 4 Year 5 19 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Cost 33 Discount Price 34 35 Revenue from full price 36 Revenue from discounted 37 Cost Production 38 39 Profit 40 41 Net Present Value 42 Initial Investment 43 44 Net Profit After Investment The screenshot above shows first five years of the Major Company problem. You can download the excel file and the problem Statement by clicking here. Consider the Major Motors Corporation problem and the screenshot above. Using dropdowns, construct the inflation rate in year 2 Cell D29) Select Select Select Select 1 Year 2 Year 3 Year 4 Year 5 Year 1 Production Amount Demand 20 21 Calculations 22 23 24 25 26 27 28 29 30 31 32 33 Sales Amout Sold at Discount Inflation rate Sales Price Cost Discount Price 34 35 36 37 38 39 Revenue from full price Revenue from discounted Cost Production Profit sent Value nvestment nvestment Select] =MAXI RANDBETWEEN GenPoisson GenBinomial - GenUniform GenNormalt SimOutput Gen Triangular GenTablet =MING simParameter Select) irst five years of the Major Company problem. You can download the excel file and the problem rporation problem and the screenshot above. Using dropdowns, construct the inflation rate in Select Select Select Year 2 Year 3 Year 4 Year 5 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Select] 33 Disc C29 34 35 Revenue fron D29 36 Revenue from d C26 C3 37 Cost C31 38 C2 39 C15 40 C23 D24 41 Net Prei D23 42 Initial i C10 43 C18 CB 44 Net Profit After C14 C17 The screenshot above shows fi C5 statement by clicking here C9 C32 Consider the Major Motors Co C24 year 2 (Cell D29). D3 D26 CA Jany problem. You can download the excel file and the problem nshot above. Using dropdowns, construct the inflation rate in Select Select + [Select 1 Select . Year 2 Year 3 Year 4 Year 5 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Cost 33 Discount Price 34 35 Revenue from full price 36 Revenue from discounted 37 Cost Production 38 39 Profit 40 41 Net Present Value 42 Initial Investment 43 44 Net Profit After Investment Select 1 C23 C18 C10 . C3 C24 D3 C26 024 . C32 D26 C29 C9 C2 D23 D29 . CB C14 . C4 the excel file and the problem The screenshot above shows first five years of the Major Comp statement by clicking here Consider the Major Motors Corporation problem and the scree year 2 (Cell D29). C5 C17 construct the inflation rate in - C15 C31 [Select Select) Select Select Year 5 20 21 Calculations 22 Year 1 Year 2 Year 3 23 Year 4 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Cost Select 33 Discount Price . C8) 34 D24) 35 Revenue from full price C24) D3) Revenue from discounted C17) 37 Cost Production D23) 38 39 C5) Profit .C3) 40 C15) 41 Net Present Value C4) 42 Initial Investment C10) ) 43 D29) 44 Net Profit After Investment C31) C23) The screenshot above shows first five years of the Major Company problem. You can download C2) statement by clicking here ! C18) Consider the Major Motors Corporation problem and the screenshot above. Using dropdowns, C29) C14) year 2 (Cell D29). C32) D26) Select) Select Select) Select 36 C9) C26) D G 7% 5% 2% 9% 20% $2.00 billions $2.40 billions $2.10 billions 100 thousand 1 Input Parameter 2 Production Adjustment 3 Inflation 4 Discount Rate 5 Surplus Discount 6 7 Initial investment 8 At least 9 At most 10 Most likely 11 12 Initial Production 13 Demand 14 Initial Mean 15 Std. Dev. 16 17 Sales Price 18 Cost 19 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 95 thousand 7 thousand $13.00 thousand $9.50 thousand Year 2 Year 3 Year 4 Year 5 Year 2 Year 3 Year 4 Year 5 19 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Cost 33 Discount Price 34 35 Revenue from full price 36 Revenue from discounted 37 Cost Production 38 39 Profit 40 41 Net Present Value 42 Initial Investment 43 44 Net Profit After Investment The screenshot above shows first five years of the Major Company problem. You can download the excel file and the problem Statement by clicking here. Consider the Major Motors Corporation problem and the screenshot above. Using dropdowns, construct the inflation rate in year 2 Cell D29) Select Select Select Select 1 Year 2 Year 3 Year 4 Year 5 Year 1 Production Amount Demand 20 21 Calculations 22 23 24 25 26 27 28 29 30 31 32 33 Sales Amout Sold at Discount Inflation rate Sales Price Cost Discount Price 34 35 36 37 38 39 Revenue from full price Revenue from discounted Cost Production Profit sent Value nvestment nvestment Select] =MAXI RANDBETWEEN GenPoisson GenBinomial - GenUniform GenNormalt SimOutput Gen Triangular GenTablet =MING simParameter Select) irst five years of the Major Company problem. You can download the excel file and the problem rporation problem and the screenshot above. Using dropdowns, construct the inflation rate in Select Select Select Year 2 Year 3 Year 4 Year 5 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Select] 33 Disc C29 34 35 Revenue fron D29 36 Revenue from d C26 C3 37 Cost C31 38 C2 39 C15 40 C23 D24 41 Net Prei D23 42 Initial i C10 43 C18 CB 44 Net Profit After C14 C17 The screenshot above shows fi C5 statement by clicking here C9 C32 Consider the Major Motors Co C24 year 2 (Cell D29). D3 D26 CA Jany problem. You can download the excel file and the problem nshot above. Using dropdowns, construct the inflation rate in Select Select + [Select 1 Select . Year 2 Year 3 Year 4 Year 5 20 21 Calculations 22 Year 1 23 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Cost 33 Discount Price 34 35 Revenue from full price 36 Revenue from discounted 37 Cost Production 38 39 Profit 40 41 Net Present Value 42 Initial Investment 43 44 Net Profit After Investment Select 1 C23 C18 C10 . C3 C24 D3 C26 024 . C32 D26 C29 C9 C2 D23 D29 . CB C14 . C4 the excel file and the problem The screenshot above shows first five years of the Major Comp statement by clicking here Consider the Major Motors Corporation problem and the scree year 2 (Cell D29). C5 C17 construct the inflation rate in - C15 C31 [Select Select) Select Select Year 5 20 21 Calculations 22 Year 1 Year 2 Year 3 23 Year 4 Production Amount 24 Demand 25 26 Sales Amout 27 Sold at Discount 28 29 Inflation rate 30 31 Sales Price 32 Cost Select 33 Discount Price . C8) 34 D24) 35 Revenue from full price C24) D3) Revenue from discounted C17) 37 Cost Production D23) 38 39 C5) Profit .C3) 40 C15) 41 Net Present Value C4) 42 Initial Investment C10) ) 43 D29) 44 Net Profit After Investment C31) C23) The screenshot above shows first five years of the Major Company problem. You can download C2) statement by clicking here ! C18) Consider the Major Motors Corporation problem and the screenshot above. Using dropdowns, C29) C14) year 2 (Cell D29). C32) D26) Select) Select Select) Select 36 C9) C26)