New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!

# ACC512 Management Accounting for Costs and Control

Published : 11-Oct,2021  |  Views : 10

## Question:

Create a spreadsheet solution to the following problem. Also paste a spreadsheet solution showing the row and column headings and the formula view. Your report should be completely formula driven.Design your spreadsheet to meet the assignment requirements set out above. In particular, check the spreadsheet requirements and the Spreadsheet Advice PDF.See pages 156-157 of your text for examples.

Review the four process costing videos provided in Interact Resources. Note that in the situation below there are two production departments. The Tuena Trading Company manufactures a single product which passes through two departments, A and B.All work is commenced in Department A, from which all output is transferred to Department B where additional materials are added when processing is 30% complete.

In Department B labour and overhead costs are treated as being incurred uniformly throughout the process. Overhead is allocated on the basis of 130% of direct labour cost. For Department B the following information relating to the month of April, 2017 is available:
Work in process, 1 April: 5000 units, 80% complete. Costs of this
work in process include:
Department A costs \$15 600
Department B materials \$ 5 900
Department B direct labour \$ 7 000

During April 150 000 units were completed and transferred to finished goods inventory.Units transferred in from Department A were charged to Department B at \$3 per unit. Department B's costs in April were materials added \$145 100 and direct labour \$298 000.On 30 April 10 000 units were in process in Department B and these were estimated to be 30% complete.

Required:
For Department B calculate for the month of April the cost of work completed and the cost of work in process as at 30 April, 2017, using the weighted average cost method.

Newbridge Company is starting operations on 1 January, 2017 with no opening inventories.Manufacturing costs of its single product have been budgeted as follows:
Direct materials \$2.75 per unit
Direct labour \$1.50 per unit
Factory overhead:
Variable \$0.25 per unit
Fixed (including \$1000 depreciation) \$5500 per month
Selling and administrative expenses, including depreciation of \$300 per month, are all fixed and total
\$3000 per month.

Other information is as follows:
The selling price of the product has been set at \$6 per unit. Collections are scheduled as follows: 70% in month of sale, 28% in month following sale, and 2% uncollectable. The inventory of direct materials will be maintained at 25% of the next month's production requirements. 60% of each month's purchases will be paid for in the month of purchase, and the remainder in the following month. A cash discount of 2% will be taken on all purchases.The direct labour payroll, factory overhead and selling and administrative expenses will be paid for in the month incurred.Sales and production for the first three month's of the year have been scheduled as follows:
Units Sold Units Produced
January 6000 10 000
February 7000 10 000
March 9 000 12 000

Required:
Prepare a budget showing the cash receipts and cash payments for the months of January and February with supporting calculations.Prepare a report to the Chief Financial Officer of your organisation about employee motivation. In the report explain the differences between personal control and social control in organisations. Your explanation should include an evaluation of the ability of personal control theories to be used in motivating staff in an organisation.As positive group norms are valuable in an organisation your report should explain some of the ways in which positive group norms can be developed.

## Answer:

 Cash Receipts Budget Particulars January February March Budgeted Unit Sales 6000 7000 9000 Price Per Unit \$6 \$6 \$6 Budgeted Sales Revenue \$36,000 \$42,000 \$54,000 Selling and Administrative Overhead \$3,000 \$3,000 \$3,000 Less: Depreciation \$(300) \$(300) \$(300) Total Cash Receipts \$28,200 \$42,480 \$52,560 Particulars January February March Units Produced 10000 10000 12000 Direct Material \$27,500 \$27,500 \$33,000 Direct Labor Hours \$15,000 \$15,000 \$18,000 Factory Overhead \$8,000 \$8,000 \$8,500 Less: Depreciation \$(1,000.00) \$(1,000.00) \$(1,000.00) Total Cash Payments \$49,500 \$49,500 \$58,500
Get An Awesome Price Quote For Your Paper – Absolutely FREE!

### Our Amazing Features

#### No missing deadline risk

No matter how close the deadline is, you will find quick solutions for your urgent assignments.

#### 100% Plagiarism-free content

All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.

#### 500+ subject matter experts

Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.

#### Covers all subjects

We offer academic help services for a wide array of subjects.

#### Pocket-friendly rate

We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.

Getting started with MyEssayAssignmentHelp is FREE

15,000+ happy customers and counting!

Rated 4.7/5 based on
1491 reviews
;