A. Formulate a linear programming model for Mesray Tiles, Ltd .

B. Solve the linear programming model by using the Excel Solver and determine the sensitivity ranges.

C. Malik believes the demand for larger single colored tiles may not be as they expected. Malik and Elhan is thinking to reduce their profit margin for the batch of larger tiles to $190 so that they can sell what they produce. How will this affect the solution?

D. The company that provides Mesray with clay has indicated that it can deliver an additional 100 kg each week at a cost of $3000. Should Mesray agree to this offer?

please answer A, B , C, D

Malik and Elhan spent several months for their industrial training at Archaeol Sdn Bhd in the northeast region during their college years. During those practical training for their engineering degree studies, they had the opportunity to learn how to make ceramic tiles. After graduation, they made use of their college experiences to start a tile manufacturing firm called Mesray Tiles, Ltd. They opened their plant in Melaka, where they would have convenient access to 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. Malik and Elhan 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 150. The first step is to pour the clay derivative into specially constructed molds. It takes 20 minutes to mold a batch of 150 larger tiles and 12 minutes to prepare a mold for a batch of 150 smaller tiles. The company has 60 hours available each week for molding. After the tiles are molded, they are baked in a kiln: 0.20 hour for a batch of 150 larger tiles and 0.60 hour for a batch of 150 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.15 hour for a batch of 150 larger tiles and 0.20 hour for a batch of 150 smaller tiles. Forty hours are available each week for the glazing process. Each batch of 150 large tiles requires 35 kg of the clay derivative to produce, whereas each batch of smaller tiles requires 20 kg. The company has 6,000 kg of the clay derivative available each week. Mesray Tiles earns a profit of $200 for each batch of 150 of the larger tiles and $260 for each batch of 150 smaller patterned tiles. Malik and Elhan 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. Provide a report that address the following questions