please this problem solve in EXCEL SOLVER

Problem Formulation We will now write the objective function and the constraints for the Electronic Communi- cations problem. We begin with the objective function. Objective function: Maximize profit Four constraints are needed to account for the following restrictions: (1) a limited adver- tising budget, (2) limited sales force availability, (3) a production requirement, and (4) a re- tail stores distribution requirement. Constraint 1 Advertising expenditures Budget Constraint 2 Sales time used s Time available Constraint 3 Radios produced = Management requirement Constraint 4 Retail distribution 2 Contract requirement These expressions provide descriptions of the objective function and the constraints. We are now ready to define the decision variables that will represent the decisions the man- ager must make. For the Electronic Communications problem, we introduce the following four decision variables: M = the number of units produced for the marine equipment distribution channel B = the number of units produced for the business equipment distribution channel 8.6 Electronic Communications Problem 327 R= the number of units produced for the national retail chain distribution channel D = the number of units produced for the direct mail distribution channel Using the data in Table 8.3, we can write the objective function for maximizing the to- tal contribution to profit associated with the radios as follows: Max 90M + 84B + 7OR + 60D Let us now develop a mathematical statement of the constraints for the problem. For the ad- vertising budget of $5000, the constraint that limits the amount of advertising expenditure can be written as follows: 10M + 8 + 9R + 150 = 5000 Similarly, with sales time limited to 1800 hours, we obtain the constraint 2M + 3B + 3R = 1800 Management's decision to produce exactly 600 units during the current production period is expressed as M+B+R+D - 600 Finally, to account for the fact that the number of units distributed by the national chain of retail stores must be at least 150, we add the constraint R2 150 Combining all of the constraints with the nonnegativity requirements enables us to write the complete linear programming model for the Electronic Communications problem as follows: Max 90M + 84B + 7OR +60D S.L. 10M + 8 + 9 + 150 S 5000 Advertising budget 2M + 3B + 3R S 1800 Salesforce availability M + B+ R+ D = 600 Production level R 2 150 Retail stores requirement M. B, RD 20