Attached below is a question, please solve use Excel

MOSSAIC TILES, LTD. 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 Gilbert Moss and Angela Pasaic spent several summers of 100 large tiles requires 32.8 pounds of the clay deriva- during their college years working at archaeological sites tive to produce, whereas each batch of smaller tiles in the Southwest. While at those digs, they learned how to requires 20 pounds. The company has 6,000 pounds of the make ceramic tiles from local artisans. After college they clay derivative available each week. made use of their college experiences to start a tile manu- Mossaic Tiles earns a profit of $190 for each batch of facturing firm called Mossaic Tiles, Lid. They opened their 100 of the larger tiles and $240 for each batch of 100 plant in New Mexico, where they would have convenient smaller patterned tiles. Angela and Gilbert want to know access to a special clay they intend to use to make a clay how many batches of each type of tile to produce each derivative for their tiles. Their manufacturing operation week to maximize profit. In addition, they have some consists of a few relatively simple but precarious steps, in- questions about resource usage they would like answered. cluding molding the tiles, baking, and glazing. Gilbert and Angela plan to produce two basic types of A. Formulate a linear programming model for Mossaic tile for use in home bathrooms, kitchens, sunrooms, and Tiles, Ltd., and determine the mix of tiles it should laundry rooms. The two types of tile are a larger, single- manufacture each week. colored tile and a smaller, patterned tile. In the manufact . Transform the model into standard form. turing process, the color or pattern is added before a tile is C. Solve the linear programming model graphically. glazed. Either a single color is sprayed over the top of a D. Determine the resources left over and not used at the baked set of tiles or a stenciled pattern is sprayed on the optimal solution point. top of a baked set of tiles. E. Determine the sensitivity ranges for the objective The tiles are produced in batches of 100. The first step function coefficients and constraint quantity values is to pour the clay derivative into specially constructed by using the graphical solution of the model. molds. It takes 18 minutes to mold a batch of 100 larger F. For artistic reasons, Gilbert and Angela prefer to pro- tiles and 15 minutes to prepare a mold for a batch of 100 duce the smaller, patterned tiles. They also believe smaller tiles. The company has 60 hours available each that in the long run, the smaller tiles will be a more week for molding. After the tiles are molded, they are successful product. What must the profit be for the baked in a kiln: 0.27 hour for a batch of 100 larger tiles and smaller tiles in order for the company to produce only 0.58 hour for a batch of 100 smaller tiles. The company the smaller tiles? has 105 hours available each week for baking. After bak- G. Solve the linear programming model by using the com- ing, the tiles are either colored or patterned and glazed. puter and verify the sensitivity ranges computed in (E). H. Mossaic believes it may be able to reduce the time J. Mossaic is considering adding capacity to one of required for molding to 16 minutes for a batch of its kilns to provide 20 additional glazing hours per larger tiles and 12 minutes for a batch of smaller tiles. week, at a cost of $90,000. Should it make the How will this affect the solution? investment? I. The company that provides Mossaic with clay has K. The kiln for glazing had to be shut down for 3 hours, indicated that it can deliver an additional 100 pounds reducing the available kiln hours from 40 to 37. What each week. Should Mossaic agree to this offer? effect will this have on the solution