Solved

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

Question 48

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.
1 A  B 23 Data 45 Sales $10,000,0006 Cost of Goods Sold $6,400,0007 Administrative Expenses $500,0008 Selling Expenses $900,0009 Depreciation Expenses $750,00010 Interest Expenses $70,00011 Taxes $620,0001213 Model 1415 Gross Profit $3,600,00016 Operating Expenses $2,150,00017 Net Operating Income $1,450,00018 Earnings Before Taxes $1,380,0001920 Net Income \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.

Correct Answer:

verifed

Verified

To find the order cost associated with t...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents