Examlex

Solved

Use the Data Given Below to Answer the Following Questions)

question 42

Multiple Choice

Use the data given below to answer the following questions) .
Below is a spreadsheet of purchase orders for a computer hardware retailer.  A  B CDEFGH Purchase 1 Orders 23 Supplier  item  Description  Item  Cost  Quantity  Cost per  Order  AP Terms  Months)   Order  No.  Order  Size  Rex  Graphics 4 Technologies  Card $8935 $3115 20 AL123  Large 5 Rex  Technologies  Monitor $15015$225025 AL234  Small 6 Rex  Technologies  Keyboard $1540$60015 AL345  Large 7 Rex  Technologies  Speakers $1520$30025 AL456  Small 8 Max’s  wavetech  HD Cables $510$5025 KO876  Small 9 Max’s  wavetech  Processor $27827$695030 KO765  Large 10 Max’s  wavetech  Hard disk $12018$216020 KO654  Small 1112\begin{array}{|l|l|l|l|l|l|l|l|l|}\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \\\hline &\text { Purchase } & & & \\1& \text { Orders } & & & \\\hline 2\\\hline 3 & \text { Supplier } & \begin{array}{l}\text { item }\\\text { Description }\\\end{array} & \begin{array}{l}\text { Item } \\\text { Cost }\end{array} & \text { Quantity } & \begin{array}{l}\text { Cost per } \\\text { Order }\end{array} & \begin{array}{l}\text { AP Terms } \\\text { Months) }\end{array} & \begin{array}{l}\text { Order } \\\text { No. }\end{array} & \begin{array}{l}\text { Order } \\\text { Size }\end{array} \\\hline & \text { Rex } & \text { Graphics } & & & & & \\4&\text { Technologies } & \text { Card } & \$ 89 & 35 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \\\hline5 & \begin{array}{l}\text { Rex } \\\text { Technologies }\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \\\hline6 & \begin{array}{l}\text { Rex } \\\text { Technologies }\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \\\hline7 & \begin{array}{l}\text { Rex } \\\text { Technologies }\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \\\hline8 & \begin{array}{l}\text { Max's } \\\text { wavetech }\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \\\hline9 & \begin{array}{l}\text { Max's } \\\text { wavetech }\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\\\hline10 & \begin{array}{l}\text { Max's } \\\text { wavetech }\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\\\hline 11\\\hline12\\\hline\end{array}
-The easiest way to locate a particular function is to select a cell and click on the Insert function button represented by on the Excel ribbon.

Recognize the impact of motivation, stereotypes, and emotional intelligence on performance and creativity.
Understand the requirements and characteristics of a well-designed intelligence test, including standardization, reliability, and validity.
Gain insight into the historical context and evolution of intelligence testing methods.
Acknowledge the diverse spectrums of intelligence, including extreme conditions like savant syndrome and intellectual disability.

Definitions:

Depreciation

Allocation of the cost of an asset over its useful life, recognizing the reduction in value due to wear and use.

Bid Price

The price at which a buyer is willing to purchase a security, currency, or commodity.

Discount Rate

It’s the interest rate applied for determining the current value of cash flows expected in the future through discounted cash flow analysis.

Depreciation Tax Shield

A reduction in taxable income that results from taking the depreciation expense as a tax deduction, thus reducing the firm's tax liability.

Related Questions