1.

1'er of collaboration: Individual We: 1.1 Verify the data set details 1.2 Analyse the sites I Where do our Revenues and Gross Profit come from? 1.3 Analyse the Products 0 what is the Revenue generated by each product and product groups? - What is their profitability? 1.4 Analyse the evolution of the company and create a forecast o How have sales and profits developed in recent years? 0 What is the forecast for the next 24 months? 0 Scenario Analysis {What If) - How does an increase in marketing spending would affect our forecast? 1.5 Analyse Customer Satisfaction - How has Customer Satisfaction developed in recent years? I What is the forecast for the next 12 months? 0 What factors affect our customer's satisfaction? . What are the characteristics of our most satisfied customers? \fDescription The Insight Toys Company is an organization that manufactures toys at different production sites worldwide. We are trying to nd ways to be more competitive and are striving to increase customer satisfaction. Managers of finance department need to better understand profitability and sales issues. Data The INSIGHTFOLSALES data set, contains 5? variables and over 1.4M observations. It represents the historic transactional data from the companvr start. For each transaction we have: Information on the items sold (Product Brand, Line, Make, Style, SKU]; The sale value (Order Total]; Various related costs (Distribution, Marketing, Product); Information on the sales representative (Rating, Target, Actual, etc.]; Geographic information (vaaciiity Lot, xyFaciiity ton, xy..., etc); Information on the vendors (Rating, Satisfaction, Distance to nearest facility); Text Notes taken at the moment of the order taking, based on conversation with the customer (vendor). Vendor Date Ended Date Category When the vendor stopped doing business with us Vendor Date Started Date Category when the vendor started doing l:iusiness with us Vendor Loyalty Program Character Category Binary field [YIN] representing whether or not this vendor ism our loyalty program Vendor Type Character Category Sitypes of vendors: Convenience store. Discount store, Department store. Kiosk or Other Market Penetration Numeric Measure For each transaction, the corresponding 96 of market share in that particular region at that time. Order Distribution Cost Numeric Measure Distribution cost associated with that transaction Order Marketing Cost Numeric Measure Marketing cost assigned to that transaction [through an activity-based cost: ng exercise] ' F ' ' h h ' , I l h Order Product Cost Numeric Measure Direct menu acturing costs associated wit t attransaction ric uded It e calculation of gross Margin Order Sales Cost Numeric Measure Sale-sarelated-costs assrgned to that transaction (through an activrtyabased costing exercise] Order Total Numeric Measure Revenue from that sale Sales Rep 96 of Target Numeric Measure A ratio of Sales Rep Actual sales divided by Sales Rep target. Calculated DAILY cumulative DAILY sales for each sales representative. This value should Sales Rep Actual Numeric Measure not be summed across the transactions [since it has already been aggregated] Sales Rep Orders Numeric Measure Number of orders assigned tothe sales representative on a given period. Sales Rep Rating Numeric Measure Subiective evaluation olthe sales representative by the vendors-from 0% to 100%, Daily sales Target lgoall for each sales representative. This value should Sales Rep target Numeric Measure not be summed across the transactions (since it has already been aggregated} Potential revenue [funnel] from all the vendors assigned to a sales Sales Rep Vendor Base Numeric Measure representative. This value should not be summed across the transactions [Since it has already been aggregated] Number of vendors assigned to a sales representative. This value should Sales Rep Vendors Numeric Measure not be summed across the transactions (since it has already been aggregated] Vendor Distance Numeric Measure Distance from the vendor location to our selling facility Vendor Rating Numeric Measure Subiective evaluation, from 0% to 100%, representing the potential value of a customer {vendor} for insight Toy. Vendor Satisfaction Numeric Measure Satisfaction of the customer {vendor} based on a marketing survey. From 0% to 10035. xyFaciIity City Lat Numeric Measure Latitude of the city where the selling facility is located xyFacility City Lon Numeric Measure Longitude of the city where the selling Facility is located xyFacility Continent Lat Numeric Measure Latitude of the continent where the selling facility is located xyFaciIity Continent Lon Numeric Measure Longitude of the continent where the selling faCIlity is located xyFacility Count ryHRegion Lat Numeric Measure Latitude of the country where the selling facility is located xyFaciIity CountryfRegion Lon Numeric Measure Longitude of the country where the selling faulity is located xyFacility Lat Numeric Measure Latitude where the selling facility is located xyFacility Lori Numeric Measure Longitude where the selling fatility is located xyFacility StatefPrciyince Lat Numeric Measure Latitude of the state where the selling facility is located xyFaCIIity StatefProvmce Lon Numeric Measure Longitude of the state where the selling facility is located xyManufactu ring Facility Lat Numeric Measure Latitude where the ma nufactory facility is located xyManufacturing Facility Lon Numeric Measure Longitude where the manufactory facility is located xyVendor Lat Numeric Measure Latitude where the vendor is located xyVendor Lon Numeric Measure Longitude where the vendor is located