Using the Spreadsheet Below, Provide the Steps in Using Excel

question 30

Essay

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. $\begin{array}{|l|l|l|l|l|l|}\hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & \text { Purchase Orders } & & & & \\\hline2\\\hline 3 & \text { Supplier } & \text { Item No. } & \text { Item Cost } & \text { Quantity } & \text { Cost per Order } \\\hline 4 & \text { Rex Technologies } & 1123 & \$ 89 & 35 & \$ 3115 \\\hline 5 & \text { Rex Technologies } & 1234 & \$ 150 & 15 & \$ 2250 \\\hline 6 & \text { Rex Technologies } & 1345 & \$ 15 & 40 & \$ 600 \\\hline 7 & \text { Rex Technologies } & 1345 & \$ 15 & 20 & \$ 300 \\\hline 8 & \text { Max's Wavetech } & 1345 & \$ 5 & 10 & \$ 50 \\\hline 9 & \text { MMax's Wavetech } & 1765 & \$ 278 & 27 & \$ 6950 \\\hline 10 & \text { Max's Wavetech } & 1654 & \$ 120 & 18 & \$ 2160 \\\hline 11 & \text { Rex Technologies } & 1765 & \$ 54 & 56 & \$ 3024 \\\hline 12 & \text { Rex Technologies } & 1100 & \$ 71 & 33 & \$ 2343 \\\hline 13 & \text { Rex Technologies } & 1100 & \$ 10 & 14 & \$ 140 \\\hline 14 & \text { Rex Technologies } & 1683 & \$ 7 & 25 & \$ 175 \\\hline 15 & \text { IMax's Wavetech } & 1683 & \$ 100 & 31 & \$ 3100 \\\hline\end{array}$

---

Definitions:

Departmental Factory Overhead Rate

A rate used to allocate indirect manufacturing costs to different departments within a factory.

Direct Labor Hours

The total time workers spend producing goods or providing services that can be directly attributed to a specific product or service.

Cutting and Sewing

The process involved in the making of garments, which includes the cutting of fabric according to patterns and sewing them together to create clothing.

Activity-based Costing

A method of accounting that assigns costs to specific activities based on their use of resources, providing more accurate product costing.