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 manufacturing Overhead applied $($in dollars$)$ given this set of data and background information on Excel. Explain how to 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.

The budgeted manufacturing overhead rate is $25\%$ of direct materials dollars. $($Hint: A job that incurs $$100$ of direct materials will be allocated $$25$ of manufacturing overhead.$)$ You can check with this information that the total manufacturing Overhead applied in the North region was $$596,209.$ What is the total manufacturing Overhead applied $($in dollars$).$ Explain how to find in Excel.