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$).$ Instructions: This workbook contains $3$ worksheets: Cover Sheet, Additional Instructions, and Data. It is recommended that you add additional worksheets to perform your calculations, as necessary. However, only answers entered in the Cover Sheet will be graded. Points $55$ The Cover Sheet worksheet contains all of the questions as well as spaces for your answers. The cells on this worksheet are locked. You can only edit the gold colored cells. Column B lists the chapter that each question is most related to$.$ However, there is overlap in many of the chapters. Column C lists the point value for each question. Many questions include either a hint or a check number. Make sure that your calculations match the check numbers. The gold colored answer cells are restricted to accept only certain number formats. For example, the answer for question $4$ will only accept a whole number. If you try to enter $54\mathrm{.}5$ you will receive an error message. The Additional Instructions worksheet contains $1)$ a description of the dataset, $2)$ links to basic Excel video tutorials, and $3)$ additional instructions and hints on how to calculate and answer each of the questions. The majority of this project relies on using formulas to calculate new columns in a table of data and then using Pivot Tables to analyze the data. 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. It is recommended that you calculate additional columns in the Data worksheet, as needed, before creating your pivot tables. Question $1$: What is the total direct material used $($in dollars$)$ for shoes? Answer: Question $2$: What is the total direct labor used $($in dollars$)$ in the South region?