Costing Project

Robm1955

I don't know how easy this will be to do in excel, but I'm certainly not sure how to do it. I've attached a sample of a spreadsheet which shows 5 quantities, their price each, and total quantity. These are actually components that have been ordered. What I want to achieve is, find the total cost if, say we order 50 of each part, which in the sample is 3. This would of course be 50 x £66.83, £43.82, and £53.16. The actual spreadsheet holds 50 parts, and I know I could do it manually, but I want to input 50, and the spreadsheet come up with a total cost for ordering 50 of each part, or whatever quantity out of the range I select (50,100,150,200,300)

Robm1955

Sorry, the example is

Qty Price Total Costs

50 £66.83 £3,341.50
100 £64.83 £6,483.00
150 £62.88 £9,432.00
200 £60.99 £12,198.00
300 £59.16 £17,748.00

50 £43.82 £2,191.00
100 £42.55 £4,255.00
150 £41.27 £6,190.50
200 £40.03 £8,006.00
300 £38.83 £11,649.00

50 £53.16 £2,658.00
100 £51.56 £5,156.00
150 £50.01 £7,501.50
200 £48.51 £9,702.00
300 £47.06 £14,118.00

fleshandbone

have you used the auto sum feature?

Le_Kirk

Maybe use a WhatIf table.