Best Gemini prompts for Parts Salespersons

I have noticed a discrepancy in my inventory report, with 10 cases of part #ABC123 missing from the warehouse. I have checked the shipping and receiving logs, but cannot find any record of the parts being removed. Use the industry-specific database to analyze the inventory movement history, and provide a step-by-step guide on how to investigate and resolve the discrepancy, including potential causes, interview questions for warehouse staff, and a plan for re-counting the inventory. Also, generate a sample email to send to the warehouse manager, requesting their assistance in resolving the issue.

I need to generate a sales forecast for the upcoming quarter, and recommend parts to stock up on based on historical sales data and seasonal trends. Use Google Data Studio to analyze the sales data from the past 2 years, and create a dashboard that shows the top 10 selling parts, total sales revenue, and profit margin. Also, provide a list of recommended parts to stock up on, along with the predicted quantity and revenue, and a brief explanation of the reasoning behind each recommendation.

I have received a customer complaint about a defective part, and need to conduct a quality audit to identify the root cause and implement corrective actions. Use the quality audit template to guide the investigation, and provide a detailed report that includes the audit findings, root cause analysis, corrective actions, and preventive measures. Also, generate a sample email to send to the customer, apologizing for the issue and providing a resolution, and a plan for re-training staff on quality control procedures.

I need to generate a daily status report that shows the current inventory levels, pending orders, and tasks to be completed. Use Google Sheets to create a dashboard that displays the key performance indicators, and provide a list of tasks to be completed, prioritized based on urgency and importance. Also, generate a sample email to send to the team, requesting their input on the tasks and deadlines, and a plan for delegating tasks and tracking progress.