Question

A Campus Manager needs a quote for a product. Here are our inputs:
Shirt Cost: $12 per shirt
Print Cost: $14 per shirt
Set Up Cost For Order: $20 flat cost
Shipping Cost: $1 per shirt
Sales Manager Commission: 7% of the entire order
Create an excel spreadsheet that gets quotes for each quantity and each markup on cost at each quantity
Quantities
20
40
220
Markups on cost
10%
30%
60%

Answer 1

$20 \times 40 \div 220 \times 10\%$