IETEET Complete all Questions in Excel 1. The shoe Buyer for a major departmental store has attained a profit of 8% for this year, she was able to maintain a 48% gross margin of $158,000. Complete a skeletal P&L for the shoe department that depicts both dollar and percentages for net sales, cost of goods sold, gross margin, operating expenses and profit. 2. For Valentine's Day, a jewelry buyer wishes to run a special $ 199 promotion on several different ruby and diamond items. The group consist of 114 pieces that cost: ' 45 pieces at $85.00 each 25 pieces at $101.00 each 44 pieces at $ 75.00 each . . Create a table that depicts the $ cost, Sretail, and markup% on each item as well as the $ cost, Sretail, and markup% for the group