Question

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

you should take the NCERT book

Answer 2

Answer:

Step-by-step explanation:

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

Let say number of shirts = x   => Cloumn A

then  x shirts cost =  $12x      = Clumn B  = ($12 * ColumnA)

Print cost of x shirts = $14x    => Column C = ($14 * ColumnA)

Setup Cost =   $20                 => Cloumn D = $20

Shipping Cost =  $x                => Couln E = ($1 * ColumnA)

Total Cost       = $12x + $14x + $20 + $x  => Coulmn F = (Column B + Column C + Column D + Column E)

Total Cost  = $27x + $20

Commisson  = (7/100) * ($27x + $20 )  => Cloumn G = (7/100) * Column F

Fina Cost Price = $27x + $20  + (7/100) * ($27x + $20 )  => Cloumn H = Cloumn F + Column G

Final Cost Price = (1.07) * ($27x + $20 )

Mark up =  y%     =    Cloumn I

Margin = (y/100) * (1.07) * ($27x + $20 )   => Cloumn J = (cloumn I/100) * (Cloumn H)

Quoted Price =      (1.07) * ($27x + $20 ) + (y/100)( (1.07) * ($27x + $20 )    => Column K = Cloumn H + Cloumn J    

Quoted Price =  (1.07) * ($27x + $20 )(1+ y/100)

for x = 20  & y = 10

Quoted Price = (1.07) * ($27*20 + $20 )(1+ 10/100)

= (1.07) * ($560 )(1.1) = $659.12

for x = 40  & y = 30

Quoted Price = (1.07) * ($27*40 + $20 )(1+ 30/100) = $1530.1

for x = 220  & y = 60

Quoted Price = (1.07) * ($27*220 + $20 )(1+ 60/100) = $10203.52