Inventory Turnover and days’ sales in inventory
Kroger, Sprouts Farmers Market, Inc., and Whole Foods Markets, Inc. are three grocery chains in the United States. Inventory management is an important aspect of the grocery retail business. Recent balance sheets for these three companies indicated the following merchandise inventory (in millions) information:
Kroger | Sprouts | Whole Foods | |
Cost of merchandise sold | $85,512 | $2,541 | $9,973 |
Inventory, end of year | 5,688 | 165 | 500 |
Inventory, beginning of year | 5,651 | 143 | 441 |
a. & b. Determine the inventory turnover and the number of days’ sales in inventory (use 365 days and round to one decimal place) for the three companies. Round all interim calculations to one decimal place. For days' sales in inventory, round final answers to the nearest day, and for inventory turnover, round to two decimal places.
Company names | Inventory Turnover | Days' Sales in Inventory |
Kroger | days | |
Sprouts | days | |
Whole Foods | days |
c. The inventory turnover ratios and days’ sales in inventory are similar for Kroger and Sprouts. Whole Foods has a higher inventory turnover and a lower days’ sales in inventory than Kroger and Sprouts. These results suggest that Kroger and Sprouts are less efficient than Whole Foods in managing inventory.
d. If Kroger had Whole Foods’ days’ sales in
inventory, how much additional cash flow would have been generated
from the smaller inventory relative to its actual average inventory
position? Round interim calculations to one decimal place and your
final answer to the nearest million.
$ million
In: Accounting
Russell Company is a pesticide manufacturer. Its sales declined greatly this year due to the passage of legislation outlawing the sale of several of Russell’s chemical pesticides. In the coming year, Russell will have environmentally safe and competitive chemicals to replace these discontinued products. Sales in the next year are expected to greatly exceed any prior years. The decline in sales and profits appears to be a one-year aberration. Even so, the company president fears a large dip in the current year’s profits. He believes that such a dip could cause a significant drop in the market price of Russell’s stock and make the company a takeover target.
To avoid this possibility, the company president calls in Zoe Baas, controller, to discuss this period’s year-end adjusting entries. He urges her to accrue every possible revenue and to defer as many expenses as possible. He says to Zoe, “We need the revenues this year, and next year can easily absorb expenses deferred from this year. We can’t let our stock price be hammered down!” Zoe didn’t get around to recording the adjusting entries until January 17, but she dated the entries December 31 as if they were recorded then. Zoe also made every effort to comply with the president’s request.
In: Accounting
The following selected accounts and their current balances
appear in the ledger of Kanpur Co. for the fiscal year ended June
30, 2019:
Please let me know the answer of Note payable (current portion) and
Note payable (final payment due 2032) using below information.
Cash | $92,000 | Gerri Faber, Drawing | $300,000 | |
Accounts Receivable | 450,000 | Sales | 8,925,000 | |
Merchandise Inventory | 370,000 | Cost of Merchandise Sold | 5,620,000 | |
Estimated Returns Inventory | 5,000 | Sales Salaries Expense | 850,000 | |
Office Supplies | 10,000 | Advertising Expense | 420,000 | |
Prepaid Insurance | 12,000 | Depreciation Expense—Store Equipment | 33,000 | |
Office Equipment | 220,000 | Miscellaneous Selling Expense | 18,000 | |
Accumulated Depreciation—Office Equipment | 58,000 | Office Salaries Expense | 540,000 | |
Store Equipment | 650,000 | Rent Expense | 48,000 | |
Accumulated Depreciation—Store Equipment | 87,500 | Insurance Expense | 24,000 | |
Accounts Payable | 38,500 | Depreciation Expense—Office Equipment | 10,000 | |
Customer Refunds Payable | 10,000 | Office Supplies Expense | 4,000 | |
Salaries Payable | 4,000 | Miscellaneous Administrative Exp. | 6,000 | |
Note Payable (final payment due 2032) | 140,000 | Interest Expense | 12,000 | |
Gerri Faber, Capital | 431,000 |
KANPUR CO. Balance Sheet June 30, 2019 |
||||||
---|---|---|---|---|---|---|
Assets | Liabilities | |||||
Current assets: | Current liabilities: | |||||
Cash | Accounts payable | |||||
Accounts receivable | Customer refunds payable | |||||
Merchandise inventory | Salaries payable | |||||
Estimated returns inventory | Note payable (current portion) | |||||
Office supplies | Total current liabilities | |||||
Prepaid insurance | Long-term liabilities: | |||||
Total current assets | Note payable (final payment due 2032) | |||||
Property, plant, and equipment: | Total liabilities | |||||
Office equipment | ||||||
Less accumulated depreciation-Office equipment | Owner's equity | |||||
Store equipment | Gerri Faber, capital | |||||
Less accumulated depreciation-Store equipment | ||||||
Total property, plant, and equipment | ||||||
Total assets | Total liabilities and owner's equity |
In: Accounting
Andretti Company has a single product called a Dak. The company normally produces and sells 124,000 Daks each year at a selling price of $44 per unit. The company’s unit costs at this level of activity are given below:
Direct materials | $ | 9.50 | |
Direct labor | 9.00 | ||
Variable manufacturing overhead | 2.40 | ||
Fixed manufacturing overhead | 4.00 | ($496,000 total) | |
Variable selling expenses | 1.70 | ||
Fixed selling expenses | 4.50 | ($558,000 total) | |
Total cost per unit | $ | 31.10 | |
A number of questions relating to the production and sale of Daks follow. Each question is independent.
Required:
1. The company has 400 Daks on hand that have some irregularities and are therefore considered to be "seconds." Due to the irregularities, it will be impossible to sell these units at the normal price through regular distribution channels. What is the unit cost figure that is relevant for setting a minimum selling price?
2. Due to a strike in its supplier’s plant, Andretti Company is unable to purchase more material for the production of Daks. The strike is expected to last for two months. Andretti Company has enough material on hand to operate at 25% of normal levels for the two-month period. As an alternative, Andretti could close its plant down entirely for the two months. If the plant were closed, fixed manufacturing overhead costs would continue at 30% of their normal level during the two-month period and the fixed selling expenses would be reduced by 20% during the two-month period.
a. How much total contribution margin will Andretti forgo if it closes the plant for two months?
b. How much total fixed cost will the company avoid if it closes the plant for two months?
3. An outside manufacturer has offered to produce 124,000 Daks and ship them directly to Andretti’s customers. If Andretti Company accepts this offer, the facilities that it uses to produce Daks would be idle; however, fixed manufacturing overhead costs would be reduced by 30%. Because the outside manufacturer would pay for all shipping costs, the variable selling expenses would be only two-thirds of their present amount. What is Andretti’s avoidable cost per unit that it should compare to the price quoted by the outside manufacturer?
In: Accounting
Laraia Corporation has provided the following contribution
format income statement. All questions concern situations that are
within the relevant range.
Sales (3,000 units) $150,000
Variable expenses 90,000
Contribution margin 60,000
Fixed expenses 48,000
Net operating income $12,000
Required:
a. What is the contribution margin per unit?
b. What is the contribution margin ratio?
c. What is the variable expense ratio?
d. If sales increase to 3,050 units, what would be the estimated
increase in net operating income?
e. If sales decline to 2,900 units, what would be the estimated net
operating income?
f. If the selling price increases by $4 per unit and the sales
volume decreases by 200 units, what would be the estimated net
operating income?
g. If the variable cost per unit increases by $5, spending on
advertising increases by $3,000, and unit sales increase by 450
units, what would be the estimated net operating income?
h. What is the break-even point in unit sales?
i. What is the break-even point in dollar sales?
j. Estimate how many units must be sold to achieve a target profit
of $54,000.
k. What is the margin of safety in dollars?
l. What is the margin of safety percentage?
m. What is the degree of operating leverage?
n. Using the degree of operating leverage, what is the estimated
percent increase in net operating income of a 15% increase in
sales?
In: Accounting
Starr Company decides to establish a fund that it will use 5
years from now to replace an aging production facility. The company
will make a $97,000 initial contribution to the fund and plans to
make quarterly contributions of $48,000 beginning in three months.
The fund earns 8%, compounded quarterly. (PV of $1, FV of $1, PVA
of $1, and FVA of $1) (Use appropriate factor(s) from the
tables provided. Round your "Table Factor" to 4 decimal places and
final answer to the nearest whole dollar.)
What will be the value of the fund 5 years from now?
|
In: Accounting
You are a member of Arrow Company’s internal audit staff. A
review of office practices indicates that an accounting assistant
routinely makes arrangements with the bank for short-term notes
payable and signs the notes.
Evaluate this practice. Would you recommend any
changes?
In: Accounting
Lackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college’s comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar’s Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended.
Department |
Annual Cost |
||
Admissions |
$ |
118,000 |
|
Registrar |
197,000 |
||
Computer Services |
420,000 |
||
Division |
Budgeted Enrollment |
Budgeted Credit Hours |
Planned Courses Requiring Computer Work |
||||||
Liberal Arts |
1,100 |
31,000 |
12 |
||||||
Sciences |
850 |
28,750 |
25 |
||||||
Business Administration |
750 |
22,750 |
25 |
||||||
Required:
|
|
In: Accounting
The following information relates to RED Co's postretirement health care benefits for the year 2019:
Defined post-retirement benefit obligation at January 1, 2019: $100,000
Plan assets, January 1, 2019: 50,000
Actual return on plan assets, 2019: 5,000
Service cost, 2019: 60,000
Plan funding during 2019: 20,000
Payments from plan to retirees during 2019: 8,000
Actuarial loss on defined post-retirement benefit obligation-2019 (end of year): 30,000
ABC Inc. follows IFRS. Discount rate is 10%
(a) Calculate the post-retirement benefit expense for 2019.
(b) Calculate the post-retirement benefit remeasurement gain or loss- other comprehensive income (OCI) for 2019.
(c) Determine the December 31, 2019 balance of the plan assets, the defined post-retirement benefit obligation, and the plan surplus or deficit.
(d) Determine the balance of the net post-retirement benefit liability/asset account on the December 31, 2019statement of financial position.
(e) Reconcile the plan surplus or deficit with the amount reported on the statement of financial position at December 31, 2019.
In: Accounting
The quality of a company's earnings and sustainable income are both important to analysts and investors. Examine the difference between the quality of earnings for a company and sustainable income. Discuss the relevancy of pro forma statements to sustainable income and quality of earnings. As an investor assume you can select information related to either quality of earnings or sustainable income prior to making a decision to invest in a company. Identify your selection and support your response with an example.
In: Accounting
Sharp Company manufactures a product for which the following standards have been set: |
Standard Quantity |
Standard Price |
Standard |
||||||
Direct materials |
3 |
feet |
$ |
5 |
per foot |
$ |
15 |
|
Direct labor |
? |
hours |
? |
per hour |
? |
|||
During March, the company purchased direct materials at a cost of $59,040, all of which were used in the production of 3,000 units of product. In addition, 4,600 hours of direct labor time were worked on the product during the month. The cost of this labor time was $34,500. The following variances have been computed for the month: |
Materials quantity variance |
$ |
4,200 |
U |
||
Labor spending variance |
$ |
3,900 |
U |
||
Labor efficiency variance |
$ |
680 |
U |
||
1. |
For direct materials: |
||||
a. |
Compute the actual cost per foot for materials for March. (Round your answer to 2 decimal places.) |
|||
b. |
Compute the price variance and the spending variance. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)) |
|||
2. |
For direct labor: (Do not round intermediate calculations.) |
|||
a. |
Compute the standard direct labor rate per hour. (Round your final answer to 2 decimal places.) |
b. |
Compute the standard hours allowed for the month’s production. |
c. |
Compute the standard hours allowed per unit of product. (Round your answer to 1 decimal place.) |
In: Accounting
(show Work and calculations)
X Company had 200,000 shares of $10 par value common stock outstanding during fiscal 2018 along with 10,000 shares of 8%, cumulative, $100 par value preferred stock four years in arrears, with each share convertible into five shares of common stock. X’s fiscal 2018 net income was $800,000 and reflects an income tax rate of 40%.
Required—Prepare in good form the fiscal 2018 EPS presentation for X Company
In: Accounting
Consolidated Pasta is currently expected to pay annual dividends of $10 a share in perpetuity on the 2.9 million shares that are outstanding. Shareholders require a rate of return of 10% from Consolidated stock.
a. What is the price of Consolidated stock? (Do not round intermediate calculations.)
b. What is the total market value of its equity? (Enter your answer in millions.)
Consolidated now decides to increase next year’s dividend to $20 a share, without changing its investment or borrowing plans. Thereafter the company will revert to its policy of distributing $10 million a year.
c. How much new equity capital will the company need to raise to finance the extra dividend payment? (Enter your answer in millions.)
d. What will be the total present value of dividends paid each year on the new shares that the company will need to issue? (Enter your answer in millions.)
e. What will be the transfer of value from the old shareholders to the new shareholders? (Enter your answer in millions.)
f. Is this figure more than, less than, or the same as the extra dividend that the old shareholders will receive
In: Accounting
Amber Mining and Milling Inc., contracted with Traux Corporation to have constructed a custom-made lathe. the machine was completed and ready for use on January 1st 2016. Amber paid for the lathe by issuing a $600,000 3 year note that specified 4% interest payable annually on December 31st of each year. the cash market price of the lathe was unknown. it was determined by comparison with similar transactions they 12% was a reasonable rate of interest
1. prepare the journal entry on January 1st 2016 for
Amber Mining and Milling purchase of the lathe.
2. prepare and amortization schedule for the three-year term of the
note.
3. prepare the journal entries to record interest for each of the
three years and payment of the note at maturity.
In: Accounting
Universal Foods issued 10% bonds, dated January one, with a face amount of 150 million dollars on January 1st 2016. do Bonds mature on December 31st 2030. the market rate of interest for similar issues with 12%. Interest is paid semi-annually on June 30th and December 31st. Universal uses the straight-line method.
1. determine the price of the bond. January 1,
2016.
2. prepare the journal entry to record the issuance by Universal
Foods on January 1st 2016
3. prepare the journal entry to record interest on June 30th
2016
4. prepare the journal entry to record interest on December 31st
2023
In: Accounting