Solved

Using the Spreadsheet Below to Answer the Following Question(s) -Using the Spreadsheet Below, Provide the Steps in Using Excel

question 15

Essay

Using the spreadsheet below to answer the following question(s).
The spreadsheet below shows the net income model for a company that sells shoes.
$\begin{array} { | l | l | l | } \hline 1 & \text { A } & \text { B } \\\hline 2 & & \\\hline 3 & \text { Data } & \\\hline 4 & & \\\hline 5 & \text { Sales } & \$ 10,000,000 \\\hline 6 & \text { Cost of Goods Sold } & \$ 6,400,000 \\\hline 7 & \text { Administrative Expenses } \$ 500,000 \\\hline 8 & \text { Selling Expenses } & \$ 900,000 \\\hline 9 & \text { Depreciation Expenses } & \$ 750,000 \\\hline 10 & \text { Interest Expenses } & \$ 70,000 \\\hline 11 & \text { Taxes } & \$ 620,000 \\\hline 12 & & \\\hline 13 & \text { Model } & \\\hline 14 & & \\\hline 15 & \text { Gross Profit } & \$ 3,600,000 \\\hline 16 & \text { Operating Expenses } & \$ 2,150,000 \\\hline 17 & \text { Net Operating Income } & \$ 1,450,000 \\\hline 18 & \text { Earnings Before Taxes } & \$ 1,380,000 \\\hline 19 & & \\\hline 20 & \text { Net Income } & \\\hline\end{array}$
-Using the spreadsheet below, provide the steps in using Excel formulas in finding the cost of the first order for Item number 1345, and the total cost of all Item numbers 1345, using the Match and Index functions in Excel.Column B is sorted by item number in ascending order.
$Using the spreadsheet below to answer the following question(s). The spreadsheet below shows the net income model for a company that sells shoes. \begin{array} { | l | l | l | } \hline 1 & \text { A } & \text { B } \\ \hline 2 & & \\ \hline 3 & \text { Data } & \\ \hline 4 & & \\ \hline 5 & \text { Sales } & \$ 10,000,000 \\ \hline 6 & \text { Cost of Goods Sold } & \$ 6,400,000 \\ \hline 7 & \text { Administrative Expenses } \$ 500,000 \\ \hline 8 & \text { Selling Expenses } & \$ 900,000 \\ \hline 9 & \text { Depreciation Expenses } & \$ 750,000 \\ \hline 10 & \text { Interest Expenses } & \$ 70,000 \\ \hline 11 & \text { Taxes } & \$ 620,000 \\ \hline 12 & & \\ \hline 13 & \text { Model } & \\ \hline 14 & & \\ \hline 15 & \text { Gross Profit } & \$ 3,600,000 \\ \hline 16 & \text { Operating Expenses } & \$ 2,150,000 \\ \hline 17 & \text { Net Operating Income } & \$ 1,450,000 \\ \hline 18 & \text { Earnings Before Taxes } & \$ 1,380,000 \\ \hline 19 & & \\ \hline 20 & \text { Net Income } & \\ \hline \end{array} -Using the spreadsheet below, provide the steps in using Excel formulas in finding the cost of the first order for Item number 1345, and the total cost of all Item numbers 1345, using the Match and Index functions in Excel.Column B is sorted by item number in ascending order.$

Definitions:

Product Costs

All costs incurred to acquire or produce a product that is intended for sale, including direct materials, direct labor, and manufacturing overhead.

Conversion Costs

Expenses related to converting raw materials into finished goods, typically including labor and manufacturing overhead.

Product Costs

Expenses directly tied to the creation of a product, including materials, labor, and manufacturing overhead.

Period Costs

Expenses that are not directly tied to the production of goods or services, such as selling, general, and administrative expenses, and are expensed in the period incurred.