Accra Brewery Ltd is planning a one week advertising campaign for its new product targeted at theYouth, theMiddle-Aged, and theAgedof a small town. The population of the town is 3000 which is equally divided between the Youth, the Middle-Aged, and the Aged. Two television stations (TV3 and GTV), and one radio station (Adom Radio) are under consideration. The cost per minute advertisement on TV3, GTV, and Adom Radio is GH1600, GH1100, and GH1200 respectively. Information available indicates that, a minute of advertisement on TV3 can reach 4%, 3.2%, and 4% of the Youth, Middle-Aged, and the Aged population respectively, whiles a minute advertisement on GTV can reach 1.5%, 1.6%, and 3% of the Youth, Middle-Aged, and the Aged respectively. On the other hand, a minute advertisement on Adom Radio can reach 1%, 2%, and 4% of the Youth, Middle-Aged, and the Aged respectively. Accra Brewery will want to reach at least 10% of the Youth population, at least 32% of the Middle-Aged population, and at least 60% of the Aged population. There must be at least 4 minutes of advertisement on TV3 within the week. However, there must be no more than 8 minutes of advertisement within the week on Adom Radio.

Formulate and solve using Excel Solver, a linear program that can be used to determine the number of minutes of advertisement to be placed on TV3, GTV, and Adom Radio