Explore BrainMass

Explore BrainMass

    Inventory Valuation and Accounts Receivables

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    4. The Howard Swatch Company had 300 swatches in its July 1 inventory. The company uses periodic inventory system and made the following purchases of swatches during July and August.

    July 8 40 swatches for $20 each
    July 27 100 swatches for $21 each
    Aug 18 50 swatches for $22 each
    Aug 24 60 swatches for $23 each

    Sales during July and August were 200 and 150 swatches respectively. The FIFO, Average, and LIFO costs of the swatches in the July 1 inventory were $19, $18, and $13 respectively.
    Calculate the ending inventory, and cost of goods sold for each month if Howard uses the FIFO, Average, and LIFO cost flow assumption.

    In addition, which cost flow assumption provides the most realistic balance sheet amount for the ending inventory? Why? Which provided the most realistic measure of income? Why?

    5. The NO More Snow (NMS) Company sells one type of snow melting machine and uses a perpetual inventory method. The January 1st balance in its cash account was $2,100 and the inventory records indicated 8 snow melting machines costing $$150 each. During January NMS made the following purchases and sales of snow melting machines.

    January 5 purchase 5 units @ $165 each
    January 12 sales 11 units @ $225 each
    January 18 purchase 12 units @ $175 each
    January 25 purchase 6 units @ $170 each
    January 29 sales 13 units @ $235 each

    All purchases were made on credit and one-half of the sales were on credit. No collections of accounts receivable were made during the month. Sales from January 12 were 8 units from the beginning inventory and 3 units from the January 5th purchase. The January 29th sales were comprised of 9 units from the January 18th purchase and 4 from the January 25th purchase.

    a. A physical count after the January 29th sale indicated 8 snow melting machines on hand. Does this agree with the information given above? If there is a difference between the accounting system (from the information given above) indicate two possible reasons for the discrepancy.
    b. Compute the NMS gross profit for the month of January.
    c. What is the balance in NMS cash account and accounts receivable at the end of January? Please explain how the cash balance can be different from the sales total.

    © BrainMass Inc. brainmass.com November 29, 2021, 11:50 pm ad1c9bdddf
    https://brainmass.com/business/inventory/inventory-valuation-accounts-receivables-5352

    Attachments

    Solution Preview

    Answer in the file attached
    4. The Howard Swatch Company had 300 swatches in its July 1 inventory. The company uses periodic inventory system and made the following purchases of swatches during July and August.

    8-Jul 40 swatches for $20 each
    27-Jul 100 swatches for $21 each
    18-Aug 50 swatches for $22 each
    24-Aug 60 swatches for $23 each

    Sales during July and August were 200 and 150 swatches respectively. The FIFO, Average, and LIFO costs of the swatches in the July 1 inventory were $19, $18, and $13 respectively.

    Calculate the ending inventory, and cost of goods sold for each month if Howard uses the FIFO, Average, and LIFO cost flow assumption.

    Shown in tables below

    In addition, which cost flow assumption provides the most realistic balance sheet amount for the ending inventory? Why? Which provided the most realistic measure of income? Why?

    FIFO provides the best method for ending inventory.
    In most of the cases the operating managers practise this. This avoids spoilage
    and obsolensce.Thus accounting treatment follows what is actually done in factories.
    LIFO provides the most realistic measure of income.
    This is because inventory is valued at its most recent cost.

    FIFO

    Cost of Sales

    Date Description Beginning inventory Purchase Sale Ending inventory Per Unit Cost Beginning inventory Purchase Cost of Sale Ending inventory (value)
    Beginning Inventory 300 300 $19.00 $5,700 $0 $0 $5,700
    8-Jul Purchase 300 40 340 $20.00 $5,700 $800 $0 $6,500
    27-Jul Purchase 340 100 440 $21.00 $6,500 $2,100 $0 $8,600
    July Sales 440 200 240 n/a $8,600 $0 $3,800 $4,800 Cost of sale= 200X 19
    18-Aug Purchase ...

    Solution Summary

    The solution provides answers to 2 question- one on inventory valuation, the other on accounts receivables.

    $2.49

    ADVERTISEMENT