Create a step-by-step excel, using the solver engine to generate the decision variablesolution. Generate an ANSWER REPORT and a SENSITIVITY REPORT. I WILL UPVOTE. THANK YOU CASE 1. Mossaic Tiles, Ltd.Gilbert Moss and Angela Pasaic spent several summers during their college years working atarchaeological sites in the Southwest. While at those digs, they learned how to make ceramic tiles from localartisans. After college they made use of their college experiences to start a tile manufacturing firm calledMossaic Tiles, Ltd. They opened their plant in New Mexico, where they would have convenient access to aspecial clay they intend to use to make a clay derivative for their tiles. Their manufacturing operation consistsof 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, patternedtile. In the manufacturing process, the color or pattern is added before a tile is glazed. Either a single color issprayed 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 speciallyconstructed molds. It takes 18 minutes to mold a batch of 100 larger tiles and 15 minutes to prepare a moldfor a batch of 100 smaller tiles. The company has 60 hours available each week for molding. After the tilesare 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 100smaller tiles. The company has 105 hours available each week for baking. After baking, the tiles are eithercolored 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 smallertiles. Forty hours are available each week for the glazing process. Each batch of 100 large tiles requires 32.8pounds of the clay derivative to produce, whereas each batch of smaller tiles requires 20 pounds. Thecompany 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 batchof 100 smaller patterned tiles. Angela and Gilbert want to know how many batches of each type of tile toproduce each week to maximize profit. In addition, they have some questions about resource usage theywould like answered.Required:1. Formulate a linear programming model for Mossaic Tiles, Ltd., and determine the mix of tiles it shouldmanufacture each week using the computer.2. Determine the resources left over and not used at the optimal solution point.3. Determine the sensitivity ranges for the objective function coefficients and constraint quantity values.

Objective Functions and Constraints: Based on the given details, the objective…

Answered: d Angela Pasaic spent e Southwest.…

d Angela Pasaic spent e Southwest. While at the ey made use of their co Opened their plant in Ne Ouse to make a clay deriv

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Which types of decisions should the decision trees be used to address for?
I need answer typing clear urjent no chatgpt used i will give upvotes both answers pls
true or false 8.Influence diagrams cannot be regarded as a method for eliciting decision trees.
When an organization has historical data from last 5 years. Now management wants to processes these data so they get help in designing new products based on customer and market feedback. Please describe the appropriate technique you want to use to support management decision making.
K Display the data to the right in a Pareto chart. Describe the difference in how the pie chart and the Pareto chart show patterns in the data. www. Choose the correct bar graph below. OA. Favorte Season hu B. Favorite Season 50₂ C. (b) Describe the difference in how the pie chart and the Pareto chart show patterns in the data. Choose the comect answer below OA. The pie chart shows the individual responses. The Pareto chart shows the distribution of the seasons. B. The pie chart shows the percentages as parts of the whole. The Pareto chart shows the rankings of the seasons Favorite Season OD. Summer 37 Fall 22% Spring 24% Winter 17% Favorite Season
I was asking for help on question number 3 not number one 3. Refer to Problems 1 and 2. Construct a graph that will enable you to perform sensitivity analysis on the problem. Over what range of P(high) would the alternative of doing nothing be best? Expand? Subcontract?
Explain the concept of data modeling in data warehousing. What are star schemas and snowflake schemas, and how are they used?
A business conducted a linear regression to estimate its demand function and obtain the following demand function Q = 200 - 1.5P + 0.55A - 2.8Py + 0.05Inc, where P is price and A is advertising. When P = $21. A = $30 and Quantity = 160, find the profit-maximizing advertising-to-sales ratio (hint: first find the price and advertising elasticities). Type as either a decimal out two spaces, like 0.10 OR as a percentage like 10%. %3! %3! Question 17 During recessions, people's reservation price (aka reserve price) searching. which results in O drops; less O rises; more drops; more O rises; less
MSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15
I need the answer as soon as possible
Explain the seven phases in problem-solving and why they are dependent on its previous phase. Identify the Problem Analyze the Current Process Develop the Optimal Solution/s Implement Changes Study the Results Standardize the Solution Plan for the Future
Please help me with thirdly part 1,2, and 3