Given the following data calculate:

A. closing book inventory

B. gross margin %

Complete your work using this file: Homework Question 1 Workbook (Excel). upload the completed file to this question for your answer. Screenshots not accepted.

Given the following data calculate: A. closing book inventory B. gross margin % A38 A. B. D E H Merchandise Handied cosT r Opennoveritory Grost Pinchates Retirns fo Vewoon Nerpechaces Hesteanster out Fregit Addhionalmany Totai Merchandise Handled Cost \% (TMH Cost/ TMH Retan "round 2 decimal placts tion Comess Sabs Cuntomer Peftums it isang 7 Net Mandowins: timploger Discoris: Totis Deductions Closing Book inventery at Retail " calculate with cest W, rounded to 2 decimul places Gross Cost of Merchendise 5 eld Gash dicours phetcost of merchandie oed Areaton coes Total Cost of Merchandise Sold Given the following data calculate: A. closing book inventory B. gross margin % A38 A. B. D E H Merchandise Handied cosT r Opennoveritory Grost Pinchates Retirns fo Vewoon Nerpechaces Hesteanster out Fregit Addhionalmany Totai Merchandise Handled Cost \% (TMH Cost/ TMH Retan "round 2 decimal placts tion Comess Sabs Cuntomer Peftums it isang 7 Net Mandowins: timploger Discoris: Totis Deductions Closing Book inventery at Retail " calculate with cest W, rounded to 2 decimul places Gross Cost of Merchendise 5 eld Gash dicours phetcost of merchandie oed Areaton coes Total Cost of Merchandise Sold