We learned how to create Pivot Tables, Calculations, and Slicers. Using the data below: Part A - Create a Pivot table that shows in aggregate form the Product, Average Number of Units sold (0 decimals), Total Sales (2 decimals), and % of Total Sales (1 decimal). Insert a Timeline by Months. Part B - Create a Pivot table that shows in aggregate form the Products in the rows, the Locations in the Columns, and the Number of Transactions (not Units) for each. (0 decimals) Group the Products eye liner and mascara and rename it "eye products" and Group the Products lip gloss and lipstick and rename it "lip products". Tum off all Subtotals (see Design menu). Part C - Create a Pivot table that shows in aggregate form the Salesperson in the rows, the Location in the Columns, and the Average Total Sales (2 decimals) for each. Then create a Pivot Chart in the form of a Line Chart with Markers making the x axis Products and they axis Average Total Sales with a Line for each Location. The y axis should show a minimum of $120 and a maximum of $220 in $5 increments. HINT-You will need to change the format of the y-axis. Part D - Create a Pivot table that shows Total Units (0 decimals) by Location, and Product. Insert two Slicers so the Pivot Table can be filtered by Salesperson and Product. Part E - Create a Pivot table that shows in aggregate form the Salesperson, Total Sales (0 decimals), and Sales per Unit (2 decimals). HINT-You will need to create a calculated field. Trans Numbe 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Salespersor Betsy Hallagan Ashley Hallagan Zaret Colleen Cristina Colleen Ashley Betsy Ashley Ashley Emilee Hallagan Zaret Emilee Colleen Jen Jen Zaret Zaret Betsy Colleen Emilee Jen Cristina Cristina Cici Zaret Cici Hallagan Emilee Emilee Betsy Colleen Emilee Ashley Zaret Emilee Betsy Zaret Zaret Location south midwest midwest west midwest midwest midwest midwest south east east west west south east east south midwest south midwest west midwest midwest west midwest midwest midwest west west west south south midwest west midwest east east west south west west midwest Date ▾ Product 4/1/04 lip gloss 3/10/04 foundation 2/25/05 lipstick 5/22/06 lip gloss 6/17/04 lip gloss 11/27/05 eye liner 3/21/04 eye liner 12/17/06 lip gloss 7/5/06 eye liner 8/7/06 lip gloss 11/29/04 mascara 11/18/04 lip gloss 8/31/05 lip gloss 1/1/05 eye liner 9/20/06 foundation 4/12/04 mascara 4/30/06 mascara 8/31/05 lip gloss 10/27/04 eye liner 11/27/05 lip gloss 6/2/06 mascara 9/24/04 eye liner 2/1/06 mascara 12/6/06 lip gloss 4/12/04 lipstick 9/22/05 foundation 3/28/06 lip gloss 6/17/04 mascara 9/9/06 mascara 2/23/06 foundation 6/24/06 foundation 2/6/04 eye liner 4/10/05 mascara 4/1/04 foundation 6/6/04 lip gloss 9/20/06 lip gloss 8/9/05 mascara 9/24/04 eye liner 5/24/05 eye liner 11/18/04 foundation 11/18/04 lip gloss 6/15/05 eye liner Units 50 55 14 60 48 63 13 77 80 29 48 28 54 23 -3 50 71 93 83 62 17 33 30 29 43 82 58 46 24 -4 43 30 24 91 60 7 98 19 42 68 6 29 Dollars $164.64 $182.41 $34.46 $236.48 $156.72 $211.19 $30.96 $297.41 $271.97 $88.20 $157.01 $85.24 $179.51 $187.76 -$26.39 $284.87 $359.58 $438.23 $283.38 $207.74 $45.70 $103.81 $92.77 $89.54 $139.19 $279.66 $193.75 $150.32 $70.98 -$29.56 $138.70 $91.87 $71.26 $311.83 $200.54 $9.42 $336.83 $52.72 $135.64 $228.84 $6.72 $88.32 0

Hi, I need help determining the answer to this Operations Management problem. Thanks!

Answer part a only

A shop is planning an order for a popular Christmas festive season product. Demand for the product usually starts from first week of December till first week of January and reduces sharply thereafter. For this reason, and to stimulate sales for leftovers, the product is sold at a significantly reduced price from the second week of January to the fourth week of January. Any leftover after the fourth week of January goes waste. The table below gives past data on total demand for the period from first week of December to first week of January, and from second week of January to fourth week of January, together with their respective chances of occurrence. The product can be purchased at a wholesale price of GHS60 per unit for a pack containing 600 products, GHS57 per unit for a pack containing 800 products, and GHS52 per unit for a pack containing 1000 products. The shop plans to sell the product for GHS80 per unit from first week of December to first week of January, and at a reduced…

Formulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns. Find the requested quantities using the appropriate matrix arithmetic. A car dealer sells sedans, station wagons, vans, and pickup trucks at sales lots in Oakdale and Roanoke. The "dealer markup" is the difference between the sticker price and the dealer invoice price. The dealer invoice prices at both locations are the same: $15,000 per sedan, $19,000 per wagon, $24,000 per van, and $26,000 per pickup. The sticker prices at the Oakdale lot are $18,900 per sedan, $23,900 per wagon, $28,900 per van, and $28,900 per pickup, while at the Roanoke lot the sticker prices are $17,900 per sedan, $22,900 per wagon, $26,900 per van, and $30,900 per pickup. Represent these prices as a dealer invoice matrix D and a sticker price matrix S. Use these matrices to find the dealer markup matrix M for these vehicles at these sales lots. (Let row 1 represent the dealer in Oakdale and row 2 represent the…

please help me with Question 3 thanks! Demand forecasts for 2021 are as follows: Month Demand Jan 140,000 Feb 78,900 Mar 85,800 Apr 89,100 May 123,600 Jun 136,350 Jul 120,450 Aug 106,950 Sep 121,950 Oct 135,750 Nov 87,000 Dec 93,300 Each worker can produce 900 products per month and is paid $1500 per month. Assume that at the end of last year, the company has 100 employees working on the production line. Hiring and layoff (firing) decisions are made at the beginning of each month, and associated costs are charged at that time. It costs the company $400 to hire and $800 to lay off a worker. The company incurs holding cost for the amount of ending inventory in each month, and incurs backorder cost at the end of each month for any unfilled orders. The company incurs $2 per month for holding one unit in inventory and $4 per unit backorder. 1 Prepare a level aggregate plan. Under this level aggregate plan, how…

Please solve very soon completely work

b6  need urgent in 15 minutes

I need answer typing clear urjent no chatgpt used i will give upvotes

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.