Problem 3 Radio Production and Workforce Management. Another electronics company needs to produce at least 20,000 radios in a four week period. The revenue per unit sold in each week is given below: The company initially has 40 workers which each produce 50 radios per week. Table 1: Add caption It is possible to hire apprentice workers who will need to be trained. For training, up to three apprentices are assigned to a single worker for one week. During this week, the worker produces no radios. After the week all of the apprentices graduate to workers and begin to produce radios. There is no limit to the number of apprentices to hire aside that every group of three apprentices require an additional worker to train them. A worker costs 200 euros per week while an apprentice costs only 100. Let xi be the number of workers assigned to production of radios in week i,yi be the number of workers assigned to train new apprentices in week i, and zi be the number of apprentices to hire in week i. Use these variables to formulate a linear program which will maximize profit over the four weeks in question. Solve the LP using Excel-solver and report both your LP and its optimal solution in your submission