Question

Gilbert Moss and Angela Pasaic spent several summers during their college years working at archaeological sites in the Southwest. While at those digs, they learned how to make ceramic tiles from local artisans. After college they made use of their college experiences to start a tile manufacturing firm called Mossaic Tiles, Ltd. They opened their plant in New Mexico, where they would have convenient access to a special clay they intend to use to make a clay derivative for their tiles. Their manufacturing operation consists of a few relatively simple but precarious steps, including molding the tiles, baking, and glazing. Gilbert and Angela plan to produce two basic types of tile for use in home bathrooms, kitchens, sunrooms, and laundry rooms. The two types of tile are a larger, single- colored tile and a smaller, patterned tile.In the manufacturing process, the color or pattern is added before a tile is glazed. Either a single color is sprayed over

the top of a baked set of tiles or a stenciled pattern is sprayed on the top of a baked set of tiles.The tiles are produced in batches of 100. The first step is to pour the clay derivative into

specially constructed molds. It takes 18 minutes to mold a batch of 100 larger tiles and 15 minutes to prepare a mold for a batch of 100 smaller tiles. The company has 60 hours available

each week for molding. After the tiles are molded, they are baked in a kiln: 0.27 hour for a batch of 100 larger tiles and 0.58 hour for a batch of 100 smaller tiles. The company has 105 hours

available each week for baking. After baking, the tiles are either colored or patterned and glazed. This process takes 0.16 hour for a batch of 100 larger tiles and 0.20 hour for a batch of 100

smaller tiles. Forty hours are available each week for the glazing process. Each batch of 100 large tiles requires 32.8 pounds of the clay derivative to produce, whereas each batch of smaller

tiles requires 20 pounds. The company has 6,000 pounds of the clay derivative available each week. Mossaic Tiles earns a profit of $190 for each batch of 100 of the larger tiles and $240 for

each batch of 100 smaller patterned tiles. Angela and Gilbert want to know how many batches of each type of tile to produce each week to maximize profit. In addition, they have some questions about resource usage they would like answered.

A) Formulate a linear programming model on excel for Mossaic Tiles, Ltd. to determine the mix of tiles it should manufacture each week.

B) For artistic reasons, Gilbert and Angela like to produce the smaller, patterned tiles better. They also believe that in the long run, the smaller tiles will be a more successful product.

What must the profit be for the smaller tiles in order for the company to produce only the smaller tiles?

C) Mossaic believes it may be able to reduce the time required for molding to 16 minutes for a batch of larger tiles and 12 minutes for a batch of the smaller tiles. How will this affect

the solution?

D) The company that provides Mossaic with clay has indicated that it can deliver an additional 100 pounds each week. Should Mossaic agree to this offer? Explain.

Answer 1

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****

a)MTL is planning to produce two different types of tiles; large tiles and small tiles. Consider large tiles as x and smaller tiles as y. These are produced in batches of 100. Large tiles earn a profit of $190 and a smaller tile earns a profit of $240.

Formulate the linear programming as shown below:

$190x + $240y

Subject to the following constants:

18x + 15y <= 3600

0.27x + 0.58y <= 105

0.16x + 0.20y <= 40

32.8x + 20y <= 6000

To determine the mix of tiles it should manufacture each week, use excel solver as shown below:

Enter the values in the excel sheet as shown below:

Access ‘Solver’ from the ‘data’ menu in the excel sheet as shown below:

Enter the objectives and the constraints in the solver as shown below:

The solver produces the following result:

Thus, 57 batches of larger tiles and 155 batches of smaller tiles must be produced to maximize the profit.

B)

Enter the values in the excel sheet as shown below:

Access ‘Solver’ from the ‘data’ menu in the excel sheet as shown below:

Enter the objectives and the constraints in the solver as shown below:

The solver produces the following result:

Thus 181 batches of smaller tiles must be produced to maximize the profit.

C)

Formulate the linear programming as shown below:

$190x + $240y

Subject to the following constants:

16x + 12y <= 3600

0.27x + 0.58y <= 105

0.16x + 0.20y <= 40

32.8x + 20y <= 6000

Enter the values in the excel sheet as shown below:

Access ‘Solver’ from the ‘data’ menu in the excel sheet as shown below:

Enter the objectives and the constraints in the solver as shown below:

The solver produces the following result:

Thus, 57 batches of larger tiles and 155 batches of smaller tiles must be produced to maximize the profit. The optimal solution remains the same.

D)

No, increasing the total pounds of clay wouldn’t affect the optimal solution due to its sensitivity range.

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****