Best ChatGPT prompts for Wholesale and Retail Buyers, Except Farm Products

Given a dataset of historical sales trends, customer demographics, and product attributes, develop a step-by-step methodology to identify the optimal product assortment for a new store location, taking into account factors such as seasonality, local competition, and supply chain constraints. Assume a minimum of 500 SKUs and a maximum of 10 product categories. Provide a detailed outline of the analysis, including data preprocessing, feature engineering, and model selection, as well as a sample Python code snippet to implement the solution.

Design a comprehensive evaluation framework to assess the performance of 15 different vendors across 5 key metrics: quality, lead time, pricing, communication, and reliability. Develop a weighted scoring system to rank vendors based on their overall performance, and provide a sample Excel template to implement the framework. Assume that each vendor has provided a minimum of 10 shipments over the past quarter, and that historical data on vendor performance is available. Also, provide a brief discussion on how to handle missing data and outliers in the evaluation process.

Develop a demand forecasting model using a combination of historical sales data, seasonal trends, and external factors such as weather and economic indicators. Assume a minimum of 2 years of historical data and a maximum of 5 product categories. Provide a detailed outline of the model development process, including data preprocessing, feature selection, and model evaluation, as well as a sample R code snippet to implement the solution. Also, discuss how to integrate the forecasting model with inventory optimization techniques to minimize stockouts and overstocking.

Conduct a comprehensive risk assessment of a global supply chain, identifying potential risks and vulnerabilities across 5 key areas: supplier insolvency, natural disasters, regulatory changes, logistics disruptions, and cybersecurity threats. Develop a risk mitigation strategy for each identified risk, including contingency planning, supplier diversification, and insurance coverage. Assume a minimum of 10 suppliers and a maximum of 5 logistics providers. Provide a detailed report outlining the risk assessment methodology, risk prioritization, and mitigation strategies, as well as a sample risk register template to track and monitor potential risks.