Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries

Worksheet: 'Sales April $2006\text{'}$

Based on the worksheet "Sales April $2006"$ and the Table $1$ below, John wants to forecast the net profits of BUBBLE TEA and TARO in May $2006.$ Please complete the worksheet "Forecast May $2006"$ with Excel formulas assuming that all the operating expenses items are unchanged, and only "Sales", "cost of goods sold" will increase$/$decrease $-$ see table $1$ below:

Table $1$:

$\backslash$table$[[$Drinks$,\backslash$table$[[$Percentage$(\%)$ increase in Sales over the$],[$previous month$]],\backslash$table$[[$Percentage $(\%)$ decrease in cost of$],[$goods sold over the previous month$]]],[$Bubble tea,$8,2],[$Taro$,10,4]]$

Worksheet: $$Forecast May $2006$

$\backslash$table$[[,$A$,$B$,$C$],[1,$May $2006,$bubble tea,Taro$],[2,$Sales,$[??0\mathrm{.}08$ mark$],[??0\mathrm{.}08$ mark$]],[3,$Cost of goods sold,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark$]],[4,$Gross profit,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark $]],[5,,,],[6,$Operating Expenses$],[,$Salaries Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries

Worksheet: 'Sales April $2006\text{'}$

Based on the worksheet "Sales April $2006"$ and the Table $1$ below, John wants to forecast the net profits of BUBBLE TEA and TARO in May $2006.$ Please complete the worksheet "Forecast May $2006"$ with Excel formulas assuming that all the operating expenses items are unchanged, and only "Sales", "cost of goods sold" will increase$/$decrease $-$ see table $1$ below:

Table $1$:

$\backslash$table$[[$Drinks$,\backslash$table$[[$Percentage$(\%)$ increase in Sales over the$],[$previous month$]],\backslash$table$[[$Percentage $(\%)$ decrease in cost of$],[$goods sold over the previous month$]]],[$Bubble tea,$8,2],[$Taro$,10,4]]$

Worksheet: $$Forecast May $2006$

$\backslash$table$[[,$A$,$B$,$C$],[1,$May $2006,$bubble tea,Taro$],[2,$Sales,$[??0\mathrm{.}08$ mark$],[??0\mathrm{.}08$ mark$]],[3,$Cost of goods sold,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark$]],[4,$Gross profit,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark $]],[5,,,],[6,$Operating Expenses$],[,$Salaries Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries

Worksheet: 'Sales April $2006\text{'}$

Based on the worksheet "Sales April $2006"$ and the Table $1$ below, John wants to forecast the net profits of BUBBLE TEA and TARO in May $2006.$ Please complete the worksheet "Forecast May $2006"$ with Excel formulas assuming that all the operating expenses items are unchanged, and only "Sales", "cost of goods sold" will increase$/$decrease $-$ see table $1$ below:

Table $1$:

$\backslash$table$[[$Drinks$,\backslash$table$[[$Percentage$(\%)$ increase in Sales over the$],[$previous month$]],\backslash$table$[[$Percentage $(\%)$ decrease in cost of$],[$goods sold over the previous month$]]],[$Bubble tea,$8,2],[$Taro$,10,4]]$

Worksheet: $$Forecast May $2006$

$\backslash$table$[[,$A$,$B$,$C$],[1,$May $2006,$bubble tea,Taro$],[2,$Sales,$[??0\mathrm{.}08$ mark$],[??0\mathrm{.}08$ mark$]],[3,$Cost of goods sold,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark$]],[4,$Gross profit,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark $]],[5,,,],[6,$Operating Expenses$],[,$Salaries Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries Question $16\mathrm{.}25$ marks$)($write Excel formula only$)$Convert the following problems from their English expressions to Excel formulas that allow Excel to calculate the answers. Refer to the worksheet 'Sales April $2006\text{'}.$John Tam is the boss of NewBest, a drink shop in Mongkok. Five different drinks are sold in NewBest: bubble tea, coffee, orange, Latte, and Taro. John wants to see the sales, net profit, gross profit and operating expense totals for each drink type in April $2006.$ The sales figures for the $5$ drinks are given in cells C$2$ to G$2.$ Write an Excel formula in cell B$2$ to calculate the total sales for all $5$ drinks. The cost of goods sold figures for the $5$ drinks are given in cells C$3$ to G$3.$ Write an Excel formula in cell B$3$ to calculate the total cost of goods sold for all $5$ drinks. Given that gross profit $=$ sales $-$ cost of goods sold. Write Excel formulas in cells C$4$ to G$4$ to calculate the gross profit for each of the five drinks. Write an Excel formula in cell B$4$ to calculate the total gross profit for all five drinks.Each drink of NewBest has the following operating expenses: Salaries

Worksheet: 'Sales April $2006\text{'}$

Based on the worksheet "Sales April $2006"$ and the Table $1$ below, John wants to forecast the net profits of BUBBLE TEA and TARO in May $2006.$ Please complete the worksheet "Forecast May $2006"$ with Excel formulas assuming that all the operating expenses items are unchanged, and only "Sales", "cost of goods sold" will increase$/$decrease $-$ see table $1$ below:

Table $1$:

$\backslash$table$[[$Drinks$,\backslash$table$[[$Percentage$(\%)$ increase in Sales over the$],[$previous month$]],\backslash$table$[[$Percentage $(\%)$ decrease in cost of$],[$goods sold over the previous month$]]],[$Bubble tea,$8,2],[$Taro$,10,4]]$

Worksheet: $$Forecast May $2006$

$\backslash$table$[[,$A$,$B$,$C$],[1,$May $2006,$bubble tea,Taro$],[2,$Sales,$[??0\mathrm{.}08$ mark$],[??0\mathrm{.}08$ mark$]],[3,$Cost of goods sold,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark$]],[4,$Gross profit,$[??0\mathrm{.}08$ mark $],[??0\mathrm{.}08$ mark $]],[5,,,],[6,$Operating Expenses$],[,$Salaries