Quantitative analysis on the current state push numbers in

Assignment Help Accounting Basics
Reference no: EM13576241

It is currently busy season at the professional service firm. You are currently juggling multiple clients, working 12 hour days, when approached by one of the senior partners at the firm. "I need your help for a very high profile client in our firm. This client contributes a great deal of revenue so I have compiled the best resources to work on this engagement together. Please meet me in the boardroom in 5 minutes where I will introduce you to the rest of your engagement team and explain the client's needs".

Innovate Solutions Inc. produces a wide variety of drums for shipment of liquids and powders. The two most common types of drums are the open top and the welded top. These drums are manufactured using injection blow molding technology and have either a separate lid or a welded type top with the bung holes molded in. Metal drums are manufactured with steel hot-rolled into long pipe-like sections then forged on a stamping press while still red-hot into drum bodies. A welded rolled seam is then made for the drum bottom, or both top and bottom. In this industry, client relationships and product quality are important for reoccurring business.

One of the company's products is a heavy-duty, environmentally friendly, corrosion-resistant metal drum, called the Stronghold drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 4,500 hours of welding time is available annually on the machine. Since each drum requires 0.6 hours of welding time, annual production is limited to 7,500 drums. At present, the welding machine is used exclusively to make the Stronghold drums. The accounting department has provided the following financial data concerning the Stronghold drums:

Stronghold Drums

Selling price per drum

$225.00

Cost per drum:


Direct materials

$78.15

Direct labor ($27 per hour)

5.40

Manufacturing overhead

6.75

Selling and administrative expense

44.70

Margin per drum

$90.00

Management believes that 9,000 stronghold drums could be sold each year if the company had sufficient manufacturing capacity. As an alternative to adding another welding machine, management has considered buying additional drums from an outside supplier of quality products, Barrels of Fun (BoF), Inc. BoF would be able to provide up to 6,000 Stronghold-type drums per year at a price of $207 per drum, which Innovate would re-label and sell to its customers at its normal selling price.

Sarah Miller, Innovate's production manager, has suggested that the company could make better use of the welding machine by manufacturing wrought iron park benches, which would require 0.75 hours of welding time per bench and yet sell for far more than the drums. Sarah believes that Innovate could sell up to 2,400 wrought iron park benches per year to municipalities and conservation areas at a price of $360 each. The Accounting Department has provided the following data concerning the proposed new product:

Wrought Iron Park Benches

Selling price per bench

$360.00

Cost per bench:


Direct materials

$149.10

Direct labor ($27 per hour)

43.20

Manufacturing overhead

54.00

Selling and administrative expense

71.70

Margin per drum

$42.00

The park benches could be produced with existing equipment and personnel. Manufacturing overhead is allocated to products on the basis of direct labor-hours. Most of the manufacturing overhead consists of fixed common costs such as rent on the factory building, but some of it is variable. The variable manufacturing overhead has been estimated at $2.00 per Stronghold drum and $2.85 per park bench. The variable manufacturing overhead cost would not be incurred on drums acquired from the outside supplier. Regardless of the in-house option chosen, efficient productivity of resources is critical for success.

Selling and administrative expenses are allocated to products on the basis of revenues. Almost all of the selling and administrative expenses are fixed common costs, but it has been estimated that variable selling and administrative expenses amount to $1.15 per Stronghold drum whether made or purchased and would be $1.95 per park bench.

All of the company's employees-direct and indirect-are paid for full 40-hour workweeks and the company has a policy of laying off workers only in major recessions. However Sarah miller is also wondering what the impact would be of eliminating full time contracts using employees as needed on an hourly basis.

REQUIRED:

  1. Quantitative Analysis on the current state: (EXCEL SPREADSHEET) Push numbers in an analysis that is relevant to the issue at hand. Differentiate between what is relevant and what is irrelevant.
  2. Qualitative Analysis on the current state: (EXCEL SPREADSHEET)  Be sure to analyze qualitative issues - they need discussion in most cases. In particular, analyze alternatives in light of key success factors - will this alternative solve the problem and fit with our key success factors.

Reference no: EM13576241

Questions Cloud

Both the reported value of longt-term and periodic interest : both the reported value of longt-term and periodic interest charges should be based on unamortized issue price and
Indicate the reporting of the 2012 pension amounts in the : complete the following exercise. submit journal entries in an excel file and written segments in an ms word document.
For simplicity assume that the demand increase and margins : investing 2000000 in tqms channel support systems initiative will at a minimum increase demand for your products 1.7 in
Right foot shoes issued a two-year 46000 interest-bearing : right foot shoes issued a two-year 46000 interest-bearing note on january 1 2008 in exchange for new equipment.
Quantitative analysis on the current state push numbers in : it is currently busy season at the professional service firm. you are currently juggling multiple clients working 12
In addition to the expenses listed above kim could have : during the current year kim incurs the following expenses with respect to her beachfront condominium in hawaiiitems
Te professor gathers information from a random sample of : a professor is interested in whether there is a difference in counseling students statistics competency scores among
Assume all of the same facts as in part a except that : roberta is an accountant employed by a local firm. during the year roberta incurs the following unreimbursed
What would you expect to happen to the price of their stock : xyz corp. has 1000 shares outstanding and retained earnings of 25000 dollars. what would you expect to happen to the

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