Vicki brasel state farm insurance

Management Information System Decision Support

Final Project Plan

https://lh3.googleusercontent.com/kbssA9QJO9yt9YZieNmz_dk0RpuW70s6Ufb3wvPMKH-0-LX_U37TG-VhShiSXYld75bzHG8gXZWYB62hNxIc1_o0yYjxZWXIJPqs3HRBb3TvQTrRZWjYntqWZZzCpyWnlom-c0YD

MGT 311

Dr. Bhargavi Bandi

Student 1, Student 2, Student 3, Student 4

April 27, 2015

Table of Contents

Executive Summary 3

Project Purpose 4

Project Objective 4

Property 4

Insurance 5

Vehicles 5

Tracking Software 5

Technology 6

Computers 6

Computer System: Oracle 7 Potential Risks 8

Project Budget & Financials 9

Conclusion 10

References 12

EXECUTIVE SUMMARY

With environmental awareness becoming more and more prominent in our society, Evergreen Recycling Management will look to provide the residents of Warrick County, IN, with an alternative to city-provided waste services through a cheaper and more simplified approach to the recycling process. Currently there are four companies vying for individual curbside trash pickup in Warrick county, Eric Griese, Advance, Waste Management, and Republic. Only one of these companies offers the option to recycle.

https://lh6.googleusercontent.com/x5PcEx5tM9tglX8yQYkSd41z3SKmb8J7pRifBfI28FzMVXldXjVaD6dTWzTFz5mbEDtUBgXbn5BICkRWf-eKSp3VqgP4GGHZW0e2p1JeFAJkVD9MLsef-hgE8btV0sf994fqC1YRThese companies charge a varied price for service to Warrick County’s 22,000 residential units, each currently paying an average of $35.00 per month for their waste and recycling services. We believe they deserve a better, cheaper option that will meet their waste-elimination needs. With a commercial lot now available in centrally located Boonville, IN, introducing Warrick County to a new system of recycling can now be managed in an efficient and effective way.

With a zoned one acre lot, service building, and utilities readily available at 424 West Main Street in Boonville, Evergreen Recycling Management would not need to dedicate an unnecessary amount of time in clearing land or building necessary structures. The lot would include a service building equipped with WIFI and other technological capabilities (computer systems, telephones, etc.) as well as plenty of space for the rented trucks and equipment to be stored when not in use.

PROJECT PURPOSE

Our project’s main goal is to provide a realistic and affordable alternative for Warrick County residents to be able to dispose properly of their recyclable items. We would like to operate from our central location in downtown Boonville, IN, in hopes of effectively serving the county’s 22,000 households by making regular routes five days a week. PROJECT OBJECTIVE

The recycling industry can be very profitable if implemented correctly, and we believe that the fees and revenue collected from each customer will help us to begin making a profit after the first year. With our initial investment of $259, 081.17, we expect our one-time costs such as vehicle tracking equipment and computer software such as Oracle to help offset our monthly costs including vehicle rent, utility, security, and maintenance costs. We hope that ending our first year with a marginal profit will allow us to grow to be a strong contender in Warrick’s recycling system.

PROPERTY

https://lh5.googleusercontent.com/JBkEolWnSlS5ybR_zT8s2BF9oR9J1ml60uI1hYW0g65OzAHFeVYlmpkrrYlCCiI7N1LrHRJtjHB59FgTpZnXVU3z4XhNe5iOq_6tYPGu-eiHh6B8fzAvMemkJO8hn76uPDn1SYrh Our property, located at 424 West Main Street in Boonville, IN, is the prime location for Evergreen Recycling Management to begin its business. With a fully-constructed office building ready for use on this $136,000 lot (Zillow), this

location would enable our company to operate out of a centralized location on a daily basis. The open space on the lot allows for plenty of room to park our three recycling trucks with room to spare. This lot also provides Evergreen with an ideal central location to serve Warrick’s nearly 700 miles of maintained roads.

INSURANCE

We are prepared to enter into a contract with State Farm’s local branch and have chosen to have Vicki Brasel serve as our insurance agent. State Farm would provide us not only with protection and limited liability for our vehicles but also for any cases involving personal injury and safety. Our insurances costs are expected to be $2,084 monthly with our annual insurance fees being $25,000 to finish out our first year of operation.

VEHICLES

Image result for recycling trucks Evergreen Recycling Management intends to rent three recycling trucks from RDK Truck Sales at a rate of $6,500 per month per truck. We currently plan to run these three vehicles on specified routes five days a week, and each vehicle’s safety guards and coverage will be purchased and installed through American Medical Response (AMR) with the necessary equipment and software being purchased at $1,500 each. Services and maintenance for each truck will also be provided by RDK for another $1,500 each month to ensure that each vehicle is up to code and meets all necessary safety standards.

Tracking software

Our vehicle tracking software will be licensed through Rhino Fleet Tracking. Our initial order cost for this technology, which would enable our business to track the speeds of the vehicles at any given time and monitor fuel levels and mechanical functions, would be about $494.25 with our monthly payments coming to be about $84.75.

TECHNOLOGY

Computers

http://www.extremetech.com/wp-content/uploads/2014/01/dell-p2213-dual-bundle-stand-et.jpgThe computer power that we will need for this company will be fairly simple. For the four of us we will have a desktop computer from Dell and will cost $479 each. These computers do not need to be the fastest on the market since we will only be using them for email, tracking software for our trucks, and maybe some YouTube videos. These computers will have the Dell i5 processors which are about middle grade. We do not need advanced graphics cards or water cooled CPU fans. These are simple and perfect for what we will use them for. For our monitors we will need the Dell 22 Dual Monitor which will cost $469.99 each. These screens will be perfect for our business because we can have the truck tracking software on one screen at all times and still have a free screen to do other business on. They are full 1080p which is good enough for what we will use them for. We do not need a screen that has 4K resolution because our desktops would not be able to handle that resolution anyway. We will need a server for our tracking software and for a potential website. The Dell PowerEdge T330 Tower Server will be perfect. We will only need one which will cost us $699. This entry level server is ideal for our business because we will only be using it for lower power usage programs. The T330 has an Intel Celeron G3900 processor with 4GB of memory and a 500GB hard drive. This server also has a 1 year warranty if anything goes wrong with it.

Of course with these computers and servers, we will need an internet connection. We will need the extreme internet package from Time Warner Cable which will cost us $54.99 a month. This internet package goes up to 50 megabytes per second which is perfect for our vehicle tracking software to run on and get the fastest updates. This will also enable us to get back to customers emails faster. Another reason we will need 50 megabytes per second is between the four of us in the office we have to split the speed. So if all of us are in the office we will only be able to get 12.5 megabytes per second. This is still a good speed to run our vehicle tracking software and be able to get to our emails. We will also need wifi for our personal computers to be able to get to our emails and vehicle tracking software from anywhere in the office. We will need the Netgear Rangemax WiFi Modem which will cost us $79.99. This modem will enable us to have internet connection from anywhere in the building. For our desktop computers we will need an ethernet cable box. This gives us the best internet connection possible for our desktops. The Black Box 6-Port Ethernet Box will cost us $209.99 but will also enable us to add two more computers for expansion. The Black Box is the best on the market because it gives us surge protection from the internet cable line so a lightning strike doesn't fry our computers if it hits the internet line. They are also the most durable and long lasting ethernet boxes on the market. Computer Systems: Oracle

In order to best track daily operations, we would like to install and utilize certain applications provided by Oracle’s E-business Suite, particularly Oracle’s Human Capital Management services. Through the E-Suite, Evergreen’s management would be able to monitor and manage nearly every possible aspect of the business, including but not limited to managing payroll accounts and time cards, refining its Customer Relations Management by collecting consumer data and ensuring that all customers served are having their needs satisfactorily met, and much more.

https://lh6.googleusercontent.com/mVMmrZV3mUW7QzD3ltczavoAMoG1pyzXU6Cy3BzoqQdGvrEMUQBGE8stIhnZ-63wQTdqAL5DuXKtkIeflV3DgPogkNWJutsmu7Rx2ws7uBFMzv63vbXCqVkPKNu8-HsNmLXK_oEq For $9.50 per month per user, Oracle’s E-business Suite would also enable Evergreen to manage its financials and reporting systems as well as inventory. Being able to handle all of this data in one place will help Evergreen to be organized and prompt when documenting training sessions for employees, reporting site standards to the Occupational Safety and Health Administration, tracking all financial processes such as taxes, and completing other tasks.

We would like to pair the E-business Suite’s capabilities with Oracle’s WebLogic Suite. For $900 per license, WebLogic would enable Evergreen’s management to merge its database from E-business to a more sophisticated format should the business decide to grow into surrounding areas such as Vanderburgh, Posey, Dubois, or Daviess counties in Indiana. WebLogic’s capabilities would allow Evergreen to build a more specialized infrastructure to hold larger quantities of data and to expand its ability to process this information in a more efficient and useful way.

POTENTIAL RISKS The greatest risk in starting any business is arguably the competition. Since we will be a new company, without any prior exposure to the market, our competitors will have an edge, especially if they are well established. We hope to overcome this risk by segmenting the market and targeting customers who we think will desire our services most. By offering better services than our competitors at competitive pricing, we think that we can overcome the risk of going bankrupt early in our career.

Another potential risk is our team setup. Since the four of us have an equal share in the company, it requires us to be in agreement on most issues. It will be important for us as a team to listen to one another and consider all of the suggested options. This will ensure that our plans are well thought out and that everyone feels as though they are bringing value to the table.

Arguably the greatest risk is financial mismanagement. With all startup businesses, financial stability is always a risk. Once we begin to bring in revenue, it is extremely imperative to manage our money as we have planned according to the budget. This will ensure that we maintain financial security.

BUDGET BREAKDOWN & FINANCIALS https://lh5.googleusercontent.com/Tv2TRva1ccCyzmcbT9vi4l6jv9Tu7yS0eDinX3_iIt7AhU8d7zYsjQsh3XKUYxj4WIO24bghM7EjoVgJbv61kU-2Ox9OagzczfmNplLdHbZRu0DY6RPhcy5DpXqXUMTzKWaCQybg

Loan Request

Projected Profits

One Time Cost

Month

Year

Land and Improvements

$150,000.00

$150,000.00

Sales

$77,000.00

$924,000.00

Loan Closing

$1,753.60

$1,753.60

dump profit

$111,718.75

$1,340,625.00

Computing Equipment

$3,667.94

$3,667.94

Oracle

$900.00

$900.00

Salary

$26,666.00

$319,992.00

Vehicle Safety and Tracking Equipment

$1,482.75

$1,482.75

Bills

$8,439.74

$101,276.88

Month

Year

Loan Payment

$30,000.00

$360,000.00

1 year rent on vehicle

$6,500.00

$78,000.00

1 year maintenance cost

$1,500.00

$18,000.00

1 year utilities

$300.00

$3,600.00

1 year Internet

$54.99

$659.88

1 year safety monitoring

$84.75

$1,017.00

Total

Total

$259,081.17

$123,613.01

$1,483,356.12

CONCLUSION

With our local community becoming much more interested in making recycling a priority, we at Evergreen Recycling Management believe that our company would provide Warrick County customers with a viable and affordable option for their recycling needs. By keeping our employee base low with only four employees, each of which will be fully trained and licensed to drive our commercial vehicles, Evergreen will be able to focus on ensuring that our daily services will help our community to be more environmentally friendly but also help our company build a profit through the high collection of low rates of $14 per household and the revenue earned from recycling the items themselves. We respectfully request this loan as an investment to not only help our business flourish but as an investment to help our area take steps to protect our environment.

REFERENCES

Truck rental

RDK Truck Sales, Sales Manager, Phone, April 2016

Maintenance and service

Advance waste disposal, Area Site manager, Phone quote, April 2016

Insurance

State Farm, Vicki Brasel, Phone quote, April 2016

Property

ERA, Dave Talley, Realtor, Phone consult, April 2016

Title processing and Insurance

Bosse Title company, Christina Lefflers, Closing Agent, Quote, 22 April 2016

http://www.oracle.com/us/products/applications/ebusiness/overview/index.html

http://www.oracle.com/us/products/applications/057307.pdf

http://searchfinancialapplications.techtarget.com/feature/Product-of-the-month-Oracle-HCM-Cloud-8

https://shop.oracle.com/pls/ostore/product?p1=OracleWebLogicSuite&p2=&p3=&p4=&p5=&intcmp=ocom_oracleweblogicsuite