6th Grade Math Textbook, Fundamentals

&KDSWHU 

0RUH(QULFKPHQW7RSLFV

1.Change the number of adult and youth short-sleeve T-shirts to 36, and

change the number of cans of dye to 9. What will the new total cost be?

If the students sell all the T-shirts, how much money will they make?

2.Discuss and Write Plan a project that your class might do. Use a

spreadsheet to find all the costs and the possible profit. Write a

short report summarizing your results.

pages 263–264 for exercise sets.

Next, they find the total cost by entering the formula
SUM(D4:D12) in cell D13. This computes the sum of all the
values in the Cost column, from cell D4 to cell D12.

Finally, they use the formula D13/48 to divide the total
cost by 48. This tells them the cost of one tie-dyed T-shirt.

Their spreadsheet now
looks like this:

Then they learn that the
company takes 50¢ off
the price of each T-shirt
for orders of 12 or more
T-shirts of any size. They
change the prices in the
spreadsheet and the
program automatically
recalculates everything.

They decide to sell the
T-shirts for $12. If they
sell all of them, they will
make $309.45 for the
hurricane relief fund.