Prepare an overhead analysis sheet

Assignment Help Managerial Accounting
Reference no: EM132977555

DBA 211 Managerial Accounting

SECTION A (Compulsory)

Question.1
You are the Management accountant of an industrial concern and have been assigned the duty of preparing a cost accounting system. Initially it has been decided to prepare three production cost centers and two service cost centers.

The subsequent data relating to the next accounting period have been estimated as follows:

 

Production Cost Centres         

Service Cost Centres

 

 

Milling

Assembly

Spraying

Stores

Maintenance

Total

No. of employees

30

75

25

6

14

150

Labour hours

1,510

3,320

950

252

595

6,627

Plant & Machines values ($)

 

225,000

 

75,000

 

45,000

 

17,000

 

85,000

 

447,000

Area (m2)

7,500

10,000

3,500

500

1,000

22,500

Material requisitions

 

1,400

 

300

 

250

-

 

550

 

2,500

Maintenance hours (minor works)

 

75

 

30

 

45

-

-

 

150

 KWH ('000)

300

70

50

10

170

600

 Machine hours

8,400

1,100

300

-

-

9,800

During the period the following data were recorded

 

Milling

Assembly

Spraying

Stores

Maintenance

Total ($)

Indirect materials

25,000

10,000

15,000

3,000

17,000

70,000

Indirect labour

15,200

25,000

22,000

42,000

110,000

214,200

Maintenance works

18,000

17,000

14,000

-

-

49,000

The following details were obtained from the accounts relating to the same period:

Fire insurance

$12,500

Power

$45,000

Heating $ Lighting

$20,000

Rent & Rates

$18,000

Machine depreciation

$84,000

Machine insurance

$85,000

Canteen deficit

$42,500

Balance of maintenance costs (excluding major works)

$17,500

Required:

Prepare an overhead analysis sheet showing how overhead costs should be apportioned between the departments.

For each allocation base you have used, explain reasons suggesting why you have preferred such an allocation base?

Question.2

Sony Inc. is a producer of music compact discs (CDs) and tapes. The following account balances are for the year ended December 31, 2020

Administrative expenses

$ 60,000

Depreciation expense - Manufacturing equipment

$50,000

Direct labor

$468,000

Manufacturing supplies expense

$40,000

Indirect labor

$36,000

Beginning inventories, January 1:


Direct materials

$14,000

Work in process

$20,000

Finished goods

$128,000

Ending inventories, December 31:


Direct materials

$44,000

Work in process

$56,000

Finished goods

$92,000

 

 

Direct materials purchases

$216,000

Rent expense - Factory

$28,000

Sales

$1,400,000

Selling expense

$72,000

Other manufacturing overhead

$126,000

Required;

Prepare a statement of cost of goods manufactured for Sony Inc. for the year ended December 31.
Prepare an income statement for the year ended December 31, 2020.

SECTION B

Attempt any Two Questions

Question .3

Chicago Inc. is careful in setting budgets in consultation with all relevant stakeholders rather than impose them on the different parts of the business. In this way, managers at all levels feel involved in the process and are more likely to feel motivated to achieve the targets in their budgets. The following financial data has been provided. It shows both actual and anticipated cash receipts and expenditures.

Month

Sales

($)

Purchases

($)

Wages

($)

General Expenses ($)

Jan. (Actual)

80,000

45,000

20,000

5,000

Feb. (Actual)

80,000

40,000

18,000

6,000

March (Actual)

75,000

42,000

22,000

6,000

April Budget

90,000

50,000

24,000

6,000

May Budget

85,000

45,000

20,000

6,000

June Budget

80,000

35,000

18,000

5,000

You are further informed that:

80% of Sale and 60% of purchase are for cash

The average collection period of debtors is 1/2 a month and credit purchases are paid off regularly after one month

Wages are paid half monthly and the rent of $500 excluded in expense is paid monthly

Cash and Bank Balance on April 1, was $70,000.

Required:
Prepare a Cash Budget for April, May and June in a columnar form using the above information. Show all the workings.
As a CFO of Chicago Inc. how would you accommodate unexpected changes in your budgets?
Explain the limitations of the budgeting process.

Question 4 Management accounting is regarded to have a wider scope, mention and explain the coverage of management accounting

You have been appointed a new management accountant of a manufacturing concern, how would you help the organization achieve its intended objectives?

In your opinion, do you think management accounting is similar to financial accounting? Discuss.

Question .5

The following direct costs were incurred on Job No. 108 of Hisense Engineering Works:

Materials

$3,600

Wages:

 

Department A

80 hours @ $2.5 per hour

Department B

60 hours @ $4 per hour

Overhead expenses were estimated as follows:

 

Variable Overheads:

 

Department A

$5,000 for 4000 direct labour hours

Department B

$6,000 for 3000 direct labour hours

Required:

Formulate a cost sheet for Job No. 108 and estimate the percentage of profit earned if the price quoted was $4,750.
In your opinion, explain the suitability of job costing method.
What are the key distinguishing features between job costing and process costing methods?

Question 6

A pharmaceutical company manufactures only one product called caviar c. The following information relates to the product:

Selling price per unit

$50

Direct material cost per unit

$6

Direct labour cost per unit

$2

Variable overhead cost per unit

$4

Sales level in units

10,000

Required;
Calculate the contribution per unit.
Calculate the number units that would be required to break-even.
Calculate the break even in dollars.
Calculate the level of activity that is required to generate a profit of, say, $40,000.
Assume that the company budgets to sell 13,000 units of it product, calculate the margin of safety in percentage.

Attachment:- Managerial Accounting.rar

Reference no: EM132977555

Questions Cloud

What is the eup for dm : Normal losses are accounted to be part of the product costs while excess loss shall be treated as period costs. What is the EUP for DM
Conduct a search on the web for mobile applications : Conduct a search on the Web for Mobile Applications. Give examples of three Mobile Applications and what business functions they may support
How much is the cost of failing to take the discount : Chinabank offers a discounted loan for 20 days at a cost of $320. How much is the cost of failing to take the discount
Estimate the current return on promotion expenditures : Estimate the current return on promotion expenditures (increase of promotion expenditures by $2m, ceteris paribus). Assume an incremental margin of 44.1%
Prepare an overhead analysis sheet : Prepare an overhead analysis sheet showing how overhead costs should be apportioned between the departments and explain reasons suggesting
What is the interest rate : What is the interest rate, r when the present value of a perpetuity is $53,200 and the payments are $10,000? The first payment occurs one year from now
How much income before income taxes hot fuss corp report : Hot Fuss leased the building to Sam's Town Company for $300,000 a year. How much income before income taxes will Hot Fuss Corp. report
Prepare the income statement for the year ended june : The present value of the lease payments is $431,213. Prepare the Income Statement for the year ended 30 June 2020
Determine the cost of ending inventory : Assume further that 50% of the remaining posters were returned to Sid incurring freight of P5,000. Determine the cost of ending inventory

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