Need help with the last table, thank you!

The sales of the company for each product can be calculated based on an cutlock for its market share of the product. The compary's market share of Product A is expected to be flat. The company's market share of Product b is expected to decline by 5% this year because of a new entrant but will then remain flat thereafter. Capacity Expansion Model Product A and B require the same amount of capacity to manufacture. That simplifies the analysis of capacity as we can measure capacity in 'un The compary will choose to deploy scarce capacity on the most profitable products. The price of Product A is $110 and the price of Product B is $100. Therefore, the company will manufacture Product A before Product B. The company currently has 500 units of capacity. The Unit Sales Given Capacity Constraints forecast of sales is based on the scenario that no capacity is added. Write formulas in the ereen boxes below to calculate how many units of each product would be sold. Hint : You will need to use a MIN/MAX/IF function. The sales of the company for each product can be calculated based on an cutlock for its market share of the product. The compary's market share of Product A is expected to be flat. The company's market share of Product b is expected to decline by 5% this year because of a new entrant but will then remain flat thereafter. Capacity Expansion Model Product A and B require the same amount of capacity to manufacture. That simplifies the analysis of capacity as we can measure capacity in 'un The compary will choose to deploy scarce capacity on the most profitable products. The price of Product A is $110 and the price of Product B is $100. Therefore, the company will manufacture Product A before Product B. The company currently has 500 units of capacity. The Unit Sales Given Capacity Constraints forecast of sales is based on the scenario that no capacity is added. Write formulas in the ereen boxes below to calculate how many units of each product would be sold. Hint : You will need to use a MIN/MAX/IF function