You do not need to show Excel formulas in Textboxes for this template calculate the value of the inventory using the following methods Beginning Inventory 100 units @ $1 Purchased 50 units Jn January...

Sheet1
                                                Template # 9
                                                SPRING 2019
    You do not need to show Excel formulas in Textboxes for this template
    calculate the value of the inventory using the following methods
    Beginning Inventory                100 units @ $1
    Purchased 50 units Jn January at $1.50
    Purchased 40 units in February $2.00
    Purchased 60 units in March @$2.50
    Sold 150 units
    Weighted Average                            SHOW CALCULATIONS HERE
    Ending inventory    100 units    $ 162                    Particulars    Units    $ Unit price    Total cost
                                Beg.Inventory    100    $ 1    $...