Find $($a$)$ estimated physical inventory and $($b$)$ actual shortage or overage percent when closing physical inventory is $$77,227.$

Opening Inventory $$159,760$

Net Purchases $$297,420$

Net Transfers Out $$1,370$

Gross Sales $$358,110$

Customer Returns $$23,428$

Net Markdowns $$38,743$

Employee Discounts $$1,817$

Estimated Shortage $0\mathrm{.}90\%$

Please use excel formulas