I am helping a friend with a business plan for his small bbq business. He currently has a smoker that can hold up to 24 boston butts (roughly 192 lbs of meat). I am hoping to create a easy to use workable excel document where he can simply manipulate 1 value:

1. Number of people needing to be fed

His local competitors do not have a tiered pricing system, they simply use a per person pricing breakdown. If someone tells Sonny's BBQ they are feeding 150 people, sonny's says that roughly 1 pound of meat feeds 5 people. Since Sonny's (here anyway) charges $11.99 per pound, the price is simply $359.70 (or 150/5 = 30 lbs, and 30 X $11.99 = $359.70).... Where as my friend can do it for more like $120!

I'm hoping to create the following tiered pricing system in a formula:
0-8 lbs = $5.63 per lb
9-16 lbs = $5.07 per lb
17-32 lbs = $4 per lb
33-72 lbs = $3.50 per lb
>73 lbs = $2.50 per lb

Any help is appreciated! Thank you.