Help desk   Support   Licensing
Overview
Stock manager
» General description
» Features
» Suggestions

Sales manager
» General description
» Features
» Components

Acquisitions manager
» General description
» Components

Promotions manager
» General description
» Components


Analysis software (Business Intelligence)

Stocks, sales, acquisitions, promotions, production.

Analysis software (Business Intelligence - BI)


Spectrum Business Intelligence is a analysis software designed on Oracle Business Intelligence Standard Edition One platform.

Spectrum Business Intelligence comes to support you:
  • with an Oracle database loaded
    • with over 300 tables
    • with over 30 different calculation algorithms
  • with an repository for Oracle Business Intelligence
    • with over 22 different sizes
    • with over 60 stars at the junction size
    • with over 600 indicators
  • with over 9 dashboards, each with multiple pages that accumulates over 100 reports
  • with the possibility to create your own interrogations


Stocks manager

General description

In a network of retail stores, one of the main components is represented by the stock of goods. This can be analyzed punctually shop by shop, and globally too, at entire network level or group of shops, with a common regional feature.

The stock of goods, in order to satisfy his mainly tendency, to ensure the continuity of sales, raises some very important issues which if they are not realized at the right time may lead to failure to provide what the market needs. These problems, which the system wishes to highlight are: the lack of goods from the shelf (out of stock), negative stocks and overstock.



^ top


Features

Optimizing the stock must be the main activity of a stock manager. To do this, Spectrum Business Intelligence pulls alarm signals about the problems that an stock analyst is facing.

Out of stoc (Lack of stock) is the most dangerous indicator in terms of stock analysis, because it can lead to loss of customers. There are highlighted at how many products the merchandise will be exhausted in the next period of time, which are these products and from which suppliers the store must supply.

Over stoc (Over stock) is an important indicator because it reflects the money restrained in unsaleable goods.

Negative stocks is also an indicator to be analyzed because they mean confused goods, which the source of origin can't be detemined.

Also, in a stock analysis solution, trends such as: certain products at exhaustion, weekly comparisons of stock's evolution, can be tracked in ideea of drawing the necessary conclusions for estimating correct the flow of goods in stores.
  • Out of stoc
  • Over stock
  • Negative stocks
  • Provider stocks on a store
  • Network provider stocks
  • Cumulative article stocks
  • Required stocks
  • Info articles
  • Stock evolution in time
  • Out & Over Stock
  • Out & Over Stock on supplier
  • Stock exhaustion time
  • Estimate of stock days
  • Estimate of stock days by product groups
  • Stock rotation
  • Types
  • Megagroup stock
  • How many days the merchandise stayed on stock


^ top


Suggestions

Spectrum Business Intelligence - Stocks Manager - finds its place commercial department office that has responsibilities in optimizing the merchandise stock from a network of stores, with or without strategic warehouse, or just in an independently shop.

^ top




Sales manager

General description

Sales analysis are focused on products dynamics and customers. Constantly the client's profile is changing, and the organization must have the necessary tools to make the decisions that will lead to an image and a better profit.

^ top


Features

The role of sales analysis is to highlight existing problems in the sales department and lead the analyst to answers and solutions.

Comparison of current sales with sales from similar past periods results, as tabular or graphical leads to questions that needs answers.

Why the number of customers decreased in one location while in another location increased? Is the store personnel well dimensioned for the number of customers, products and shop area? What about during rush hours?

In Spectrum Business Intelligence - Sales manager you can find the top selling product and which are the products sold together with that product on the receipt.

What-if analysis type (what happens if..) are very easy to configure to make a deeper analysis with the data extracted from the system.

There are implemented different algorithms of the addition, so you can detect products that generate maximum profit with minimum effort.
  • FIFO (First In First Out)
  • LIFO (Last In First Out)
  • AC (Average Cost)


^ top

Components

  • Monthly sales
  • Daily stores sales
  • Daily groups sales
  • Weekly sales
  • Time span sales
  • Time span stock
  • Additions top articles
  • Groups
  • Articles
  • Monthly indicators
  • Suppliers
  • Supplier articles
  • Centralized outputs
  • Receipt sales charts
  • Current prices
  • Receipt data sheet
  • Weight
  • Brand addition


^ top


Acquisitions manager

General description

Acquisitions manager focus their attention on how to work with suppliers. Should be able to access the information needed to create more profitable contracts with the suppliers and to be able to track if there are any clauses in the contracts that are not fulfilled.

Focusing attention on suppliers with the highest turnover is very important.

Implementation of an integrated orders to suppliers system and verifying of compliance with orders made.

^ top






















Components

  • Centralized entries
  • Input articles
  • Transfers
  • Brands
  • Orders
  • Varieties for suppliers
  • Active / partner
  • Active / Megagroup
  • Groups without partner
  • Stores or warehouse partners
  • Percentages supplier
  • Margin supplier
  • Top articles on suppliers
  • Partners article details


^ top


Promotions Manager

General description

The myriad ways in that a store network can loyalty its customers using Spectrum Retail Solution, makes from promotions analysis an important chapter to focus for analysts from the commercial office.

Each way of promotion, require their own methods of analysis to determine if a promotion is effective or not.

Also, the analysis before deciding what kind of promotions should be used is very important and requires special reports.

^ top






















Components

  • Bonus related articles
  • Common receipts
  • Sale price adjustment analyses
  • Promotions
  • Brands
  • Taxable promotions
  • Promotion efficiency
  • Stocks promotions
  • Promotions analysis
  • Number of promotions customers
  • Current promotions stocks
  • Promotions necessary
  • Current promotions stock


^ top



Contact us
Tel. / Fax 0268 323 400
Tel. RDS 0368 005 684
Mobile 0723 556 783


Printscreen








Copyright 2010 Spectrum Ltd Brasov. All rights reserved.