Production and Delivery Management in Manufacturing – Case Study

In the manufacturing sector one of the most important factors to increasing profit margins is by optimizing the production process. Without an effective production scheduling method, deadlines can be missed and labour costs can eat into profits. This isn’t unique to manufacturing, as any business that creates a product needs to manage schedules, but in fabrication where a project can involve manufacturing hundred or thousands of parts a solid method of scheduling those projects is important.

We were approached by Apex Fabrication & Supply Ltd. in London to help take their existing spreadsheet-based schedule and offer a more easily-manageable and flexible system. Apex deals mainly in design and fabrication of sprinkler systems and other custom fabrication needs. They needed a solution that offered an easy-to-manage production schedule where they can add and manage jobs, as well as a special delivery schedule system where they could assign deliveries for completed jobs to their various drivers. After identified specific needs we built out a custom scheduling system that offered a variety of key features that optimized their production scheduling and their delivery assignment.

Improved Project Management

The heart of the system is in it’s custom calendar system that we built to handle the client’s unique scheduling needs. We looked at several existing solutions and found that none offered exactly what was needed, so we built a customized solution based off the a calendar plugin called FullCalendar. FullCalendar offered a very basic core framework that we then heavily customized to suit our needs. The final calendar system offered the client several unique features including:

  • Weld & Thread job types linked to separate schedules.
  • Weekend and non-weekend schedules.
  • Colour coding jobs.
  • Blocking out holidays and blocks of time.
  • Reordering scheduled jobs

We simplified the job addition process by creating a small form that allowed Apex to schedule a job immediately after the previous one. By default, weekends were skipped unless a job was specifically scheduled for then and jobs with a duration that ran multiple days automatically spanned.

Client Management

Apex needed the ability to assign jobs to their own clients, so we built a client management section that allowed them to enter client details. Several of their clients have multiple locations so we built the system to allow additional locations to be assigned to each client through a simple single-screen panel. From the sidebar, the client’s name would have a number appended to the right showing the number of locations that client has. They would then be able to select the exact location when it came time to assign the delivery.

Delivery Schedules

Scheduling deliveries was the second biggest component to this project and had several unique requirements. As jobs were added to the production schedule they would also appear in the Delivery section. When a job was completed Apex could select one of their drivers and drag the job to their delivery schedule. They could assign an order to deliveries and move them between days. If a job duration was changed during production or a job was moved to a different day, the delivery schedule would automatically notify them that the delivery schedule has changed and update the system. After a schedule was set their drivers could log in with their own account and view their delivery schedule for a specific week or day.

The day schedule showed a list of deliveries formatted in a way that allowed it to be printed out for the driver to take with them. The printout showed the delivery location for each job along with a map of the location as well as custom order notes.

Simple User Management

We built the application with a simple user authentication system that allowed Apex to create accounts for their staff. Administrative accounts could be assigned to allow full control of the production and delivery schedule, as well as driver accounts that would allow access to only the delivery schedule of that driver.

Fully-Hosted and Secure

Once the project was finalized we offered the client a secure and fully hosted solution for the application that allowed them instant access to their schedules from wherever they may be. It was set up as a custom virtual server which could easily be migrated to an in-house server down the road if they decide to go that route.

The Technical Details

The full application was built in PHP and MySQL using the Laravel framework and hosted on a secure Linux server. The interface elements were based off the Aquincum theme. The core framework of the calendar is based off a heavily modified version of FullCalendar. The front-end functionality of the application relies heavily on jQuery and AJAX.

Web and Mobile Applications in the Agricultural Sector – Case Study

Our studio is located within a community that is largely comprised of rich rural farmland. Chatham-Kent is known as one of the biggest agricultural suppliers in the world and as such is home to many ag-related companies. To those not familiar with the agriculture sector, it may come as a surprise to find out that farms quite often utilize cutting edge technology to help with production and management. From the heavy equipment that is used to farmers on their iPhones and Blackberries in the field, technology use is widespread.

One such company that has decided to utilize this innovative technology is Greenhill Produce. Greenhill is a producer of bell peppers that over the years has expanded operations over a few facility locations. Operating multiple locations can introduce several logistical challenges and the production tracking system they were using was no longer able to meet their needs.

The Greenhill Production Application

At the beginning of 2012, Greenhill approached Logix to see what we could do to help improve and streamline their production system. They had several main needs that were identified:

  • A way for management and staff to submit and view production receipts.
  • The ability to view instant reports for weekly, monthly and yearly production.
  • Access to instant yield reports.
  • Flexibility to manage their locations and add new locations in the future.
  • Pepper variety and colour management.
  • Customer management.
  • Access to data and reports from previous years.
  • PDF and email generation of receipts.
  • Search and sort functionality.

All of these features also needed to be accessible online if the client was off-site. Because of this need it was determined that a web application was the best route. A server was placed on-site at Greenhill’s main office to securely host the web application. Security was put in place to protect the data and user authentication was added for an extra level of protection.

Data from previous years was imported into the new application and it was fully rolled out in May of 2012.

The Purchase Order Application

Shortly following the success of the Production application, Greenhill approached us again. They were very happy with how the production system was working and now wanted to streamline the management of their internal purchase orders for projects. The project needed:

  • Online access similar to the Product application.
  • The ability to manage Vendors that they purchase from.
  • Project and Location details.
  • Multi-item purchase order entry.
  • Generation of purchase order as a PDF and email.
  • Staff user authentication.
  • Searchable entries.

During the development of the Production application, the Logix team had been looking into a variety of potential frameworks that would provide a solid base for future projects. We came across a PHP framework called Laravel which we were able to transition into relatively quickly. The framework provided a very solid, secure and stable starting point that would easily allow for projects to be extended in the future. Because of it’s flexibility, we decided that we would use Laravel as the framework behind the new Purchase Order application. It allowed us to add features into the application that would have normally taken 2-3 times more time to build from scratch. As our first application built with Laravel, we were incredibly impressed and have decided to continue using it as our framework of choice for future projects.

When the app was finalized it was launched on the same server that ran the production application. It allowed Greenhill to fill out complete purchase order details and track purchases by vendor, location and project. Total yearly expenses for a project as well as yearly purchases by vendor could be viewed with a simple search function.

There was one additional component to this project that we enjoyed working on the most and the client was very pleased with, and that was a mobile app.

There’s An App For That

Being able to add purchase orders was great, but sometimes the client needed to enter information while away from their computer. The iPhone was identified as the best tool to achieve this so planning of an iPhone app was underway. The app mirrors the functionality almost exactly except that the interface is customized specifically for the iPhone to allow for quick and easy data entry and viewing.

The main interface consists of four sections: Purchase Orders, Projects, Vendors and Location. Each section allows the user to view and edit existing entries as well as add new ones. The purchase order form allows detailed entry of multiple items similar to the full web application. While it’s main purpose was to allow quick entry of POs, it also provides an easy interface to view previous orders.

Greenhill made the decision to purchase new iPhone 5s and the app was rolled out internally. It was a great complimentary piece to the full web application.

A Suite of Applications

The final outcome from these projects was a full suite of applications that helped Greenhill Produce better track their production and operational expenses.

 

On the move… Again!

We’ve had a busy and exciting few months in the studio. Last year we moved into new office space to be able to better accommodate our local clients. We experienced quick growth and launched a few new projects along the way. Our client base has grown and we’ve become even more interested in locally focused initiatives.

Now we’re growing again, in a new way.

On February 15th, Logix will be moving to a new space at 67 King Street West where we will be sharing space with two other fantastic web companies, CIK Marketing and Potensia Corp. CIK is the force behind the local co-working project called The Perch which up until recently was located in DeKoKo’s on Fourth Street.

Our move also offers us opportunity to participate in some new and exciting initiatives. In the meantime, we’re excited for this new step, and look forward to working with our past, present, and future clients in our new workspace.

Stay tuned for more from 67 King St. just around the corner!

How much does a website cost?

One of the first questions we get asked whenever someone calls our office is how much a website costs. It’s a valid question and one of the most important questions when someone is trying to plan the marketing budget for their business. Unfortunately it’s not always a simple answer.

The cost of a website varies with the options you choose and the size you want to make it. In this way it’s similar to buying a car. You don’t go to a dealership and ask them how much a car costs because the price ranges based on style, size and features. You can buy the Porsche of websites with all the options and fancy features or you can buy a base-model Ford. Now, there’s no problems with a Ford, I own one myself. It all comes down to needs and budget. A basic website with a custom design and five pages of content might start you around $1,200-1,500 whereas a large corporate site with dozens of pages and custom features could get up into multiple thousands.

So what goes into the cost of a website?

There are many factors in determining the cost of a website.  Some of the most common factors are:

  • Number of pages
  • Is a custom design needed or will a pre-designed template be used?
  • Are they static pages or is a content management system needed?
  • Target market and competition research
  • Features needed other than basic content (forms, newsletters, e-commerce, etc)
  • Are stock photos or photography services needed?
  • Is all content supplied or are copywriting services needed?
  • Is the logo and brand identity in place or does this need worked on?

As you can see, there are a lot of decisions to be made, and this is just a few of the things that need considered.

When hiring a web design company, just like any other business, they have to take other expenses into consideration as well. Things like time, rent, utilities, employee wages and other operational costs always have to be factored in. This is why you’ll often see individuals offering website design for a very low rate compared to a web design company. Both have their advantages and disadvantages. You just want to make sure that whomever you hire has the experience and reliability to create an effective online presence for your business.

At Logix, our custom websites generally start around the $1,625 mark and increase from there based on client needs. We always aim to be flexible to suit any project and budget so we have a number of options available.

For new businesses just starting out or businesses that have a small budget there are always other options as well. We run a service called ckBusiness.ca for local businesses of Chatham-Kent. In an effort to promote local small business within our community we launched this service as a cost-effective way to get an online presence. A business can get a website for as little as $29.95. The cost here is greatly reduced because there is no custom design work involved. A design is chosen from several pre-designed layouts and then customized to include the client’s logo and colours. It doesn’t offer quite as much flexibility but it’s an easy entry in a time when all businesses should be online.

Hopefully this gives you a little insight into what a website costs. I know it’s not a definitive number like you may have been hoping for but it should give you a good idea of what to budget for.

If you’re interested in finding out more about having a website developed for your business, contact us. We’ll gladly answer any questions you might have.

Municipal engagement through Facebook. It can be done.

There is no lack of public engagement when it comes to speaking out online about municipal affairs. With easy access to things like Facebook, more and more people are stepping up on their virtual soapbox to announce their displeasure of their city’s actions. From casual political debate to the downright nasty and negative, we’re seeing an era of social media discourse that’s quickly evolving and presenting our city officials with a new problem. Everyone is getting their 15 minutes.

Unfortunately the comments through Facebook almost always lean towards negative criticisms, which feel more like virtual shouting matches and name-calling. Spurred by our current economic turmoil, it’s hard to avoid. People are emotional beings and anger is one of the easiest feelings to convey. They feel abandoned by their municipal counterparts. Opinions are often left on deaf ears.

Or are they?

We would be silly to assume that in all of our time spent complaining about the state of our poor city that no municipal official has had our concerns brought to their attention. They aren’t all dinosaurs plodding through town stepping on the little townsfolk. While that may seem like a confusing analogy, its not far off from what many envision.

The truth is, many municipal staff are online (yes they own computers), and a large percentage of them are on Facebook and most likely even reading your comments. As a municipal employee, responding to comments can be a scary thing, and there tends to be red tape involved which prevents a lot of it.

Does the city really need a Facebook page?

In an article earlier this year, the mayor of New York discussed the potential of building a Facebook page for their city. He realized that social media isn’t going anywhere so he feels the city should get on board. He already runs his own Facebook page with over 30,000 likes. He comments on recent news articles and events, no different than you or I. Now I’m sure that an official of his stature in a city the size of New York doesn’t update his own Facebook page all of the time but it makes him appear more accessible to the general public.

Another example of a city establishing a Facebook presence is the city of Takeo in Japan where they switched from a standard website to Facebook entirely. Their reasons were slightly different but make great sense. They wanted to interact with citizens on Facebook because it presents a little more accountability. People can anonymously comment on news sites very easily, but when you’re name is attached to that comment like on Facebook the comments tend to be a bit more reserved and thought out.

So how can the municipality take part?

The reason for the Facebook pages, in both cases above, are to communicate with citizens, respond to concerns, and provide an outlet for local events supported by the city. It provides a more real-time method of getting in touch with the people. The wall could be used to post important notices and welcome comments from the people. Custom tabs and applications can be used to provide a range of features. A simple discussion section can act as an open forum for municipal affairs. It’s a lot easier for someone to voice a concern there rather than attending a once-a-month council meeting. Photo galleries can be used to show pictures of around the community, including events that have taken part there. Municipal department info can be easily organized and displayed for quick access. I would urge local council members to take part as well. The opportunities are massive and their are a great number of examples of successful Facebook pages out there. Most are businesses like McDonalds and Coke, but similar efforts can be translated for municipal use. Yes there will be the usual red tape and policies that have to be followed but that shouldn’t dissuade the city from doing it.

While all of this may not fend off all of the negativity online, it will make the city more accessible to those who live in it and let them know that someone is listening.  It won’t turn around the economy and it won’t answer all our questions but it will make the citizens feel like they are a part of their city and have a connection with those who run it.

It will build community.

Interested in hiring us? Get in touch. The coffee is on us!

Are you looking for a website for your business, or interested in redesigning an existing one? Are you a new business looking for branding and marketing help? Let us know. We would be happy to sit down over a coffee and discuss your project. Click the button above or give us a call. We look forward to hearing from you!