Since You can't interact directly with Excel or the data I have, please guide me through the steps and calculations I need to perform. This means you don't need to solve for a number answer, just help explain with words how I can solve for it: 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: the photo is just an example of the data on excel. No need to use those numbers as it's just for visual reference onthe type of data available.

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