See the Wormy Composting Case Study.

------------------------------------------------------------------------------------------------------------------------------------------------------------

Wormy Composting Case Study

Wormy Composting, Inc Case Study

New routing software for a compost company

Wormy Composting, Inc. is considering purchasing a software application that will automate their pickup routes. They believe by automating some of the back office processes they can increase their capacity to service 20-25% additional customers.

Currently, Emma spends approximately 6 hours per day scheduling commercial and residential compost bucket pick ups in Lincoln, NE. Emma is a salaried worker whose loaded cost is $40/hour. She also is responsible for processing new customers, moves / address changes, defining the daily pick routes, assessing routes that have grown beyond capacity and adjusting as needed.

Wormy currently has a contract with Compost Logistics, Inc., a software application that plots customers and maps them for $1200 / year. They also use ACT Software to manage the customer database at $3,000 / year. Billing is done by a full-time person (Sally) whose loaded cost is $30/hour. The vehicle GPS tracking service costs $100/year. They have 5 vehicles and 3500 customers.

Wormy is considering buying a new software package that has the following features:

• Routing Module:
  • Automatically places new customers on existing routes based on their location.
  • Optimizes the daily routes and creates a manifest for each driver. Drivers use an app on their phone to see and complete each stop along the route with weight of bucket and time of pickup.
• Customer Management Module:
  • Integrates with billing, automatically refunds customer when the customer requests a skip.
  • Customers can choose if they want email or text notification when a new bucket has been dropped off.
  • Customers can purchase products on the portal such as finished compost, potting soil, t-shirts, etc. The software notifies the driver to bring the product for drop off.
• Billing Module:
  • Subscription based billing schedule determines pick up schedule and customer portal for providing credit card information.
  • Integrates with Stripe for processing payments (credit cards, ACH).
• Vehicle Tracking Module:
  • Tracks vehicles in real time.
• Employee Time Clock Module:
  • Captures employee time (clock in/out) and can export it to excel for payroll.

Cost to implement:

• Flat fee of $3500 to configure and cover administration.
• Base monthly fee of $250/month.
• Cost per active customer location 12 cents per customer per month.
• SME Consulting costs to implement estimated at $18/hour for 120 hours.
• Requires 5 android phones (one for each vehicle) and a wireless plan @ $60/month (includes the phone).

Andy Wormy is the president of Wormy Composting. He and Emma negotiated with Tom Sugar from Urban Compost Systems, Inc.on the price and timing of the project. Tom believes that the system will reduce the amount of billing resource time to 50% of their current billing time. Emma expects to reduce the amount of time she is working on activities that will be automated by the systems by 40%. Freeing up Emma and Sally's time will allow them to support additional growth. Andy expects that the system will allow them to expand their business by 20% each year over the next 4 years after implementation. The bank has indicated their current interest rate would be 4%. The current customer subscription rate is $15/month.

----------------------------------------------------------------------------------------------------------------------------------------

You will be developing a project charter and cost benefit analysis, Work Breakdown Structure (WBS), schedule, and communication plan.

This week, create a project charter, to include a cost-benefit analysis, for Wormy Composting.

Do research to find a project charter template to use . The template should include at minimum the following sections:

• Project name and description
• Project objectives
• Anticipated costs
• Scope
  • In Scope
  • Out of Scope
• Key Stakeholders
• Anticipated duration of project and Milestones
• Anticipated resource requirements
• Known risks, constraints
• Cost/benefit Analysis
• Success criteria
• Signature of project sponsor and project manager

Rubric

Assignment Rubric

Criteria

Ratings

Pts

This criterion is linked to a Learning OutcomeAppropriate and Relevant Experience

30 pts Submission is articulate and relevant to course learning objectives. Submission provides clear evidence from the course readings and lecture information that demonstrate sound interpretation and reasoning. All opinion-based comments relate to the assignment and are fully supported by evidence from the course resources and research.

30 pts

This criterion is linked to a Learning OutcomeInnovation and Critical Thinking

50 pts Submission expands the analysis beyond the scope of presented materials by providing evidence of reflection and insight, as well as integration of original ideas. Submission provides solutions or positions based on well supported conclusions (i.e. evaluated relative to the issues of the assignment); Submission explore sound ideas in nontraditional ways. Submission recognizes the interrelatedness of stakeholders and identify that are crucial to the analysis and clearly address alternative points of view through integration of various perspectives.

50 pts

This criterion is linked to a Learning OutcomeProfessional Language and Style

10 pts Submission is free of spelling and grammar errors Language of submission clearly and effectively communicates ideas. Submission style is consistently professional. APA style is used for references and contains no errors.

10 pts

This criterion is linked to a Learning OutcomeOverall outcomeOverall Assessment

10 pts Excellent

7 pts Good

4 pts Fair

2 pts Poor

10 pts