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

  Unrealized holding gain on securities

On January 2, 2010, it purchased for cash $25,300 of equity securities that it classified as available-for-sale. It received cash dividends of $4,070 during the year on these securities. In addition, it has an unrealized holding gain on these secu..

  Direct write-off method of accounting problem

Journalize the following transactions using the direct write-off method of accounting for uncollectible receivables.

  Computing amount of sales revenue

Complete the sales budget by filling in the missing amounts. Determine the amount of sales revenue Camtech will report on its second quarter pro forma income statement.

  How much in dividends will the company declare at the end

At the end of fiscal year 2010, the Acme Company wishes to declare $50,000 in common stock dividends. They currently have 100,000 shares of common stock outstanding and 5,000 shares of $100 par value, 5%, cumulative preferred stock.

  Prepare the liabilities section of life inc balance sheet

Prepare the liabilities section of life Inc balance sheet of Dec 31, 2012 to show how the company report these items, report current liabilities and total liabilities.

  A company must incur annual fixed costs of 4000000 and

a company must incur annual fixed costs of 4000000 and variable costs of 400 per unit and estimates that it can sell

  How many boxes does gentry expect to purchase

Gentry Company produces speaker systems for trucks. Estimated sales (in units) in January are 20,000; in February 25,000; and in March 22,000. Each unit is priced at $45. Gentry wants to have 25% of the following month's sales in ending inventory.

  Assuming a current ratio of 10 how will the purchase of

assuming a current ratio of 1.0 how will the purchase of inventory with cash affect the ratio? a. increase the current

  Journal entries and conversion of bonds

Prepare the journal entries for the June 30, 2013, interest payment by Madison and the conversion of the bonds (book value method).

  What is the motivation behind the tax departments

as of december 30 2009 robin corporation a calendar year taxpayer has gross income from operations of 497000 expenses

  Affecting retained earnings

Which of the following will not affect retained earnings?

  Abraham inc a new jersey corporation operates 57 bakeries

abraham inc. a new jersey corporation operates 57 bakeries throughout the northeastern section of the united states. in

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