document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=990531>Question 990531</A>: <I><SPAN STYLE=\"word-break: break-all;\"> Please show solution in Excel, Thank you.\r<BR>\n" );
document.write( "\n" );
document.write( "Mossaic Tiles, Ltd.\r<BR>\n" );
document.write( "\n" );
document.write( "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.\r<BR>\n" );
document.write( "\n" );
document.write( "A.Formulate a linear programming model for MossaicTiles,Ltd.,and determine the mix of tiles it shouldmanufacture each week.\r<BR>\n" );
document.write( "\n" );
document.write( "B.Transform the model into standard form.\r<BR>\n" );
document.write( "\n" );
document.write( "C.Solve the linear programming model graphically.\r<BR>\n" );
document.write( "\n" );
document.write( "D.Determine the resources left over and not used at theoptimal solution point. </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #610640 by </B><A HREF=/tutors/aboutme.mpl?userid=solver91311><B>solver91311(24713)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=solver91311><IMG SRC=http://www.algebra.com/images/aboutme-small.gif BORDER=0 alt=\"About Me\" VALIGN=MIDDLE></A>&nbsp;<IMG SRC=http://www.algebra.com/cgi-bin/show-face.mpl?user=solver91311><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=610640\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> <font face=\"Times New Roman\" size=\"+2\">\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "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.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "John<BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=\"/cgi-bin/rendertex.cgi?\LARGE e^{i\pi}\ +\ 1\ =\ 0\"><BR>\n" );
document.write( "My calculator said it, I believe it, that settles it\r<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=\"/cgi-bin/rendertex.cgi?\Large \ \\r\"> </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );