Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 6 16 Marks Ultimate Sounds Ltd manufactures and sells a new line of electric guitars. Unfortunately, it suffered serious fire damage at its accounting

image text in transcribed
Question 6 16 Marks Ultimate Sounds Ltd manufactures and sells a new line of electric guitars. Unfortunately, it suffered serious fire damage at its accounting office and, as a result, the accounting records for March 2021 were partially destroyed. The company has hired you to help figure out the missing pieces of the accounting information. The following accounts have been retrieved for the month of March 2021. Debit Credit Finished Goods, 1 March 36.100 Work in Process, 1 March 12.500 Raw Materials, 1 March 8,200 Prepaid Rent 40.500 Accounts Payable 27.000 Share Capital 70,000 Retained Eamings 55,500 Work in Process, 31 March 45,800 Freight Inwards 1.750 Sales Revenue 1.249.500 Discount Allowed 7,200 Direct Materials used during month of March 385.900 Freight Outwards 9,300 Direct Labour 360,500 Raw Materials Purchases 390,800 Indirect Labour 120.600 Gross Profit 390.280 Plant Energy Costs 69.230 Insurance Expense (40% for manufacturing building, 60% for office 99,450 building Electricity and Gas Expense 70% belong to production) 45,00 Plant Manager Salary 42.450 Administrative Salaries Expenses 65,080 Interest Expense 28,100 Machinery Depreciation Expense 25,000 Depreciation Expense - Sales Office 27,000 Required: a) Prepare the Costs of Goods Manufactured statement for the month ended 31 March 2021. 8 marks b) Calculate the following amounts (Show all workings): i. Cost of Sales 2 marks ii. Net profit for the month of March 4 marks iii. Ending finished goods Inventory 2 marks You are required to use excel functions to calculate the required values for the above requirements. Workings must be included

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Effective Communications

Authors: Elearn

1st Edition

1138456136, 9781138456136

More Books

Students also viewed these Accounting questions

Question

Identify the factors influencing why people help others.

Answered: 1 week ago