Estimate cost behaviour for the complex electricity costs

Assignment Help Managerial Accounting
Reference no: EM132506722

HI5017 Managerial Accounting Assignment - Holmes Institute, Australia

Assessment Task - Tutorial Questions

Purpose: This assignment is designed to assess your level of knowledge of the key topics covered in this unit.

Unit Learning Outcomes Assessed:

1. Critically evaluate the various approaches to performance measurement and control in various types of organisations, and devise and evaluate indicators of performance;

2. Demonstrate the need for a balance between financial and non-financial information in decision making, control and performance evaluation applications of management accounting;

3. Analyse a company's financial statements and/or management reports and identify the strengths and weaknesses of the company and articulate these to the various stakeholders.

Description: Your task is to answer a selection of tutorial questions for weeks 1 to 5 inclusive and submit these answers in a single document. The questions to be answered are:

Question 1 - The following data refer to Nani's Fashions for the current year:

Sales Revenues

$475,000

Work in process inventory, 31 December

15,000

Work in process inventory, 1 January

20,000

Selling and administrative expenses

75,000

Income tax expense

45,000

Purchase of raw materials

90,000

Raw materials inventory, 31 December

12,500

Raw material inventory. 1 January

20,000

Direct labour

100,000

Electricity: plant

20,000

Depreciation plant and equipment

30,000

Finished goods inventory, 31 December

25,000

Finished goods inventory, 1 January

10,000

Indirect material

5,000

Indirect labour

7,500

Other manufacturing overhead

40,000

Required -

a) Prepare the schedule of cost of goods manufactured for Nani's fashion.

b) Prepare the schedule of cost of goods sold for Nani's Fashions and explain the information provided by the schedule of cost of goods sold.

c) Prepare an income statement for the current year.

Question 2 - Brisbane Indoor Sports, a sporting complex, has opening hours that fluctuate from month to month. The electricity costs and hours of operation for past six months is listed below:

Month

Total hours of operation

Total electricity cost

January

650

$4,240

February

700

$4,400

March

800

$4,800

April

600

$4,200

May

550

$3,700

June

500

$3,600

Required -

a) Use the high-low method to estimate the cost behaviour for the complex's electricity costs, assuming that the variable costs vary in proportion to the hours of operation. Express the total cost behaviour in formula form (Y = a + bx). What is the variable electricity cost per hour of operation?

b) During July, the complex will open for 570 hours. Predict the complex's total electricity costs for July using the cost estimation method employed in above requirement a).

c) What is the main drawback of the high-low method of cost estimation?

Question 3 - Toys World started and finished job number A26, a batch of 1,000 cuddly koalas, during March 2020. The job required $4,850 of direct material and 32 hours of direct labour at $20 per hour. The predetermined overhead rate is $10.50 per direct labour hour. On 31st March, 900 of the cuddly koalas were shipped to a local toy shop.

Required -

a) Prepare journal entries to record the incurrence of production costs, completion of job number A26 and the shipment of 900 cuddly koalas to local toy shop.

b) Calculate the cost per cuddly koala for job number A26.

c) How might the managers at Toys World use this information?

Question 4 - Rigby Ltd accumulates costs for its single product using process costing. Direct material is added at the beginning of the production process, and conversion activity occurs uniformly throughout the process. The following is a partially completed production report for May.

 

Production report, May

Physical units

 

Percentage of completion with respect to conversion

Equivalent units

Direct materials

Conversion

Work in process, 1 May

$25,000

40%

 

 

Units started during May

30,000

 

 

 

 

55,000

 

 

 

Units completed and transferred out during May

35,000

 

35,000

35,000

Work in process, 31 May

20,000

80%

20,000

16,000

Total units accounted for

55,000

 

 

 

 

 

Direct material

Conversion

Total

Work in process, 1 May

 

$143,000

$474,700

$617,700

Costs incurred during May

 

$165,000

$2,009,000

$2,174,000

Total costs to account for

 

$308,000

$2,483,700

$2,791,700

Required -

a) Complete the following process costing steps using the weighted average method:

i. Calculation of equivalent units.

ii. Calculation of unit costs.

iii. Analysis of total costs.

b) Prepare a journal entry to record the transfer of the cost of goods completed and transferred out during May.

Question 5 - Mel Snow is the manager of a firm, Taxation Matters, which specialises in the preparation of income tax returns. The firm offers two basic products: the preparation of income tax returns for wage and salary earners, and the preparation of income tax returns for small businesses. Any clients requiring more complex services are referred to Snow's brother Roger, who is a partner in a large firm of chartered accountants.

The processing of wage and salary tax returns is quite straightforward, and the firm uses a software package to process data and print the return. A software package is also used to prepare returns for small businesses, although more information is required, particularly about business expenses.

Snow has only recently joined Taxation Matters and he is concerned about the firm's pricing policy, which sets flat fees of $60 per return for wage and salary clients and $300 for small businesses. He decides to use activity-based costing to estimate the costs of providing each of these services.

At the end of the year, Snow reviewed the firm's total costs and activities, resulting in the following list:

Activity

Activity cost

Activity driver

Quantity of activity driver

Interview salaried client

$60,000

No. of salaried clients

8,000

Interview business client

75,000

No. of business clients

2,000

Obtain missing data

600,000

No. of follow-up calls

8,000

Input data

120,000

No. of data entries

400,000

Print return

90,000

No. of returns

10,000

Verify return with client

180,000

No. of hours

6,000

Rectify errors

90,000

No. of errors

6,000

Submit return

30,000

No. of returns

10,000

Total costs

$1 245,000

 

 

In identifying the activities required for each type of return, Snow noted the following:

Clients are interviewed only once per return.

All follow-up calls to obtain missing data relate to business returns; on average, each business tax return requires four follow-up calls.

Processing a wage and salary tax return requires 20 data entries, whereas a business return requires 120 data entries.

On average, it takes 22.5 minutes to verify a wage and salary tax return, whereas it takes one and a half hours to verify a business return.

All errors relate to business returns; on average, there are 3 errors per business return.

Required -

a) Use activity-based costing to estimate the cost of preparing:

i. A wage and salary tax return.

ii. A business tax return.

b) In the light of your answers to requirement 1, evaluate the firm's pricing policy.

Reference no: EM132506722

Questions Cloud

Potential long-run unemployment rates in economy : Following a permanent, negative aggregate demand shock, which of the following are potential long-run unemployment rates in this economy?
Calculate the depreciation for each of the three years : Calculate the depreciation for each of the three years using the straight-line, units of production and double declining balance methods.
Demand and supply curves for v-neck t-shirts : Below, you are provided with the demand and supply curves for v-neck t-shirts and the world price of a v-neck t-shirt. You will use this information
What is cash flow and free cash flow from assets : What is cash flow from assets (i.e. free cash flow) in 2020? In 2020 and 2019, your cash was 4,563 and 3,597, your accounts receivables
Estimate cost behaviour for the complex electricity costs : Estimate the cost behaviour for the complex's electricity costs, assuming that the variable costs vary in proportion to the hours of operation
What is the npv besides the initial cost : What is the NPV? Besides the initial cost of $100,000, assume all cash flows and sequel cost occur at the end of their respective year.
Relative demand curve relating the relative demand : Derive the relative demand curve relating the relative demand for Widgets to the relative price of Widgets. Algebraically, show what the curve looks
What are the factors they may influence producing pda : What are the factors they may influence producing PDA and What are methods available to evaluate the project? Discuss in detail? - What is the IRR of project
How much money does sophia have in account : Fixed deposit account which pays 5% interest rate compounded monthly. How much money does Sophia have in her account after the last deposit?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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