urgent please solve using excel

2) A start-up company is considering entering the market with what they believe to be a smaller and faster computer than some of the existing products on the market. They want to get a feel for whether or not customers would be willing to switch from some of the existing bigger brands to consider their product. They want to collect a reasonable sample from across the country representative of all age brackets. They have split the country into 2 regions: North and South. They want at least 65% of their sample to cover the North and no fewer than 25% of the South. They also have divided the age groups into 3 categories: 18-35, 36-69, and 70 and up. They want at least 50% of their sample to be between 18 and 35 and at least 40% to be between 36 and 69. The costs per person surveyed is given in the table below: Region North South 18-35 $2.50 $3.50 36-69 $2.00 $3.00 70 and up $1.50 $2.00 Assume that at least 1,000 people are to be surveyed. The problem for the company is to decide how many people to survey from each age bracket within each region in order to minimize costs while meeting requirements. Setup this as an appropriate programing problem and find the optimal solution and minimum cost in Excel using solver. Show all your work