Calculate the predetermined overhead rate for 2013

Assignment Help Financial Management
Reference no: EM13907191

1. Calculate the predetermined overhead rate for 2013 and the amount of over/under applied overhead applicable to January. Overhead is applied based on direct labor costs. Assume that the actual overhead incurred in the month is $705,000.

The Fabulous Widget Company has been producing a single product, called the computer widget, since 1995. A black generic widget, which was the company's original product, is produced for general consumption and is sold through major computer stores. In 2010, a new line of brightly colored computer widgets (red, purple and green) was introduced. Widgets produced for this market are designed to meet specific requirements of the buyer.

The black widget is produced evenly (1,400,000 units) throughout the year with approximately 116,500 units produced each month in a single production run. To maintain quality, at the end of each month, the system is stopped, any required maintenance is performed and a new run is set up for the next month. The specialty widgets are produced on demand in runs ranging from 5,000 to 100,000 units. At the start of each specialty widget production run, the production system is modified to meet specifications and maintenance is performed. The company uses a job order costing system to account for manufacturing costs for both product lines.

The black widget is a solid seller but there has been no increase in sales over the last three years. On the other hand, the specialty widget is a very popular product. Since its introduction, production volume has almost double each year. For the next year, company management expects demand to slow slightly but they still expect an annual increase of 20%.

The selling price for both the black widgets and the specialty widgets has been set at $13.00 per unit. The company believes that the markup is appropriate for both products. The $13 selling price for the black widget was believed to be most that the market will bear given the competition. Competitors currently produce a similar product. In the past few months, the competitors' selling price has been dropped to $12 per unit. The lower selling price of the competitors is expected to have an impact on FWC sales of the black widget within 6 months. The specialty widgets might support a higher price given the dramatic increase in demand but the company is unwilling to increase the price since it fears new competition if the unit margin is higher. No competition exists in the specialty market as of yet but the CEO does not expect this to last indefinitely.

The following information is provided on the production over the past two years as well as the unit costs. The decline in unit costs is due solely to an economy of scale as the fixed costs are applied over more units. Sales information for the past two years is also presented in the second schedule. The company is pleased to see the turnaround in profits. The introduction of the specialty widgets in 2010 apparently caused the company to initially experience a slid in earnings but over the past two years, the company has shown a significant increase in earnings and the profit percentage.

Production process: One department, forming /assembling, is used to produce the widgets. Materials costs are added at the beginning of the process and direct labor costs are added to each job during the month as these costs are incurred. Overhead is applied as each job is completed and moved to finished goods. If jobs are incomplete at the end of the month, overhead is also applied to the incomplete jobs based on the amount of direct labor costs that have been attached to that job. As the incomplete job is finished during the next month, additional overhead is applied in relation to the amount of additional direct labor costs that is attached to the job during the new month. The budgeted production for 2013 is 2,660,000 units. This is a static level of production in black widgets (1,400,000 units) and a 20% increase in specialty widgets (1,260,000).

Overhead application. Overhead is applied based on direct labor costs in each department. At the beginning of the current year, the Company estimated that total overhead for the forming /assembling department would be $13,500,000. Total direct labor costs were estimated to be $3,990,000. Any under/over applied overhead is assumed to be immaterial and is assigned to cost of goods sold at the end of each month. The Company currently applies overhead to production based on a single plant-wide rate. The application rates used during the past two years are as follows: 2011 - 239% and 2010 - 292%.

In the third schedule, information is provided about the beginning work in process inventory, the jobs started during the month, and the jobs completed and moved to finished goods. There is no job in beginning finished good inventory (January 1, 2013). The direct material attached to the beginning WIP is 100% of the materials to be added. The direct labor and overhead has been added according to the percentage given. Additional labor and overhead will be added to the jobs as they are completed and moved to finished goods.

Plant-wide overhead application rate.

1. Calculate the predetermined overhead rate for 2013 and the amount of over/under applied overhead applicable to January. Overhead is applied based on direct labor costs. Assume that the actual overhead incurred in the month is $705,000.

 

2012

Percentage

2011

Percentage

Sales

     31,850,000

100.00%

     26,130,000

100.00%

COGS

     22,503,250

70.65%

     20,059,800

76.77%

 Gross profit

        9,346,750

29.35%

       6,070,200

23.23%

Operating expenses

 

 

 

 

Selling commission

        2,548,000

8.00%

       2,090,400

8.00%

Other selling

        2,500,000

7.85%

       2,500,000

9.57%

Administrative expense

        3,578,000

11.23%

       3,578,000

13.69%

  Operating expenses

        8,626,000

27.08%

       8,168,400

31.26%

Operating income

           720,750

2.26%

     (2,098,200)

-8.03%

 

 

2012

2011

Units sold

1,400,000

1,050,000

1,400,000

610,000

Product costs

Black

Specialty

Black

Specialty

Direct material

  4.10

            4.10

           4.10

4.10

Direct labor

1.50

            1.50

           1.50

1.50

Overhead

3.59

            3.59

           4.38

4.38

 Unit cost

9.19

            9.19

           9.98

9.98

Reference no: EM13907191

Questions Cloud

Assume that polaris snowmobile division is charged : Assume that Polaris snowmobile division is charged with preparing a master budget.
List of command line arguments : Write a program that takes a list of command line arguments, each of which is a full path of a command (such as /bin/ls, /bin/ps, /bin/date, /usr/bin/who, /bin/unameetc). Assume the number of such commands is N, your program would then create N ch..
Montel company''s july sales budget calls for sales : Montel Company's July sales budget calls for sales of $ 600,000. The store expects to begin July with $ 50,000 of inventory and to end the month with $ 40,000 of inventory.
Combination of memory technologies : Give an example of how an operating system may use a combination of memory technologies with varying speeds, capacities and costs to achieve overall good performance at acceptable cost.
Calculate the predetermined overhead rate for 2013 : Calculate the predetermined overhead rate for 2013 and the amount of over/under applied overhead applicable to January. Overhead is applied based on direct labor costs. Assume that the actual overhead incurred in the month is $705,000.
Lighthouse company anticipates total sales : Lighthouse Company anticipates total sales for June and July of $ 420,000 and $ 398,000, respectively.
What is the cumulative earned value at the end of week three : What is the cumulative earned value at the end of week 3? For those familiar with the DoD and PMI terminology, this is the BCWP. Using data from Tables 1 3, what is the Cost Performance Index at the end of week 3?
Size of an uncompressed text : Suppose the size of an uncompressed text file is 1 megabyte. How long does it take to download the file over a 32 Kilobit per second modem? How long does it take to take to download the file over a 1 megabit per second modem?
What barriers to success might people with disabilities : What barriers to success might people with disabilities

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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