Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started