Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Marketing estimates that at least 200 square feet of Grades I, 100 square feet of Grades II and III tiles are required. Answer the question

Marketing estimates that at least 200 square feet of Grades I, 100 square feet of Grades II and III tiles are required. Answer the question without solving a new linear program. How would the optimal profit and optimal solution change? You might need to use auxiliary variable in the linear program and get your answers from the Sensitivity Report. Question 2 options: A) optimal profit will not change, but optimal solution changes B) optimal profit will not change, optimal solution will not change either C) optimal profit will decrease, optimal solution will not chThis question is a revision in the textbook. 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. 

 

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 least 100 square feet of Grades I, II and III tiles are required. Each square foot of tile weighs approximately 2 pounds. Develop and solve a linear optimization model using Excel Solver. How many of each grade of tile the company should make next week to maximize profit contribution, and what is the profit? You may use my Excel spreadsheet provided togethe with the assignment.

Question 1 options:

 

A) 

Grades I=0, II=0, III=8000, and optimal profit =40,000
 

B) 

Grades I=100, II=100, III=7870, and optimal profit =40,000
 

C) 

Grades I=100, II=100, III=6870, and optimal profit =35,000
 

D) 

none of above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To determine how the optimal profit and optimal solution would change without solving a new linear p... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics Data Analysis And Decision Modeling

Authors: James R. Evans

5th Edition

132744287, 978-0132744287

More Books

Students also viewed these General Management questions

Question

=+b) Should the company send the fact-finding trip? Explain.

Answered: 1 week ago