Pricing grid base calculation

arithmetic

I am useless at maths and have been trying to figure this out for ages. I am creating an website for a client which prices fabric based on square inch of material. Their supplier gave them the attached table but I cannot work out the base price per square inch to use as a multiplier. Is there a formula that can work this out?

I have been calculating the base square in price by dividing the price by square in but it changes as the size goes up? When finished the customer should be able to enter width and height and get a price?

price calc

Sorry if this seem pretty obvious but its wrecking my head

Thanks in advance

Joe

Best Answer

All the values left of 60 width and up from 42 drop fit roughly $18.77+0.94({\text{width+drop}\over6}-8)$ and beyond that I'm not much help. But as everyone says, All they need to do is change it and you're no longer able to find it easily without lookup.

Related Solutions

[Math] Proof without calculation

I think the trick is that the question just asks for a proof that there exist two of the numbers such that their product is non-negative. In principle there could be other products that were negative.

Now, if at least two of the numbers are non-negative, then their product is non-negative too.

If less than two of them are non-negative, there must be at least two negative numbers among them ...

Multiplication in a 3×3 grid

import math
import itertools
def prod(l):
    r1 = l[0]*l[1]*l[2]
    r2 = l[3]*l[4]*l[5]
    r3 = l[6]*l[7]*l[8]
    c1 = l[0]*l[3]*l[6]
    c2 = l[1]*l[4]*l[7]
    c3 = l[2]*l[5]*l[8]
    return (r1+r2+r3+c1+c2+c3)

x = itertools.permutations([1,2,3,4,5,6,7,8,9])

minsum = math.inf

maxsum = 0

minlist = []
maxlist = []

for i in x:
    a = prod(i)
    if a < minsum:
        minlist = i
        minsum = a
    if a > maxsum:
        maxlist = i
        maxsum = a

print(minsum)
print(maxsum)
print(minlist)
print(maxlist)`

Not extremely enlightening but I ran this python code to find an answer of $436$, (and a max of $947$).

Best Answer

Related Solutions

[Math] Proof without calculation

Multiplication in a 3×3 grid

Related Question