Calculate price variances for material and labor

Assignment Help Cost Accounting
Reference no: EM13794508

Section I: Cost-Volume-Profit Analysis

The Hampshire Company manufactures umbrellas that sell for $12.50 each. In 2014, the company made and sold 60,000 umbrellas. The company had fixed manufacturing costs of $216,000. It also had fixed costs for administration of $79,525. The per-unit costs of each umbrella are as follows:

Direct Materials: $3.00
Direct Labor: $1.50
Variable Manufacturing Overhead: $0.40
Variable Selling Expenses: $1.10

Using the information above, perform a cost-volume-profit (CVP) analysis by completing the steps below. All CVP calculations should be completed in the Hampshire CompanySpreadsheet. Note: The CVP analysis satisfies Part A of Section I.

1. Compute net income before tax.
2. Compute the unit contribution margin in dollars and the contribution margin ratio for one umbrella.
3. Calculate the break-even point in units and dollars of revenue. Note: This is a required part of the CVP analysis and satisfies Part C of

Section I.

4. Calculate the margin of safety:
a. In units
b. In sales dollars
c. As a percentage
5. Calculate the degree of operating leverage.
6. Assume that sales will increase by 20% in 2015. Calculate the percentage of before-tax incomefor this increase. Provide calculations to prove that your percentage increase is correct based on the operating leverage calculated in step 5.
7. Compute the number of umbrellas that Hampshire is required to sell if it plans to earn $150,000 in income before taxes by using the target income formula. Proof your calculation.
8. A company that specializes in tours in England has offered to purchase 5,000 umbrellas at $11 each from Hampshire. The variable selling costs of these additional units will be $1.30 as opposed to $1.10 per unit. Also, this production activity will incur another $15,000 of fixed administrative costs. Should Hampshire agree to sell these additional 5,000 umbrellas to the touring business? Provide calculations to support your decision.

Additionally,complete Parts B and D ofSection I as outlined in the Final Project Guidelines and Rubric document.

Section II: Inventory Management

The information below represents the beginning and ending inventory amounts along with the production and sales for the month in umbrella units.

Beginning Inventory: 0 Umbrellas
Production: 80,000 Umbrellas
Sales: 60,000 Umbrellas
Ending Inventory: 20,000 Umbrellas

Using the information provided above and the costs and sales information provided in SectionI, complete the followingin the Hampshire CompanySpreadsheet in order to assist you in responding to all components of Section II:

• Prepare a variable costing income statement.
• Prepare an absorption costing income statement.

Additionally,complete Parts A through E ofSection IIas outlined in the Final Project Guidelines and Rubric document.

Section III: Benchmarking

The management of the Hampshire Company would like to implement benchmarking. Standard costs have been established and are presented below. You will want to complete a variance analysis to include efficiency and price variances for materials (cloth and handle assemblies) and labor based on the following data:

Units Produced = 80,000
Units Sold = 60,000

Direct Materials Purchased and Used
Actual square yards of cloth purchased and used: 128,000
Actual price incurred per yard: $1.25

Actual handles purchased and used: 80,808
Actual price per handle/rib/stretcher assembly: $0.99

Direct Manufacturing Labor Used
Actual direct labor hours used: 15,748
Actual price per hour: $7.62
Direct labor costs: $120,000


Standard Rates
Standard labor hours per unit: 0.20
Standard labor price per hour: $7.50
Square yards material per unit: 1.50
Standard price per yard: $1.15
Handle/rib/stretcher assembly per unit: 1
Standard price per handle assembly: $1.05

Companies can use variance analysis and benchmarking to measure performance within their own company and against competitors. This can be done by setting standards/budgets and comparing a completed variance analysis to results from prior periods or comparing them to competitors' results. Using the information provided above, complete the following calculations (steps 1 and 2) in the Hampshire CompanySpreadsheet. This will assist you in responding to all components of Section III.

1. Calculate price variances for material and labor and denote whether they are favorable or unfavorable.
2. Calculate efficiency variances for material and labor and denote whether they are favorable or unfavorable.

In order to measure performance and make use of the variance analysis completed, management understands the need to compare results with their competitors. Following the steps outlined below, you will research benchmarking and propose the most effective approach for your company. Respond to Parts A through C of Section III as outlined in the Final Project Guidelines and Rubric document.

Section IV: Alternative Costing Method

Hampshire has always produced stick umbrellas. However, it is considering expanding its production to include collapsible umbrellas. This consideration has been spurred by Tours Today, a touring company that is interested in providing its customers with collapsible umbrellas imprinted with its logo. The management at Hampshire is currently working out a deal with the touring company to produce 3,000 collapsible umbrellas and believes it can sell those umbrellas for $14.00 each. Here are the costs that can be directly traced to this special order:

Direct Materials: $9,300
Direct Labor Hours: 600
Hourly Rate of Direct labor: $8.00

In the traditional costing approach, overhead is applied at the rate of $24.60 per labor hour. This expansion in production will add additional overhead costs. The total overhead costs (assuming production of the stick and collapsible umbrellas) to include the cost pools and cost drivers are provided in Table 2.

An alternative costing method that might benefit Hampshire is the implementation of activity-based costing (ABC). Hampshire would like to implement an ABC approach to analyze the production of this special order of collapsible umbrellas. The controller has assembled the following information:


Stick

Collapsible

Units Sold

60,000

3,000

Selling Price

$12.50

$14.00

Direct Material Cost per Unit

$3

$3.10

Direct Labor Cost per Hour

$7.50

$8.00

Variable Manufacturing Overhead

$0.40

$0.40

Variable Selling Costs

$1.10

$1.10

Labor Hours per Unit

0.2

0.2

Sales Orders

120

1

Purchase Orders

50

3

Production Runs

45

6

Material Moves

86

10

Machine Setups

130

6

Machine Hours

525

32

Inspections

200

10

Shipments

60

3


Table 1: Direct Cost Information and Activities

Activity

Activity Cost

Activity Cost Driver

Order Processing

$35,000

Number of Sales Orders

Purchasing

$36,000

Number of Purchase Orders

Material Handing

$28,000

Material Moves

Machine Setup

$14,000

Machine Setups

Production

$99,000

Production Runs

Assembly

$80,000

Machine Hours

Inspecting

$11,000

Number of Inspections

Shipping

$7,500

Number of Shipments

Table 2: Activity Cost Pools and Cost Drivers

Another alternative to traditional costing and ABC is time-driven activity-based costing (TDABC). You will need to determine which of these three methods would be the best approach for theHampshire Company. The following article may assist you in your analysis: Time-Driven Activity-Based Costing. Additionally, you may want to use the Shapiro Library to conduct further research on the three methods. You will need to defend your position when answering the prompts for the written portion of this section.

Using the information provided above, complete the following in the Hampshire CompanySpreadsheet in order to assist you in responding to all components of Section IV:

1. Calculate the allocation rates for each cost driver using ABC.
2. Use the traditional costing approach to calculate the total cost and the unit cost of the stick and collapsible umbrellas.
3. Use ABC to compute the total costs and the unit cost for the stick and collapsible umbrellas.
4. Compute the difference between the product cost per stick and collapsible umbrellas using the unit cost that you computed with the traditional approach and the one that you computed using ABC.

Based on your calculations from steps 1-4, respond to Parts A through C in Section IV as outlined in the Final Project Guidelines and Rubric document.

Section V: Memo to Management

The management of the Hampshire Company is very interested in measuring performance. They would like you to recommend a strategy to increase business performance. They are not sure whether they should focus on product differentiation or cost leadership. Research additional performance tools to include the balanced scorecard. During your research, consider what performance measurements you would use based on the four perspectives. Provide examples.

In your recommendation, you will want to include the outcome of your previous quantitative analysis and research performed related to cost-volume-profit (CVP), variable and absorption costing, just-in-time (JIT), standard costs, variances, and benchmarking. You will want to review key points and make recommendations based on your current research and prior analysis completed and research performed.

Your two- to three-page memo to management must be submitted as a Word document and must include your responses to Parts A through C of Section V as outlined in the Final Project Guidelines and Rubric document.

Reference no: EM13794508

Questions Cloud

Write summary of the article indian sovereignty an overview : Write a summary of tyhe two articles "Indian Sovereignty: An Overview" by Robert Bryce and "Indian Sovereign Immunity Should Be Restricted" bu James M. Johnson.
Demonstrates knowledge of the fundamental subject areas : Compose a theoretically sound and conceptually rich essay that demonstrates knowledge of the fundamental subject areas of the student's academic discipline and specialization. Curriculum and Teaching
When the boat starts moving upstream : When the boat starts moving upstream, a float was dropped from it. The boat travels 4.2 kms and returns and reaches the float.
Case study on stopping outshopping : Stopping Outshopping
Calculate price variances for material and labor : Prepare a variable costing income statement - Prepare an absorption costing income statement and calculate price variances for material and labor and denote whether they are favorable or unfavorable.
What can a coherent question provide for you : What can a coherent question provide for you? What is the BEST reason to compose "healthy paragraphs" based on an article?
Paper on business initiative and technology : paper on Business Initiative and Technology
Social entrepreneurship and social responsibility : Social Entrepreneurship and Social Responsibility
Use of advocacy to impact change : Discuss how the health education community sought to assess and address community needs.

Reviews

Write a Review

 

Cost Accounting Questions & Answers

  Compute interest on loans

Neka also instructed the programmer to use a 360-day year to compute interest on loans (receivables). Discuss whether Neka is behaving in a professional manner.

  Evaluate the 2010 cash-basis net income

Evaluate the 2010 cash-basis net income and evaluate the 2010 accrued-basis net income (show calculations)

  Estimate value of the stock using the gordon model

Explain the relationship observed between the required rate of return, growth rate and the dividend paid, and the estimated value of the stock using the Gordon Model.

  Cost recovery deductions for tax purposes

Principal business activity is plumbing installation and repair and its business code number is 238220. It files its income tax returns on this calendar-year basis.The partnership requires maximizing its cost recovery deductions for tax purposes

  Do you agree with the proponents of the exclusion

To date, Congress has concluded that the benefits gained by the states and municipalities and their residents, such as access to capital and the creation of jobs to construct and maintain critical infrastructure, outweigh any damages to our progre..

  Calculate the cost of inventory reported on balance sheet

The total merchandise on hand at the end of the year as determined by taking a physical inventory is $55,000. Of the $55,000, $7,000 is held on consignment.

  Evaluate the breakeven point in pillows

Evaluate the breakeven point in pillows and evaluate breakeven level in pillows, assuming the selling price goes up by 10 percent, fixed manufacturing costs decline by 10 percent, and other fixed costs decline by $100?

  Example on implicit interest and incremental borrowing rate

Example on implicit interest rate and incremental borrowing rate

  Extra paid-in capital of parent company

Popper did not get any of this newly issued stock. How would this transaction affect the extra paid-in capital of parent company?

  Prepare a production budget and a direct labor budget

Prepare a production budget and a direct labor budget for Donnegal Company by month and for the first quarter of the year. The direct labor budget should include direct labor hours

  Rhinestone company has a sales budget for subsequently

rhinestone company has a sales budget for subsequently month of 300000. cost of goods sold is expected to be 40 of

  Determine the cost of units started and completed

The following information concerns production in the Forging Department for September. All direct materials are placed into the process at the beginning of production, and conversion costs are incurred evenly throughout the process. The beginni..

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