Provide Instructions on how to solve for the total direct material used $($in dollars$)$ for shoes given this set of data and background information on Excel. Use Formulas to calculate new columns and then Pivot Tables on Excel to solve.

Background Information: The Fashionable Leather Company manufactures two product lines $($ shoes and jackets $)$and operates in four regions $($ North $,$South$,$ East, and West $).$The company buys direct materials and supplies only after receiving orders from customers, and therefore does not hold a material amount of inventory. The CFO asked you to analyze the company's performance for the year across a number of dimensions including by region, by product line, and by manufacturing cost. The raw job costing data was exported into Excel from the company's accounting system $($ the data is saved in the Data worksheet $).$

The Data worksheet contains the raw job costing data from the company's accounting system. Each row of the data table corresponds to one job. Each job can include orders for multiple quantities of a given product. A more detailed

description of the data is included in the Additional Instructions tab.

How Data is Provided on Excel:

Description of Data:

Explain how to find the total direct material used $($in dollars$)$ for shoes in Excel.