Try it$!$ Suppose that a manufacturing company buys raw materials from a supplier.

If the cost in any month is $$x,$ the company pays $40\%$ of this cost one month from

now and the other $60\%$ two months from now. Use the OFFSET function to

calculate the payments made in January through August in the green cells to the

right, based on the costs through July. These calculated payments should change

automatically if you change the inputs in the blue or red cells above. For example,

make sure your formulas react correctly if you enter $2$ and $3$ in the two red cells.

$($Scroll to the right to see the answer.$)$