Problem 1 Decisin Variables (2 pts): Solver solution (1 pts) [create the excel tables below this box) Urtadn Solutions Iric., is a manufacturer of lurich buggs. The derrarid in the riext four months is expetied to be 350, 500, 800, and 850 espectively. - With its current production facility, the company can produce maximum BDD Iunch bags eachi month. Dbjective Fucmtion (1.5 pts): - The corriparty would like to meet all the expecled derrarnd, so it will nested to Larry imventory to meat demand in later months. - Eiach lunch bag sold generates a revvenue uf 56. - Eiach unit in imventary at the end of a month posts \$2 - Urtoan solutions has 25 lunch basgs in irwentory to start the production plan. Constraints (2.5pts) Subject to, Wrtan scluticas top management has given you the assignment of mociesling this probsesm tn find the production plan for the next four months. In particular, ynu are asked to dretermine hnw many lunch hags to produce in cach manth 50 thet you satisfy the monthly drmand. They want to to maximize the total profit imnney gained from sales minus the invertory castal Formulate the ahcwc problem matheratically as lincar programming modrl: + Define you decsion variables clearly and use them to formulate the objective function and constraints. Finally, combine swerything to get the final moxcl. Solve the problem using solwer and giwe a briaf interpretation of the results. Interpretation of results (0.5pts)