LIFO Perpetual Inventory

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.

3. Determine the ending inventory cost on June 30.
$

LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date    Transaction    Number of Units Per    Unit Total

Apr. 3    Inventory    84,    $225,    $18,900

8    Purchase 168, 270, 45,360

11 Sale 113,    750, 84,750

30 Sale 71,    750,    53,250

May 8    Purchase 140,    300,    42,000

10 Sale    84,    750,    63,000

19 Sale    42, 750, 31,500

28    Purchase    140,    330, 46,200

June 5    Sale 84,    790, 66,360

16 Sale 112,    790, 88,480

21 Purchase 252,    360, 90,720

28    Sale    126,    790, 99,540

Required: 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Dunne Co. Schedule of Cost of Merchandise Sold LIFO Method For the three-months ended June 30 Purchases Cost of Merchandise Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Apr. 3 $ $ Apr. 8 $ $ Apr. 11 $ $ Apr. 30 May 8 May 10 May 19 May 28 June 5 June 16 June 21 June 28 June 30 Balances $ $ 2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period. Total sales $ Total cost of merchandise sold Gross profit $ 3. Determine the ending inventory cost on June 30. $

LIFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows:

Required:

1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.

3. Determine the ending inventory cost as of June 30.
$

LIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 78 $525 $40,950 8 Purchase 156 630 98,280 11 Sale 105 1,750 183,750 30 Sale 66 1,750 115,500 May 8 Purchase 130 700 91,000 10 Sale 78 1,750 136,500 19 Sale 39 1,750 68,250 28 Purchase 130 770 100,100 June 5 Sale 78 1,840 143,520 16 Sale 104 1,840 191,360 21 Purchase 234 840 196,560 28 Sale 117 1,840 215,280 Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Dunne Co. Schedule of Cost of Goods Sold LIFO Method For the Three Months Ended June 30 Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Apr. 3 $ $ Apr. 8 $ $ Apr. 11 $ $ Apr. 30 May 8 May 10 May 19 May 28 June 5 June 16 June 21 June 28 June 30 Balances $ $ 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. Total sales $ Total cost of goods sold $ Gross profit from sales $ 3. Determine the ending inventory cost as of June 30. $

LIFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as follows:

Required:

1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.

3. Determine the ending inventory cost as of June 30.
$

LIFO Perpetual Inventory

The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are as follows:

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.

3. Determine the ending inventory cost on June 30, 2016.
$

LIFO Perpetual Inventory

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.

3. Determine the ending inventory cost on June 30.
$

LIFO Perpetual Inventory

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.

3. Determine the ending inventory cost on June 30.
$

COSTS AND REVENUES FOR URGENT CARE CENTER

COSTS: Urgent Care Center

All costs and revenues are per year

* Labor Cost

5 Primary Care Physicians                   Salary $150,000            $   750,000

8 RN/BSN Salary                                  Salary $ 64,000              $   512,000

Payroll Taxes (all employees)                                                    $   327,400

Benefits (all employees)                                                            $1,893,000

* Other Variable Costs

Supplies & Misc. Overhead                                                        $    102,400

Advertising                                                                                 $      35,000

      TOTAL VARIABLE COST        $3,619,800

* Capital Cost

Annualized Building Cost                                                           $    465,403

Annualized Equipment Cost                                                       $     93,081               

* Other Fixed Costs

Insurance                                                                                   $   341,295

Legal                                                                                          $   232,701

Administrative                                                                           $   418,873

Administrative Fee to Franchise                                                $   120,000

TOTAL FIXED COST                  $ 1,671,343

REVENUES: Urgent Care Center

Each for the five (5) primary care physicians can see 3200 patients in a year, at an average annual fee per patient of $300.

Question 1: Feasible Range for the Urgent Care Center

In order to justify our scale of operation we must be able to attract enough patients to be inside the feasible range of production. The feasible range is governed by the way productivity changes as more staff must share the fixed resources. Unfortunately it is rare for detailed information about productivity to be available to decision-makers. However because of the one-to-one correspondence between productivity and cost, we can see the boundaries of the feasible range reflected in our variable costs, and these costs are always available to decision makers on a detailed and up-to-date basis.

Step 1: Find Average Variable Cost by dividing the Total Variable Cost by the total number of patients served by all four physicians, given under Revenues.

Step 2: The fee per patient is also given under Revenues. Does the fee per patient cover the Average Variable Cost?

Question 2: Breaking Even for the Urgent Care Center

In the short run it is enough to establish that your scale of operation is justified, but in the long run we have to cover our capital costs as well as our labor and other variable costs.

Step 1: Find the Total Cost by summing the Total Variable Cost and Total Fixed Cost.

Step 2: Find the Average Total Cost by dividing Total Cost by the total number of patients served by four physicians.

Step 3: Does the fee per patient cover the Average Total Cost?

1. Carlos plans to start a new dry cleaning business. For that he purchased a space which costed him $100,000. For that he withdrew his savings worth $50,000 and borrowed the remaining $50,000 from a bank. His savings was earning him 3% interest per annum and the banks charges him 6% interest per annum. Based on this what would be Carlos opportunity cost of purchasing the space?

2. Which of the following statements is correct?

3. For a firm the Marginal Cost of producing 60th unit is $3.90 and the Average Total Cost of producing 59 units is $3.30. This would mean that

4. Brandon starts a new business for which he got loan from bank worth $200,000 charging him interest 6% per annum. Further he also used his savings worth $100,000 on which he was earning an interest of 2% per annum. Based on this information, Brandon explicit cost of capital would be

5. Sunny sells lemonade for $0.50 per cup. In a day he sold 300 cups. His total revenue for the day would be