all information is here, all dropdowns included solve for (D32) thanks

D E A 7% 5% 2% 9% 20% 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 $2.00 billions $2.40 billions $2.10 billions 100 thousand 95 thousand 7 thousand $13.00 thousand $9.50 thousand 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 22 Sold at Discount 28 Inflation rate 30 31 Sales Price Cost Year 2 Year 3 Year 4 Year 5 Year 2 Year 2 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 Net Profit After trivestment 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 cost in year 2 Cel D321 5 Select Select # Select Year 2 Year 3 Year 4 Year 5 Year 1 Production Amount Demand Sales Amout Sold at Discount Inflation rate Sales Price Cost Discount Price 20 21 Calculations 22 23 24 25 26 27 28 29 30 31 32 33 Select 1 C14 C10 C31 C15 C20 02 C3 026 CB 03 C32 024 D29 1 C23 C6 C4 026 [ C24 023 full price counted oduction Profit int Value estment estment five years of the Major Company problem. You can download the excel file and the problem oration problem and the screenshot above. Using dropdowns, construct the cost in year 2 (Cell Select 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 Cost 33 Discount Price 34 35 Revenue from full price 36 Revenue from discounted 37 Cost Production 38 39 Profit 40 Net Present Value 42 Initial Investment 43 44 Net Profit After Investment The screenshot above shows first five years of the Maior Company problem. You can download the excel file and the problem statement by clicking here Select Consider the Major Motors Corp shot above. Using dropdowns, construct the cost in year 2 (Cell 032) Select Select Select : [Select Select 20 21 Calculations Year 1 22 Year 2 Year 3 Year 4 Year 5 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 Select Consider the Major Motors Corporation problem and the screens 12 bnstruct the cost in year 2 (Cell D32) (0 (1 Select) . [Select Select Select Select 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 Sales Amout Sold at Discount Inflation rate Sales Price Cost Discount Price 31 32 33 34 35 36 37 38 39 40 41 42 43 Revenue from full price Revenue from discounted Cost Production Profit Net Present Value Initial restment 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. Select Consider the Major Motors Corporation problem and the screenshot above. Using dropdowns, co 0321 Select Select 2 1 Select . Select Year 2 Year 3 Year 4 Year 5 Year 1 Production Amount Demand 20 25 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 35 36 37 38 39 40 Revenue from full price Revenue from discounted Cost Production Profit Select 024) C10) 017) C14) D2a) 026) C261 C5) CO) C31) CB) C24) C18) C23 015) C32) 42 Net Present Value Initial investment 43 44 Net Profit Alter 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 cost in pear 2 (Cell 032) 029) C3) 0291 C4) C23) 031 Select Select Select 1 Select) D E A 7% 5% 2% 9% 20% 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 $2.00 billions $2.40 billions $2.10 billions 100 thousand 95 thousand 7 thousand $13.00 thousand $9.50 thousand 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 22 Sold at Discount 28 Inflation rate 30 31 Sales Price Cost Year 2 Year 3 Year 4 Year 5 Year 2 Year 2 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 Net Profit After trivestment 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 cost in year 2 Cel D321 5 Select Select # Select Year 2 Year 3 Year 4 Year 5 Year 1 Production Amount Demand Sales Amout Sold at Discount Inflation rate Sales Price Cost Discount Price 20 21 Calculations 22 23 24 25 26 27 28 29 30 31 32 33 Select 1 C14 C10 C31 C15 C20 02 C3 026 CB 03 C32 024 D29 1 C23 C6 C4 026 [ C24 023 full price counted oduction Profit int Value estment estment five years of the Major Company problem. You can download the excel file and the problem oration problem and the screenshot above. Using dropdowns, construct the cost in year 2 (Cell Select 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 Cost 33 Discount Price 34 35 Revenue from full price 36 Revenue from discounted 37 Cost Production 38 39 Profit 40 Net Present Value 42 Initial Investment 43 44 Net Profit After Investment The screenshot above shows first five years of the Maior Company problem. You can download the excel file and the problem statement by clicking here Select Consider the Major Motors Corp shot above. Using dropdowns, construct the cost in year 2 (Cell 032) Select Select Select : [Select Select 20 21 Calculations Year 1 22 Year 2 Year 3 Year 4 Year 5 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 Select Consider the Major Motors Corporation problem and the screens 12 bnstruct the cost in year 2 (Cell D32) (0 (1 Select) . [Select Select Select Select 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 Sales Amout Sold at Discount Inflation rate Sales Price Cost Discount Price 31 32 33 34 35 36 37 38 39 40 41 42 43 Revenue from full price Revenue from discounted Cost Production Profit Net Present Value Initial restment 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. Select Consider the Major Motors Corporation problem and the screenshot above. Using dropdowns, co 0321 Select Select 2 1 Select . Select Year 2 Year 3 Year 4 Year 5 Year 1 Production Amount Demand 20 25 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 35 36 37 38 39 40 Revenue from full price Revenue from discounted Cost Production Profit Select 024) C10) 017) C14) D2a) 026) C261 C5) CO) C31) CB) C24) C18) C23 015) C32) 42 Net Present Value Initial investment 43 44 Net Profit Alter 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 cost in pear 2 (Cell 032) 029) C3) 0291 C4) C23) 031 Select Select Select 1 Select)