Question Five (15 marks) You are newly appointed to the position of factory manager. The management has asked you to maximize the total profit amount based on the available resources. The factory you managed produces four different types of wooden door. Each type of door is made by gluing and pressing together a different mixture of cedarwood and pinewood. The following table summarizes the required amount of gluing, pressing, and a mixture of wood required to produce each type of wooden door: Door Design Spring Summer Autumn Winter Total Profit Quantity Progit $350 $950 $800 $400 $0 Resources Used per Door Design Used Available Glue 6 7 8 5 0 12580 20 35 30 25 50000 Pressing Cedar Wood Pinewood 56 27 43 28 ololo 75000 45 51 32 22 70000 Demand 520 380 450 520 Indicated on the table, you have 12580 quarts of glue, 50000 hours of pressing capacity, 75000 pieces of cedarwood, and 70000 pieces of pinewood available. Each door can be sold at a profit of $350, $950, $800, and $400, respectively. The demand projected for the next financial quarter on each door type is 520 for Spring, 380 for Summer, 450 for Autumn, and 520 for Winter. You are required to reproduce the table on a spreadsheet, build in the appropriate formula, and in Solver to set the objective function, the calculation fields, and necessary constraints to compute the maximum total profit value. Question Five (15 marks) You are newly appointed to the position of factory manager. The management has asked you to maximize the total profit amount based on the available resources. The factory you managed produces four different types of wooden door. Each type of door is made by gluing and pressing together a different mixture of cedarwood and pinewood. The following table summarizes the required amount of gluing, pressing, and a mixture of wood required to produce each type of wooden door: Door Design Spring Summer Autumn Winter Total Profit Quantity Progit $350 $950 $800 $400 $0 Resources Used per Door Design Used Available Glue 6 7 8 5 0 12580 20 35 30 25 50000 Pressing Cedar Wood Pinewood 56 27 43 28 ololo 75000 45 51 32 22 70000 Demand 520 380 450 520 Indicated on the table, you have 12580 quarts of glue, 50000 hours of pressing capacity, 75000 pieces of cedarwood, and 70000 pieces of pinewood available. Each door can be sold at a profit of $350, $950, $800, and $400, respectively. The demand projected for the next financial quarter on each door type is 520 for Spring, 380 for Summer, 450 for Autumn, and 520 for Winter. You are required to reproduce the table on a spreadsheet, build in the appropriate formula, and in Solver to set the objective function, the calculation fields, and necessary constraints to compute the maximum total profit value
