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

  About the residual distribution model

Puckett Products is planning for $4.7 million in capital expenditures next year. Puckett's target capital structure consists of 60% debt and 40% equity. If net income next year is $2.5 million and Puckett follows a residual distribution policy with a..

  Prepare financial analysis

Prepare financial analysis of a chosen company Samsung Electronics a global telecommunications based company and the ticker symbol is Samsung Electronics Co.Ltd. SSNLF.

  About the future value of this cash flow stream

If you receive $2,590 at the end of each year for the first three years and $627 at the end of each year for the next two years. What is the future value of this cash flow stream? Assume interest rate is 6%.

  What he will earn by paying taxes prior to deposit

Timothy Clum is in the 25 percent tax bracket and is considering the tax consequences of investing $2,000 at the end of each year for 30 years, assuming the investment earns 8 percent annually. What is the amount of earnings that Timothy gives up by ..

  While checking the wall street journal bond listings

While checking the Wall Street Journal bond listings you notice that the price of an AT&T bond is the same as the price of a K-Mart bond. Based on this information you know that

  Calculate the differences in cost and risk

Explain with examples how the cost of capital is determined. Calculate the differences in cost and risk. Explain why the costs and risks of external financing are important for the organization to understand. Explain why rapid growth plans are import..

  From the attached list choose an institution for your final

from the attached list choose an institution for your final project that has not yet been chosen by a classmate check

  To minimize collection float

To minimize collection float, a firm should do which of the following?

  Calculate the depreciation tax shield for project in year

Your firm needs a computerized machine tool lathe which costs $49,000 and requires $11,900 in maintenance for each year of its 3-year life. After three years, this machine will be replaced. The machine falls into the MACRS 3-year class life category...

  Considering the introduction of a new product line

Your company is considering the introduction of a new product line. The initial investment required for this project is $500,000, and annual maintenance costs are anticipated to be $35,000. Annual operating cost will be directly in proportion to the ..

  How many in dividends were paid to shareholders

New Money inc. reported $50 million of net income and $770 of retained earnings. the previous retained earnings were $780. How many in dividends were paid to shareholders during that year? Assume that all dividends declared were paid.

  Value on the ownership position in briarwood hospital

What impact would change have on the equity value of the business and what if the growth rate were only 2 percent?

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