EXERCISE $2\mathrm{.}4$

ABC Company's income and expense for year $2009$ are shown in Figure $2\mathrm{.}4\mathrm{.}4,$ in B$2$ and B$3.$ ABC expects that Incomes to increase by $10\%$ each year for five consecutive years ending in $2014.$ Expenses are expected to increase $$1,000$ each year. Compute the projected incomes and expenses and profits from $2010$ thru $2014.$

a$)$ Enter formulas in $C2$ and $C3$ for projected income and expense for $2010.$

b$)$ Enter formulas in B$4$ to compute the profit. Copy the formula in B$4$ to C$4.$

c$)$ Copy the formulas in column $C$ to the columns on the right until column $G.$

$\backslash$table$[[,$A$,$B$,$C$,0,E,$F$,],[1,,2009,2010,2011,2012,2013,2014],[2,$Income,$1000000,,,,,],[3,$Expense,$9500\mathrm{.}00,,,,,],[4,$Piofit,,,,,,$]]$

Figure $2\mathrm{.}4\mathrm{.}4$

$2.$ The projected monthly sales for ABC Manufacturing are given in the table below $($row $5).$ The monthly production is also projected at $1,050$ units every month $($row $4).$ The beginning inventory in January is $1,600.$ Use formulas to complete the projected inventory schedule for ABC Manufacturing.

Note that the ending inventory of each month is equal to the beginning inventory of the month, plus production, minus sales. The beginning inventory of each month is equal to the ending inventory of the previous month.

Complete the whole schedule. Enter only one formula in Cell D$3.$ Copy the formulas to the rest of the cells on the right $($from February thru December.$)$ Enter another formula in cell C$6.$ Copy the formula from C$6$ to cells D$6$ thru N$6.$