(EXCEL)

Sandy Edge is president of Edge File Works, a firm that manufactures two types of metal file cabinets. The demand for the two-drawer model is 650 cabinets per week; demand for the three-drawer cabinet is 400 per week. Edge has a weekly operating capacity of 1,600 hours, with the two-drawer cabinet taking 1.5 hours to produce and the three-drawer cabinet requiring 2 hours. Each two-drawer model sold yields a $12 profit, and the profit for the three-drawer model is $14. Edge has listed the following goals: Goal 1: Attain a profit as close to $12,000 as possible each week. Goal 2: Avoid underutilization of the firm's production capacity. Goal 3: Sell as many two- and three-drawer cabinets as the demand indicates. Set up and solve this problem as a goal programming model using following methodsa. Consider goal 1 to be 3 time more important than goal 2, and 4 times more important than goal 3. Solve using weighted method. b. Consider the 3 goals to be equally important. Solve using weighted method. c. Consider goal 1 to be your top priority (Rank 1), goal 2 to be second priority (Rank 2) and goal 3 to be third priority (Rank 3). Solve using Rank method.

Sandy Edge is president of Edge File Works, a rm that manufactures two types of metal le cabinets. The demand for the twodrawer model is 650 cabinets per week; demand for the threedrawer cabinet is 400 per week. Edge has a weekly operating capacity of LEDD hours, with the hyo-drawer cabinet talcing 1.5 hours to produce and the threedrawer cabinet requiring 2 hours. Each twodrawer model sold yields a $12 prot. and the prot for the th reed rawer model is $14. Edge has listed the following goals: Goal 1: Attain a prot as close to $12,0lII as possible each week. Goal 1: Avoid underutilization of the rm's production capacity. Goal 3: Sell as many two and three-drawer cabinets as the demand indicates. Set up and solve this problem as a goal programming model using following methods- a. Consider goal 1 to be 3 time more important than goal 2. and 4 times more important than goal 3. Solve using weighted method. . Consider the 3 goals to be equally important. Solve using weighted method. c. Consider goal 1 to be your top priority [Rank 1}. goal 2 to be second priority {Rank 2] and goal 3 to be third priority {Rank 3}. Solve using Rank method