Reference no: EM131440272
Question: 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 contributions to profit. The following information shows the percentage of materials needed for each grade and the profit per square foot.
|
|
Grade I
|
Grade II
|
Grade III
|
|
Profit/square foot
|
$2.50
|
$4.00
|
$5.00
|
|
Clay
|
50%
|
30%
|
25%
|
|
Silica
|
5%
|
15%
|
10%
|
|
Sand
|
20%
|
15%
|
15%
|
|
Feldspar
|
25%
|
40%
|
50%
|
Each week, Sanford Tile receives raw-material shipments, and the operations manager must schedule the plant to efficiently use the materials to maximize profitability. Currently, inventory consists of 6,000 pounds of clay, 3,000 pounds of silica, 5,000 pounds of sand, and 8,000 pounds of feldspar. Because demand varies for the different grades, marketing estimates that at most 8,000 square feet of Grade III tile should be produced, and that at least 1,500 square feet of Grade I tiles are required. Each square foot of tile weighs approximately 2 pounds.
a. Develop a linear optimization model to determine how many of each grade of tile the company should make next week to maximize profit contribution.
b. Implement your model on a spreadsheet and find an optimal solution.
c. Explain the sensitivity information for the objective coefficients. What happens if the profit on Grade I is increased by $0.05?
d. If an additional 500 pounds of feldspar is available, how will the optimal solution be affected?
e. Suppose that 1,000 pounds of clay are found to be of inferior quality. What should the company do?
f. Use the auxiliary variable cells technique to handle the bound constraints and generate all shadow prices.
|
Forklift tipped over going around a corner
: Question: While responding to an accident where a forklift tipped over going around a corner, the supervisor tells you that the cause was simply operator error since the driver was going too fast. The supervisor does not see the need to investigat..
|
|
Explain how many hours per week the apprentice will work
: Use the Department of Labor's Employment and Training Administration website and find the area on Registered Apprenticeship. Explore the Employers section. Based on the information found here, create an apprenticeship proposal for a position in th..
|
|
Construct a piece in the model of the new york times
: Construct a piece in the model of The New York Times "36 Hours" features you've examined as part of the course readings. Your essay needs to be around 1200 words.
|
|
Accident investigation involving a worker
: Question 1: You recently completed an accident investigation involving a worker injured by an unguarded blade on a table saw. The investigation revealed that the guard had been removed some months before by persons unknown.
|
|
Find an optimal solution for given data
: 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 material..
|
|
What do you think about the debate over funding
: What do you think about the debate over funding a new jobs creation program - What do you think about proposals from members of Congress to cut corporate taxes to stimulate corporate re-investment in business development to stimulate the economy in..
|
|
Used in solar-powered water purification system
: The Goodparts Company produces an assembly that is used in a solar-powered water purification system. The assembly consists of three parts (A, B, and C) that are purchased from outside suppliers. Determine the process capacity, measured by the number..
|
|
What is the purpose of your chosen superpower
: If you could have the superhero power of invisibility or flying, which would you choose? No one else on earth has superhero powers, and you would have only the one. State your choice explicitly and then explain why it is your choice.
|
|
Identify the relationship of the outsourced service
: Many companies benefit from outsourcing services because it allows the company to lower costs, focus on its organizational culture, and increase the speed and quality of services. You have been asked to analyze how the outsourced service interacts..
|