Estimate wholesale and retail value of gems, following pricing guides, market fluctuations, and other relevant economic factors.
AI does the arithmetic and suggests what to look at; the conclusions are yours.
Show prompt & steps
AI can do the arithmetic, build the spreadsheet formula and suggest what to look at. Deciding what the numbers mean for your situation is still you.
Ready-to-use prompt
I work as a gem / diamond worker. Part of my job is to estimate wholesale and retail value of gems, following pricing guides, market fluctuations, and other relevant economic factors. Context: We use Spectrophotometer analysis software and Business accounting software; the work draws on sales and marketing, production and processing and customer and personal service. Goods or services: [crops, merchandise, products] Data: [cost, quality, market prices] Recommend a value or price range with reasoning and formulas for mark-up or mark-down. Show your working step by step and give spreadsheet formulas so I can reproduce the numbers.
10-minute exercise: Value and pricing
AI makes arithmetic mistakes. Recompute anything that matters with a spreadsheet formula.
Importance 4.4/5 · core task · O*NET work activity: Determine the value of goods or services..