A manufacturing company wants to maximize profits on products A, B, and C. The profit margin is $3 for A, $6 for B, and $15 for C. The production requirements and departmental capacities are as follows: Department | Production requirement | Departmental capacity by product (hours) A B C 2 3 2 Total hours) Assembling Painting Finishing 30,000 38,000 28,000 Formulate the LP Problem and solve using Excel Solver. 7) What is the maximum profit in this model?
8) What is the maximum profit if the profit margin on A changes to $7.00
9) What is the maximum profit if the profit margin on C changes to $10.00
10) What is the maximum profit if the capacity of the finishing department changes to 33,000 hours
11) What is the maximum profit if the capacity of the painting department changes to 40,000 hours
7)
8)
9)
10)
11)

Problem 8-6 cullumber company is a multi product firm. presented below is information concerning one of its products, the hawkeye. date transaction quantity price/cost 1/1 beginning inventory 2,700 $17 2/4 purchase 3,700 26 2/20 sale 4,200 43 4/2 purchase 4,700 33 11/4 sale 3,900 47 calculate average-cost per unit. (round answer to 4 decimal places, e. g. 2.7613.) average-cost per unit $ link to text compute cost of goods sold, assuming cullumber uses: (round average cost per unit to 4 decimal places, e. g. 2.7631 and final answers to 0 decimal places, e. g. 6,548.) cost of goods sold (a) periodic system, fifo cost flow $ (b) perpetual system, fifo cost flow $ (c) periodic system, lifo cost flow $ (d) perpetual system, lifo cost flow $ (e) periodic system, weighted-average cost flow $ (f) perpetual system, moving-average cost flow $ click if you would like to show work for this question: open show work