1. Assuming that the company will continue purchasing the part: a) The economic order quantity b) Total annual inventory holding cost c) Total annual ordering cost d) Total annual purchasing cost e) Total annual holding, ordering and purchasing cost

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Can i get help with question 1 and 2....or just 1 

Managers at ABC, Inc. are reviewing the economic feasibility of manufacturing a part that the
company currently purchases from a supplier. Forecasted annual demand for the part is 3300
units. ABC operates 250 days per year.
3. Make a detailed recommendation as to whether the company should purchase or
manufacture the part. Explain why? Give at least three reasons why.
a) Reason 1
b) Reason 2
c) Reason 3
ABC's financial analysts established a cost of capital of 10% for the use of funds for
investments within the company. In addition, over the past year S500,000 was the average
investment in the company's inventory. Accounting information shows that a total of $24,000
was spent on taxes and insurance related to the company's inventory. In addition, an estimated
$9000 was lost due to inventory shrinkage, which included damaged goods as well as
pilferage. A remaining $15,000 was spent on warchouse overhead, including utility expenses
for heating and lighting.
An analysis of the purchasing operation shows that approximately four hours are required to
process and coordinate an order for the part regardless of the quantity ordered. Purchasing
salaries average S28 per hour, including employee benefits. In addition, a detailed analysis of
125 orders showed that $2375 was spent on telephone, paper, and postage directly related to
the ordering process.
Currently, the company has a contract to purchase the part from a supplier at a cost of $22 per
unit. However, over the past few months, the company's production capacity has been
expanded. As a result, excess capacity is now available in certain production departments, and
the company is considering the alternative of producing the parts itself.
Forecasted utilization of cquipment shows that production capacity will be available for the
part being considered. The production capacity is available at the rate of 1000 units per month.
Production costs are expected to be $20 per part.
A concern of management is that setup costs will be substantial. The total cost of labor and lost
production time is estimated to be S70 per hour, and a full eight-hour shift will be needed to
set up the equipment for producing the part.
Managerial Report
Develop a report for management of ABC that will address the question of whether
the company should continue to purchase the part from the supplier or begin to
produce the part itself. Include the following factors in your report:
1. Assuming that the company will continue purchasing the part:
a) The economic order quantity
b) Total annual inventory holding cost
c) Total annual ordering cost
d) Total annual purchasing cost
e) Total annual holding, ordering and purchasing cost
2. Assuming that the company will start making the part:
a) The economic production quantity
b) Total annual inventory holding cost
c) Total annual setup cost
d) Total annual manufacturing cost
e) Total annual holding, setup and manufacturing cost
1
2
Transcribed Image Text:Managers at ABC, Inc. are reviewing the economic feasibility of manufacturing a part that the company currently purchases from a supplier. Forecasted annual demand for the part is 3300 units. ABC operates 250 days per year. 3. Make a detailed recommendation as to whether the company should purchase or manufacture the part. Explain why? Give at least three reasons why. a) Reason 1 b) Reason 2 c) Reason 3 ABC's financial analysts established a cost of capital of 10% for the use of funds for investments within the company. In addition, over the past year S500,000 was the average investment in the company's inventory. Accounting information shows that a total of $24,000 was spent on taxes and insurance related to the company's inventory. In addition, an estimated $9000 was lost due to inventory shrinkage, which included damaged goods as well as pilferage. A remaining $15,000 was spent on warchouse overhead, including utility expenses for heating and lighting. An analysis of the purchasing operation shows that approximately four hours are required to process and coordinate an order for the part regardless of the quantity ordered. Purchasing salaries average S28 per hour, including employee benefits. In addition, a detailed analysis of 125 orders showed that $2375 was spent on telephone, paper, and postage directly related to the ordering process. Currently, the company has a contract to purchase the part from a supplier at a cost of $22 per unit. However, over the past few months, the company's production capacity has been expanded. As a result, excess capacity is now available in certain production departments, and the company is considering the alternative of producing the parts itself. Forecasted utilization of cquipment shows that production capacity will be available for the part being considered. The production capacity is available at the rate of 1000 units per month. Production costs are expected to be $20 per part. A concern of management is that setup costs will be substantial. The total cost of labor and lost production time is estimated to be S70 per hour, and a full eight-hour shift will be needed to set up the equipment for producing the part. Managerial Report Develop a report for management of ABC that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself. Include the following factors in your report: 1. Assuming that the company will continue purchasing the part: a) The economic order quantity b) Total annual inventory holding cost c) Total annual ordering cost d) Total annual purchasing cost e) Total annual holding, ordering and purchasing cost 2. Assuming that the company will start making the part: a) The economic production quantity b) Total annual inventory holding cost c) Total annual setup cost d) Total annual manufacturing cost e) Total annual holding, setup and manufacturing cost 1 2
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Types of Scheduling
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.