Reference no: EM13832943

QUESTION 1- Manufacturing statement and income statement Spreadsheet.

See the Spreadsheet Advice in Interact 2 Resources and the examples in you textbook. See the requirements within the spreadsheet template below.

Hint: The net income is a lucky number.

Check the spreadsheet assignment requirements. Ensure you have separate data and report areas showing only formulas. Use IF functions to allow for the possibility of either a net income or a net loss.

QUESTION 2- Understanding the entries in the Materials Control account.

The Materials Control account balances were $30 000 on 1 June and $25 000 on 30 June. Raw materials purchased during June cost $90 000. Direct materials issued to production during June were $40 000.

Required:

Reconstruct the Materials Control T-account and show the general journal entry to record the cost of raw materials issued as indirect materials during June.

QUESTION 3- Understanding the entries in the Accrued Payroll account

Salaries and wages payable to factory employees were $10,000 on 1 March and $4,000 on 31 March. Gross salaries and wages paid during March totalled $30,000. March's direct labour totalled $18,000.

Required:

T-account for Accrued Payroll and general journal entries for recording salaries and wages earned by, and paid to, factory employees during March.

QUESTION 4- Payroll entries

The Passive Company has a gross payroll of $10,000 per day. Withholdings for PAYG taxes are $3,000 per day. There are no other deductions from employees' earnings. The firm works five days per week, Monday to Friday inclusive. The payroll period covers Thursday to Wednesday inclusive and the payroll for the week is paid on the following Friday.

Gross payroll consists of $6,000 direct labour, $1,500 indirect factory labour, $1,500 selling expenses and $1,000 general and administrative expenses each day. The following calendar should be used to answer the questions:

A. What is the total amount to be credited to Accrued Payroll in respect of July earnings?

B. If balance day adjustments are performed at the end of each month, what would be the balance in Accrued Payroll account at the close of business on July 31?

C. Suppose that a single journal entry is made on the last day of each month to record the distribution of total labour costs for the month, but that entries are made each Friday to record payment of wages and withholdings. Also, PAYG taxes withheld are remitted to the Taxation Department at the end of each month.

1. Show the weekly journal entry.

2. Construct the necessary ledger accounts to show all entries in respect of labour costs during the month of July.

QUESTION 5- Activity Based Costing

Your employer is contemplating changing the existing costing systems used in the business to adopt activity based costing (ABC).
Prepare a business report to critically evaluate arguments for and against ABC. Use the Internet as a resource (about 300 words excluding references). The following resource will help you prepare and format your report:

https://bit.ly/FoBAcademic-Writing-Skills

QUESTION 6- Service department cost allocation

Spreadsheet problem. Check the spreadsheet assignment requirements and review the examples in your textbook

Using template 1 below, re-allocate the service centre costs to the production departments by

(a) the direct method

(b) the step method

(c) the reciprocal services method

(d) complete the T accounts shown in the second template for EACH method. Add this template to the first template such that all solutions are created automatically.

(e) Assume you are the manager with the task of choosing one only of these methods to implement. With reference to the outcomes of each method, outline the criteria relevant to your decision.

Rationale

This assignment is designed to assess your application of knowledge, understanding and skills in certain topics including cost flows in management accounting, functions, terminology, manufacturing statements, spreadsheet construction, product costing, materials acquisition systems, labour payment systems, accounting for overhead, activity based costing, (ABC) and the allocation of overhead including service department costs.

Criteria

Relevance of the answer - are the important issues raised in the question identified? Did the student answer the questions?

Critical capacity. Has reference material been carefully analysed or critically accepted?

Structure of the answer. Is the answer well-structured and the argument logically developed?

Writing style. Is the style concise and lucid or confused, making it difficult for the reader to get the point?
Scope of reading. Does the answer indicate a satisfactory coverage of literature relevant to the questions?

Answers should:

• be well planned with arguments flowing logically;

• use correct sentence structure, punctuation and spelling;

• present original ideas where appropriate;

• and present a justified conclusion and acknowledge all sources.

Presentation

• Please read this in conjunction with the assignment requirements below.

• Single spacing and small margins are welcome to save paper.

• For any business report style questions a report structure is expected.

• Provide references throughout your assignment including page references to texts, articles and URL's of websites.

• APA is the referencing style used by the Faculty of Business but in this subject I am not too fussy about the style of referencing used, as long as you acknowledge ALL sources used.

• At the end of your assignment include a complete Bibliography (Reference List) of resources actually used including the Internet, textbook, Study Guide, Software help files and videos supporting this subject.