CMGT/445: Case Study: Appliance Warehouse – Application Design
BlackWolf
ResourceLibrary.zipResource Library/build-costs-and-durations.xlsx
Sheet1
| Costs for in-house development | Standard Development Times | ||||
| As standard practice, use these costs for all in-house development. | As standard practice, use these guidelines (assume 8 hours of work per day). | ||||
| Cost per hour (for first year) | Duration | ||||
| Database Development | $ 60 | Database design | 5 days | ||
| Web developers | $ 75 | Database build | 10 days | ||
| App developers | $ 75 | Design of a report (web or app) | 2 days | ||
| UX designers | $ 60 | Design of data entry page (web or app) | 2 days | ||
| Business Analyst | $ 50 | Design of static text page (web or app) | 1 day | ||
| Trainers | $ 50 | Build of a report (web or app) | 1 day | ||
| Cybersecurity specialists | $ 90 | Build of data entry page (web or app) | 1 day | ||
| System Admin | $ 70 | Build of static text page (web or app) | 1 day | ||
| Connection to separate system or database (sys admin) | 8 days | ||||
| Analysis work (both web and app combined) | 20 days | ||||
| Training | 5 days | ||||
| Equipment: | Cybersecurity work | 10 days | |||
| Servers | $ 2,500 | ||||
| Routers | $ 200 | ||||
| Expected Monthly Maintenance: | |||||
| Development (web or app) | 2 days | ||||
| System Admin | 3 days | ||||
| Training | 1 day | ||||
| Key: | |||||
| Web or app = activity must be done for both web and app. Same amount of time required for each deliverable. | |||||
| Both web and app = time given includes development for both of the web and app deliverables. |
Resource Library/historical-analysis-phase-durations.xlsx
Sheet1
| Analysis and Design task durations | |||
| Project name | Year | Task name | Duration |
| Accounts Payable | 2018 | ||
| Interview process | 5 days | ||
| Development of User Questionnaire | 2 days | ||
| Identification of risks | 1.5 days | ||
| DFD diagram | 4 days | ||
| UML diagram | 4 days | ||
| Layout of 1 report | 4 hours | ||
| Layout of 1 user screen | 2 hours | ||
| Testing plan | 5 days | ||
| Implementation plan | 3 days | ||
| Human Resources | 2017 | ||
| Interview process | 4 days | ||
| Development of User Questionnaire | 2 days | ||
| Identification of risks | 1 day | ||
| DFD diagram | 3.5 days | ||
| UML diagram | 2 days | ||
| Layout of 1 report | 2 hours | ||
| Layout of 1 user screen | 4 hours | ||
| Testing plan | 7 days | ||
| Implementation plan | 3 days | ||
| Payroll | 2019 | ||
| Interview process | 6 days | ||
| Development of User Questionnaire | 1 day | ||
| Identification of risks | 2 days | ||
| DFD diagram | 4.5 days | ||
| UML diagram | 5 days | ||
| Layout of 1 report | 1 day | ||
| Layout of 1 user screen | 4 hours | ||
| Testing plan | 5 days | ||
| Implementation plan | 3.5 days |
Resource Library/organizational-staffing.docx
Appliance Warehouse staffing
Parts Department – purchasing, inventory control, sales
· Director: Maddox Farley
· Sales staff: Tyler Cummings, Steve Dawson, Amelia Warner
· Purchasing: Celia Martel, Joe Perez
· Inventory/warehouse: Ben Cooke, Melissa Benedict, Matt Jones
Appliance Sales – sales of new appliances in 4 departments
· Director: Sonia Lopez
· Large Kitchen Appliance department: Mike Nelson (manager), Jessica Scott, Rachel Evans, Justin Cooper
· Laundry Appliance department: Tina Turner (manager), Mackenzie Scott, James Wright
· Audio/Visual department: Samantha Campbell (manager), Tim Reynolds, Tracey Oliver
· Small Appliance department: Peter Parker (manager), Ken Howell, Marti Castillo
Service Department
· Service Manager: Emily Johns
· Technicians: Liam Henson, Mark Robles, Lee Wong
· Appointment setters: Lisa Shields, Jake Meyers
· Equipment and parts: Rhonda Patel
Storewide Cashiers:
· Manager: Abby Franklin
· Cashiers: Nancy Richards, Joy Vasquez, David Goodman, Paul Patton, Maria Nunez
Administrative roles:
· Owner (store manager reports to this role): Mae Roth
· Store Manager (all department heads and assistant manager report to this role): Alan Marks
· Store Assistant Manager (admin roles report to this assistant manager): Ali Miranda
· Admin Assistant to store manager: Tim Stafford
· Human Resources specialist: Joey Booker
· Accounting, payroll, accounts payable/receivable: Doug Dorsey, Tia Carey
· IT department: Carlie Davis (manager), Tony Barlett, Meredith Parks, you
Resource Library/results.docx
Questionnaire results
Results are ordered by importance. The top result (#1) is the most important to that group.
Most common features requested by appointment setters:
1. Reminder services calls/messages
2. See technician’s availability
3. Determination of discounts for customers
4. See availability of parts to schedule repair
5. View service history
Most common features requested by technicians:
1. Able to view own calendar
2. See availability of parts to schedule repair
3. Keep notes for each customer
4. Mobile access of scheduling
5. View service history
6. Reminder services calls/messages
Most common features requested by parts department:
1. Can pull inventory requests every two hours.
2. Database of requested parts.
Most common features requested by management:
1. Reporting by time period, type of appliance, brand
2. Determination of discounts for customers
3. Mobile access of scheduling
4. Routing and mapping of technician’s driving to appointments
5. See technician’s availability
6. Suggest preventative maintenance to customers
Resource Library/service-records-sample.docx
Service Records Sample
