Ir al contenido
Menú
Se marcó esta pregunta

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.

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
2
jul 25
366
1
may 25
1159
0
nov 24
840
0
mar 25
1871
3
abr 23
4397