60707 – Assessment 1 – Business Investigation Project (Due 09

SOLUTION AT Australian Expert Writers

Details:
1 – (Due 09 Oct 2020, 11:30pm)DescriptionThe Insight Toys Company is an organization that manufactures toys at different production sites worldwide. We are trying to find ways to be more competitive and are striving to increase customer satisfaction. Managers of finance department need to better understand profitability and sales issues.DataThe INSIGHTTOY_SALES data set, contains 57 variables and 1,416,058 observations. It represents the historic transactional data from the company start. For each transaction we have:® 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 (xyFacility Lat, xyFacility Lon, 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).Data DictionaryNameTypeClassDescriptionFacility Character Category Unique identifier of the selling facilityFacility City Character Category City where the selling facility is locatedFacility Continents Character Category Continent where the selling facility is locatedFacility Country/Region Character Category Country where the selling facility is locatedFacility Country/Region Code Character Category Unique 2-letter code for each countryFacility Date Closed Date Category If a facility were ever to be closed, none are in this datasetFacility Date Opened Date Category Date the manufacturing facility was opened, varies from 1980 to 2010Facility State/Province Character Category State or Province where the selling facility is locatedManufacturing Batch Character Category Manufacturing batch corresponding to each transactionManufacturing Batch SKU Character Category Stock Keeping Unit of various Manufacturing BatchesManufacturing Facility Character Category Identifier and location of the manufacturing facilityOrder Character Category Unique identifier of the orderOrder note Character DocumentCollection Free form text – notes taken at the moment the vendor ordered items. This can be used in Text AnalyticsProduct Brand Character Category 2 brands of products: Novelty and ToysProduct Line Character Category 8 lines of products, falling in the two product brandsProduct Make Character Category 77 product make, falling into the 8 product linesProduct SKU Character Category 779 product SKUs produced, falling into the various product stylesProduct Style Character Category 355 product styles, falling into the various product makesSales Rep Character Category Identification of the sales representative who made the saleTransaction Date Date Category Date of the saleTransaction Day of Week Date Category Day of the week of the saleTransaction Month of Year Date Category Month of the saleVendor Character Category Identifier and location of the vendor (customer)page 1Vendor Date Ended Date Category When the vendor stopped doing business with usVendor Date Started Date Category When the vendor started doing business with usVendor Loyalty Program Character Category Binary field (Y/N) representing whether or not this vendor is in our loyalty programVendor Type Character Category 5 types of vendors: Convenience store, Discount store, Department store, Kiosk or OtherMarket Penetration Numeric Measure For each transaction, the corresponding % of market share in that particular region at that time.Order Distribution Cost Numeric Measure Distribution cost associated with that transactionOrder Marketing Cost Numeric Measure Marketing cost assigned to that transaction (through an activity-based costing exercise)Order Product Cost Numeric Measure Direct manufacturing costs associated with that transaction. Included I the calculation of gross MarginOrder Sales Cost Numeric Measure Sales-related costs assigned to that transaction (through an activity-based costing exercise)Order Total Numeric Measure Revenue from that saleSales Rep % of Target Numeric Measure A ratio of Sales Rep Actual sales divided by Sales Rep target. Calculated DAILYSales Rep ActualNumericMeasure Cumulative DAILY sales for each sales representative. This value should not be summed across the transactions (since it has already been aggregated)Sales Rep Orders Numeric Measure Number of orders assigned to the sales representative on a given period.Sales Rep Rating Numeric Measure Subjective evaluation of the sales representative by the vendors – from 0% to 100%.Sales Rep TargetNumericMeasure Daily sales Target (goal) for each sales representative. This value should not be summed across the transactions (since it has already been aggregated)Sales Rep Vendor BaseNumericMeasure Potential revenue (funnel) from all the vendors assigned to a sales representative. This value should not be summed across the transactions (since it has already been aggregated)Sales Rep VendorsNumericMeasure Number of vendors assigned to a sales representative. This value should not be summed across the transactions (since it has already been aggregated)Vendor Distance Numeric Measure Distance from the vendor location to our selling facilityVendor Rating Numeric Measure Subjective 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 100%.xyFacility City Lat Numeric Measure Latitude of the city where the selling facility is locatedxyFacility City Lon Numeric Measure Longitude of the city where the selling facility is locatedxyFacility Continent Lat Numeric Measure Latitude of the continent where the selling facility is locatedxyFacility Continent Lon Numeric Measure Longitude of the continent where the selling facility is locatedxyFacility Country/Region Lat Numeric Measure Latitude of the country where the selling facility is locatedxyFacility Country/Region Lon Numeric Measure Longitude of the country where the selling facility is locatedxyFacility Lat Numeric Measure Latitude where the selling facility is locatedxyFacility Lon Numeric Measure Longitude where the selling facility is locatedxyFacility State/Province Lat Numeric Measure Latitude of the state where the selling facility is locatedxyFacility State/Province Lon Numeric Measure Longitude of the state where the selling facility is locatedxyManufacturing Facility Lat Numeric Measure Latitude where the manufactory facility is locatedxyManufacturing Facility Lon Numeric Measure Longitude where the manufactory facility is locatedxyVendor Lat Numeric Measure Latitude where the vendor is locatedxyVendor Lon Numeric Measure Longitude where the vendor is locatedpage 2Assessment 1 – Business Investigation ProjectYou are to write short research report (miximum 1500 words) on“Explain and evaluate the key ethical issues confronting the individual/organisation when collecting and reporting data.”for one of the sectors:• Media Services• Online Retail Business• Online Services Business• Human Resources • Banking and Financial Management• Automotive (e.g. cars, planes, ships, rails, drones)• Transports Logistics (e.g. aviation, shipping, rails, trucking, pipelines, warehousing, postal)• Manufacturing• Hospitality (e.g. hotels, restaurants, catering)• Retail (Bricks and Mortar)• Utility (e.g. electricity, water, gas)• Energy (e.g. hydro, coal, solar, wind, biomass, gas, nuclear)• Risks Management (e.g. insurance, any security) • Real Estate, Building and Construction Management • Infrastructure Management.page 3

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER