Midwest Farm Supplies
• Began operations in 1931
• Provides farming supplies such as
• Steady profits for 70years
• Distribution centers:
➢ Competitors are getting more computer literate
➢ Products sold by Midwest are manufactured by other companies but guided by the designs and specifications provided by Midwest.
➢ Prefers face to face dialogue with sales rep due to some limitations by phone conversation.
Firm as a system:
• The management is organized and communicates ...view middle of the document...
• Sales reps with home-based offices cost less than those of conventional employees in the offices spread across Iowa
• Sale reps are competent since the management provides continuous learning and training on technical competencies of each
• Cost for accessing company-wide applications are higher than the need to be
• Current order entry application takes longer to run
• The added communications needed to support the changes ends up with added expenses
• Customers already feel comfortable with the ordering system of the company
• Midwest already established a good customer relation to their clients through face to face interaction of sales reps to their customers.
• Sales reps of Midwest farm supplies are competent since their technical competencies are continuously being trained by the company thus they are confident in answering customer requirement and queries
• With Iowa being sparsely populated, distances between farms are greater and sales reps have to travel farther to service customers
ACA#1: Upgrade to Client-Server Database System-but with DR(data recovery system)
▪ Secure - Servers can better control access and resources, to guarantee that only those clients with the appropriate permissions may access and change data.
▪ Easier to administer - Since data storage is centralized, updates to those data are easier to administer and view realtime.
▪ Traffic congestion - As the number of simultaneous client requests to a given server increases, the server can become severely overloaded – this needs to have a login control/counter to monitor simultaneous logins
▪ Lacks robustness - Under client-server, should a critical server fail, clients’ requests cannot be fulfilled – this needs to have a DR (data recovery) system that requires another set of DB to sync with the server DB once or multiple times a day.
ACA#2: Upgrade to Distributed Database System
▪ Reflects organizational structure - database fragments are located in the departments they relate to.
▪ Local Autonomy - a department can control the data about them
▪ Improved performance - data is located near the site of greatest demand
▪ Complexity - Extra work must be done to...