You need a working spreadsheet for a cost/benefit analysis (over five years), including ROI, NPV (@ 4 %), and a breakeven analysis (refer to the benefits and cost numbers calculated by your spreadsheet for the economic feasibility)

Systems Request

Project Name: Integrated Information System for My Sweats Inc.

Project Sponsor: Franklin Sierra, CEO of My Sweats Inc.

My Sweats Inc., located in Richmond, Virginia, sells sweatshirts, sweatpants, and T-shirts. They have defined their mission as being a provider of high-quality sweat and T-shirt apparel using simple designs. More specifically, they purchase the right to use the name/logo of institutions (e.g., universities) and sports franchises. For the first two years of operation, My Sweats operated out of a garage. However, because of a rapid increase in demand, the owners leased some office space that housed all aspects of their operation: sales/marketing, production, distribution, billing, and administration. During the first year after the move, My Sweats increased its workforce by 50% to keep up with demand. However, profits have started to dwindle. The owners feel that the lack of a proper information infrastructure is the main cause for the drop in profits. My Sweats would like to upgrade its information system to restore profitability and to continue to expand its business. Currently, the company employs 20 people.

Business Need: My Sweats Inc. is facing challenges due to the rapid increase in demand for its sweatshirt, sweatpants, and T-shirt apparel. To increase profitability, support business expansion, My Sweats Inc. is considering an integrated information system that streamlines its operations, enhances inventory control, and enables efficient order processing, billing, and distribution. The company also seeks the management reporting capabilities to make informed decisions.

Business Requirements:

• Order Processing: Implement an automated order processing system.
• Inventory Management: Develop a system for monitoring inventory levels.
• Billing and Royalty Calculation: Integrate billing and royalty calculation processes.
• Distribution and Shipping: Automate creation of invoices and update accounts receivable information.
• Purchase Order Management: Automate the procurement process.
• Customer Relationship Management (CRM): Develop a centralized customer database.
• Web Integration: Utilize the World Wide Web to enhance customer service.
• Management Reporting: Create a comprehensive reporting system.

Business Value:

• The new system will eliminate redundant data entry, manual processes and provide increased operational efficiency. The new system will help improve the inventory management, enhance customer service and provide advanced reporting capabilities to the management to help them enable data-driven decision-making and strategic planning.

Special issues and constraints:

• Implementation must be on or before MM/DD/YYYY.
• No new facilities.
• Personnel must remain the same.
• Only four additional computers have been approved for this project.