Vertical Analysis of Income Statement
Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows:
| Current Year | Previous Year | |||
| Sales | $580,000 | $522,000 | ||
| Cost of goods sold | 324,800 | 261,000 | ||
| Selling expenses | 104,400 | 104,400 | ||
| Administrative expenses | 110,200 | 93,960 | ||
| Income tax expense | 17,400 | 26,100 | ||
a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers.
| Innovation Quarter Inc. | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount | Current year Percent | Previous year Amount | Previous year Percent | |
| Sales | $580,000 | % | $522,000 | % |
| Cost of goods sold | 324,800 | % | 261,000 | % |
|
$ | % | $ | % |
| Selling expenses | 104,400 | % | 104,400 | % |
| Administrative expenses | 110,200 | % | 93,960 | % |
|
$ | % | $ | % |
|
% | % | ||
| Income tax expense | 17,400 | % | 26,100 | % |
|
$ | % | $ | % |
Feedback
b. The vertical analysis indicates that the cost of goods sold as a percent of sales
In: Accounting
Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below:
| Flexible Budget | Actual | ||||||
| Sales (15,000 pools) | $ | 675,000 | $ | 675,000 | |||
| Variable expenses: | |||||||
| Variable cost of goods sold* | 435,000 | 461,890 | |||||
| Variable selling expenses | 20,000 | 20,000 | |||||
| Total variable expenses | 455,000 | 481,890 | |||||
| Contribution margin | 220,000 | 193,110 | |||||
| Fixed expenses: | |||||||
| Manufacturing overhead | 130,000 | 130,000 | |||||
| Selling and administrative | 84,000 | 84,000 | |||||
| Total fixed expenses | 214,000 | 214,000 | |||||
| Net operating income (loss) | $ | 6,000 | $ | (20,890 | ) | ||
*Contains direct materials, direct labor, and variable manufacturing overhead.
Janet Dunn, who has just been appointed general manager of the Westwood Plant, has been given instructions to “get things under control.” Upon reviewing the plant’s income statement, Ms. Dunn has concluded that the major problem lies in the variable cost of goods sold. She has been provided with the following standard cost per swimming pool:
| Standard Quantity or Hours | Standard Price or Rate |
Standard Cost | ||||
| Direct materials | 3.0 pounds | $ | 5.00 | per pound | $ | 15.00 |
| Direct labor | 0.8 hours | $ | 16.00 | per hour | 12.80 | |
| Variable manufacturing overhead | 0.4 hours* | $ | 3.00 | per hour | 1.20 | |
| Total standard cost per unit | $ | 29.00 | ||||
*Based on machine-hours.
During June, the plant produced 15,000 pools and incurred the following costs:
It is the company’s policy to close all variances to cost of goods sold on a monthly basis.
Required:
1. Compute the following variances for June:
a. Materials price and quantity variances.
b. Labor rate and efficiency variances.
c. Variable overhead rate and efficiency variances.
2. Summarize the variances that you computed in (1) above by showing the net overall favorable or unfavorable variance for the month.
In: Accounting
Problem 17-3A Applying activity-based costing LO P1, P3, A1, A2, C3
[The following information applies to the questions
displayed below.]
Craft Pro Machining produces machine tools for the construction
industry. The following details about overhead costs were taken
from its company records.
| Production Activity | Indirect Labor | Indirect Materials | Other Overhead | ||||||||
| Grinding | $ | 380,000 | |||||||||
| Polishing | $ | 145,000 | |||||||||
| Product modification | 450,000 | ||||||||||
| Providing power | $ | 205,000 | |||||||||
| System calibration | 470,000 | ||||||||||
Additional information on the drivers for its production activities
follows.
| Grinding | 19,000 | machine hours |
| Polishing | 19,000 | machine hours |
| Product modification | 1,600 | engineering hours |
| Providing power | 20,000 | direct labor hours |
| System calibration | 800 | batches |
| Job 3175 | Job 4286 | |||
| Number of units | 190 | units | 2,375 | units |
| Machine hours | 350 | MH | 3,500 | MH |
| Engineering hours | 33 | eng. hours | 24 | eng. hours |
| Batches | 5 | batches | 15 | batches |
| Direct labor hours | 510 | DLH | 4,590 | DLH |
Problem 17-3A Parts 2, 3 & 4
2, 3 & 4. Compute the activity overhead
rates using ABC. Combine the grinding and polishing activities into
a single cost pool. Determine overhead costs to assign to the
following jobs using ABC. What is the overhead cost per unit for
Job 3175? What is the overhead cost per unit for Job 4286?
(Round your activity rate and average overhead cost per
unit to 2 decimal places. Round "overhead assigned" to the nearest
whole dollar.)
Overhead Cost----Activity Drivers-----Activity Rate---Activity Driver incurred----------Overhead assigned------Activity Driver incurred------Overhead Assigned
Grinding and Polishing---------------------------/--------------/Machine Hours-------------/--------------------------------/-------------------------------------/------------------------------------/------------------------------------l
Product Modification-----------------------------/---------------/Engineering Hours--------/--------------------------------/-------------------------------------/------------------------------------/-------------------------------------l
Providing Power----------------------------------/----------------/Direct Labor Hours--------/-------------------------------/--------------------------------------/------------------------------------/-------------------------------------l
System Calibration-----------------------------/---------------/batches-------------------------/-------------------------------/--------------------------------------/-------------------------------------/------------------------------------l
In: Accounting
Waterway Family Instruments makes cellos. During the past year,
the company made 6,380 cellos even though the budget planned for
only 5,580. The company paid its workers an average of $15 per
hour, which was $1 higher than the standard labor rate. The
production manager budgets four direct labor hours per cello.
During the year, a total of 24,790 direct labor hours were
worked.
(a) Calculate the direct labor rate and efficiency
variances. (If variance is zero, select "Not
Applicable" and enter 0 for the amounts.)
| Direct labor rate variance | $Enter a dollar amount | Select an option UnfavorableNot ApplicableFavorable | |
|---|---|---|---|
| Direct labor efficiency variance | $Enter a dollar amount | Select an option FavorableUnfavorableNot Applicable |
In: Accounting
Department G had 3,600 units 25% completed at the beginning of
the period, 11,000 units were completed during the period, 3,000
units were 20% completed at the end of the period, and the
following manufacturing costs were debited to the departmental work
in process account during the period:
| Work in process, beginning of period | $40,000 |
| Costs added during period: | |
| Direct materials (10,400 units at $8) | 83,200 |
| Direct labor | 63,000 |
| Factory overhead | 25,000 |
All direct materials are placed in process at the beginning of
production, and the first-in, first-out method of inventory costing
is used. What is the total cost of the units started and completed
during the period (round unit cost calculations to whole
dollars)?
a.$211,200
b.$190,275
c.$20,934
d.$120,060
In: Accounting
Alpha Company provided the following data concerning its income statement: sales, $1,025,000; purchases, $500,000; beginning inventory, $260,000; ending inventory, $242,000; operating expenses, $93,000; freight-in, $5,000; sales discounts, $27,000; purchases discounts, $15,000; sales returns & allowances, $95,000; and purchases returns & allowances, $38,000. The data are complete and provide the basis for preparation of an income statement. How much is net income?
In: Accounting
Marilyn Helm Retailers is attempting to decide on a location for a new retail outlet. At the moment, the firm has three alternatives: stay where it is but enlarge the facility; locate along the main street in nearby Newbury; or locate in a new shopping mall in Hyde Park.
The company has selected the four factors listed in the following table as the basis for evaluation and has assigned weights as shown:
|
Factor |
Factor Description |
Weight |
Present LocationPresent Location |
NewburyNewbury |
Hyde ParkHyde Park |
|
1 |
Average community income |
0.400.40 |
3535 |
5555 |
5050 |
|
2 |
Community growth potential |
0.150.15 |
1515 |
2525 |
8080 |
|
3 |
Availability of public transportation |
0.200.20 |
2525 |
5555 |
5555 |
|
4 |
Labor availability, attitude, and cost |
0.250.25 |
8585 |
5555 |
4545 |
a) Based on the given information, the best location for Marilyn Helm Retailers is to open the new retail outlet in _____, with a total weighted score of_____(Enter your response rounded to two decimal places.)
b) A new subway station is scheduled to open across the street from the present location in about a month, so its third factor score should be raised to 75. Then, the best location for Marilyn Helm Retailers is to open the new retail outlet in ______, with a total weighted score of ____.(Enter your response rounded to two decimalplaces.)
In: Accounting
Oriole Company was organized on July 1, 2019. Quarterly financial statements are prepared. The unadjusted and adjusted trial balances as of September 30 are shown as follows.
FIRST Journalize the adjusting entries that were made THEN create an income statement, retained earnings, and balance sheet.
|
Oriole Company |
||||||||
| Unadjusted | Adjusted | |||||||
| Dr. | Cr. | Dr. | Cr. | |||||
| Cash | $ 8,700 | $ 8,700 | ||||||
| Accounts Receivable | 10,500 | 11,600 | ||||||
| Supplies | 1,450 | 700 | ||||||
| Prepaid Rent | 2,150 | 1,250 | ||||||
| Equipment | 18,000 | 18,000 | ||||||
| Accumulated Depreciation—Equipment | $0 | $ 750 | ||||||
| Notes Payable | 9,500 | 9,500 | ||||||
| Accounts Payable | 2,450 | 2,450 | ||||||
| Salaries and Wages Payable | 0 | 720 | ||||||
| Interest Payable | 0 | 95 | ||||||
| Unearned Rent Revenue | 1,900 | 1,000 | ||||||
| Common Stock | 21,600 | 21,600 | ||||||
| Dividends | 1,600 | 1,600 | ||||||
| Service Revenue | 17,100 | 18,200 | ||||||
| Rent Revenue | 1,380 | 2,280 | ||||||
| Salaries and Wages Expense | 8,200 | 8,920 | ||||||
| Rent Expense | 1,850 | 2,750 | ||||||
| Depreciation Expense | 750 | |||||||
| Supplies Expense | 750 | |||||||
| Utilities Expense | 1,480 | 1,480 | ||||||
| Interest Expense | 95 | |||||||
| $ 53,930 | $ 53,930 | $ 56,595 | $ 56,595 | |||||
In: Accounting
Problem 08-3A Flexible budget preparation; computation of materials, labor, and overhead variances; and overhead variance report LO P1, P2, P3, P4 Skip to question [The following information applies to the questions displayed below.] Antuan Company set the following standard costs for one unit of its product. Direct materials (4.0 Ibs. @ $6.00 per Ib.) $ 24.00 Direct labor (1.9 hrs. @ $13.00 per hr.) 24.70 Overhead (1.9 hrs. @ $18.50 per hr.) 35.15 Total standard cost $ 83.85 The predetermined overhead rate ($18.50 per direct labor hour) is based on an expected volume of 75% of the factory’s capacity of 20,000 units per month. Following are the company’s budgeted overhead costs per month at the 75% capacity level. Overhead Budget (75% Capacity) Variable overhead costs Indirect materials $ 15,000 Indirect labor 90,000 Power 15,000 Repairs and maintenance 30,000 Total variable overhead costs $ 150,000 Fixed overhead costs Depreciation—Building 24,000 Depreciation—Machinery 72,000 Taxes and insurance 18,000 Supervision 263,250 Total fixed overhead costs 377,250 Total overhead costs $ 527,250 The company incurred the following actual costs when it operated at 75% of capacity in October. Direct materials (61,000 Ibs. @ $6.20 per lb.) $ 378,200 Direct labor (22,000 hrs. @ $13.10 per hr.) 288,200 Overhead costs Indirect materials $ 41,050 Indirect labor 176,800 Power 17,250 Repairs and maintenance 34,500 Depreciation—Building 24,000 Depreciation—Machinery 97,200 Taxes and insurance 16,200 Supervision 263,250 670,250 Total costs $ 1,336,650 rev: 04_27_2020_QC_CS-209738 Problem 08-3A
Part 3 3. Compute the direct materials cost variance, including its price and quantity variances. (Indicate the effect of each variance by selecting for favorable, unfavorable, and No variance.)
Problem 08-3A Part 4
4. Compute the direct labor cost variance, including its rate and efficiency variances. (Indicate the effect of each variance by selecting for favorable, unfavorable, and No variance. Round "Rate per hour" answers to two decimal places.
In: Accounting
|
Refi Corporation is planning to repurchase part of its common stock by issuing corporate debt. As a result, the firm’s debt-equity ratio is expected to rise from 40 percent to 50 percent. The firm currently has $3.5 million worth of debt outstanding. The cost of this debt is 7 percent per year. The firm expects to have an EBIT of $1.34 million per year in perpetuity and pays no taxes. |
| a. |
What is the market value of the firm before and after the repurchase announcement? (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.) |
| b. | What is the expected return on the firm’s equity before the announcement of the stock repurchase plan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
| c. | What is the expected return on the equity of an otherwise identical all-equity firm? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
| d. | What is the expected return on the firm’s equity after the announcement of the stock repurchase plan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
In: Accounting
Selected information about income statement accounts for the
Rogers Company, Inc. is presented below (the company's fiscal year
ends on December 31):
|
2018 |
2017 |
|||
|
Sales |
$ |
4,400,000 |
$ |
3,500,000 |
|
Cost of goods sold |
2,860,000 |
2,000,000 |
||
|
Administrative expenses |
800,000 |
675,000 |
||
|
Selling expenses |
360,000 |
312,000 |
||
|
Interest revenue |
150,000 |
140,000 |
||
|
Interest expense |
200,000 |
200,000 |
||
|
Loss on sale of assets of discontinued component |
50,000 |
— |
||
On July 1, 2018, the company adopted a plan to discontinue a
division that qualifies as a component of an entity as defined by
GAAP. The assets of the component were sold on September 30, 2018,
for $50,000 less than their book value. Results of operations for
the component (included in the above account balances)
were as follows:
|
1/1/18-9/30/18 |
2017 |
||||||||
|
Sales |
$ |
400,000 |
$ |
500,000 |
|||||
|
Cost of goods sold |
(290,000 |
) |
(320,000 |
) |
|||||
|
Administrative expenses |
(50,000 |
) |
(40,000 |
) |
|||||
|
Selling expenses |
(20,000 |
) |
(30,000 |
) |
|||||
|
Operating income before taxes |
$ |
40,000 |
$ |
110,000 |
|||||
In addition to the account balances above, several events occurred
during 2018 that have not yet been reflected in the above
accounts:
Required:
Prepare a multiple-step income statement for the Rogers Company for
2018, showing 2017 information in comparative format, including
income taxes computed at 40% and EPS disclosures assuming 300,000
shares of common stock.
In: Accounting
Discussion Question
Cash in Hand Topic: Revenue Recognition/Misrepresentation of Fact by Client Characters: Heather Hunter, Senior in CPA firm “Buzz” Thompson, Owner/manager of Fashion First Sandy, part-time bookkeeper of Fashion First Author: Mary Brady Greenawalt, Associate Professor of Business Administration, The Citadel Co-author: Janine Cloutier, Virginia Tech
In addition to the usual mix of compilation, review, and audit clients for which Heather Hunt serves as a senior in a small office of a regional CPA firm, she has been assigned a new client that recently engaged the firm. Fashion First, an incorporated retail outlet, is a thriving local store. The business is run by a single owner/manager, “Buzz” Thompson, who makes all major decisions. The business has not previously used the services of a CPA firm. In addition to preparation of financial statements, the CPA firm will handle tax returns for the business. At her first visit to the client’s office, Heather is introduced to Sandy, the part-time bookkeeper who is also a full-time accounting student at the local university. At a subsequent meeting, Sandy confides to Heather that she found the job at the beginning of the semester after an extensive search. Sandy really needs the money to help finance her education, and feels lucky to have found a good-paying job during the current economic downturn. Feeling that Heather is someone she can talk to and get advice from, Sandy describes a situation that has been on her mind for some time now. Sandy’s concern relates to the handling of sales revenues. When monies from sales revenues are counted and deposited on a weekly basis, a chart is filled out with categories carefully delineating the type of payment: cash, checks, American Express, or Visa/Mastercard. Sandy’s employer, after depositing the weekly total, brings this chart back with his own written-in total of the actual amount deposited. After looking over some of these weekly deposit chats, Sandy noticed that $500 cash was missing from each deposit. After a more thorough inspection of monthly tax documents that “Buzz” Thompson has filled out, Sandy noticed that the reported monthly gross revenue was $2,000 less than what had been actually counted. The employer is the only person handling the money after it has been counted. He is also the only one to deposit the money. When Sandy asked Mr. Thompson about revenue not being reported for tax purposes, he assured her that every dollar of income was reported on the tax forms. Furthermore, “Buzz” asserted, since Sandy wasn’t the person who signed the forms, she shouldn’t be concerned.
Questions: Explain your reasoning for each question in full length! What are the Ethical Issues? Who are the Primary Stakeholders? What are the Possible Alternatives? What are the Ethics of the Alternatives?
In: Accounting
Porter Corporation owns all 28,000 shares of the common stock of Street, Inc. Porter has 58,000 shares of its own common stock outstanding. During the current year, Porter earns net income (without any consideration of its investment in Street) of $209,000 while Street reports $181,000. Annual amortization of $13,000 is recognized each year on the consolidation worksheet based on acquisition-date fair-value allocations. Both companies have convertible bonds outstanding. During the current year, bond-related interest expense (net of taxes) is $41,000 for Porter and $21,000 for Street. Porter’s bonds can be converted into 5,000 shares of common stock; Street’s bonds can be converted into 7,000 shares. Porter owns none of these bonds.
1. What are the basic earnings per share amounts that Porter should report in its current year consolidated income statement? (Round your answers to 2 decimal places.)
2. What are the diluted earnings per share? (Round your answers to 2 decimal places.)
In: Accounting
The information that follows is for Nancy’s Name Tents for the year ended December 31, 2015 and
covers questions 26-31. All per unit costs below are based on the production and sale of 3,000 name tents.
The relevant range is from 0 - 3,500 units.
Sales $50 sales price per name tent
Costs:
Variable Costs Per Tent (3,000 name tents produced and sold)
Direct materials 8
Direct labor 7
Manufacturing overhead 8
Period Costs 5
Fixed Costs
Manufacturing overhead 10
Period Costs 5
1) If 10,000 tents are produced and sold, what is the product cost per tent?
2) If 15,000 tents are produced and sold, what is the product cost per tent?
3) If 2,000 tents are produced and sold, what is the product cost per tent?
4) What is the fixed cost per tent at 1,000 tents (including period costs) produced and sold?
5) What are total period costs at 1,000 name tents (produced and sold)?
In: Accounting
Classifying Costs
The following is a manufacturing cost report of Marching Ants Inc. Evaluate and correct this report.
| Marching Ants Inc. Manufacturing Costs For the Quarter Ended June 30 |
||
| Materials used in production (including | ||
| $73,400 of indirect materials) | $792,800 | |
| Direct labor (including $110,100 maintenance salaries) | 734,100 | |
| Factory overhead: | ||
| Supervisor salaries—plant | 675,400 | |
| Heat, light, and power—plant | 183,500 | |
| Sales salaries | 455,100 | |
| Promotional expenses | 411,100 | |
| Insurance and property taxes—plant | 198,200 | |
| Insurance and property taxes—corporate offices | 286,300 | |
| Depreciation—plant and equipment | 161,500 | |
| Depreciation—corporate offices | 117,500 | |
| Total | $4,015,500 | |
| Marching Ants Inc. | ||
| Manufacturing Costs | ||
| For the Quarter Ended June 30 | ||
| Cost of direct materials used in production | $ | |
| Direct labor | ||
| Factory overhead: | ||
| Maintenance salaries | $ | |
| Indirect materials | ||
| Supervisor salaries-plant | ||
| Heat, light, and power-plant | ||
| Insurance and property taxes-plant | ||
| Depreciation-plant and equipment | ||
| Total factory overhead | ||
| Total manufacturing costs | $ | |
In: Accounting