Preparing a schedule of cost of goods manufactured and an income statement for a manufacturing company

Certain item descriptions and amounts are missing from the monthly schedule of cost of goods manufactured and income statement of Elly Manufacturing Company. Fill in the blanks with the missing words, and replace the Xs with the correct amounts.

Beginning Direct Ending Direct Direct Manufacturing Overhead Total Total Ending Direct Materials Beginning Direct Materials Purchases of Direct Materials \( 27,000 \) X \( X X X (25,000) 180,000 44,000 \) X 56,000 84,000 (20,000) ELLY MANUFACTURING COMPANY

Net Sales Revenue Cost of Goods Sold Total Income Cost of Goods Sold: Gross Profit Expenses: Selling Expenses Administrative Expenses Cost of Goods Ending Beginning \( X \) X 232,000 258,000 X 160,000 98,000 $ 110,000 X X X E

Short Answer

Expert verified

The Cost of Goods Manufactured are $182,000 and the net operating income is $98,000.

Step by step solution

01

Step-by-StepStep 1: Completion of schedule of cost of goods manufactured

Elly Manufacturing Company
Income Statement
Month Ended June 30, 2018

Amount ($)

Amount ($)

Amount ($)

Beginning WIP Inventory

$27,000

Direct Material used:

Beginning Direct Material

$28,000

Purchases of direct material

56,000

Direct Material available for use

84,000

Ending Direct Materials

-20,000

Direct Materials Used

64,000

Direct Labor

72,000

Manufacturing overhead

44,000

Total manufacturing cost incurred during the month

180,000

Total manufacturing costs to account for

207,000

Ending WIP Inventory

25,000

Cost of goods manufactured

$182,000

Working Notes: Missing amounts

Beginning Direct materials:

Direct material available for use

$84,000

Purchases of direct material

-56,000

Beginning Direct materials

$28,000

Direct materials Used:

Ending materials available for use

$84,000

Ending Direct Materials

-20,000

Direct materials used

$64,000

Direct Labor:

Total manufacturing costs incurred during the month

$180,000

MOH

-44,000

Direct materials used

-64,000

Direct Labor

$72,000

Total Manufacturing Costs to Account For:

Beginning Work-in-Process Inventory

$27,000

Total Manufacturing Costs Incurred During the Month

180,000

Total Manufacturing Costs to Account For

$207,000

Cost of Goods Manufactured:

Total Manufacturing Costs to Account For

$207,000

Ending Work-in-Process Inventory

-25,000

Cost of Goods Manufactured

$182,000

02

Completion of Income statement

Elly Manufacturing Company
Income Statement
Month Ended June 30, 2018

Amount ($)

Amount ($)

Net Sales Revenue

$490,000

Cost of goods Sold

Beginning finished goods inventory

$110,000

Cost of goods manufactured

182,000

Cost of goods available for sales

292,000

Ending Finished goods inventory

-60,000

Cost of goods sold

232,000

Selling and administrative Expenses:

258,000

Selling Expenses

98,000

Administrative Expenses

62,000

Total Selling and administrative Expenses

160,000

Operating Income

$98,000

Working Notes: Missing Amounts

Net Sales Revenue:

Cost of goods sold

$232,000

Gross Profit

258,000

Net Sales Revenue

$490,000

Cost of Goods Available for sale:

Beginning FG Inventory

$110,000

COGM

182,000

Cost of goods available for sale

$292.000

Ending Finished Goods Inventory:

Cost of goods available for sale

$292,000

COGS

-232,000

Ending FG Inventory

$60,000

Administrative Expenses:

Total selling and administrative expenses

$160,000

Selling Expenses

-98,000

Administrative Expenses

$62,000

Operating Income:

Gross Profit

$258,000

Total selling and administrative expenses

-160,000

Operating Income

$98,000

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

The Institute of Management Accountants’ Statement of Ethical Professional Practice requires managerial accountants to meet standards regarding competence, confidentiality, integrity, and credibility. Consider the following situations. Which standard(s) is(are) violated in each situation?

e. You do not provide top management with the detailed job descriptions they requested because you fear they may use this information to cut a position in your department.

Question:Applying ethical standards

Natalia Wallace is the new controller for Smart Software, Inc. which develops and sells education software. Shortly before the December 31 fiscal year-end, James Cauvet, the company president, asks Wallace how things look for the year-end numbers. He is not happy to learn that earnings growth may be below 13% for the first time in the company’s five-year history. Cauvet explains that financial analysts have again predicted a 13% earnings growth for the company and that he does not intend to disappoint them. He suggests that Wallace talk to the assistant controller, who can explain how the previous controller dealt with such situations. The assistant controller suggests the following strategies:

a. Persuade suppliers to postpone billing \(13,000 in invoices until January 1.

b. Record as sales \)115,000 in certain software awaiting sale that is held in a public warehouse.

c. Delay the year-end closing a few days into January of the next year so that some of the next year’s sales are included in this year’s sales.

d. Reduce the estimated Bad Debts Expense from 5% of Sales Revenue to 3%, given the company’s continued strong performance.

e. Postpone routine monthly maintenance expenditures from December to January.

Requirements

1. Which of these suggested strategies are inconsistent with IMA standards?

2. How might these inconsistencies affect the company’s creditors and stockholders?

3. What should Wallace do if Cauvet insists that she follow all of these suggestions?

Calculating unit cost per service

Marx and Tyler provides hair-cutting services in the local community. In February, the business cut the hair of 190 clients, earned \(4,800 in revenues, and incurred the following operating costs:

Hair Supplies Expense \) 950

Wages Expense 548

Utilities Expense 190

Depreciation Expense—Equipment 60

What was the cost of service to provide one haircut?

Determining the flow of costs through a manufacturer’s inventory accounts

True Fit Shoe Company makes loafers. During the most recent year, True Fit incurred total manufacturing costs of \(21,900,000. Of this amount, \)2,600,000 was direct materials used and \(14,800,000 was direct labor. Beginning balances for the year were Direct Materials, \)700,000; Work-in-Process Inventory, \(1,500,000; and Finished Goods Inventory, \)1,100,000. At the end of the year, balances were Direct Materials, \(800,000; Work-in-Process Inventory, \)2,000,000; and Finished Goods Inventory, $1,080,000.

Requirements Analyze the inventory accounts to determine:

1. Cost of direct materials purchased during the year.

2. Cost of goods manufactured for the year.

3. Cost of goods sold for the year.

Calculating cost of goods sold for merchandising and manufacturing companies

Below are data for two companies:

Company 1 Company 2

Beginning balances:

Merchandise Inventory \( 11,600

Finished Goods Inventory \) 15,400

Ending balances:

Merchandise Inventory 12,400

Finished Goods Inventory 11,300

Net Purchases 152,500

Cost of Goods Manufactured 214,500

Requirements

1. Define the three business types: service, merchandising, and manufacturing.

2. Based on the data given for the two companies, determine the business type of each one.

3. Calculate the cost of goods sold for each company

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free