Reference no: EM133129823
Newfort Glass Company (NGC) has two plants in North Texas that make insulated glass (IG) products and tempered glass (TG) products for commercial and residential use in the region. Each week, NGC needs to decide how to allocate the production of orders across the two plants. Both insulated glass and tempered glass production involve three main steps: cutting, edging (also called seaming or polishing), and finally tempering, which involves heat-treating the glass in a furnace. These three steps are performed at stations (or "cells") that operate independently inside each plant (i.e., they are not part of a continuous production line). The two plants utilize different technologies and so they perform the three main steps at different rates, measured in SQFT of finished product per hour.
PLANT 1
|
IG 1
|
TG 1
|
|
PLANT 2
|
IG 2
|
TG 2
|
|
|
|
|
|
|
|
Cutting 1
|
500 SQFT/HR
|
500 SQFT/HR
|
|
Cutting 2
|
700 SQFT/HR
|
700 SQFT/HR
|
Edging 1
|
400 SQFT/HR
|
250 SQFT/HR
|
|
Edging 2
|
500 SQFT/HR
|
400 SQFT/HR
|
Furnace 1
|
400 SQFT/HR
|
600 SQFT/HR
|
|
Furnace 2
|
600 SQFT/HR
|
800 SQFT/HR
|
The variable costs (labor, materials, energy, etc.) associated with production at each plant are different as well (measured in $/SQFT):
PLANT 1
|
IG 1
|
TG 1
|
|
PLANT 2
|
IG 2
|
TG 2
|
|
$9 per SQFT
|
$7 per SQFT
|
|
|
$8 per SQFT
|
$6 per SQFT
|
NGC employs two 8-hr shifts per day and operates 5 days per week at each plant. Total orders for finished product this week are for 38000 SQFT of insulated glass and 23000 SQFT of tempered glass. How should NGC allocate their glass production across the two plants this week?
A. Write down the LP formulation for NGC's production problem.
B. Solve your model in Excel. Indicate your optimal solution (i.e., production schedule) and optimal value (i.e., minimum cost).
C. Would improving the efficiency of the furnace at either plant help reduce costs? Why or why not? What operation(s) at what plants are most critical to the production of glass?