Manufacturing cost schedule and income statement

Assignment Help Managerial Accounting
Reference no: EM13503320

Question Manufacturing Cost Schedule and Income Statement

Neptune Manufacturing Co is a wholly owned subsidiary of Jupiter Australia and utilises a traditional manufacturing cost flow inventory and accounting system. Neptune Manufacturing Co is incorporated and operates in Australia and pays tax at the Australian corporate rate of 30%. There are no adjustments for accruals or prepayments.

Trading data for Neptune Manufacturing Co for the 2013 calendar year was as follows:

Account:

$

Raw Materials & Ingredients (Purchases)

12,582,000

Freight Inwards

370,000

Plant Utility Costs

2,486,500

Depreciation of Factory Plant, Equipment & Machinery

1,250,000

Depreciation of Office Equipment & Furniture

156,000

Office Salaries and Costs

1,256,000

Factory Direct Labour Cost

3,658,000

Factory Indirect Labour Cost

1,123,000

Manufacturing Overhead

482,000

Interest & other charges

1,901,000

Sales Revenue

32,101,000

Freight Outwards

672,000

Sales & Marketing Expenses

1,985,000

Accounting & Audit costs

875,000

On December 31st 2013 selected account balances of Neptune Manufacturing Co were as follows (with comparative 31/12/2012 Opening Balance figures):

Account:

Dec 31, 2013

Dec 31, 2012

Cash & Cash Equivalents

327,000

1,243,000

Accounts Receivable 

2,459,000

1,926,000

Factory Plant, Equipment & Machinery (at cost)

8,500,000

7,125,000

Office Equipment & Furniture (at cost)

1,500,000

1,450,000

Land & Buildings (at cost)

13,500,000

13,500,000

Raw Material Inventory

386,500

426,000

Work in Process (WIP) Inventory:

 

 

Raw Materials

1,178,000

902,000

Direct Labour

647,000

561,000

Manufacturing Overhead

296,000

205,000

Total WIP

2,121,000

1,668,000

Finished Goods Inventory

1,254,000

1,002,000

Accounts Payable

621,000

987,000

Long Term Debt

15,000,000

15,000,000

Using Excel prepare a Schedule of Cost of Goods Manufactured, Schedule of Cost of Goods Sold, and an income statement for the Jupiter Manufacturing Co from the information provided.

Reference no: EM13503320

Questions Cloud

Determine the cost value of closing wip : Determine the cost value of closing WIP and the cost value of goods transferred out during the period using First In First Out and Weighted Average Cost Method
How much time passes before police car overtakes the speeder : An unmarked police car traveling a constant 95 is passed by a speeder traveling 115 . Precisely 1.00 after the speeder passes, how much time passes before the police car overtakes the speeder
Define ph will bromocresol green be a perfect green color : Bromocresol green, Ka = 2.0x10^-5, is yellow in its protonated form (HX) and blue in its ionized form (X^-). At what pH will bromocresol green be a perfect green color
Compute the angle of refraction : A ray of light, traveling in the air, strikes the surface of mineral oil at an angle of 27.9 degrees with the normal to the surface. What is the angle of refraction
Manufacturing cost schedule and income statement : Manufacturing Cost Schedule and Income Statement - prepare a Schedule of Cost of Goods Manufactured, Schedule of Cost of Goods Sold, and an income statement for the Jupiter Manufacturing Co from the information provided.
What is the total distance run by the dog : A woman and her dog are out for a morning run to the river, which is located 4 km away. The woman runs at 2.5 m/s in a straight line. What is the total distance run by the dog
How much heat would be given off if one mole is reacted : Suppose .050 moles of a substance reacts in 25.0 grams of water. If the water temperature goes from 22 degrees C to 26 degrees C, how much heat was given off. How much heat would be given off if one mole of the substance reacted
Strategic management accounting case study : Strategic Management Accounting Case Study - prepare a 'before and after' comparative analysis of the revenues and costs of the 'Nutty Nut' product line incorporating the 20% predicted sales increase and the 10% predicted savings in prime costs
Obtain the average power dissipated in the circuit : A 3400 resistor and a 1.6 µF capacitor are connected in series across a generator (60.0 Hz, 120 V rms). Determine the average power dissipated in the circuit

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Conversion cost for month in the first processing department

The ending inventory was 80% complete with respect to materials and 20% complete with respect to conversion costs and what are the equivalent units for conversion costs for the month in the first processing department?

  Description of cost classifications

Compare and contrast various cost classifications, behaviors, and drivers. You may want to consider what types of financial and nonfinancial performance metrics you will be recommending to be sure we are collecting appropriate costs

  Evaluate original decision to acquire the automated machine

Re-compute the predetermined rate assuming that the new machine will be installed and explain why the new predetermined overhead rate is higher (or lower) than the rate that was originally estimated for the year 2014

  Learning points from marginal costing

Recognize three key learning points with respect to application of concepts like fixed costs, variable costs, contribution margin, breakeven analysis, indifference point, and operating leverage to organization's overall financial performance.

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company as of April 30 and calculate the amount of over- or under-applied overhead and what is the significance of this over- or under-applied amount of overhead?

  Families first is a managed care plan that has been asked

families first is a managed care plan that has been asked to submit a premium bid to abc company a large manufacturer

  Summarize the strategic planning from article

Rebecca meets with the managers of each location each month to review operations results. this meeting, the manager must present a projection of operations for the coming month. Explain how Rebecca utilizes strategic planning.

  Evaluate the total contribution margin

Indiana Corporation produces a single product that it sells for $9 per unit. During the first year of operations, 100,000 units were produced, and 90,000 units were sold.

  Utilization of managerial accounting in operational planning

Rebecca owns several successful coffeehouses. Each one has its own manger and is operated independently of the others. In what ways do the coffeehouses utilize managerial accounting in the operational planning process?

  What are the direct material and direct labour price

Calculate a) net book value of the equipment at the end of the third year using the straight-line method of depreciation; and b) depreciation expense for the second year using the double-declining balance method of depreciation.

  Unit product cost for the month under absorption costing

What is the unit product cost for the month under absorption costing and prepare a contribution format income statement for the month using variable costing.

  How the short term nature of such measures

"Both Return on Investment (ROI) and Economic Value Added (EVA), when used as performance measures in an organisation, encourage managers to be short-term in their focus and decision making".

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd