Describe the data needs of a small company

Assignment Help Management Information Sys

Reference no: EM132102827

Information System Project Case Study

Geo and Sally's Flower Shoppe

The following is a case study to describe the data needs of a small company.

The descriptive material includes:

- Background
- Business Processes
- Personnel
- Forms and Documents
- Interviews

Background

Geo and Sally's Flower Shoppe began 10 years ago as a small local flower shop by two friends who loved creating beautiful flower arrangements for a reasonable price. Over time, Geo and Sally's customer base began to expand as local customers told friends and family members around the country about the wonderful arrangements Geo and Sally could create for a very reasonable price.

Besides flower arrangements, customers were interested in purchasing the unique pots they used for the arrangements, floral and garden accessories, garden flowers, vegetable plants, bushes, and even smaller trees. In addition to family customers, the business has expanded to include several small and even a few larger businesses in the local area. Through all of the expansion, flower arrangements remain the mainstay and primary profit center for the business. Geo's brother Sammy suggested Geo and Sally set up an Internet storefront to sell more flower arrangements, which they did last year. They now find themselves owners of an ever-expanding Internet business with a loyal local customer base at their shop in Denver, Colorado.

The shop itself has grown from the initial 500 square foot modified living room of an old home Geo used to live in to a new 6,000 square foot facility the company moved into two years ago. It includes a 1000 square foot showroom where they can display a variety of unique flower arrangements and containers. Arrangements in the showroom that do not sell within three days must be replaced so only the best items are seen and purchased by the large walk-in customer base.

Geo and Sally's information and data storage needs have exceeded the capacity of the current system. Sammy told Geo that he and Sally need to hire a consulting group to help them to implement a modern database system for accounting, payroll, inventory control, and sales.

Business Processes
Personnel (position: name - process responsibility)

1. Owners: Geo and Sally - all
2. Sales Manager: Sammy - 1, 5
3. Salespersons: Saria, Rasta, Danny, Tiffany, and John (Internet sales only)
4. Bookkeeper: Sasha - 5, 6, 7, 8
5. Operations Manager: Dylan - 2, 3, 4, 6
6. Workers: Jeremiah, Sharon, Mariah, Shelly, and Linda
7. Purchasing Manager: Donn - 2, 3, 4

Forms and Documents

(Figures 1 through 13 represent skeletal data descriptions-input and output-of the manual system.)

1. Customer Invoice

2. Commission Statement

3. Vendor Data Card

4. Vendor Invoice

5. Inventory Report

6. Purchase Order

7. Daily Sales Summary

8. Time Card

9. Payroll Check and Summary Form

10. Federal 941 Payroll Tax Withholding Summary

11. General Ledger

12. Bank Deposit Record

13. Cash Register Ticket

Attachment:- Information System Project Case Study.rar

Reference no: EM132102827

Questions Cloud

Briefly outline the workforce planning process : Briefly outline the workforce planning process. Briefly explain each step in the recruitment and selection process.

Minimize the factory total annual average inventory cost : Calculate the EOQ that would minimize the factory’s total annual average inventory cost.

Corporations differ from nonprofit organizations : How do the pricing strategies for corporations differ from nonprofit organizations (NPOs)? Provide examples.

Employee involvement and quality-of-work-life programs : What are the three components of employee involvement and quality-of-work-life programs?

Describe the data needs of a small company : Describe the data needs of a small company - implement a modern database system for accounting, payroll, inventory control, and sales

Compare two sources of financing you might obtain : Research ways to get the money for such a business. Compare two (2) sources of financing you might obtain.

Research accounting fraud since enron and financial crisis : Ability to focus the reader's attention on the subject of the research paper in a thorough paragraph which effectively leads into the thesis statement;

Discussion on Identifying and recruiting top talent : Identifying and recruiting top talent is a major priority for any organization. Selection involve many potential steps: human judgment, behavioral interviews

Develop a faux special event to be held in a location : Utilizing this five stage process, develop a faux special event to be held in a location of your choice.

User Account

All Pages