Question 990534: Please show solution in Excel, Thank you.
Mossaic Tiles, Ltd.
Gilbert Moss and Angela Pasaic spent several summersduring their college years working at archaeological sitesin the Southwest. While at those digs,they learned how tomake ceramic tiles from local artisans. After college theymade use of their college experiences to start a tile manu-facturing firm called Mossaic Tiles,Ltd. They opened theirplant in New Mexico,where they would have convenientaccess to a special clay they intend to use to make a clayderivative for their tiles. Their manufacturing operationconsists of a few relatively simple but precarious steps,in-cluding molding the tiles,baking,and glazing.Gilbert and Angela plan to produce two basic types of tile for use in home bathrooms,kitchens,sunrooms,andlaundry rooms. The two types of tile are a larger,single-colored tile and a smaller,patterned tile. In the manufac-turing process,the color or pattern is added before a tile isglazed. Either a single color is sprayed over the top of abaked set of tiles or a stenciled pattern is sprayed on thetop of a baked set of tiles.The tiles are produced in batches of 100. The first stepis to pour the clay derivative into specially constructedmolds. It takes 18 minutes to mold a batch of 100 largertiles and 15 minutes to prepare a mold for a batch of 100smaller tiles. The company has 60 hours available eachweek for molding. After the tiles are molded,they arebaked in a kiln:0.27 hour for a batch of 100 larger tiles and0.58 hour for a batch of 100 smaller tiles. The companyhas 105 hours available each week for baking. After bak-ing,the tiles are either colored or patterned and glazed.This process takes 0.16 hour for a batch of 100 larger tilesand 0.20 hour for a batch of 100 smaller tiles. Forty hoursare available each week for the glazing process. Each batchof 100 large tiles requires 32.8 pounds of the clay deriva-tive to produce,whereas each batch of smaller tilesrequires 20 pounds. The company has 6,000 pounds of theclay 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 100smaller patterned tiles. Angela and Gilbert want to knowhow many batches of each type of tile to produce eachweek to maximize profit. In addition,they have somequestions about resource usage they would like answered.
Formulate an LP model and write the algebraic equations into your XLS, along with the relevant LP parameters. Integrate all the requirements into one model . Assume partial tiles are marketable to produce as trim.
1) What is the optimal solution for Z variable (round to two decimal digits of precision, e.g., 12.34)
2) What is value of the first decision variable (X or L or Large Tiles) in the problem (round to two decimal digits of precision, e.g., 12.34)
3) What is the value of the second decision variable (Y or S or Small Tiles) in the problem (round to two decimal digits of precision e.g., 12.34)
4) What is the value of the largest surplus or slack resource in the problem (without plus or minus signs, round to two decimal digits of precision, e.g., 12.34
5) What is the slope in the model representing the feasible solutions for the objective function (assuming two variables and only whole units were allowed calculated to four decimal digits of precision, e.g., for a fraction of +1/16 enter +0.0625)
Answer by solver91311(24713)   (Show Source):
You can put this solution on YOUR website!
You want a lot for free. In fact, way too much. Write back and we can discuss a reasonable fee for the time it will take to complete this.
John
My calculator said it, I believe it, that settles it
|
|
|
