Apple Inc. (not the computer) is located in Washington state. They want to produ

Apple Inc. (not the computer) is located in Washington state. They want to produce apples on newly required land or they could do nothing. The new apples will be gala and granny smith. Some industry publications has released the following data:Granny smith demandGala demand Weak StrongWeak .10 .40Strong .20 .30Revenue projections shows an annual contribution to profit of $15000 if Apple Inc. only produces gala apples and demand is weak for gala apples. However $50000 can be earned if only gala apples are produced and demand is strong. If Apple Inc. only plants granny smith apples then $10000 can be earned if demand is weak and $70000 if demand is strong.If Apple Inc. produces both apples then look at the following table:Granny smith demandGala demand Weak StrongWeak $13000 $45000Strong $17000 $55000What is the decision to be made and how much is the profit contribution for all options? Show all your work using the excel add in. Show all branch solutions.