Determine the company predetermined budgeted overhead rate

Assignment Help Accounting Basics
Reference no: EM131456759

INTRODUCTORY MANAGEMENT ACCOUNTING ASSIGNMENT

Problem 1 -

Sunny Company specializes in processing and the distribution of a variety of blends of coffee. Sunny buys coffee beans from around the world and roasts, blends, and packages them in small one-pound bags and sells them to retail shops.

Currently the company offers 15 coffees to gourmet shops in one-pound bags. Some of the coffees are very popular and sell in large volumes; a few of the newer brands have very low volumes. Sunny prices its coffee to cover all its production cost, including allocated overhead, plus a markup of 30 percent. The company competes primarily on the quality of its products, but customers are price conscious as well.

The major cost is direct materials; however, a substantial amount of factory overhead is incurred in the predominantly automated roasting and packing process. The company uses relatively little direct labor.

Data for the 2011 budget include factory overhead of $3,000,000, which has been allocated by its current costing system on the basis of each product's direct labor cost. The budgeted direct labor cost for 2011 totals $600,000.

The budgeted direct costs for one-pound bags of two of the company's products are as follows:

 

Dark Sweet

Dark Beauty

Direct materials

$4.20

$3.20

Direct labor

0.30

0.30

Sunny's controller, Amy Chan, believes that its current product costing system could be providing misleading cost information. A team consists of members from product design, manufacturing, and accounting, is formed to use an ABC approach to refine its job-costing system. The two direct-cost categories were retained. The team decides to replace the single indirect-cost pool with six indirect-cost pools. The cost pools represent six activity areas at the facility, each with its own supervisor and budget responsibility.

The resulted 2011 budgeted factory overhead costs are as follow:

Activity

Cost Allocation Base

Budget Activity Level

Budgeted Cost

Purchasing

Purchase orders

1,158

$579,000

Materials handling

Setups

1,800

720,000

Quality control

Batches

720

144,000

Roasting

Roasting-hours

96,100

961,000

Blending

Blending-hours

33,600

336,000

Packaging

Packaging-hours

26,000

260,000

Total factory overhead cost

 

 

$3,000,000

Data regarding the 2011 production of two of its lines, Dark Sweet and Dark Beauty, follow. There is no beginning or ending direct materials inventory for either of these coffees.

 

Dark Sweet

Dark Beauty

Budgeted production volume

100,000 pounds

2,000

Number of batches

10 batches

4 batches

Number of setups

30 setups

12 setups

Number of purchase orders

4 purchase orders

4 purchase orders

Roasting time

1 hour per 100 pounds

1 hour per 100 pounds

Blending time

0.5 hour per 100 pounds

0.5 hour per 100 pounds

Packaging time

0.1 hour per 100 pounds

0.1 hour per 100 pounds

Required:

1. Using Sunny Company's current product costing system,

a. Determine the company's predetermined budgeted overhead rate using direct labor cost as the single cost driver.

b. Determine the total manufacturing costs of one pound of Dark Sweet coffee and one pound of Dark Beauty coffee. (Supporting calculations are not required)

2. Using the activity-based costing data presented above,

a. compute the cost-allocation rate for each overhead activity.

b. compute the manufacturing overhead cost per pound for the six activities of each type of coffee.

c. compute the revised total manufacturing costs of one pound of each type of coffee. (Supporting calculations are not required)

3. Comment on the results. What new insights are available with the activity-based information on (a) product costing and (b) cost reduction and process improvement?

Problem 2 -

Hong Kong Sports Corp. manufactures plastic boards used for riding the waves at the beach. The standard cost for material and labor is $89.20 per board. This includes 8 kilograms of direct materials at a standard cost of $5 per kilogram and 6 hours of direct labor at $8.20 per hour. The following data pertain to January, 2012:

  • Purchase of material: $255,440 (all materials purchased were used).
  • Total actual labor costs: $311,402.
  • Actual hours of labor: 37,700 hours.
  • Direct material efficiency variance: $1,500 unfavorable.
  • Work-in-process inventory on January 1: $0
  • Work-in-process inventory on January 31: $0
  • Units completed: 6,400 (i.e., all 6,400 units are started on January and transferred to Finished-Goods Inventory account).

Required: Compute the following amounts. Indicate whether each variance is favorable or unfavorable (supporting calculations are not required).

(1) Direct manufacturing labor price variance.

(2) Direct manufacturing labor efficiency variance.

(3) Actual kilogram of material used in the production process during January.

(4) Actual price paid per kilogram of direct material in January.

(5) Total amount of direct material and direct labor cost transferred to Finished-Goods Inventory during January.

Problem 3 -

Amigo Company has the following information for its budgeting process for June 2012.

-The ending cash balance as at May 31, 2012 is $15,000.

-The budgeted sales for June 2012 are $290,000.

-All sales are on account.

-Sales proceeds are collected as follows: 80% the month of sale, 10% the following (second) month, and 10 % the third month.

-Accounts receivable are $44,000 on May 31, 2012, consisting of $20,000 from April sales and $24,000 from May sales.

-The budgeted purchases for June 2012 are $192,000.

-The company pays 25% of purchases during the month of purchase and the remaining balance in the following month.

-Accounts payable on May 31, 2012 are $145,000.

-All operating expenses requiring cash are paid during the month of recognition, except that insurance is paid annually in December for the forthcoming year.

-The following operating expenses included in the budgeted income statement for June 30, 2012:

  • Salaries $36,000
  • Utilities 5,000
  • Marketing 10,000
  • Depreciation 1,000
  • Office expense 4,000
  • Insurance 3,000

Required: Compute the following amounts for Amigo Company for June 2012. Please show supporting calculations.

(1) Total cash collections.

(2) Total cash disbursements.

(3) Ending cash balance.

Problem 4 -

McKenna Company uses standard costing. It allocates manufacturing overhead (both variable and fixed) to products on the basis of standard direct manufacturing labor-hours (DLH). The budgeted overhead rate is calculated based on annual budgets for overhead and direct manufacturing labor-hours. The manufacturing overhead budget for 2012 is based on budgeted output of 390,000 units, which requires 1,950,000 direct manufacturing labor-hours.

During March 2012, a total of 35,750 output units were produced and total direct manufacturing labor-hours used were 170,625. Manufacturing overhead (MOH) costs incurred for March 2012 amounted to $186,500. Additional information is provided as follow:

Annual Manufacturing Overhead Budget 2012

Actual MOH Costs for March 2012

 

Annual Total

Per DLH

Budget March 2012

Variable MOH

 

 

 

 

Indirect manufacturing labor

$448,500

$0.23

$37,375

$37,375

Supplies

604,500

0.31

50,375

55,000

Fixed MOH

 

 

 

 

Supervision

331,500

0.17

27,625

26,000

Rent

273,000

0.14

22,750

27,500

Depreciation

487,500

0.25

40,625

40,625

Total

$2,145,000

$1.10

$178,750

$186,500

Required: Calculate the following amounts for McKenna Company for March 2012 (supporting calculations are not required):

a. Total manufacturing overhead costs allocated              

b. Variable manufacturing overhead spending variance

c. Fixed manufacturing overhead spending variance

d. Variable manufacturing overhead efficiency variance

e. Production-volume variance

Problem 5 - Show all supporting calculations

Part I) Cat Furniture Limited manufacturing old-fashion dinning room furniture is approached by a foreign customer to fulfill a one-time-only special order for a product similar to one offered to domestic regular customers.  Cat Furniture Limited has excess capacity in manufacturing.  No extra marketing cost will be incurred for this special order. The following per unit data apply for sales to regular customers:

Direct materials - $80

Direct labor - 40

Manufacturing support (Variable 45%; Fixed 55%) - 160

Marketing costs (Variable 35%; Fixed 65%) - 70

Selling price is equal to full cost plus 45% of full cost as mark up

Required:

1) What are the full cost and the selling price of the product per unit?

2) What is the contribution margin per unit?

3) What is the minimum acceptable price of this special order?

4)  What is the change in operating profits if the one-time-only special order for 1,000 units is accepted for $360 per unit?

5) Will you advise the management to accept the one-time-only special order at a minimum acceptable price?  Why and why not? (Consider also non-financial factors)

Part II) Dog Company manufactures a part for use in its production of automobiles. When 10,000 units are produced, the costs per unit are:

Direct materials - $ 12

Direct manufacturing labor - 60

Variable manufacturing overhead - 24

Fixed manufacturing overhead - 32

Total - 128

Money Company has offered to sell Dog Company 10,000 units of the part for $120 per unit.  If Dog Company  accepts  the  supplier's  offer,  the  plant  facilities  could  be  used  to  manufacture  another product with expected revenue of  $180,000.  In addition, $20 per unit of fixed manufacturing over­head on the original part would be eliminated.

Required: What is the relevant per unit cost for the original part? Which alternative (financially) is better for Dog Company? Show your supporting calculations.

Reference no: EM131456759

Questions Cloud

Business career involving international assignments : In 200 - 300 words, what can you do to prepare yourself for a business career involving international assignments?
Do the largest companies differ in performance from others : The Wall Street Journals Shareholder Scoreboard tracks the performance of 1000 major U.S. companies (The Wall Street Journal, March 10. 2003).
Sources of financing for healthcare organizations : Sources of financing for healthcare organizations change over time. Historically, many donors often provide financial assistance to the organization.
Quality dimension and measures table : Open your web browser and research the six dimensions identified by the Institute of Medicine (IOM) that are used to measure high-quality care.
Determine the company predetermined budgeted overhead rate : ACCT2121A-O INTRODUCTORY MANAGEMENT ACCOUNTING ASSIGNMENT. Determine the company's predetermined budgeted overhead rate
Consideration the external and internal environments : Strategic goals flow from the company's mission statement and take into consideration the external and internal environments.
Determining the management tools : PART III: What are some time management tools you can present to your employees.
Different types of research methodologies : Explain the different types of research methodologies used in the health sciences.
Provide an overview of the statute : Labor relations and collective bargaining are significant challenges within the organization and when not addressed properly will cause issues.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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