COMMERCE 3QA3 Midterm: brs_mdm3_tif_ch03
13 Feb 2019
School
Department
Course
Professor
Document Summary
Chapter 3 linear programming modeling applications with computer analyses in excel. Difficulty: easy: the objective function of a transportation problem is to, maximize transportation cost, maximize supply quantities, minimize total demand, minimize total shipping cost, minimize production cost. 1: in a multi-period production scheduling application, the objective function is to, minimize production and inventory costs, minimize demand over the production horizon, maximize capacity over the production horizon, minimize capacity over the production horizon, maximize inventory. Consider the following product mix problem and its associated spreadsheet model. 3x1 + 3x2: refer to the spreadsheet above. What formula should be entered in cell d3 to compute total profitability: =sumproduct(b1:c1,b3:c3, =sum(b3:c3, =b2*b3 + c2*c3, =sumproduct(b3:c3,e6:e8, =b1*b3 + c1*c3. Which cell(s) specifies the "changing cells" in solver: b1:c1, d6:d8, b3:c3, d3, b2:c2. Which cell(s) designates the objective function as specified in. Which equation should be entered in cell d8 to compute the consumption of resource 3 (i. e. , constraint #3): =sumproduct(b1:c1,b8:c8, =sumproduct(b2:c2,b7:c7, =sumproduct(b2:c2,b8:c8, =sumproduct(d6:d8,e6:e8, =sumproduct(b2:c2,e6:e8)
