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

  Calculate the total simulated hours

Calculate the total simulated hours, total waiting time for the customer service team member, and the total wait time for the customer?

  Prepare a job cost sheet

Prepare a job cost sheet and record the information given above and also a cost summary for job and prepare a purchases budget in units and dollars for the quarter ending 30th December 2014.

  Describe the four perspectives of the balanced scorecard

List and describe the four perspectives of the Balanced Scorecard and what steps would you encourage him or her to take in order to successfully implement and use the Scorecard?

  Do you believe firm quality initiatives have been successful

Do you believe this firm's quality initiatives have been successful? Be sure to justify your opinion with specific information.

  Predetermined overhead rate-mallory corporation

Mallory Corporation produces two products: A and B. The company's expected factory overhead costs for the coming year are as follows: Calculate the predetermined overhead rate based on direct labor hours and based on machine hour. Calculate the unit..

  1 lehner corporation has provided the following data from

1. lehner corporation has provided the following data from its activity-based costing accounting systemnbsp indirect

  Calculate total manufacturing overhead costs

If the cost object is an airplane, classify each cost as one of the following: direct material (DM), direct labor, (DL), indirect labor (IL), indirect materials (IM), other manufacturing overhead (other MOH), or period cost.

  Job order costing or process costing decision

Your CFO, in her initial work, needs to decide whether to set up a job order costing system or a process type costing system. She has asked you to make a recommendation based on the following information.

  Components of cost-volume-profit analysis

Describe the components of cost-volume-profit analysis. Employ cost-volume-profit analysis and break-even analysis to make business decisions.

  Net present value cma adapted lo 3 maybe i should have

net present value cma adapted lo 3 maybe i should have stuck with teaching high school art. no matter what i try i cant

  Requiredstudy the information given below and determine

requiredstudy the information given below and determine which of the two investment opportunities it should choose.

  Sales volume variance analysis-master vs flexible budget

During the period, actual sales totaled 58,000 units. Prepare a variance report to show the difference between the master budget and the flexible budget.

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