Equivalent Units and Product Cost Report—FIFO Method
In its first month's operations (January 2016), Allred Company's Department 1 incurred charges of $165,000 for direct materials (10,000 units), $70,000 for direct labor, and $84,700 for manufacturing overhead. At month-end, 8,800 units had been finished and transferred out. The remaining units were finished with respect to material but only 25% complete with respect to conversion costs.
Assuming Allred uses the FIFO method and that materials are added at the beginning of the process and conversion costs occur evenly, compute the following:
b. The cost per equivalent unit for material and conversion.
c. The total cost assigned to the units transferred out.
d. The total cost assigned to the ending inventory.
e. Prove that your solutions to requirements (c) and (d) sum to the total costs to be accounted for.
Product Cost Report | ||||||
---|---|---|---|---|---|---|
Direct Materials |
Conversion Costs |
|||||
Beginning Inventory | $ | $ | $ | |||
Current | ||||||
Total Costs to Account For | $ | $ | $ | |||
÷ Total Equivalent Units | ||||||
Average cost / Equivalent unit | $ | b. | $ | b. | ||
Beginning inventory | ||||||
Costs incurred in Month 0 | $ | |||||
Costs incurred in Month 1 | ||||||
Started and finished | ||||||
Cost of Goods Manufactured | $ | c. | ||||
Ending Inventory: | ||||||
Direct Materials | $ | |||||
Conversion costs | ||||||
Cost of Ending Inventory | $ | d. | ||||
Total Costs Allocated | $ | e. |
In: Accounting
M7-8 Calculating Cost of Goods Available for Sale, Cost of Goods Sold, and Ending Inventory under Periodic FIFO, LIFO, and Weighted Average Cost [LO 7-3]
In its first month of operations, Literacy for the Illiterate opened a new bookstore and bought merchandise in the following order: (1) 200 units at $7 on January 1, (2) 500 units at $8 on January 8, and (3) 800 units at $9 on January 29. Assume 975 units are on hand at the end of the month. |
Calculate the cost of goods available for sale, ending inventory, and cost of goods sold under the (a) FIFO, (b) LIFO, and (c) weighted average cost flow assumptions. Assume a periodic inventory system is used |
In: Accounting
Mullet Technologies is considering whether or not to refund a $75 million, 15% coupon, 30-year bond issue that was sold 5 years ago. It is amortizing $9 million of flotation costs on the 15% bonds over the issue's 30-year life. Mullet's investment banks have indicated that the company could sell a new 25-year issue at an interest rate of 9% in today's market. Neither they nor Mullet's management anticipate that interest rates will fall below 9% any time soon, but there is a chance that rates will increase.
A call premium of 7% would be required to retire the old bonds, and flotation costs on the new issue would amount to $7 million. Mullet's marginal federal-plus-state tax rate is 40%. The new bonds would be issued 1 month before the old bonds are called, with the proceeds being invested in short-term government securities returning 4% annually during the interim period.
Conduct a complete bond refunding analysis. What is the bond refunding's NPV? Do not round intermediate calculations. Round your answer to the nearest cent
$ _____
What factors would influence Mullet's decision to refund now rather than later? (100 words or 4 bullet points)
_____________________________________________________________
______________________________________________________________
______________________________________________________________
In: Accounting
Streeterville Foods, Inc., has recently purchased a small mill that it intends to operate as one of its subsidiaries. The newly acquired mill has three products that it offers for sale—wheat cereal, pancake mix, and flour. Each product sells for $10 per package. Materials, labor, and other variable production costs are $4.90 per bag of wheat cereal, $6.10 per bag of pancake mix, and $3.10 per bag of flour. Sales commissions are 10% of sales for any product. All other costs are fixed |
The mill’s income statement for the most recent month is given below: |
Total Company |
Wheat Cearal |
Pancake Mix |
Flour |
|
Sales |
1,170,000.00 |
390,000.00 |
490,000.00 |
290,000.00 |
Expenses |
||||
Materials, labor, other |
579,900.00 |
191,100.00 |
298,900.00 |
89,900.00 |
Sales Commissions |
117,000.00 |
39,000.00 |
49,000.00 |
29,000.00 |
Advertising |
156,050.00 |
73,000.00 |
50,000.00 |
33,050.00 |
Salaries |
98,500.00 |
43,300.00 |
10,200.00 |
45,000.00 |
Equipment Depreciation |
58,500.00 |
19,500.00 |
24,500.00 |
14,500.00 |
Warehouse rent |
23,400.00 |
7,800.00 |
9,800.00 |
5,800.00 |
General Administration |
84,000.00 |
28,000.00 |
28,000.00 |
28,000.00 |
Total Expenses |
1,117,350.00 |
401,700.00 |
470,400.00 |
245,250.00 |
Net Operating income (loss) |
52,650.00 |
(11,700.00) |
19,600.00 |
44,750.00 |
The following additional information is available about the company: |
a. |
The same equipment is used to mill and package all three products. In the above income statement, equipment depreciation has been allocated on the basis of sales dollars. An analysis of equipment usage indicates that it is used 40% of the time to make wheat cereal, 50% of the time to make pancake mix, and 10% of the time to make flour.. |
b. |
All three products are stored in the same warehouse. In the above income statement, the warehouse rent has been allocated on the basis of sales dollars. The warehouse contains 46,800 square feet of space, of which 8,000 square feet are used for wheat cereal, 14,000 square feet are used for pancake mix, and 24,800 square feet are used for flour. The warehouse space costs the company $0.50 per square foot per month to rent. |
c. |
The general administration costs relate to the administration of the company as a whole. In the above income statement, these costs have been divided equally among the three product lines. |
d. |
All other costs are traceable to the product lines. |
Streeterville Foods’ management is anxious to improve the mill’s 4.5% margin on sales. |
Required: |
1. |
Prepare a new contribution format segmented income statement for the month. Adjust the allocation of equipment depreciation and warehouse rent as indicated by the additional information provided. |
||
In: Accounting
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