Wednesday, April 30, 2008

Blog 11: Which Treatment Plan Should Cancer Patients Choose?

As more research and technology is advancing in the medical field today, there are many more choices in the treatment of cancer. The decision on the type of treatment is very important because it is someone's life on the line. So how does a cancer patient decide the right route to take?

What may help a cancer patient is a decision support system. A decision support system can help inform the user of other treatments and medications that the patient may have been unaware about. In an article, $2 million is dedicated for the combination of research initiatives and a national website that is aimed to match breast cancer patients with clinical trials nationwide and even provide decision support tools.

How the DSS will help the patient is by allowing the user to come out the DSS fully informed and confident with his/her decision. The data base will have the the different types of breast cancer, stages of cancer, cancer information, treatment types and information, medication, support group information, prosthesis retailers, and doctors that specialize in cancer treatment and related fields.

The user will be prompted to choose why they are visiting the site and go straight to the needed decision support tool or go through a formalized system of questions. Information and links will be tied to certain questions such as if a patient has a mascetomy, links to reconstruction and prothesis will be provided by the side. Also, the patient can view side effects of certain medications and treatments while using the DSS. If the patient is unfamiliar with what steps to take, the DSS will guide her linearly through the menu and questions. If a professional is using the DSS such as a doctor, the doctor can input certain conditions so that the database can match those conditions to the right treatment.

References
De Gier, Vanessa. Safeway Foundation Gives $2 million to UCSF for Breast Cancer Support. University of California, San Francisco. 30 April 2008.
http://pub.ucsf.edu/newsservices/releases/200804301/

Wednesday, April 23, 2008

Blog 10: Should Companies "Go Green" by Recycling?

The recent trend is building to recycle. Many companies may still think that implementing "earth-saving techniques and methods" may cost them more, but maybe that is just an misconception.

In fact, manufacturing plants in particular can save costs by recycling scraps. Costs that would have incurred if plants did not recycle are - disposal fees, additional material purchases, labor to rid the piles of waste, and an overall less friendly environment.

To analyze the problem, a decision support system can be designed by allowing the user to design a plant layout with the ability to reproduce production processes through historical data and forecasts. Historical data can also represent the average amount of scraps from each part produced and packaged. In addition, potential savings are instant if items are easily recyclable. However, what can't be modeled are employees' attitudes towards the recycling program. Perhaps a survey can be used to know the majority of employee's attitudes towards the recycling implementation. Incentives such as a $25 gift certificate or half day off if a certain recycling quota is met (i.e. 800 lbs of recycled paper within 1 week is the projected goal) will be given to employees for motivation and cooperation for the implementation of the program.

If companies start utilizing decision support systems in deciding implementation for recycling, then maybe more companies might realize that recycling may even reduce costs.

References

Manufacturers achieve scrap recycle targets. Environmental Transport Association (ETA). 21 April, 2008. Retrieved April 21, 2008 from http://www.eta.co.uk/node/10487.

Wednesday, April 16, 2008

Blog 9: Earthquake Prediction and the Effect on Decision Makers

Natural disasters can greatly impact a supply chain by sending it to a halt. When earthquakes occur, supply chain specialists need to know how to respond and be proactive prior to the earthquake. But if an earthquake is a natural disaster, how is it accurately predicted? To predict an earthquake, a scientific-detailed model is used to forecast the natural disaster.

First, the model needs the most current, up-to-date geological and seismological data. In addition, historical patterns must be examined as well as major fault lines. From here, these results include the degree of earthquake magnitudes and its effect on the land. These results can greatly impact supply chain decisions such as where to locate a facility (obviously-not on a major fault line!), and if products are expensive-don't locate a warehouse in a high-risk earthquake area. Although, many may think a computerized earthquake model is irrelevant, it can greatly affect any business decision. As a result, a simulation model should include forecast models for earthquakes so that businesses can maintain a resilient supply chain.

References

Bowles, Jennifer. California Earthquake Probability Study Rejiggers Inland Causes for Concerns. 15 April, 2008. ARN. Retrieved April 15, 2008 from http://www.blogger.com/post-edit.g?blogID=3961439252729962199&postID=4748261664757262560.

Wednesday, April 9, 2008

Blog 8: Where do you want to live?

As a Saint Louis born native, I haven't always been satisfied living here. The article, "Best Places to Live:2007" at CNNmoney.com lists the best places to live based on "economic opportunity, good schools, safe streets, things to do and a sense of community." Although the article has a miniature interactive tool that lets the user choose the best place to live regarding their needs, the program is too broad. If I ever wanted to relocate to another state, I would first examine locations through research based on what I wanted and what was most important to me.

To model the best place to live, there would be a database of top 150 cities based on population and attractions (150 is just a recommended cut-off). These cities are then divide into three categories such as large cities, medium cities, and small cities with a population range for each category, in which CNN did not take city size into consideration. The database will then have standard characteristics that are assigned to each city such as types of attractions: trout fishing, surfing, American battleground, Indian reservation, and attractions as such. In addition, other city characteristics such as climate, unemployment level, affordable housing, architectural styles, proximity to certain landmarks, and number of businesses' corporate headquarters are taken into consideration. The user will choose what factors are important to them, and the places with the most matches will show up as the best places to live. Also, the user can choose points on a map, where the decision support system can calculate the center of gravity and match the closest top-city as the best place to live. This DSS should also have current or real-time data since cities are constantly growing and changing.

This DSS can help individuals each time they want to relocate. Relocation is due to many reasons: college graduation, divorce, career change, or other reason.

References
Money Magazine's Best Places to Live. CNNmoney.com. Retrieved April 9, 2008 from http://money.cnn.com/magazines/moneymag/bplive/2007/top100/

Wednesday, April 2, 2008

Blog 7: Opening a Shopping Center

The grand opening is finally announced for the Orchad Town Shopping Center! This shopper center is an outdoor center with nearly one million square feet of stores, restaurants, and attractions. Although there are malls are being erected regularly in developing areas, there usually is a little more to it.

When opening a new shopping mall, many efforts and analyses are considered before actual implementation. To forecast the success of the mall, a decision maker may hire a consultant to create a simulation model.

The simulation model can predict demand for the shopping mall based on attractiveness, such as square footage, how much demand it can grab from other potential competitors, and the distance from consumers.

However, other qualitative factors may affect the shopping center's success as well. The attractiveness may not be the size of the shopping center, but rather the actual stores and specialties that the new place offers. In addition, the decision making team must look at demographics within the area such as age, gender, and household income. The amount of traffic passing through the location may also be an important factor. Nevertheless, the cost of land may be too high and business may not be successful.

The simulation model can predict the demand and find a center of gravity to help decision makers pick a feasible location with potential positive profit margins. Although the center of gravity is a heuristic and can not find the optimal location, the center of gravity helps decision makers by centering itself based on weighted customer demand. From here, decision makers can find a location close to the center of gravity.

Although the simulation results may find high demand and a great location for the shopping center, other factors (as mentioned before) such as demographics, traffic amount, and cost of land are things to also think about before implementation.

References
Grand opening set for Orchard Town Center. Denver Business Journal. 2 April, 2008. Retrieved April 2, 2008 from http://www.bizjournals.com/denver/stories/2008/03/31/daily48.html

Wednesday, March 19, 2008

Blog 6: Auto Plant Simulates its Production System

Background

The Nissan Motor Manufacturing plant in the United Kingdom
needed to optimize production processes for Nissan's new Qashqai model, a sport utility vehicle with a unique look. The Nissan plant considered two options, either the traditional industrial engineering methods or the use of a simulation model.

Which solution-manual calculations or simulation software?
The traditional manual calculation method included "calculations determining the capacity using a planned system efficiency percentage" and creation of production charts. Manual calculations are too time consuming, in which requires more labor costs, and has a higher risk of errors.

Nissan found that the simulation approach was better suited since the analysis is more in-depth. First, the simulation model software created a scenario for each smaller production cell in the line to improve process times. After the smaller cells were improved, the Nissan team produced a large-scale model with all the smaller production cell data combined.

Possible Data for the Simulation
Possible data for the simulation analyses are machine processing times, capacity of machine and labor, idle time (if applicable), number of machines available, demand for the product, number of workers available, batch sizes, and probability of defects. Qualitative data needed may be the condition of the machinery, worker motivation, and order of tasks. Nissan may also keep in mind lead times and shipment times that affect its customer service levels.

What kind of results does Nissan want?
Nissan probably wants faster processing times, increased capacity, eliminated/reduced idle time, improved quality, and a low defect number. Each individual model should be analyzed before moving on to the large-scale model for analysis.

How are simulation models helpful?
Simulation models have helped Nissan by providing a visual, interactive, and dynamic aid to decision makers. Nissan doesn't have to shut down its plant just to test a new methodology or process, decision makers can change variables and scenarios in the simulation model to represent the real-life process. In addition, simulation models can help improve the production capacity due to the growing demand for the Qashqai model.

Unlike manual calculations, simulation models replicate calculations easily by just a few clicks. Where as in a hand simulation, calculations need to be completed from step one. By modeling scenarios, Nissan can find more feasible solutions for their production processes.

References
Car plant simulates production systems. Manufacturingtalk. 17 March, 2008.Retrieved March 19, 2008 from
http://www.manufacturingtalk.com/news/lan/lan111.html

Wednesday, March 12, 2008

Blog 5: A Simple Model in Finding Stock Value

Situation
The article, US Airways Shares Fall as JPMorgan Downgrades Airline Stocks, discusses the decrease in airline stock prices such as Tempe and other large airlines. Due to rising fuel prices and a weakening economy, Standard & Poor's Ratings Services plan to review the top ten US airline companies. For example, "US Airways stock closed at $9.98 per share Tuesday and dipped to $8.87 Wednesday before starting a rebound to end the day at $9.44 (Luebke 2007)."

Who is Affected?
Stock holders with risky stock such as the airline industry need to know when to buy in the market and when to sell their stock. In this situation, the main decision makers in this situation are stock holders such as the corporation and individuals.

What Model Should be Used?
A simple financial model known as the Dividend Discount Model (DDM). DDM tells you the value of equity, which is stock. Three variables are needed to determine the current value/price of stock. First, the dividend amounts are needed for a base period and for the following period after that. Second, the percentage of total expected return by investors (current income + price change), which is defined as variable R. Third, the annual growth rate from the base period and the next period is needed, which is defined as variable G. To find the stock's price, divide the next period's dividend amount by R minus G as so:

Price of Stock = Dividend of Next Period
__________________
R - G

How the Dividend Discount Model is Useful
The dividend discount model is a quick and dirty method for decisions in buying and selling securities. If the 'Price of Stock' from the model is less than the actual stock price, than the stock holders should try to sell their stock or on the other hand, potential investors should not buy the stock. If the 'Price of Stock' from the model is more than the actual stock price, then the potential buyers should buy the stock because it is undervalued, or stock holders may decide to keep the stock.

Although this model is simple, it is a quick way to evaluate stocks and is readily available with only a few necessary variables.

References
Luebke, Cathy. US Airways Shares Fall as JPMorgan Downgrades Airline Stocks. Phoenix Business Journal. 12 March 2008. Retrieved March 12, 2008 from http://www.bizjournals.com/phoenix/stories/2008/03/10/daily27.html?jst=b_ln_hl

Wednesday, February 27, 2008

Blog 4: Another Factory Closing

Situation
GPX, an international tire corporation announced the closing of its production facility in Mississauga, Canada. The company plans to consolidate its manufacturing operations in its other three plants in Maine, Pennsylvania, and China. In the past, GPX has only ran its manufacturing operations in the U.S. four days a week. When their Canadian plant closes, they plan to manufacture products 5 days a week.

Closing a facility is a huge decision. Sometimes, I still wonder if companies make the right judgment when they choose to relocate or close a facility. When making this type of decision, a network optimization model can help top management decide what is best for their company. Network optimization models help businesses decide possible facility locations, size, and the optimal number of facilities in their distribution network. In a typical company's distribution network, a company's facilities include suppliers, manufacturers, distributors, warehouses, distribution centers, wholesalers/retailers, and customers.

Modeling GPX's Situation
Transportation data files are needed in the optimization model to represent flows relating to the inbound shipments, interplant transfers, plant to distribution center (DC), DC transfers, and outbound shipments. Transportation files can help reflect a company's freight cost and to configure an optimal freight system. In addition, operating costs such as fixed facility costs and variable costs are inputted into the model for comparison of new facility costs if the Canadian plant is closed.

How Can GPX Make a Decision Based on a Network Optimization Model
The model results show the change of customer service levels, increase/decrease of transportation costs, and increase/decrease in operating costs. The model can also recommend a center of gravity plant that is the best location based on the distance from customers. In addition, GPX should consider special discounts that the Canadian plant receives, and if it closes, what is the forseen costs in the future? For example, the Canadian plant receives a discount from a local vendor, in which, the vendor will not continue the discount if shipping materials to a plant in the U.S. or China.

A network optimization model is a decision support system that uses linear or multi-linear software to physically find the best facility location(s), facility size(s) (square footage), number of facilities, and even optimal inventory levels. Results such as transportation costs, operating costs, and inventory levels can help top management to make legitimate choices for cutting costs and/or increasing sales.


References
GPX to Close Canada Factory. Tire Review. 25 February 2008. Retrieved February 27, 2008 from
http://www.tirereview.com/default.aspx?type=wm&module=4&id=2&state=DisplayFullText&item=10661

Wednesday, February 20, 2008

Blog 3: Implementing an ERP, is it really cost efficient?

At Issue
India's IT e-newspaper, CXO Today, published the article, "ERP Moves Toward Cost Efficiency" that announced an opportunity for an affordable enterprise resource planning (ERP) system. An ERP system is software and hardware, such as a database, that integrates and centralizes all data and processes within an organization. Organizations are finding it difficult to obtain the data with out any redundancies. Redundancies are costly because it increases wasteful processing time and requires extra storage space. Although ERP systems solve redundancies, they are costly and hard to implement. The article describes how Oracle, a well-known database solution provider, is offering a "predictable monthly" ERP cost and "a lower total cost of ownership" for firms in India.

Although this may sound like a great bargain, firms in India must first consider other options. It is a huge decision to implement an ERP since it is an entire new system and is usually costly. In addition, other problems may arise due to the ERP implementation.

Modeling the Decision
The firm should first look at their current direct costs such as maintenance of the data and indirect costs such as time wasted on redundant data entry. Also, the company should complete an in-depth analysis of all the waste and data issues due to different data in different departments. Next the company should either decide to build an in-house ERP system or purchase one from a vendor such as Oracle. A cost-benefit analysis is needed to compare which ERP system is better suited. Data collected should include costs, current work that each worker completes and the possible elimination of certain tasks, and the time it takes to complete these tasks. While building a model to represent the ERP implementation (either the in-house or vendor-purchased), the new system should be carefully planned and simulated.

Model Results
The model results should represent the costs and possible time saved from implementing an ERP system. Although costs may decrease, firms need to consider other factors such as extra training to learn how to use the ERP system and consulting costs to execute the system. Also, firms should take in consideration the illusion of false savings from staff cuts. When purchasing an ERP system from a vendor, firms think they can lay off IT (information technology) workers since the software is pre-written, but this is only a misconception. A company may need to hire additional IT application specialists.

How does this decision support model help top management make decisions?
This model shows the physical costs and time that is possibly saved or increased due to the implementation of the ERP. These cost savings may be significant, but experienced decision makers should be able to see if the efficiency and uniformity of an ERP system outweighs the other costs that result from the ERP implementation (additional training and staffing). If the decision makers are inexperienced, then a detailed cost-benefit analysis should be presented with a clearly stated recommendation.

References
ERP Moves Toward Cost Efficiency. CXO Today. 19 July, 2007. Retrieved February 20, 2008 from
http://www.cxotoday.com/India/News/ERP_Moves_toward_Cost_Efficiency/551-82287-911.html

Wednesday, February 13, 2008

Blog 2: Long lines at the DMV? Who ever heard of that?

Situation
Millions of Americans experience long lines on a normal basis at their state's Department of Motor Vehicles (DMV). The article, "NC DMV Expects Long Lines, Wants 100 New Workers," describes how the state of North Carolina is trying to address this issue. Although hiring more workers may increase the capacity, productivity and efficiency, hiring more workers comes with high costs.

Currently, there are 500 license examiners. Division spokesperson, Marge Hall stated that officials will ask the legislature for 28 supervisors and 76 new license examiners. But the question is, is this the only solution to long lines?

A New Approach to the Problem
I've been to several local DMV's in the state of Missouri. By looking at how the lines are arranged, it's clearly the set up of the line operation that causes the long waits. The longest line is for plate renewals where there is only one or two clerks. There are two other lines where one is designated for the driver license while the other is for some other service. Training each employee to process all types of inquiries such as driver license and plate renewals, could make lines flow more smoothly. Also, the DMV process should be analyzed to identify steps with non-value added activities. This way, service times are reduced, speeding up the line(s).

Modeling This Problem
Three models must be created for comparison. First, the North Carolina DMV should model their current situation. Second, the new model with clerks (with no increase in clerks) who can serve all customer requests should be analyzed. Lastly, the state of North Carolina should model the DMV operation with the extra employees. Data collection for these models should include customer demand for each type of inquiry, average service times for each service, and how the line(s) is/are arranged.

Results
The models' results such as operational costs, wait times, and length of lines will be compared in order to find the optimal solution. The model with the lowest operational costs and greatest efficiency shall be implemented.

How Can this DSS Help Solve The Issue?
In order for ongoing improvement, the DMV needs a software program that allows them to re-organize their operation system. The model shall allow DMV officials to change the counter operation (i.e. single counter to multiple counters), line arrangement, number of clerks, service times, and other factors that may affect the cause of long lines. With this software, DMV officials are able to create better ways to decrease or even eliminate long lines.

Reference
"NC DMV Expects Long Lines, Wants 100 New Workers." The Associated Press. 11 Feb 2008. Retrieved Feb. 13th, 2008 from http://www.witntv.com/home/headlines/15507667.html.

Monday, January 28, 2008

Blog 1: Should parking time be increased?

02/06/2008
Michelle Quach
Decision Support Systems

Background of Situation

The article, "
Council to Take Up Plan to Ease Parking Limits" by Joe Taylor, addresses the issue of one hour street parking in a downtown city of Michigan. The new city plan, if passed, will change one hour street parking to two hour parking, three hour parking in certain designated zones around the courthouse and government buildings. In addition, the new plans calls for decrease in parking fines from $25 to $15.

Potential Problem

Although citizens are anxious for the new initiative to pass, will two hour parking cause a larger issue? If cars are allowed to park for two hours, there may be a greater chance that other cars arriving may not be able to find a parking space on the street, which may result in angrier citizens.

Modeling the Problem
In order to implement the model, data must first be collected. Data collected must include
(1) the demand for parking (number of vehicles arriving in the downtown area-per unit of time),
(2) the time that vehicles park at the meters (on a typical day) for the current situation-one hour parking max.
(3) the total number of meters in the downtown area.
The assumption made is that all vehicles are looking to park on the street, which in reality, may be preferable since downtown parking lots/garages are expensive. From here, the model should run at least twice; first with the current parking situation; and the second model for the new parking plan (2 hour parking). If we assume two hour parking times for the process time, then we may be overestimating parking times. If possible, two hour parking times can be forecasted based on one hour parking times multiplied by two; or possibly using random numbers for the two hour parking times (that are greater than one hour).

Results
If there is a significant queue of vehicle due to
shortage of parking spaces, then the new initiative should not pass. If there is not significant queue, then the new initiate should proceed.

What if the plan was initiated with out the model?
Running the model will provide a comfort and confidence level for authorities and supporters of this new plan. If the new initiative was passed and created even more issues, authorities and supporters would be embarrassed for creating a larger disaster. Hence, the model can support decisions to whether pass or decline the initiative for all parties-the government, supporters, and oppossers.

References
Lawlor, Joe. "Council to Take Up Plan to Ease Parking Limits." The Flint Jounral. 6 Feb. 2008. Retrieved Feb. 6, 2008 from http://www.mlive.com/news/flintjournal/index.ssf?/base/news-48/1202311223311430.xml&coll=5.

test

This is a test entry.