Question

Reconsider the Wyndor Glass Co. case study introduced in Section 2.1/ in class. Suppose that the estimates of the unit profits for the two new products now have been revised to $500 for the doors and $350 for the windows. A curve-fitting procedure was used to estimate the weekly marketing costs required to sustain a production rate of D doors and W windows: • Marketing cost for doors = $25D2 • Marketing costs for windows = $6662 Hours Used Per Unit Produced : Available Doors Windows hours for each plant Plant 1 0 4 Plant 2 0 2 12 Plant 3 3 2 18 1 Questions: a. Formulate the model algebraically. (Please clearly define all the decision variables, clearly write down the objective function and each constraints) b. Formulate and solve the model for this problem on a spreadsheet and use solver to solve it. (The number of the products are NOT required to be integer.)

Answer 1

formulahon of a Lineao Doogramming a Problem Decisions to be made as the number of Door , Windows of products to be produced every hour so as to maximize their total prohits Hit Number of Doors of product 1 produ M2 3 Number of Windows of produce ze total proht per hour ( is dollars) Thus In, and ne are decision variable for the modell 5oon, +.350 12 op himal Runction z z spobjective hinchon maximize Zz Soon, + 35012 ► Decision variable In, and 12 Mathematically we get Maximize 500n, +35042 hinchor z z subject to constraints mi 34, 36ons- Strant 2n2 s 12 3n+212.< 18 Nazo and nizo Decision variable,

30,+242<18 (3 used solver to solve the app problem Max Ze 300 M +350M2 subject to constricants x, su 212 12 n, zo nazo g. solved in MS Excel conclusion y PLEASE DO UPROTE THANK YOU I

Book2 Product Activation Failed) [email protected] Insert Page Layout Formas Data "Review View Help Tell me what you want to do Share FTS Eta WA ? Solver 1 A1 A2 ΚΙΣΙΣ Now 21 Sort S: Geography Filter Text to Outline Refresh All- Connections Columns - Data Tools What-If Forecast Analysis - Sheet Forecast Get Transform Types Sort & Filter Analyze 4 A B с D E F G H 1 K L M N O 1 2 3 wyndoor glass co.product mix problem 4 5 6 7 8 9 10 11 plant door plant 1 plant 2 plant 3 profit/uni 500& window avaliable hours for each plant 1 0 4 o 2 12 2 2 18 toatal pro toatal profit for door is &500 and for chair is&350.determine thed toatal profit for door is &500 and for chair is&350.determine the $350 12 maximum capacity Decision varaible contribution Door Window Total 0 85899348 500 350 3.01E+10 1 13 14 15 16 17 18 19 20 21 Plant 1 Plant 2 Plant 3 0 o 2 1.72E+ 2 1.72E+05 4 12 0 3 18