Detailed Business Process Analysis Workshop

Document Sample
Detailed Business Process Analysis Workshop Powered By Docstoc
					Detailed Business Process Analysis Workshop
Trade-Sales


Prepared for
Tailspin Toys



Project
Microsoft Dynamics ERP Implementation



Prepared by
Brian Burke
Application Consultant

Brian.burke@treyresearch.com
                                                                          Microsoft and
Revision and Signoff Sheet

Change Record
 Date       Author        Version   Change reference

 April 2010 Brian Burke   1         Initial draft for review/discussion
                                                                                                                                   Microsoft and
                                                           Table of Contents

1   Introduction..................................................................................................................................... 2

2   Consultant Preparation .................................................................................................................... 4

3   Customer Preparation ...................................................................................................................... 5

4   Participants ..................................................................................................................................... 6

5   Conduct the Workshop ..................................................................................................................... 7

6   Deliverables ..................................................................................................................................... 9

7   Appendices ...................................................................................................................................... 9
                                                                                        Microsoft and
                                  1       INTRODUCTION
This document explains how to conduct a Detailed Business Process Analysis Workshop. It is
intended that this guide be used both by the consultant and by the customer lead. The guide is also
used to capture the results of running the individual workshops.


The Detailed Business Process Analysis activity commences in the Analysis phase of an
implementation, followed by two change control activities in later phases. Within Sure Step, the
Detailed Business Process Analysis activity is conducted within the Business Process Analysis Cross-
Phase and includes three activities overall:


Analysis
Detailed Business Process Analysis
Design
Review and Update Business Process Models
Development
Review and Update Business Process Models


For each business process, typically there would be different participants involved from the
customer. Therefore it is recommended that separate workshops should be held. For example the
following workshops could be run:
          Finance
          Purchasing
          Sales
          Warehouse
          Production
          Planning
          CRM


Each workshop may take from two to five days depending upon the complexity of the business
process.


The deliverable of these workshops is to define the business process, in a clear and simple manner,
using the business process model templates provided from the Sure Step Methodology. The
implications of selecting individual templates should be clarified with the customer lead. This may
involve discussing additional functionality that may prove beneficial to their business or to identify
gaps in functionality that can be addressed by other activities and cross phases. The approach is to
avoid a complete redesign of the business process by simply adapting the templates as necessary.
                                                                                       Microsoft and
It is unlikely that a demonstration of the software will be required during the workshop. Indeed,
there are pitfalls associated with showing the software and may even prove a hindrance. This is
best done during the Design phase when the investment of a significant amount of time to
configure the software to the business requirements has been completed. It is recommended that
PowerPoint should be used to give an overview of the systems functionality.


The Detailed Business Process Analysis Workshops are based on the components that the customer
chose in the Scoping Assessment from the Diagnostic Phase. When the Detailed Process Analysis
Workshops have been completed, the Create Solution Design Document is built in the Design Phase
and the Finalize Solution Design Document is built in the Development Phase to configure the
solution and to obtain customer sign-off of the proposed configuration. This will require an activity
to review and update the business process models before either of these activities is completed.


If, during the Detailed Business Process Analysis Workshop, significant process gaps or potential
modifications are identified, they should be referred to the Fit Gap Analysis Workshop. During this
workshop alternatives will be researched and a decision made over how to solve the gap.
                                                                                            Microsoft and
                                2        CONSULTANT PREPARATION
    The consultant involved should complete the following actions to prepare for the workshop:

Action                                                                          Completed
   1. Obtain list of attendees and their contact details.
   2. Obtain the current functional scope and list the details onto a flip
      chart or a PowerPoint for review during the workshop.
   3. Obtain the list of known functional issues and list the details onto
      a flip chart, PowerPoint or Excel for review during the workshop.
   4. Review the template models and make any changes applicable. If
      certain functionality is out of scope the models could be simplified
      by removing the relevant parts. Also if additional functionality is
      to be covered extra steps could be added.
   5. Print the models:
             It is best to print the models in color.
             It is recommended that a set of the models should be
              printed at least on larger paper size than normal. These are
              to be stuck onto the workshop room’s walls or on the
              central table. String could be used to make the logical
              connection between the different pages.
             Print a set of the models on to normal sized paper so that
              each participant will have a copy.
   6. Obtain a set of PowerPoint presentations that will give an
      overview of the functionality that will be covered as part of the
      business process flow.
   7. Distribute copies of the workshop guide to the participants a few
      weeks before the workshop is held. Need to request that they
      complete their preparation tasks listed in the document.
   8. Prepare the room for the workshop:
             Overhead projector is required to show the process flows
              and any PowerPoints.
             Flip chart is very useful for capturing issues, gaps or just to
              help explain a topic.
             Set up the printed models onto the workshop room walls
              or table.
                                                                                        Microsoft and
                                    3      CUSTOMER PREPARATION
    The participants from the customer should complete the following actions to prepare for the
      workshop:

Action                                                                   Completed
   1. Document their key current business processes that will be
      covered in the workshop. If there are several participants the
      customer needs to manage who should document which area.
      Best to use PowerPoint or Visio for this. They do not need to
      follow any particular standards for this.


         With some customers they may request that the consultants
         should document the current ‘As Is’ process.
   2. Identify any potential improvements in the existing business
      processes.
                                                                                      Microsoft and
                                      4         PARTICIPANTS
     The following participants were involved in the workshop:

Name                           E-mail Address
& Job Title                    & Phone Number                    Company/Department
   1.
   2.
   3.
   4.
   5.
   6.
   7.
   8.
   9.
   10.
                                                                                          Microsoft and
                                   5       CONDUCT THE WORKSHOP
    The following agenda should be followed:

Action                                                                        Completed
   1. Introductions.
   2. Review functional scope for the business process being discussed.
   3. Review known issues identified for the business process being
      discussed.
   4. Give overview of the system functionality that will be used for the
      business process being covered.
   5. The customer participants present their current process flows and
      any potential improvements they have identified.
   6. The consultant now starts to walk through the process flow
      template page at a time. The object here is to agree the future ‘To
      Be’ process. This process will prompt a lot of discussion.


         The consultant should apply changes to the page being discussed
         with agreement from the group. This can be done either with the
         modeling tool or manually drawn onto a flip chart to be updated
         later. Any gaps and issues should be captured by a scribe or the
         consultant.


         Gaps and issues could be listed on the flip chart so that they are
         viable to everyone.


         Gaps should be discussed to see if there could be either an easy
         work around or a change made to the existing business process
         rather than modifying the system. If a process change is required,
         this should be documented in the deliverable section below as
         well in the ‘To Be’ process flow.


         It is helpful to mark on the large printed models which page is
         being currently discussed. It is easy for the participants to lose
         track where the discussion has reached.
   7. The consultant should have updated the model and printed the
      new process flows. The group then reviews the models to ensure
      that the agreed changes have been made.
   8. The Gap and Issue list are reviewed.
   9. The workshop participants will now present the agreed ‘To Be’
      process to their own business. This typically can be done two
                                                                      Microsoft and
   ways:
          Present to the other workshop participants. They should
           represent departments and functions within the
           customer’s organization.
          For multi site implementations the participants need to
           present back to their own key management.
10. The team then needs to reconvene and review the process flow
    with the feedback from the presentations. The final changes
    should be agreed and applied to the model with the gaps, issues
    and process change lists being updated.
                                                                                               Microsoft and
                                            6           DELIVERABLES
       The following future ‘To Be’ business processes were agreed:

  High-        Detailed Business Process Description                Attachment
  level
  Business
  Process
  ID
  SMSF.1       Sales Department Structure and Responsibilities
  SMSF.2       Entering Customer Information and                    Detailed Product Profile
  SMSF.6       Prices/Discounts                                     Overview

  SMS.4        Entering Long-term Sales Agreements
  SMS.3        Sales Quote/Order Creation
  SMS.4
  SPSO.1
  SPSO.2
  SPSO.5
  SMSF.4       Sales Order Follow-Up                                Sales Process Overview
  SPSO.3



The following business process changes have been identified between ‘As Is’ and ‘To Be’:

  Business Process Change                                                         Priority
     1.
     2.
     3.
     4.
     5.


       The following functional gaps were identified:

  Business      Functional      Gap ID - Description          Possible Solution    Priority
  Process ID    Requirement
                ID
  SPSO.2        FR-6            TR-5 Connection between                            Medium
                                sales order and purchase
                                of transport
  SMS.3         FR-5            NEW – Multiple alternate                           Medium
                                items for one item
  SMS.3         NEW             NEW – Order promising                              Important
                                                                                           Microsoft and
                             functionality
SPSO.5       FR-8            NEW – Sales persons                               Important
                             should not manually
                             create purchase orders for
                             direct delivery sales
                             orders
SMSF.6       FR-2            AS-3 Sales prices and                             Critical
                             discounts must be strictly
                             followed by sales groups
                             and sales persons. They
                             should not be allowed to
                             change proposed prices
                             and discount



    The following issues were identified:

Business     Functional           Issue                                        Priority
Process ID   Requirement ID
SPSO.2       FR-9                 It was not possible to perform analysis about Low
                                  e-sales, since the Web site has not yet been
                                  constructed. It is unclear when Tailspin Toys
                                  will be handling this aspect. No analysis was
                                  thus possible concerning Enterprise Portal
                                  and E-commerce.
                                                                                                         Microsoft and
Business Process Analysis


Sales Department
Tailspin Toys divided its Sales Department into smaller sales groups, each responsible for maintaining a high sales
level for a specific geographical area, with its own warehouse at its disposal.



         Sales Group - Code      Sales Department -         Responsible              Area             Warehouse
                                        Name

                              Liverpool, Great Britain   Shawn Richardson     /                   /

        RC-AMERICA            Liverpool, Great Britain   Kevin Kennedy        America             Boston,
                                                                                                  Massachusetts

        RC-EMEA               Liverpool, Great Britain   Heidi Steen          EMEA                Liverpool, Great
                                                                                                  Britain

        RC-ASIA               Liverpool, Great Britain   Junmin Hao           Asia + Australia    Hong Kong, China




        Sales Department
Liverpool, Great Britain, is the General Sales Department that manages all sales groups, but does not interact directly
with Tailspin Toys’ customers. The head of this department is Shawn Richardson, who keeps a close look on sales
figures and analyzes different geographical revenue levels. He is responsible for the coordination of all sales
processes and sets a uniform price and discount strategy. To realize this management task, he should be able to
access all database information for all the different groups.


       Sales Groups
Customers within a specific geographical area, all have a specific Sales Group at their disposal where all sales related
questions can be answered. To be able to fulfill customer’s requests as soon as possible each Sales Group can count
on a specific warehouse.

The salespersons responsible for all EMEA customers are in direct connection with the distribution warehouse in
Liverpool from where all items are shipped to these customers. For American customers, the sales group can relate
on the distribution warehouse in Boston.

Asian and Australian customers are served through their own sales group, who have the central warehouse in Hong
Kong at their disposal. In many cases these customers are also managed through direct delivery sales orders, since
Tailspin Toys’ vendors, the manufacturers of toys, are close to their customers. This saves both in time and costs
(warehouse, transport, and so on).

Salespersons are only responsible for their own geographical area and should only be able to view relevant
information for their sales activities. There is no need to view sales orders from other Sales Groups, so this option
should be blocked.
                                                                                                       Microsoft and
Customers
Customer Mix

Tailspin Toys has a wide variety of customers. The biggest group of customers consists of toy store retailers, which
are specialized companies that only sell toys, directly to the end customer. Tailspin Toys offers these customers long
term agreements and price advantages.

A second customer group consists of big box retailers. These retailers do not sell toys as their core business, but do
maintain a considerable amount of products in stock. They distribute catalogs to end consumers, so if necessary they
can always order the toys with Tailspin Toys.

Recently Tailspin Toys decided to expand its Web site with the possibility of online shopping, opening up its products
directly to the end consumer market. Tailspin Toys wants to test the feasibility of this project on the American
market first, before taking the project to a worldwide level. The Web site however still needs to be adapted to this
new feature. They still need to contract an appropriate partner to handle online sales setup. Tailspin Toys also wants
its IT-system to be adapted to this new sales process by entering all foreseen price and discount settings.

Although the Sales Department services different geographical area of the market, each sales group deals with all
customer types. They have to concentrate on the sales process itself, administer incoming sales demands, maintain
close contact with existing customers and follow up on the promised deliveries. Therefore some other sales-related
subtasks are diverted to other departments. Scouting the market for new customers is the responsibility of the
central Marketing Department, and customer complaints and returns are sent to the central Customer Service
Department, also located in Liverpool, Great Britain.



Current Important Customers

          Big Box Retail
               o Zanlan Corp. – South Africa
               o Candoxy Canada Inc. - Canada
               o TraxTonic Sdn Bhd - Malaysia
          Toy Store Retail
               o Parmentier Boutique - France
               o New Concepts - USA
               o Zuni Home Crafts Ltd. - Australia
          End Consumer
               o Spotsmeyer - USA



Long Term Agreement

Tailspin Toys has some long term agreements with a few toy store retailers who are committed to purchasing a
certain amount of products on a yearly basis. These commitments result in lower prices and a guarantee that
Tailspin Toys deliver the goods within 24 hours. Tailspin Toys wants to track these contracts to be able to keep track
of the sold versus the outstanding quantity to the customer. Customers need to mention the contract number with
each order and apart from this they can still place separate orders or ask for separate quotes.

Long term agreements made between the Sales Groups and the toy store retailer, need approval from the General
Sales Manager.
                                                                                                         Microsoft and
Customer Prices and Discounts
To maintain control over the different price and discount offerings, Tailspin Toys decided to keep these decisions
with the Sales Manager, Shawn Richardson, in Liverpool, Great Britain. He is responsible for controlling all Sales
Groups. Periodically he reviews the item cost prices and adapts sales prices accordingly.

A few years ago Tailspin Toys implemented a strict price politic, dividing its customers into specific groups: toy store
retailers and big box retailers. With the introduction of e-commerce possibilities for end consumer sales, it also
introduced a separate price for this customer group.

Discount setting is more complicated than the price setting, where a discount not only depends on customer type,
but also on product type. The following product groups are already identified: Digital Entertainment, Baby Toys,
Family Games and Crafts. In this case a discount is given per sold item. The following discounts are set up by Tailspin
Toys:

Product type /                  Big Box Retail         Toy Store Retail          End Consumer
      Customer type             (BIGBOX)               (TOYSTORE)                (ENDC)
Digital Entertainment (DE)      /                      /                         Christmas holidays
                                                                                 (20dec – 10jan): 5%
                                                                                 with a minimum of 5
                                                                                 videogames of 5 DVDs
Baby Toys (BT)                  6%                     8%                        /
Family Games (FG)               /                      /                         Christmas holidays
                                                                                 (20dec – 10jan): 15%
Crafts (CR)                     /                      All paints: 5% with a     clay: 20%
                                                       minimum of 300 CAN
                                                       or 30 PACK

Tailspin Toys’ best customers (New Concepts and Candoxy Canada Inc.) also benefit from an extra discount when
purchasing for a large amount. For invoices for a minimum amount of 5.000 GBP there is a discount of 2% and when
a minimum of 10.000 GBP is reached, 5% is subtracted from the invoice. These discounts come on top of other
discounts or alternative prices that are already granted to these customers.

As far as financial handling of discounts is concerned, both discount types are handled together with normal revenue
postings, and not posted on separate general ledger accounts.

Since Tailspin Toys has a complex price and discount setting, it is easy for sales administrators to make mistakes in
granting the correct price and/or discount to a customer. Therefore all prices and discounts must be pushed forward
from the system and must not be filled in manually by the salespeople.

Detailed Product Profile

The specific product prices per customer type are represented in the attached product profile details.
                                                                                                      Microsoft and


Customer Service
Tailspin Toys’ salespersons are confronted with many different sales documents: quotes, contracts and orders (which
can, but does not have to, originate from a quote or contract). Whenever handling one of these documents,
salespersons expect a certain amount of flexibility and user friendly features, which allows them to quickly and
accurately interact with their customers.

Critical information factors for an optimal customer service are:
         Customer’s current available credit; with a warning when the credit limit is reached.
         Price settings for the customer-product combination.
         Discount opportunities.
         Item availability
         In case of direct delivery: available vendors and connection with specific purchase order
         Connection with the long-term agreement or quote.
         Delivery time.
         Transportation costs
         Alternate items

A couple of these factors are further highlighted here.


Documents

All customers can look up price information on Tailspin Toys’ Web site, but they can also ask for more specialized
quotes at all times.

A customer’s order can arrive at the respective Sales Group in many forms and for many reasons.

          As a result of a long-term agreement: The toy store decides to order some of the promised quantities at
           the predetermined conditions.
          As a result of a sales quote: The retailer decides to agree with the offered prices and orders under the
           conditions as presented by the quote.
          As a result from a direct order:
             o The retailer immediately decides to place an order by making a phone call, sending a fax or e-mail.
             o The American end consumer will also have the opportunity to order directly with Tailspin Toys
                  through its Web site.

Once the order confirmation is sent to the customer, it is up to the warehouse to further handle the picking and
shipping procedures and up to Corporate Accounting to create and send the invoices and follow up with customer
payments.

All sales interactions require an outgoing document with the specifications of the agreed upon products, quantity,
price, shipping conditions and delivery dates.


Item Availability and Reservation

When dealing with customers it is very important to have an accurate view on current stock levels per warehouse
and per variant. Tailspin Toys likes to have a view on item availability for a period of 90 days starting from the
current day, checking one day at a time.
                                                                                                            Microsoft and
When an item is no longer in stock, if receipts are already planned, and when the item is going to arrive at the
company, needs to be easily visible. Even when a toy is still in stock, it is possible that it is already promised to
another customer. These reserved items must not be taken into account when viewing available stock.

Alternate items

If customers request items that are currently unavailable regardless of the reason, (out of stock, or reserved for
other sales orders), salespersons can offer alternative similar products. First, however, the salesperson needs to be
warned about the unavailability of the item, and, second, information about the possible substitutes needs to be
immediately visible. Since Tailspin Toys has a wide variety of products, some substitution is possible. For example,
the different stuffed animals are all considered to be each other’s alternative.

Order Promising

A crucial aspect in providing sales-order-related information to a customer is the exact delivery date. Can the toys be
delivered on the requested date? If not, what is the soonest delivery date possible? Which shipping agent can be
used for a quicker delivery?

The calculation of the exact delivery date is influenced by a number of factors:

First, holidays and annual closing periods of all parties involved must be taken into account. Tailspin Toys follows the
common weekly closing procedure days of Saturday and Sunday and a closing period during the seasons’ slowest
period (from the 20th of May until the 10th of July). All EMEA and American customers follow this work calendar.
Only the Asian and Australian customers slightly differ in the fact that they have a different closing period (from the
1st of October until the 10th of October). Since it is virtually impossible to follow up on all end consumers’ available
delivery dates, they are assumed to be available at every possible date. Normally, the work days of the shipping
agent are taken into consideration, but Tailspin Toys has selected those agents that are always open for business.

Second, the delivery date depends on the time it takes to pick the items from the warehouse and get them ready for
transportation. Since each warehouse has its own specific work flow (see the Detailed Business Process Analysis
Workshop – Inventory/Logistics), this warehouse handling time also differs from location to location. The Hong Kong,
China warehouse generally takes two days from the moment of order creation until the moment of handing over
the toys to the shipping agent. Because Boston, Massachusetts, and Liverpool, Great Britain, have smaller
warehouses, they only need one day before transportation.

The time needed to get the toys from the warehouse to the customer, depends on the shipping agents shipping
time. Tailspin Toys has carefully selected its partners concerning transportation to be able to reduce the delivery
time as much as possible. The following shipping times are promised by each shipping agent. DHL delivers within 24
hours and deliveries with FEDEX and UPS take four days. Within EMEA Tailspin Toys prefers to work with DHL and for
American big box retail and end consumer customers either FEDEX is used, while UPS is preferred by American toy
store retailers. Asian and Australian customers are immediately serviced through the vendor.

A combination of the above mentioned factors results in the following delivery date calculation:

Delivery date = shipment date + warehouse pick time + shipping agents shipping time.

If the toys are not available on the shipment date, it becomes important to immediately look for the possible options
and compare a couple of different scenarios. Tailspin Toys should be able to figure out the soonest possible delivery
date when the products are replenished through either a purchase or a transfer. However the actual replenishment
is left up to the respective authorized departments.
                                                                Microsoft and
    stock
  availability
                       customer
                        request




                                              work days
                                             Tailspin Toys
shipping agents
 shipment time



                  sales delivery date
                           ?                        work days
                                                    customer




  warehouse
   pick time


                              work days
                            shipping agent
                                                                                                       Microsoft and
Direct Delivery Sales Orders

For some Asian and Australian customers, sales are shipped directly from the vendor to the customer. When
entering these direct delivery sales orders, it should be possible to automatically create the corresponding purchase
order. The sales and purchase order should be linked together, meaning that the items from the purchase order
should be reserved exclusively for the sales order. These purchase orders are however the responsibility of the
Purchase Department.

Transport

Tailspin Toys arranges all transport for their customers. Each sales group is responsible for their customers and thus
also for purchasing related transport. When creating transport purchase orders, they should be able to connect the
corresponding sales order. This should be helpful for the Accounting Department when controlling the incoming
invoices from shipping agents. When the sales order is not recorded for a shipment, the purchase invoice will not be
approved. Also it can be of useful help to check whether all sales have been invoiced to customers.

Sales Order Follow-Up
Once the sales are recorded for the customer and transport has been arranged, it is up to the warehouse to handle
shipments and the Accounting Department to control and record sales invoices. However, sales persons should be
able to view the progress of these processes. They have to view how many products have already been shipped from
the warehouse and how many of them have already been invoiced to the customer.

Backorders

When sales orders are delivered partially, backorder information needs to be printed out on the delivery
documentation and invoices.
                                                                                                                                                   Microsoft and
                                                                 7                 APPENDICES

        1.1 Sales Process Overview
                                                    SALES DEPARTMENT
                                                    Liverpool, Great Britain


                              price &
                                                   approval
                             discount
                                                   process
                              setting

                                                                                                                          Sales Executive
                                                                                                                         Shawn Richardson




      customer                  item                                   order date
     information            information                                calculation


                                                                                                                           Sales Manager
                                                                                                                     Kevin Kennedy / Heidi Steen
                                                                                                                            / Junmin Hao

                                                   long term
                            sales quote              sales             sales order                  direct
                                                  agreement                                        delivery
  Account Manager /
   Order Processor



                                                                                                         PURCHASE DEPARTMENT
                                                                                                           Liverpool, Great Britain
                             CUSTOMER                  Web site, e-mail,
                                                       phone call, fax,...
                                                                                                                          $
                                                                                                                          $




                                                                                                                              $




                                                 sales demand

                                                                                                                   Purchasing


Big Box Toy Store  End
 Retail   Retail Consumer                                                                                                VENDOR
                               America / EMEA                   Asia / Australia



                                                                                             Transport Agent
                                                                                                                           Shipping



                               Transport Agent                                       CORPORATE ACCOUNTING
                                                                                       Liverpool, Great Britain
                    WAREHOUSE
           Liverpool, Great Britain / Boston,
          Massachusetts / Hong Kong, China                                         create sales
                                                                                      invoice
                                                                                                               Accounts Receivable




                                                                                   sales invoice
                             Shipping
                                                                                                                  Administrator
                                                                                                                     Arnie
                                                                                                            Microsoft and
         1.2 Detailed Product Profile
Product Profile Detail - Videogame


Product type:                     Digital Entertainment


Parent Product Name:              Videogame
Parent Product code:              DE00001


Manufacturer/Vendor:              Malay-Dan Export Unit Sdn Bhd
                                  12, Jalan Ampang
                                  MY-50450 AMPANG, Kuala Lumpur
Country of Origin:                Malaysia
Order Address:                    Malay- Dan Export Unit Sdn Bhd
                                  30, Jalan Ampang – Videogames Department
                                  MY 50450 AMPANG, Kuala Lumpur
Delivery conditions:              Malay always delivers according to the Inco-term DES (Delivered Ex Ship), which
                                  means that it arranges transport, but does not include this in its sales price. It sends a
                                  separate invoice for the shipping costs.
Delivery time:                    Malay delivers all its products within 3 days.

Production code:                  Each videogame is assigned a unique production number,
                                  following the sequence MDEU-VG- #### / ******
                                  where #### stands for the production year and ***** is the
                                  number of produced items.
Warranty:                         A warranty of 2 months is granted for each videogame and
                                  customers can only return videogames within this warranty period.


Variants:                         Videogames are divided into different age groups; Tailspin Toys provides
                                  videogames starting from age 12 and age 18.
Variant Description:              Parent product name + descriptions for each of the variants.
Vendor Variant Details:

Variant                   Vendor Product Number       Vendor Price
Videogames age 12              VG1995.003               98,348 MYR/PCS
Videogames age 18              VG1996.007              122,935 MYR /PCS

Alternative vendors:

Vendor                 Variant                Vendor Price            Delivery            Delivery time
                                                                      Conditions
Tengah Butong          Videogames age 12      122,935 MYR/PCS         CIF                 5D
                       Videogames age 18      147,54 MYR/PCS          CIF                 5D


Sales:



Variant /                  Big Box Retail        Toy Store Retail      End Consumer

   Customer Type

Videogames age 12          32,49 GBP/PCS         28,884 GBP/PCS        36,095 GBP/PCS

Videogames age 18          39,7045 GBP/PCS       36,095 GBP/PCS        43,32 GBP/PCS
                                                                    Microsoft and
Inventory levels:



Videogames age 12

Warehouse           Minimum Qty.   Bin               Max Capacity
W-LIVERPOO            200 PCS      W-LI-0001         1.000 PCS
                                   W-LI-RESERVE-DE     200 PCS
W-BOSTON              50 PCS       W-BO-1001           500 PCS
W-LOSANGEL            20 PCS       W-LA-2001           200 PCS

Videogames age 18

Warehouse           Minimum Qty.   Bin               Max Capacity
W-LIVERPOO            200 PCS      W-LI-0002         1.000 PCS
                                   W-LI-0003         1.000 PCS
                                   W-LI-RESERVE-DE     200 PCS
W-BOSTON              50 PCS       W-BO-1002           500 PCS
W-LOSANGEL            20 PCS       W-LA-2002           200 PCS
                                                                                                           Microsoft and
Product Profile Detail – DVD

Product type:                     Digital Entertainment


Parent Product Name:              DVD
Parent Product code:              DE00002


Manufacturer/Vendor:              Malay-Dan Export Unit Sdn Bhd
                                  12, Jalan Ampang
                                  MY-50450 AMPANG, Kuala Lumpur
Country of Origin:                Malaysia
Order Address:                    Malay- Dan Export Unit Sdn Bhd
                                  25, Jalan Ampang – DVD Department
                                  MY 50450 AMPANG, Kuala Lumpur
Delivery conditions:              Malay always delivers according to the Inco-term DES (Delivered Ex Ship), which
                                  means that it arranges transport, but does not include this in its sales price. Malay
                                  sends a separate invoice for the shipping costs.
Delivery time:                    Malay delivers all its products within 3 days.


Production code:                  /


Variants:                         Some DVD’s are sold together in DVD boxes, like a TV-series or
                                  for promotional purposes; in this case they are combined in boxes of 5 DVD’s.
Vendor Variant Details:

Vendor Product Number         Vendor Price
    DVD20003.007                24,587 MYR/PCS
    DVD20003.009              108,1828 MYR/BOX

Alternative vendors:

Vendor                 Vendor Price            Delivery          Delivery time
                                               Conditions
Tengah Butong          34,426 MYR/PCS          CIF               5D
KDHSL99                172,13 MYR/BOX          CFR               6D

Sales:



Variant /                  Big Box Retail          Toy Store Retail      End Consumer

    Customer Type

/                          21, 657 GBP/PCS         21, 657 GBP/PCS       21, 657 GBP/PCS

                           79,409 GBP/BOX          79,409 GBP/BOX        79,409 GBP/BOX


Inventory levels:


DVD

Warehouse              Minimum Qty.         Bin                   Max Capacity
W-LIVERPOO               100 PCS            W-LI-0004              750 PCS
                                            W-LI-0005              750 PCS
                                            W-LI-RESERVE-DE        100 PCS
                                            Microsoft and
W-BOSTON     35 PCS   W-BO-1003   350 PCS
W-LOSANGEL   20 PCS   W-LA-2003   200 PCS
                                                                                                       Microsoft and
Product Profile Detail - Stuffed Animal


Product type:                 Baby Toys


Parent Product Name:          Stuffed Animal
Parent Product code:          BT00001


Manufacturer/Vendor:          Tengah Buton Sdn Bhd
                              4KM Jalan Tuaran
                              MY-88100 KOTA KINABALU, Sabah
Country of Origin:            Malaysia
Delivery conditions:          Tengah always delivers according to the Inco-term CIF (Cost Insurance and Freight),
                              which means that it is fully responsible for the delivery to Tailspin Toys. This includes
                              taking the shipping costs for its account.
Delivery time:                Tengah delivers all its products within 5 days.
Production code:              /


Variants:                     Stuffed animals come in different sizes and colors; there are large pink, medium
                              green and small yellow variants of stuffed animals.
Variant Description:          Parent product name + abbreviation of size and color.
Vendor Variant Details:

Variant                       Vendor Price            Campaign Promotions
Large Pink Stuffed Animal      73,761 MYR/PCS         Christmas holidays (20 dec – 10 jan):
Medium Green Stuffed Animal    49,167 MYR/PCS                        -10%
Small Yellow Stuffed Animal    24,587 MYR/PCS

Alternative vendors:          /


Sales:



Variant /                         Big Box Retail       Toy Store Retail        End Consumer

   Customer Type

Large Pink Stuffed Animal         21,666 GBP/PCS       18,055 GBP/PCS          25,277 GBP/PCS

Medium Green Stuffed Animal       18,055 GBP/PCS       14,448 GBP/PCS          21,666 GBP/PCS

Small Yellow Stuffed Animal       14,448 GBP/PCS       10,836 GBP/PCS          18,055 GBP/PCS
                                                                    Microsoft and
Inventory levels:


Large Pink Stuffed Animal

Warehouse           Minimum Qty.   Bin               Max Capacity
W-LIVERPOO             20 PCS      W-LI-0007          200 PCS
                                   W-LI-0008          200 PCS
                                   W-LI-RESERVE-BT     20 PCS
W-BOSTON              15 PCS       W-BO-1004          150 PCS
W-LOSANGEL            7 PCS        W-LA-2004           75 PCS

Medium Green Stuffed Animal

Warehouse           Minimum Qty.   Bin               Max Capacity
W-LIVERPOO             25 PCS      W-LI-0008          300 PCS
                                   W-LI-RESERVE-BT     25 PCS
W-BOSTON              20 PCS       W-BO-1005          200 PCS
W-LOSANGEL            15 PCS       W-LA-2004          150 PCS

Small Yellow Stuffed Animals

Warehouse           Minimum Qty.   Bin               Max Capacity
W-LIVERPOO             30 PCS      W-LI-0009          450 PCS
                                   W-LI-RESERVE-BT     30 PCS
W-BOSTON              25 PCS       W-BO-1006          250 PCS
W-LOSANGEL            22 PCS       W-LA-2004          225 PCS
                                                                                                       Microsoft and
Product Profile Detail – Doll

Product type:                     Baby Toys


Parent Product Name:              Doll
Parent Product code:              BT00002


Manufacturer/Vendor:              Tengah Buton Sdn Bhd
                                  4KM Jalan Tuaran
                                  MY-88100 KOTA KINABALU, Sabah
Country of Origin:                Malaysia
Delivery conditions:              Tengah always delivers according to the Inco-term CIF (Cost Insurance and Freight),
                                  which means it is fully responsible for the delivery to Tailspin Toys. This includes
                                  taking the shipping costs for its account.
Delivery time:                    Tengah delivers all its products within 5 days.
Production code:                  /

Vendor Details:

Vendor Price            Campaign Promotions
 48,976 MYR/PCS         Christmas holidays (20 dec – 10 jan):
                                       -15%

Alternative vendors:

Vendor                      Vendor Price           Delivery          Delivery time
                                                   Conditions
Malay-Dan Export Unit       73,479                 DES               3D


Sales:



Variant /                 Big Box Retail          Toy Store Retail     End Consumer

    Customer Type

/                         28,888 GBP/PCS          28,888 GBP/PCS       28,888 GBP/PCS



Inventory levels:


Doll

Warehouse              Minimum Qty.        Bin                   Max Capacity
W-LIVERPOO                50 PCS           W-LI-0010              600 PCS
                                           W-LI-RESERVE-BT         50 PCS
W-BOSTON                 30 PCS            W-BO-1001              300 PCS
W-LOSANGEL               20 PCS            W-LA-2001              200 PCS
                                                                                                      Microsoft and
Product Profile Detail - Board Game

Product type:                    Family Games


Parent Product Name:             Board Game
Parent Product code:             FG00001


Manufacturer/Vendor:             Tengah Buton Sdn Bhd
                                 4KM Jalan Tuaran
                                 MY-88100 KOTA KINABALU, Sabah
Country of Origin:               Malaysia
Delivery conditions:             Tengah always delivers according to the Inco-term CIF (Cost Insurance and Freight),
                                 which means it is fully responsible for the delivery to Tailspin Toys. This includes
                                 taking the shipping costs for its account.
Delivery time:                   Tengah delivers all its products within 5 days.
Production code:                 /


Variants:                        There are many different board games, which can be divided into two main age
                                 groups; Tailspin Toys provides board games starting from age 12 and age 18.
Variant Description:             Parent product name + descriptions for each of the variants.
Vendor Variant Details:

Variant                      Vendor Price               Tailspin Toys Advantage
Board games age 12             117,4944 MYR/PCS          minimum 500 PCS: 105,745 MYR/PCS
Board games age 18             156,6592 MYR/PCS          minimum 500 PCS: 140,9933 MYR/PCS

Alternative vendors:             /


Sales:



Variant /                 Big Box Retail        Toy Store Retail     End Consumer

   Customer Type

Board games age 12        36,105 GBP/PCS        28,884 GBP/PCS       43,326 GBP/PCS

Board games age 18        43,326 GBP/PCS        36,105 GBP/PCS       50,54 GBP/PCS



Inventory levels:


Board games age 12

Warehouse              Minimum Qty.        Bin                     Max Capacity
W-LIVERPOO                 100 PCS         W-LI-0011                800 PCS
                                           W-LI-RESERVE-FG          100 PCS
W-BOSTON                   45 PCS          W-BO-1008                450 PCS
W-LOSANGEL                 10 PCS          W-LA-2001                100 PCS

Board games age 18

Warehouse              Minimum Qty.        Bin                     Max Capacity
W-LIVERPOO                 100 PCS         W-LI-0012                800 PCS
                                           W-LI-RESERVE-FG          100 PCS
                                            Microsoft and
W-BOSTON     45 PCS   W-BO-1002   450 PCS
W-LOSANGEL   10 PCS   W-LA-2002   100 PCS
                                                                                                           Microsoft and
Product Profile Detail – Paint


Product type:                   Crafts


Parent Product Name:            Paint
Parent Product code:            CR00001


Manufacturer/Vendor:            KDHSL99 Sdn Bhd
                                220, Jalan Limbongan
                                MY-42000 PELABUHAN KLANG, Selangor
Country of Origin:              Malaysia
Delivery conditions:            KDHSL99 always delivers according to the Inco-term CFR (Cost and Freight), which
                                means it is fully responsible for the delivery to Tailspin Toys. This includes taking the
                                shipping costs for its account.
Delivery time:                  KDHSL99 delivers all its products within 6 days.
Production code:                /


Variants:                       Paint comes in many different colors, but Tailspin Toys decided to stick to the basics
                                and keep only red, yellow and blue in stock;
                                Tailspin Toys sells paint in separate small cans or combined in a pack of 10 cans,
                                which results in a lower price per can for the customer.
Variant Description:            Parent product name + descriptions for each of the variants
Vendor Variant Details:

Variant                   Vendor Product Number         Vendor Price              Tailspin Toys Advantage
Red Paint                        PR995.765                                        * 1 PACK -> pay 9 CAN

Yellow Paint                        PY995.777            19,5904 MYR/CAN          * minimum 700 CAN:
                                                                                    18,61088 MYR/CAN
Blue Paint                          PB995.723                                     * minimum 70 PACK:
                                                                                    167,4979 MYR/PACK

Alternative vendors:

Vendor                    Variant               Vendor Price           Delivery            Delivery time
                                                                       Conditions
Malay-Dan Export Unit     Red Paint             29,3874 MYR/CAN        DES                 3D
                                                293,874 MYR/PACK       DES                 3D
Tengah Buton              Yellow Paint          24,488 MYR/CAN         CIF                 5D
                                                244,88 MYR/PACK        CIF                 5D
                          Blue Paint            24,488 MYR/CAN         CIF                 5D
                                                244,88 MYR/PACK        CIF                 5D
                                                                                         Microsoft and
Sales:



Variant /              Big Box Retail                 Toy Store Retail    End Consumer

   Customer Type

Red Paint              5,776 GBP/CAN                  4,3314 GBP/CAN      7,22 GBP/CAN

                       57 GBP/PACK                    43 GBP/PACK         72 GBP/PACK

Yellow Paint

                       minimum 200 CAN or 20 PACK:

Blue Paint             5,054 GBP/CAN

                       50 GBP/PACK


Inventory levels:


Red Paint

Warehouse           Minimum Qty.        Bin                Max Capacity
W-LIVERPOO              300 CAN         W-LI-0013          1.500 CAN
                                        W-LI-RESERVE-CR      300 CAN
W-BOSTON                75 CAN          W-BO-1010            750 CAN
W-LOSANGEL              25 CAN          W-LA-2007            250 CAN

Yellow Paint

Warehouse           Minimum Qty.        Bin                Max Capacity
W-LIVERPOO              300 CAN         W-LI-0014          1.500 CAN
                                        W-LI-RESERVE-CR      300 CAN
W-BOSTON                75 CAN          W-BO-1011            750 CAN
W-LOSANGEL              25 CAN          W-LA-2007            250 CAN

Blue Paint

Warehouse           Minimum Qty.        Bin                Max Capacity
W-LIVERPOO              300 CAN         W-LI-0015          1.500 CAN
                                        W-LI-RESERVE-CR      300 CAN
W-BOSTON                75 CAN          W-BO-1012            750 CAN
W-LOSANGEL              25 CAN          W-LA-2007            250 CAN
                                                                                                           Microsoft and
Product Profile Detail – Clay


Product type:                    Crafts


Parent Product Name:             Clay
Parent Product code:             CR00002


Manufacturer/Vendor:             KDHSL99 Sdn Bhd
                                 220, Jalan Limbongan
                                 MY-42000 PELABUHAN KLANG, Selangor
Country of Origin:               Malaysia
Delivery conditions:             KDHSL99 always delivers according to the Inco-term CFR (Cost and Freight), which
                                 means it is fully responsible for the delivery to Tailspin Toys. This includes taking the
                                 shipping costs for its account.
Delivery time:                   KDHSL99 delivers all its products within 6 days.

Production code:                 Clay is produced in bulk through a mixture of products.
                                 Afterwards the clay is divided into smaller amounts and sold in
                                 packs. Each mixture is given a production number, which is
                                 mentioned on the packing slip of every pack of clay (several
                                 packs can have the same production number, since they
                                 originate from the same production mix).
                                 The production numbers follow the sequence CLMIX-********
Expiration:                      clay can only be used for one year after production, and the
                                 expiration dates are mentioned on the product label.

Vendor Details:

Vendor Price
 83,3102 MYR/PACK

Alternative vendors:             /


Sales:



Variant /                 Big Box Retail        Toy Store Retail          End Consumer

    Customer Type

/                         18,045 GBP/PACK       18,045 GBP/PACK           18,045 GBP/PACK



Inventory levels:


Clay

Warehouse              Minimum Qty.        Bin                     Max Capacity
W-LIVERPOO                 10 PACK         W-LI-0016                100 PACK
W-BOSTON                   5 PACK          W-BO-1013                50 PACK
W-LOSANGEL                 5 PACK          W-LA-2008                50 PACK

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:16
posted:11/6/2011
language:English
pages:32