I own a small job shop. Everything I sell is manufactured to order. I am setting up my parts with operations on work centers with estimated or calculated cycle times (durations). When my customers reach out for a quote on a part, I want to use the price of the material, the time on the machine times machine hourly rate, and setup time to calculate the cost of the parts for the customer's desired quantity. Currently, Odoo is only outputting the value for a single part, and if I put 100 parts on a line in a sales quote, Odoo fills in the cost per unit as though I was making one part and calculates a total that would include 100 setups of the machine, even though I would obviously only set up the machine once for all 100 parts. Is there a solution for this?

Here is the equation that I would typically use to calculate the cost of an order.

1.67 = shop rate (dollars/minute)

S = setup time (in minutes)

T = cycle time (duration, minutes)

Q = quantity quoted (units)

C = material cost/material unit (dollars/UoM for material)

L = amount of required material (UoM for material)

P = item price returned on quote (dollars)

P = ((S x 1.67) / Q) + (T x 1.67) + (C / L)

I would like to incorporate this equation into my quotes, so the price automatically updates based on the quantity quoted.