XYZ Lawn Trimmer Company produces two types of lawn trimmers - a gas model and an electric model. The company has two manufacturing facilities: san Diego and Atlanta. Both plants have the capability to produce both of the models but the manufacturing and transportation costs are different.
San Diego Atlanta Demand
Gas $125 $100 225
Electric $115 $95 275
Capacity 400 units 200 units
Storage Space 10,000 sq ft 5,000 sq. ft
Leased WH Cost $5 per sq. ft $4 per sq ft.
Leased WH Capacity 15,000 sq ft $18,000 sq ft.
The company has just received a contract from a large retailer for the production of 225 gas models and 275 electric models. The San Diego plant can produce up to 400 units and the Atlanta plant can produce up to 200 units. Because the manufacturing facilities have limited storage space, there is concern that space will have to be rented to store the finished products. The San Diego plant has 10,000 sq ft available on site, and the Atlanta plant has 5,000 sq ft on site. After this space is filled, off-site space will have to be rented. All of the models require about the same square footage (about 30 square feet), but the price for rental space in each of the locations is different. The rental price in San Diego is $5 per square foot and the price in Mexico is $4 per square foot. There are 15,000 sq ft available in San Diego and 18,000 sq ft available in Atlanta.
Formulate a linear programming model to minimize total cost. Be sure to define your decision variables. Determine how many of each type will be manufactured iin San Diego and Atlanta, and also determine if any additional storage space is needed. Just set up the model, do not attempt to solve it.
Please see the attached solution
Problem description: XYZ Lawn Trimmer Company received an order to supply Gas and electric powered lawn trimmers. Company can produce both the products can be produced by the company at the facilities in San Diego and Atlanta. Each facility has a different production and distribution cost. There is a storage attached to each facility and an additional storage space available at extra cost. Objective is to develop an optimal production and distribution plan that minimizes total cost of production, storage and distribution.
Notations: S-San Diego facility and A-Atlanta facility
G-Gas trimmer and E-Electric trimmer
O-Own storage space and L-Leased storage space
Decision variables: Let X_GSO be the quantity of Gas trimmers produced at San Diego facility and supplied through Own ...
The solution provides detailed step by step on how to formulate a linear programming problem. It exaplins how to setup decision variables, number of variables, formulating objective function and constraints. Also provided is the guide on how to solve it using Excel Solver