Please download the Excel file provided in this question, co…

Please download the Excel file provided in this question, complete it, and upload the file after finishing the questions. The cells containing question instructions are colored in blue and protected from editing. The sections colored in orange are the cells where you can enter your answers. Exam 2 problems-1.xlsx

Find the Total Cost of Merchandise Sold (dollar) for a depar…

Find the Total Cost of Merchandise Sold (dollar) for a department with the following figures: Net Sales                                       $875,000 Gross Margin                                $466,700 MMU%                47.21%

Using the following figures, determine retail dollar for Pur…

Using the following figures, determine retail dollar for Purchases:                                  Opening Inventory             Purchases Retail                             $110, 000 Cost                                                                        $75,000                                      Markup %                      64.00%                            56..50%