Question

In: Accounting

10 The following data are obtained from DK Stores Inc.’s financial records: 2021 Cost Retail Beginning...

10

The following data are obtained from DK Stores Inc.’s financial records:

2021

Cost

Retail

Beginning Inventory

$75,600

$126,000

Purchases

176,000

244,000

Purchases discount

1,130

Net markups

9,500

Net markdowns

10,625

Normal spoilage

1,200

Sales to customers

215,000

Sales to employees (after 40% employee discounts)

9,705

Price index

1.05

Price indices are based on January 1, 2021 which is the base year.

Suppose DK uses the average cost retail inventory method to account for its inventory. What is the current period cost-to-retail % (rounded to the nearest 0.1%)?

Solutions

Expert Solution

DK Stores Inc.,
Cost Retail
Beginning Inventory $75,600 $126,000
Purchases $176,000 $244,000
Purchases discount ($1,130)
Net Markups $9,500
Net Markdowns ($10,625)
Total $250,470 $368,875
Cost to Retail % = (Cost/Retail Price) * 100
Cost $250,470
Retail $368,875
Cost/Retail % 67.90%
Computation of Ending Inventory at Retail
Total Retail Value $368,875
Normal spoilage ($1,200)
Sales to Customers ($215,000)
Sales to Employees ($16,175)
Ending Inventory at retail $136,500
Ending Inventory at retail at current price $136,500
Price index            1.05
Ending Inventory at retail at base price $130,000
Computation of Ending Inventory at Cost
Ending Inventory at retail at
base price
$130,000
Cost/Retail % 67.90%
Ending Inventory at cost $88,270

Related Solutions

The data shown were obtained from the financial records of Italian Exports, Inc., for March:
The data shown were obtained from the financial records of Italian Exports, Inc., for March:Estimated Sales$590,000Sales567,925Purchases294,831Ending Inventory*10%Administrative Salaries50,320Marketing Expense**5%Sales Commissions2%Rent Expense7,300Depreciation Expense900Utilities2,700Taxes***15%*of next month's sales**of estimated sales***of income before taxesSales are expected to increase each month by 10%.Prepare a budgeted income statement. Round your answers to the nearest dollar.Italian Exports, Inc.Budgeted Income StatementFor the Month Ending Mar. 31, 2020Sales$Cost of Goods SoldBeginning Inventory$PurchasesCost of Goods Available for Sale$Ending InventoryCost of Goods Sold$Gross ProfitOperating ExpensesAdministrative Salaries$Marketing ExpensesSales CommissionsRent ExpenseDepreciation ExpenseUtilitiesTotal Operating...
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Estimated...
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Estimated Sales $580,000 Sales 567,926 Purchases 294,819 Ending Inventory* 10% Administrative Salaries 50,320 Marketing Expense** 5% Sales Commissions 2% Rent Expense 7,700 Depreciation Expense 1,200 Utilities 2,300 Taxes*** 15% *of next month's sales **of estimated sales ***of income before taxes Sales are expected to increase each month by 10%. Prepare a budgeted income statement. Round your answers to the nearest dollar. Italian Exports, Inc. Budgeted...
The following information was obtained from the accounting records and financial statements of Palmer Inc. Assets...
The following information was obtained from the accounting records and financial statements of Palmer Inc. Assets 2019 2020 ∆ Cash $ 280,000 315,000 35,000 Accounts receivable 720,000 755,000 35,000 Inventory 855,000 800,000 (55,000) Capital assets 1,720,000 1,930,000 210,000 Accumulated depreciation (580,000) (550,000) 30,000 Net capital assets 1,140,000 1,380,000 240,000 Total 2,995,000 3,250,000 Liabilities and Stockholders’ equity Accounts payable 445,000 360,000 (85,000) Interest payable 60,000 75,000 15,000 Income taxes payable 40,000 50,000 10,000 Bonds payable 800,000 900,000 100,000 Common stocks 1,200,000...
The following information was obtained from the accounting records and financial statements of Fairbanks Inc. Assets...
The following information was obtained from the accounting records and financial statements of Fairbanks Inc. Assets 2019 2020 ∆ Cash $ 662,000 781,000 119,000 Accounts receivable 524,000 707,000 183,000 Raw materials inventory 404,000 521,000 117,000 Finished goods inventory 1,212,000 1,190,000 (22,000) Land 1,200,000 1,000,000 (200,000) Machinery and equipment 3,330,000 3,511,000 181,000 Accumulated depreciation (1,555,000) (1,725,000) (170,000) Net capital assets 1,775,000 1,786,000 11,000 Total 5,777,000 5,985,000 Liabilities and Stockholders’ equity Accounts payable 888,000 961,000 73,000 Wages payable 122,000 107,000 (15,000) Long-term...
The following information was obtained from the accounting records and financial statements of Kenai Inc. Assets...
The following information was obtained from the accounting records and financial statements of Kenai Inc. Assets 2019 2020 ∆ Cash $ 750,000 $ 685,000 (65,000) Accounts receivable 345,000 498,000 153,000 Inventory 250,000 378,000 128,000 Capital assets 1,456,000 2,354,000 898,000 Accumulated depreciation (128,000) (196,000) (68,000) Net capital assets 1,328,000 2,158,000 830,000 Total 2,673,000 3,719,000 Liabilities and Stockholders’ equity Accounts payable 463,000 168,000 (295,000) Salaries payable 367,000 456,000 89,000 Long-term debt 100,000 192,000 92,000 Common stocks 750,000 1,500,000 750,000 Retained earnings 993,000...
The following data concerning the retail inventory method are taken from the financial records of Blake...
The following data concerning the retail inventory method are taken from the financial records of Blake Company.                                                                                                   Cost                        Retail             Beginning inventory                                           $132,000              $ 220,000             Purchases                                                            362,500                 550,000             Freight-in                                                               16,000                       —             Net markups                                                               —                      45,000             Net markdowns                                                          —                      16,000             Sales                                                                          —                    625,000 a.) What is the ending inventory at retail?                         b.) If the ending inventory is to be valued at approximately the conventional retail inventory method, the calculation of the cost to retail...
The records of Lohse Stores included the following data: Inventory, May 1, at retail, $14,500; at...
The records of Lohse Stores included the following data: Inventory, May 1, at retail, $14,500; at cost, $10,440 Purchases during May, at retail, $42,900; at cost, $31,550 Freight-in, $2,000; purchase discounts, $250 Additional markups, $3,800; markup cancellations, $400; net markdowns, $1,300 Sales during May, $45,500 Calculate the estimated inventory at May 31 on a LIFO basis. Estimated inventory
The following information is obtained from Rapid Corporation’s financial records:
The following information is obtained from Rapid Corporation’s financial records:                                                             Units               Unit Cost                    Total Cost Jan. 1   Beginning inventory               100                     $10                          $ 1,000 Mar. 1 Purchased                                400                     $12                          $ 4,800 Mar. 5 Sold                                         (250)                  May 2 Purchased                                100                     $15                          $ 1,500 Aug. 1 Sold                                         (150) Oct. 3 Purchased                                100                     $25                         $ 2,500 Dec 31 Ending inventory                    300                       ?                                 ?             (Per physical count) Required:       Calculate the cost of the ending...
The following data concerning the retail inventory method are taken from the financial records of Blake Company.
The following data concerning the retail inventory method are taken from the financial records of Blake Company.                                          Cost                     Retail            Beginning inventory                                           $132,000              $ 220,000            Purchases                                                            362,500                 550,000            Freight-in                                                                16,000                       —            Net markups                                                              —                      45,000            Net markdowns                                                          —                      16,000            Sales                                                                          —                    625,0001. What is the ending inventory at retail?                       2. If the ending inventory is to be valued at approximately theconventional retail inventory method, the calculation of the cost to retail ratio should be based on goods available for sale...
The following data is obtained from the general records in the shipping department at Rapid Parcel...
The following data is obtained from the general records in the shipping department at Rapid Parcel Delivery Company for August: Inspecting packages prior to placement on truck takes 1 minute per package. Processing paperwork for each shipment (each truck loaded) takes 30 minutes. Loading packages takes 2 minutes of labor per package plus an additional 3 labor hours per truck Miscellaneous tasks take 2 hours per truck. Temporary employees to perform all of the above tasks can be hired for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT