Problems

When an item is shipped, the shipping cost is determined by the quanity of the item being shipped. The greater the quantity being shipped the lower the shipping cost per unit. The Shipping Costs worksheet provides the costs per unit for shipping different quantities of items $w-1,w-2,w-3,$ and $w-4.$

Use formulas to populate D$2$:D$31$ with the appropriate shipping cost per unit.

Use formulas to populate E$2$:E$31$ with the shipping total.

Use formulas to populate N$2$:N$5$ with the number of shipments for each item.

Use formulas to populate $02$:$05$ with the average quanity for each item.

Use formulas to populate P$2$:P$5$ with the total shipping cost for each item.