Can you solve the above question using Excel Solver? I want to see how this problem is solved using Excel Solver.

A leather company is adding temporary workers to produce its new Fall line of leather goods. The company projects that it will need 200,000 additional items for May, 300,000 for June, 270,000 for July, and 150,000 for August. Management can hire both experienced and novice workers on a temporary basis. After one month, novice workers are then classified as apprentices; after two months, they are considered "experienced" workers. Cost and productivity estimates for temporary workers are as follows: Temporary workers are hired at the beginning of a month, and when they are terminated, this occurs at the end of a month. All temporary workers must be terminated by the end of August. Prepare a report recommending an optimal hiring/termination policy over the fourmonth period which minimizes total costs while meeting the additional production requirements. Include an analysis of the effects of changes on training and ternination costs and on required production quotas