Create VBA for Packaging Company Product Calculation

We are a packaging company and I need a VBA or any other form to calculate the cost of the paper bags, cardboard boxes, and rigid boxes.

Here's a brief introduction of how a paper bag/ box is made:
1. Received quotation request from customer, will receive [Paper Bag/Box style, paper kind, paper thickness, size, printing colors, any surface treatment, quantity]
2. Calculate the paper size based on the paper bag/box style based on the least wastage of paper, and get the *paper price*
3. Calculate the printing cost, including the printing plate (fixed price), ink price (different varies on quantity)
4. Calculate the surface treatment, such as embossing, debossing, foil stamping, and others

Here's the example: 8*8*8cm Lid-off Box - 4 Colors Printing - Embossing - Foil Stamping - 5000pcs
Lid-off box contains 2 pieces, the box, and the lid.
Lid: Left to Right = Length+4*Height+(2*1) = 42cm
Top to Bottom = Width +4*Height +(2*1) = 42cm
Box: Left to Right = Length+4*Height+(2*1)+(2*1.5) = 45cm
Top to Bottom = Width+4*Height+(2*1)+(2*1.5) = 45cm
1. We will need to see if we can combine the Lid and Box print together in the same piece of paper or not. And this will affect all the costs after. For the calculation above, the lid and box can be put on the same piece of paper.
2. Calculate the printing cost. The printing plate is fixed price, $300/1 color. The printing cost varies on the paper thickness and quantity.
3. Calculate the surface treatment, such as embossing, debossing, foil stamping, and others.

Here is what I want to get with the file:
I want to put in the size, choose all the variables, and the price will come up automatically.

There are different formulas for different boxes. We can provide all the formulas, but we will need someone to do the excel for us.

The budget could be discussed, and if you can put this on our website as an auto calculation for customers, we can raise our budget too.

Please take a look at the attachment, and let us know if you are the perfect candidate for this.