The following Cognos system reports (login required) are recommended by Accounting Services for Research and Sponsored Programs (ASRSP) for administrators to use when monitoring their unit's sponsored projects.

GM044 - Sponsored Project Portfolio

GM086 - Projects Balances Report

GM045 - Sponsored Project Budget Statement

GM047 - Milestone (Deliverable) Report

GM091 - Sponsor Payments Received

GM092 - Subcontract Monitoring Report

GM093 - Cost Share Commitment Status

GM096 - Grants Transaction History Queries

GM097- Sponsored Project Actuals Balance Report

• GM097 Guide to Understanding
• GM097 ASRSP Formatting Recommendations
• The GM097 displays a comprehensive view of a research departments' entire research project portfolio, including non-clinical sponsored projects, cost-shared projects, and clinical trials.
• Non-clinical project balances are displayed Total Budget less Direct and F&A Expenditures and Encumbrances.
• Clinical project balances are displayed Cash Received less Direct and F&A Expenditures and Encumbrances, with Protocol numbers.

GL008 - Revenue and Expense Activity Report

SC016 - Open Encumbrances Report

GL069 - Financial Summary

• Warehouse management is a subset of inventory management and is focused on knowing which products are incoming and outgoing, as well as where each item is located.
• Warehouse management is similar to inventory management, except more narrowly focused on the operation of a specific storage facility, including data on product quantities and locations, as well as operator performance.
• To run an efficient warehouse, appoint a knowledgeable warehouse manager and implement a warehouse inventory management system that helps you keep tabs on process and product.
• This article is for small business owners who are expanding into their first warehouse or who want to streamline the operations of their existing warehouses.

If your small business stores the goods you sell in a warehouse, warehouse management is an integral part of your supply chain management. Warehouse management is essential to tracking the products your business keeps on hand, as well as ensuring you maintain optimal levels so you can quickly fulfill customer orders. Understanding how to develop a warehouse management plan – and choose the inventory management software your business needs to support it – is key to staying apprised of your stock, preventing loss and theft, and keeping customers happy by quickly filling orders.

Editor’s note: Looking for the right inventory management software for your business? Fill out the below questionnaire to have our vendor partners contact you about your needs.

What is warehouse inventory management?

Warehouse inventory management is the process by which stock stored in a warehouse or other storage facility is received, tracked, audited and managed for order fulfillment. Warehouse management also includes the replenishment of stock when predetermined minimum quantities are reached, refreshing your stock to optimal levels based on historical sales data. Much like broader inventory management processes, warehouse management is focused on managing incoming and outgoing products, all the while knowing where individual pieces are located.

“Inventory management is controlling the inflow and outflow of your inventory, as well as maintaining and controlling that inventory,” said David Singletary, CEO of tech consulting firm DJS-DIGITAL. “So, [inventory management is] being able to know where your pieces are at all times.”

Warehouse management is a specific subsection of a broader inventory management plan, which governs all products held by a company from the point of creating purchase orders for suppliers to ensuring the safe delivery of products to customers. Warehouse management is focused on the organization and tracking of stock while it is in storage, as well as how quickly certain items are sold.

“Warehouse management is all about volume and velocity,” said Gavin Davidson, ERP product management lead at Oracle NetSuite. “You don’t want your warehouse to get in the way of shipping products. You want to make sure your employees are able to pick, pack and ship as many orders as they’re given.”

Key takeaway: Warehouse management is the process by which warehouses operate in an efficient and reliable manner. It is a smaller part of the broader inventory management process that a business uses to governs stock across its entire ecosystem.

What is the difference between warehouse management and inventory management?

Warehouse management is specifically related to goods that are stored in warehouses and storage facilities, rather than those kept in storefronts or those that are used in the manufacturing process. It is part of the larger inventory management process, which monitors stock from the point of acquisition to the point of sale. But while that stock is in storage at your warehouse, you need a process in place to ensure it doesn’t go missing, so it is ready to go when the time comes to sell it.

Warehouse management relates to a broader inventory management process by ensuring that items are shipped out to storefronts or customers in a timely manner. When a sale is made or a transfer order comes in, the warehouse should be set up to enable employees to quickly pick items, pack them and ship them. This means storing items in predictable locations and then tracking them as they move out the warehouse door through final delivery.

“When you go to multi-store, people often realize inventory management software doesn’t do that well,” said Corey Holton, founder and executive VP of product development for Evosus. He recommended a software tool with more advanced warehouse management features for operations with multiple locations and a centralized storage facility.

Key takeaway: Warehouse management is part of a broader inventory management plan, focused specifically on your storage facilities.

How do warehouse inventory management systems work?

Warehouse inventory management software offers several key features to help you monitor the goods within your storage facilities and oversee inventory control. In some cases, warehouse management software is built into broader enterprise resource planning (ERP) software solutions; in other cases, warehouse management software serves as a stand-alone system. It is best to purchase a seamlessly integrated process if you want to manage your inventory across the entire ecosystem of your company.

Inventory management software covers the acquisition, tracking, and shipping of products, ensuring you know what products are where at what time. They can also serve as forecasting tools, helping you to order items based on expected customer demand according to historical sales data. Some also offer alerts and notifications to Strengthen the operational process of your warehouse, indicating when it is time to perform cycle counts, for example.

Key takeaway: Warehouse inventory management software is available as a standalone solution or as part of an ERP system that includes inventory management software.

Best practices for managing your warehouse inventory

These four steps are key to setting up your warehouse for success and efficiency. When first creating your warehouse, ensure these processes are in place in order to maximize efficiency and quickly move products when needed.

1. Appoint a warehouse manager.

Running an efficient warehouse starts with appointing someone capable to lead; your business should recruit a warehouse manager who has extensive experience operating a warehouse similar to the type you will be running.

“If you have an actual warehouse, you need a warehouse manager,” Singletary said. “The job of a warehouse manager is to make sure everything is running smoothly … they’re the quarterback of the warehouse. [You need] someone who is organized, familiar with warehouse operations and not afraid of technology.”

Your warehouse manager will monitor your workers in their day to day positions, ensuring that items are being scanned and cataloged properly. They will also regularly engage with your warehouse inventory management software to maintain a bird’s eye view of your inventory. Finally, any anomalies or issues that arise will be handled by your warehouse manager, so they should be able to respond dynamically whenever your warehouse employees identify a problem.

2. Determine the warehouse layout.

The physical layout of your warehouse will either help or hinder your warehouse employees in quickly picking, packing and shipping items out when a sale is made or a transfer order is placed. According to Holton, separating warehouses into zones or lots and numbering aisles and bins can help warehouse workers navigate the storage facility more effectively.

Not every warehouse is set up the same way, but an organized warehouse is a prerequisite to efficient operations. How you design your warehouse space could vary depending on what types of products you store. For example, a warehouse storing large machinery might have specific zones but is unlikely to have bins and aisles, like a warehouse storing smaller retail products.

You should consider how a warehouse employee will move throughout your warehouse when you’re designing the physical space. Make sure your high-value and high-transaction-volume items are easily accessible, Davidson said.

“You would typically have … rows of racks, and you might organize those into different zones,” he said. “Maybe you reorganize your warehouse as your business changes. Part of that is identifying the items moving quickly through your warehouse and positioning those in locations that are easier to get to.”

3. Establish a workflow.

With a leader appointed to monitor the operations of your warehouse and a system of organization in place, you will also need to put in place a specific workflow. The warehouse manager should have experience in this area, so work with them closely on how to establish a warehouse workflow that makes sense for your business. According to Singletary, your workflow should address several key points:

• How do I receive new inventory?
• When new inventory is received, where does it go?
• How is inventory tracked when it arrives, when it is moved and when it leaves the warehouse?

“When it’s time to sell that piece, knowing [its location] is very helpful,” Singletary said. “You need a system to tell you to go to the exact place where the product lives. You need to track it as it gets moved from its location all the way out the door to delivery to the customer.”

In addition, you should discuss several operational considerations with your warehouse manager, including:

• Inventory location tracking: Determine whether you need serial tracking, lot tracking or a mix of both. Tracking is a key part of inventory control, helping operators to know precisely where a product is when it comes time to pick it. Serial tracking is useful for high-value items that sell in low quantities, while lot tracking is effective for low-value, high-quantity items. Barcoding features can be employed to automate the updating of tracking information for individual items within a warehouse inventory management software. Tracking is especially important when selling on multiple sales channels, preventing you from overselling and running into negative quantities by mistake.
• Cycle counts and regular inventory audits: Performing regular cycle counts is important for loss prevention and inventory control. Without regular cycle counts, units could be lost or stolen unbeknownst to your warehouse manager. If you only conduct inventory counts once a year, you could quickly recognize that you’ve lost a lot of inventory over time. It’s especially important to implement regular cycle counts when dealing with goods that expire. Run inventory counts more frequently on your highest-value or bestselling items.
• Accounting methods: Depending on how your warehouse operates, you might prefer to use first in first out (FIFO), last in first out (LIFO), or average costing methods. These accounting methods are important to your warehouse management, because most inventory management software integrates with your accounting software to prevent the need for double entry and eliminates the risk of human error. Your warehouse inventory management software should have a costing method compatible with the rest of your accounting.
• Data reporting: Warehouse managers are responsible for generating and distributing data reports, which can be generated and customized in your warehouse inventory management software. These reports include information like product quantities, sales data, requisition data from vendors and information about any lost or expired products.

4. Implement warehouse inventory management software.

A warehouse inventory management software can help automate and simplify a number of warehouse management tasks, as well as update a record of all existing stock in real time. As long as your warehouse team properly scans and catalogs items as they come into your warehouse and move throughout it, your warehouse inventory management software will reflect all your existing stock and its specific location in the warehouse.

“Most information should be available in the ERP software,” Davidson said. “The information tells you which items should be cycle counted and how often they need to be counted – that comes from transactional data.”

“It should also look at trends over time, like how many packages did you ship this month versus last month and the month before,” Davidson added. “Look for trends to see if something is happening on the operational side of your business to prevent shipping and receiving.”

Additionally, warehouse inventory management software can be set up to automatically reorder stock when products reach a predetermined minimum quantity. The best software automatically analyzes historical sales data to determine optimal minimum quantities for automatic reordering, as well as to which quantities it should replenish each product.

Key takeaway: To efficiently operate a warehouse, hire a reliable warehouse manager, implement effective inventory management software and devise a workflow that includes regular cycle counts, inventory tracking and robust data reporting.

ENVIRONMENT:

A leading Healthtech company is looking for a Senior BI Developer to join their Johannesburg team. Senior candidates, ideally with a minimum 5 years’ experience in development. This role is an end-to-end role where the incumbent will be involved in both BI Development in the back end and in the presentation, layer compiling reports and doing analysis. The right candidate will be someone who comes from a back-end BI development, SQL Development and maybe database administration background, BI/Cognos training, Qlik suite of tools will be beneficial, and a Tertiary qualification e.g., B SC or B Com – Information Technology degree.

DUTIES:

Business Intelligence end-to-end development in terms of design, development & implementation of the following (both existing and new initiatives e.g., ad hoc requests and projects):

Metadata Layer

• Cognos 11 Metadata Modeling (Framework Manager)
  • Implementation of best practices & recommended methodology in terms of metadata layer design & development.
  • Star-schema & dimensional modeling of relational data sources.
  • Report Writing & Analysis.
• Cognos 11 Report Writing (Report Studio & Analysis Studio)
  • Relational (off relational data sources).
  • Dimensional (off cubes).
  • SQL (SQL query against Microsoft SQL Server).
  • Microsoft SQL Server 2008 and 2014
    • Development of stored procedures for reporting.
    • Writing of SQL queries for reporting & testing purposes.
  • Multidimensional Modeling
    • Cognos 11-Dimensional Modeling (Transformer).
  • ETL
    • SSIS package design and development.
  • Business Intelligence Design
    • Ensure metadata, reports & multidimensional model design is aligned with required standards for efficiency, flexibility, sustained stability requirements, as well as business requirements.
    • Ensure design allows for optimal maintenance efficiency.

Business Intelligence Administration

• Assist with management of Business Intelligence security.
• Monitor Business Intelligence server, checking available space, temp files, performance, etc.
• Version control.
• Optimisation of metadata layer, reports & cubes.
• Automation of routine Business Intelligence tasks.
• Validation (diagnostic checks) with the required exception reporting and notifications.
• Troubleshooting and incident resolution.

Testing of Development (Technical & Functional) in the Business Intelligence front-end environment Documentation Management.

• Relevant documentation management of all above-mentioned.
• Update of tickets, ad-hoc requests, etc.

Internal Relationships

• BI department.
  • General Manager: Business Analytics and Risk Management.
  • BI developers.
  • Risk modelling analyst.
  • Systems analyst.
  • Cognos: BI architect/technical lead.
  • SQL: BI architect/technical lead.
    • Business Users.
    • Project Managers.
    • Functional Managers.
    • IT Development Managers.
    • IT Implementation Manager.
    • EXCO.
    • Sub Project Managers.
    • Operational managers.

External Relationships

• Industry Partners/software suppliers.
• Outsourced development where relevant – contracted parties e.g., iOCO consulting.

REQUIREMENTS:

• Matric.
• BI/Cognos training.
• Qlik suite of tools will be beneficial.
• Tertiary qualification e.g., B SC or B Com – Information Technology degree.

Background Experience & Technical Skill Requirements (What Experience & Technical Skills Are Required to Manage This Function Successfully?)

• Cognos – a min of 5 years’ experience.
• Cognos 11 Metadata Modelling (Framework Manager).
• Cognos 11Report Writing (Report Studio).
• Relational (off relational data sources).
• Dimensional (off cubes).
• SQL (SQL query against Microsoft SQL Server).
• Cognos 8-Dimensional Modelling (Transformer).
• Microsoft SQL Server.
• Proficient in writing queries and stored procedures for reporting & testing purposes.

The following technical skills will be advantageous:

• Microsoft SQL Server 2019 SSIS, including active X-scripting (VB script).
• Microsoft SQL Server 2019 Transact-SQL & stored procedures.
• Ralph Kimball Data Warehouse star schema methodology.

ATTRIBUTES:

• Passion for data integrity management/data warehouse environment.
• Technical Professional Knowledge and skill.
• Strong inherent conceptional skills.
• Strong analysis and problem-solving skills.
• Attention to detail/ quality orientation.
• Decision making
• Delivery/outcomes orientation.
• Ownership.
• Drive & Initiative.
• Building Positive Working Relationships (Collaboration/Interpersonal skills).
• Communication skills.

While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.

COMMENTS:

When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Apply here [URL Removed] e-mail a Word copy of your CV to [Email Address Removed] and mention the reference number of the job.

Desired Skills:

Learn more/Apply for this position

Building or purchasing a warehouse for rent is a lucrative investment in the real estate market, especially, if it is well situated either close to the market, air or sea ports among others.

One advantage of investing in the building of a warehouse is that it can be converted into an office, restaurant, furniture or vehicle retail shops and so on by the tenants.

Purchasing a warehouse as an investment property is potentially a lucrative strategy for long-term passive income. 

Warehouses are also considered a more profitable type of commercial real estate investment than others as it comes with several benefits. 

Some of those benefits are; 

Increased Potential Income with Lower Volatility

Because of the sheer size of a typical warehouse, the income potential in rent from a warehouse is significantly higher than for most types of residential real estate. 

Warehouse rental also produces higher income than other income streams found in a typical investment portfolio such as money market accounts, savings accounts and so on.

Additionally, rental income from warehouse is extremely stable.

Triple Net Leases

This makes the tenant responsible for rent in addition to maintenance costs, insurance premiums, and taxes associated with the property. Triple net leases are usually 10 years or longer, but they can also be anywhere from five years up to 20 years.

Rent Payment

The rent can stay the same during the entire lease, or it can go up in increments every year or few years, often based on inflation. This type of lease is extremely attractive to the landlord because it is so hands-off. 

Passive Income

Money collected from a rental warehouse truly is a passive income where you are doing very little. After the initial investment and preparation for a tenant, a warehouse becomes mostly hands-off, especially with a triple net lease.

Property Appreciation

The value of the property will increase by doing nothing at all. When a lease agreement expires for a warehouse, the value of that warehouse will be significantly higher than when the lease was written. 

Tax Deductions

Several tax deductions can be taken related to owning a warehouse as a commercial real estate property. Owners of a warehouse can deduct for depreciation and mortgage interest and other tax deductions, including expenses of maintenance, repair and management. 

Initial Capital

This involves the initial cost of building or purchasing the warehouse.

This, however, varies depending on the location but my findings show that an investor needs a minimum of N5million or N50 million to venture into this investment opportunity.

Profitability

With most warehouse rent always on long lease, my investigations revealed that, a 10 year lease could go for N8million to N30million, which, when divided annually, will translates to between N800,000 and N3million profit. This could even be more, depending on the earlier mentioned factors. 

The best PDF editors enable you to get even more done with PDF files but the real question is which PDF editor is best suited to your needs and workflow. 

Despite their finalized appearance, Portable Document Format files can be changed in the same way you alter a text document – you just need the right software. The best PDF editors let you open up almost any PDF file so that you can edit, alter, annotate, sign or convert it to other popular file formats including Microsoft Word.