Sandford Tile Case Study: Linear Optimization Problem
Not what you're looking for?
Sandford Tile company makes ceramic and porcelain tile for residentail and commercial use. They produce three different grades of tile for walls, residential flooring, and commercial flooring each of which requires different amounts of materials and production time and generates different contribution to profit. The spreadsheet shows the percentage of materials needed for each grade and the profit per square foot. Each week Sandford tile receives raaw materials shipments and the operations manager must schedule the plan to efficiently use the matierals to maximize profitability. Currently inventory consists of 6000 pounds of clay, 3000 pounds of silica, 5000 pounds of sand, and 8000 pounds of Feldspar. Because demand varies for the different grades marketing estimates that at most 8000 square feet of grade III tile should be produced and that at east 1500 square feet of grade i tiles are required. Each square foot of tile weighs two pounds.
1. Develop a linear optimization model to determine how many of each grade of tile the company should make next week to maximize profit.
2. Implement the model on a spreadsheet and find an optimal solution
3. Explain the sensitivity information for the objective soefficients. What happens in the projit on Grade I is increased by $.05?
4. If an additional 500 pounds of feldspar is available how will the optimal solution be affected?
5. 1,000 pounds of clay are found to be of poor quality, what should the company do?
6. Use the auxilary variable cells technique to handle the bound contraints and generate all shadow prices.
Purchase this Solution
Solution Summary
The expert examines linear optimization problems for Sanford Tile Case Study.
Solution Preview
See the attached file. Thanks
Linear Programming Model
"Sandford Tile company makes ceramic and porcelain tile for residential and commercial use. They produce three different grades of tile for walls, residential flooring, and commercial flooring each of which requires different amounts of materials and production time and generates different contribution to profit. The spread sheet shows the percentage of materials needed for each grade and the profit per square foot. Each week Sandford tile receives raw materials shipments and the operations manager must schedule the plan to ...
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.