Find an optimal solution for given data

Assignment Help Engineering Mathematics
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.

Reference no: EM131440272

Questions Cloud

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..

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Prime number theorem

Dirichlet series

  Proof of bolzano-weierstrass to prove the intermediate value

Every convergent sequence contains either an increasing, or a decreasing subsequence.

  Antisymmetric relations

How many relations on A are both symmetric and antisymmetric?

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Prepare a system of equations

How much money will Dave and Jane raise for charity

  Managing ashland multicomm services

This question is asking you to compare the likelihood of your getting 4 or more subscribers in a sample of 50 when the probability of a subscription has risen from 0.02 to 0.06.]  Talk about the comparison of probabilities in your explanation.

  Skew-symmetric matrices

Skew-symmetric matrices

  Type of taxes and rates in spokane wa

Describe the different type of taxes and their rates in Spokane WA.

  Stratified random sample

Suppose that in the four player game, the person who rolls the smallest number pays $5.00 to the person who rolls the largest number. Calculate each player's expected gain after one round.

  Find the probability density function

Find the probability density function.

  Develop a new linear programming for an aggregate production

Linear programming applied to Aggregate Production Planning of Flat Screen Monitor

  Discrete-time model for an economy

Discrete-time model for an economy

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd