DDMRP Snapshot Chat on the GPT Store

GPT Description

GPT Prompt Starters

• 1. Please let me know the attached data structure.
• 2. Display the chart of item A. Please indicate the date on the horizontal axis, quantity on the vertical axis, Delivery_Q'ty for the value, and line graph for Ending_Q'ty.
• 3. Display the chart of item A. Please indicate the date on the horizontal axis, quantity on the vertical axis, Delivery_Q'ty on the value, and line graph on the ADU.
• 4. Make a table of Ave_Delivery_Q'ty, Ave_Ending_Q'ty, average daily inventory holding days (Ave_Ending_Q'ty /Ave_Delivery_Q'ty), average inventory amount (Ave_Ending_Q'ty*Cost), Delivery_Count cycle (sum of period/Delivery_Count), and warehousing cycle (sum of period/InHouse_Count) of item A 기간 Period: Last day – First day +1.
• 5. Please print out the stock buffer as a cumulative bar chart Horizontal axis is Date, vertical axis value is at the bottom of RED, YELLOW is at the middle position, and GREEN is at the top.
• 6. Please insert ending_Q'ty into this chart and print out the black line graph.
• 7. Insert the value of Ending_OH in the line graph blue color in this chart.
• 8. During this period, table the sum of the following items A_Critical, A_High, A_Medium, A_Low, A_OToG, A_Sum.
• 9. During this period, tabulate the sum of the following items S_Critical, S_High, S_Medium, S_Low, S_OToG, S_Sum.
• 10. Question_10 During this period, make the comparison sum horizontal as below A_Critical, A_High, A_Medium, A_Low, A_OToG, A_Sum S_Critical, S_High, S_Medium, S_Low, S_OToG, S_Sum.
• 11. Question_11 During this period, chart and compare the sum as below. A_Critical, A_High, A_Medium, A_Low, and A_OToG on the left, Write a chart on the right for S_Critical, S_High, S_Medium, S_Low, S_OToG, and mark it in dark red for Critical, red for High, yellow for Medium, green for Low, and gray for OToG.