Question

In: Computer Science

If I have a data warehouse for drugstores, what are the problems that this warehouse solves,...

If I have a data warehouse for drugstores, what are the problems that this warehouse solves, what are its requirements and what is the process run for it?

Solutions

Expert Solution

-> Deficient or erroneous records regularly uncover themselves when a distribution center laborer endeavors to recover item from a normal area and it isn't there or then they are coordinated to store item into an area that is as of now full. Time and exertion are squandered making physical checks and attempting to address mistake, frequently prompting deferred shipments and mis-picks.

A large number of these issues are an aftereffect of not exactly ideal, troublesome manual procedures that bring about creating wrong information in the framework. One arrangement is the fuse of distribution center execution framework (WES) applications and different frameworks that help to computerize information recording exercises.

-> The presence of pointless, over the top treatment of item torment numerous distribution centers, with cases or beds being traveled through a few transitional areas. Frequently, however, repetitive exercises can be more subtle. Duplication of data and copy information section are instances of significant timewasters.

What to do about it? Approach the group for thoughts and, for an alternate point of view, talk with authorities in distribution center innovation. Another design may help, or perhaps it's the ideal opportunity for interest in a cutting edge WES.

-> In the event that picking isn't done productively, clearly time and cash are squandered. However what does "effective" resemble? In a perfect world, picking limits time and development, with the objective of boosting units picked every hour. Distribution center robotization can help with this by actualizing computerized recovery and picking arrangement.

Not exploiting information perusing and section advances can likewise prompt problematic picking. Slip-ups are made, conceivably making twofold dealing with and stock issues.

-> The arrangements are to normalize forms, including pick courses, and put resources into proper computerization for information dealing with/stock administration.

Accomplishing great space usage has taken on new criticalness with the ascent of web based business. In satisfaction focuses, there's greater development and picking, expanding the expense of helpless design. Likewise, stockroom areas near populace places frequently involve increasingly costly land, which drives up costs.

Utilizing a WES information to distinguish the most every now and again picked things and afterward, reworking capacity areas to limit separation went for picking these. Moreover, investigate what new racking and capacity innovation could never really impact use. For instance, a high-thickness mechanized capacity and recovery framework (AS/RS) could essentially expand space usage.

-> There are horde of reasons that item can be harmed in a distribution center. Now and again this is found during picking.

Present day racking and bed stream frameworks can move item more cautiously than more established innovation. Cases are decelerated and zero weight frameworks keep up a base detachment to forestall harms. AS/RS is, by and by, another arrangement.

-> File this under “poor layout” if you want, but it’s a problem big enough to warrant a separate heading. As e-commerce has grown, so too have return volumes. A common problem with an informal or haphazardly planned system incurs double handling. What’s more, poor record keeping results in workers spending time resolving queries.

As a potential solution, start by understanding the product flow and documenting the activities being conducted in the warehouse. From there, move into standardization and assess how technology could help. Automation providers experienced in assessing warehouse problems and providing efficient solutions may have ideas you haven’t considered.


Related Solutions

Fluid Mechanics Friction Problem: Write one MATLAB m-file that solves the Type I and II problems...
Fluid Mechanics Friction Problem: Write one MATLAB m-file that solves the Type I and II problems presented in class based on the file posted for the Type III problem (use Colebrook to estimate f). Type I: Solve hL for v=0.74x10-5ft^2/s, D=3 in, L=1000 ft, e=0.006 in, and Re=80000. f=0.0258 from Moody Chart. Type II: Solve Q for v=10^-6 m^2/s, D=0.2 m, L=500 m, e=0.046 mm, and hL=30m. Use “rough” Colebrook to generate an estimate for f.
Set up a spreadsheet that implements the secant method and then solves each of the problems....
Set up a spreadsheet that implements the secant method and then solves each of the problems. Use the graph of each function to select an initial guess. Recall the iteration formula for the secant method: X^k+1=x^k-[f(x^k)/f(x^k)-f(x^k-1)](x^k-x^k-1) Put the formula for the function under the heading f(xk-1) and f(xk). In the cell under xk+1, put the secant method iteration formula. In the second row, replace the previous xk-1 with xk and then xk with xk+1. Now copy the two formulas down...
C programming problem I have to design an efficient algorithm which solves this problem. Also, it...
C programming problem I have to design an efficient algorithm which solves this problem. Also, it needs to include time and space complexities of this algorithm. There is a matrix (N times N) of integers which rows and columns are sorted in non-decreasing order. A sorted matrix and integer M will be given and we need to find the position(row,column) of M in this matrix. it's okay to report only one position if there are more than one answers. when...
What are the similarities and differences between database, data warehouse, and data mining?
What are the similarities and differences between database, data warehouse, and data mining?
a) List and explain three problems with IRR, and whether or not MIRR solves each problem....
a) List and explain three problems with IRR, and whether or not MIRR solves each problem. Your explanation should include why these are problems (why we can't just ignore these issues). b) List and explain (in one to two sentences each) two problems with payback period that are not problems for NPV. Your explanation should include why these are problems (why we can't just ignore these issues). c) There are three characteristics that we need to know about a project's...
1.    What is Big Data? Why Is Big Data Different? (from data mart, data warehouse) 2.    What Are...
1.    What is Big Data? Why Is Big Data Different? (from data mart, data warehouse) 2.    What Are the Benefits of Big Data? 3.    Some of the potential business benefits from implementing an effective big data analytics 4.    How can organization leverage Big Data? For example, Big Data can be used to develop the next generation of products and services. For instance, manufacturers are using data obtained from sensors embedded in products to create innovative after-sales service offerings such as proactive maintenance to avoid...
With a cube from a database or data warehouse, you are bringing data "forward." Explain what...
With a cube from a database or data warehouse, you are bringing data "forward." Explain what this means and how it impacts the front-end and back-end user from a database perspective. Provide examples to illustrate your ideas. typed please
Suppose you are choosing between the following two algorithms: Algorithm A: solves problems of size n...
Suppose you are choosing between the following two algorithms: Algorithm A: solves problems of size n by recursively solving two subproblems each of size (n-1) and then combining the solutions in constant time (take T(0) = 0). Algorithm B: solves problems of size n by recursively solving one subproblem of size (n-1) and then combining the solution in (log n) time (take T(1) = 0). Write down the recurrence relations for the above algorithms.                           Solve the recurrence relations...
Why airplanes in War World I was important to society and the problem it solves?
Why airplanes in War World I was important to society and the problem it solves?
Hello, I'm having a hard time solving these problems because I have no idea on what...
Hello, I'm having a hard time solving these problems because I have no idea on what to do with accrued interest. Help is highly appreciated! On March 1, 2015, Bowan Corporation issued 6% bonds dated February 1, 2015, the face amount of $700,000. The bonds were sold for the present value of the bonds on March 1, 2015 plus one-month accrued interest. The bonds mature on January 31, 2018. Interest is paid semiannually on July 31 and January 31. Bowan's...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT