Develop an inventory for ordering a quantity

Assignment Help Managerial Accounting
Reference no: EM132418486

Problem: Managers at Granger Fabricating Company are reviewing the economic feasibility of manufacturing a part that the company currently purchases from a supplier. Forecasted demand for this part is 12,800 units. Granger operates 250 days per year.

Granger's financial analysts established the cost of 9% for the use of funds for investments within the company. Also, over the past year $1,000,000 was the average investment in the company's inventory. Accounting information shows that a total of $45,000 was spent on taxes and insurance related to the company's inventory. Additionally, an estimated 36,000 was lost to inventory shrinkage, this included broken and damaged goods, and pilferage. $20,000 was spent on warehouse overhead, including expenses for heating and lighting.

Two hours are required to process and coordinate an order for the part regardless of the quantity ordered. Purchasing salaries average $29 per hour, including benefits. A detailed accounting analysis on 250 orders revealed that $5,225 was expensed for internet, paper and postage directly related to this ordering process.

Lead time for this part is one-week. The use of the part during the lead time is normally distributed with a mean of 130 units and a standard deviation of 18 units. The company's policy regarding stock-outs is that one stock-out per year is permitted.

The company has a current contract to purchase the part from the supplier for $26 per unit. Granger has increased its manufacturing capacity and is considering producing the part in house. The utilization of the increased capacity will produce at a rate of 3,500 units per month with up to 5 months of production time available. Management believes that with a two-week lead-time it can schedule the production of the part when needed. . The use of the part during the lead time is normally distributed with a mean of 256 units and a standard deviation of 35 units. Production costs are estimated at $23 per unit.

A major concern for the company is the fact that it will take a full 8 hour shift to set up the equipment. The total cost of labor is estimated to be $65 per hour.

Managerial Report.

Develop a managerial report as to whether the company should purchase or manufacture the part itself. It should include the following factors in the report:

1. An analysis of the holding cost.

2. An analysis of the ordering cost.

3. An analysis of setup cost.

4. Develop an inventory for ordering a quantity form the supplier and producing a quantity in house.

5. Such information as Q, number of orders/production runs, cycle time, ROP, amount of safety stock, expected maximum inventory, annual cost of the units purchase or manufactured should be included

6. A recommendation to management whether the company should purchase or manufacture the part and the cost savings associated

Reference no: EM132418486

Questions Cloud

What is its weighted average cost of capital : Assume that a not-for-profit company has $17 million of long-term tax-exempt debt with an interest rate of 3.5%. The organization
Act as a judge and offer a decision on the case : Act as a judge and offer a decision on the case, given the facts and the constitutional precedent - Guinninvs Superintendent of Mockingbird High
What are the excess capacity costs : If so, what are the excess capacity costs? How can Dr. Meara reduce the costs of excess capacity? More generally, should Dr. Meara try to reduce the costs of ex
Compare the annual population growth rate of both countries : Compare the annual population growth rate of both countries. What factors do you think are contributing to the differences observed between the two countries?
Develop an inventory for ordering a quantity : Develop an inventory for ordering a quantity form the supplier and producing a quantity in house.
Developing a marketing strategy : Developing a Marketing Strategy-Summarize key details about your organization, Perform a SWOTT analysis, Analyze the organization's mission statement and submit
Implications of the change in the structure of manufacturing : What are the implications of the change in the structure of manufacturing costs caused by the use of technology and robotics in the allocation
Define what constitutes an invasive or alien species : Define what constitutes an invasive or alien species. Why, in general, do invasive species pose such a serious problem for natural ecosystems?
Life cycles and harbourages assignment : From one of your chosen non-chemical control methods, describe in detail how you undertake this work, including tools, materials and safety concerns

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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