a. Write a linear optimization model (i.e., identify decision variables, objective function and constraints) b. Use Solver in EXCEL to solve the following problems and highlight the optimal solutions in your Excel files. Production Planning. The Bogard Corporation produces three types of bookcases, which it sells to large office supply companies. The production of each bookcase requires two machine operations, trimming and shaping, followed by assembly, which includes inspection and packaging. All three types require 0.4 hours of assembly time, but the machining operations have different processing times, as shown in the following table, in hours per unit: Standard Narrow Wide Trimmer 0.2 0.4 0.6 Shaper 0.6 0.2 0.5 Each machine is available 150 hours per month, and the current size of the assembly department provides capacity of 600 hours. Each bookcase produced yields a unit profit contribution as follows: Standard Narrow Wide Profit $8 $6 $10 What are the optimal production quantities for the company? What is the pattern in the optimal allocation?
https://papershelpdesk.com/wp-content/uploads/2021/05/Logo-300x75.png 0 0 admin https://papershelpdesk.com/wp-content/uploads/2021/05/Logo-300x75.png admin2021-12-29 18:49:372021-12-29 18:49:37The bogard corporation produces three types of bookcases, which it
All the information and papers on papershelpdesk.com website are published in good faith and for research and reference purposes only. We do not allow submitting these papers as it is for academic credit.