a.
Variable Definition:
X = Number of doors
Y = Number of windows
Objective function:
Wyndor Glass Company would like to maximize their profits.
Profit = revenue - cost
Profit = [500X + 350Y] - [ 25D2 + 66W2]
Profit = 500X + 350Y - 25D2 - 66W2
Therefore we can write that,
Maximize Z = 500X + 350Y - 25D2 - 66W2
Constraints:
1X <=4 .............Constraint as limited time available at plant 1
2Y <=12 .............Constraint as limited time available at plant 2
3X + 2Y <=18...........Constraint as limited time available at plant 3
X,Y >=0 ............Non-negativity constraint as number of doors and windows cannot be negative
b.
Now solving using excel.
Framing problem in excel as below:
Formulas shown below
Now solve using solver function from the Data tab in the menu bar:
1. Set objective as shown in the figure below to MAX
2. Add constraints as shown in the figure below from clicking the Add button on right side of solver window
3. Set the solving method to GRG Non-linear
4. Click Solve
Final solution by excel
Therefore,
X = Number of doors = 2
Y = Number of windows = 6
Profit = $ 5,376
Reconsider the Wyndor Glass Co. case study introduced in Section 21/ in class. Suppose that the...
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...
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 = $66W2 Hours Used Per...
Please write an 1. executive overview of the above case study. 2. in detail, what is the critical issue or problem in the above case study. 3. please provide a detailed analysis of the cause of the issue or problem in the above case study. 國connect VIDEO CASE 1 Chobani: Making Greek Yogurt a Household Name Everybody should be able to enjoy a pure, simple cup of yogurt. And that's what Chobani is," says The very first cup for sale...
109 CASE STUDY Dream Desk Compary Dream Desk Company is a major supplier of office desks for can profit from this market growth if prices can be held in line home and business. The company has been in existence since 1875. Affler serving an apprenticeship as a cabinet maker in the and quick delivery can be promised. Dream Desk operates a 250,000 sq. ft. manufacturing fa- cast, George Dreamer had a violent disagreement with the shop eility in Casa Petite,...
Identify the cost issues facing the firm in this case. Chrystal Moulding and Repairs Works (CMRW) is a successful SME based in Ashhurst, a small rural town close to Palmerston North. CMRW manufactures a variety of products and provides a range of services to clients. Work involves (a) moulding of plastics and other materials, (b) custom builds using plastic, fibreglass, kevlar, carbon fibre and other new age materials and (c) the repair of anything using these materials. George Hood, one...
Read about Cokes strategy in Africa in the article below and discuss the ethics of selling soft drinks to very poor people. Is this an issue that a company like Coke should consider? Africa: Coke's Last Frontier Sales are flat in developed countries. For Coke to keep growing, Africa is it By Duane Stanford Piles of trash are burning outside the Mamakamau Shop in Uthiru, a suburb of Nairobi, Kenya. Sewage trickles by in an open trench. Across the street,...