Question one: cell G$2-$ Enter a formula that results in the estimated number of units to produce using the data in row two.

Question two: cell I$2-$ Enter a formula that result in the budgeted sales amount in dollars using the data in row two

The next questions are in relation to a pivot table, please tell me how to set up the table to get the right answers. The filters are product, region, estimated beginning inventory, desired ending inventory, expected unit sales, units to produce, unit sales price, total estimated sales.

Question one: How many units of product eight should be produced to cover estimated sales and desired ending inventory for all regions?

Question two: How many units of expected sales of products two, nine, and $14$ combined were reported by the region with the second highest number of units?

Question three: How many units in the bay delta region are required for the product with the fewest number of units to be produced?

Question four: What percentage of units to produce of products five and $12$ in all regions are represented by the blue ridge region and the marine region combined?