
A manager is trying to decide whether to purchase a certain part or to have it produced internally. Internal production could use either of two processes. One would entail a variable cost of $17 per unit and an annual fixed cost of $200,000; the other would entail a variable cost of $14 per unit and an annual fixed cost of $240,000. Three vendors are willing to provide the part. Vendor A has a price of $20 per unit for any volune up to 30,000 units. Vendor B has a price of $22 per unit for demand of 1,000 units or less, and $18 per unit for larger quantities. Vendor C offers a price of $21 per unit for the first 1,000 units, and $19 per unit for additional units.
a)

To determine: The best alternative from a cost standpoint for an annual volume of 10,000 units and 20,000 units.
Introduction: Decision-making is the process that helps to make decision. It is the process of choosing a best alternative by evaluating many alternatives.
Answer to Problem 8P
Explanation of Solution
Given information:
A manager has to decide whether to purchase a product or produce it internally. Internal production consists of two processes. Variable cost and fixed cost of the first process is $17 and $200,000 respectively. Variable cost and fixed cost of the second process is $14 and $240,000 respectively.
There are three vendors available to purchase a product. Vendor A has a price of $20 per unit up to 30,000 units. Vendor B has a price of $22 per unit if the demand is 1,000 units or less and $18 for larger volumes. Vendor C has a price of $21 per unit for first 1,000 units and $19 per unit for additional units.
Determine the best alternative from a cost standpoint for an annual volume of 10,000 units:
Calculate the total cost for the first internal process:
It is calculated by adding the fixed cost with the value attained by multiplying the variable cost and the annual volume. Annual volume is given as 10,000 units. Hence, the total cost for the first internal process is $370,000.
Calculate the total cost for the second internal process:
It is calculated by adding the fixed cost with the value attained by multiplying the variable cost and the annual volume. Annual volume is given as 10,000 units. Hence, the total cost for the first internal process is $380,000.
Calculate the total cost for the Vendor A:
It is calculated by multiplying the price and the annual volume. Hence, the total cost for Vendor A is $200,000.
Calculate the total cost for the Vendor B:
It is calculated by multiplying the price and the annual volume. It is given that the price is $22 if the volume is less than 1,000 and $18 if the volume is larger. As the annual volume is more than 1,000, the price is $18. Hence, the total cost for Vendor B is $180,000.
Calculate the total cost for the Vendor C:
It is calculated by multiplying the price and the annual volume. It is given that the price is $21 for the volume up to 1,000 and $19 for the additional volume. Thus, price is $21 for the 1,000 units and $19 for additional 9,000 units. Hence, the total cost for Vendor C is $192,000.
At the annual volume of 10,000 units, Vendor B has the lowest total cost of ($180,000). Hence, it should be chosen from a cost standpoint.
Determine the best alternative from a cost standpoint for an annual volume of 20,000 units:
Calculate the total cost for the first internal process:
It is calculated by adding the fixed cost with the value attained by multiplying the variable cost and the annual volume. Annual volume is given as 20,000 units. Hence, the total cost for the first internal process is $540,000.
Calculate the total cost for the second internal process:
It is calculated by adding the fixed cost with the value attained by multiplying the variable cost and the annual volume. Annual volume is given as 20,000 units. Hence, the total cost for the first internal process is $520,000.
Calculate the total cost for the Vendor A:
It is calculated by multiplying the price and the annual volume. Hence, the total cost for Vendor A is $400,000.
Calculate the total cost for the Vendor B:
It is calculated by multiplying the price and the annual volume. It is given that the price is $22 if the volume is less than 1,000 and $18 if the volume is larger. As the annual volume is more than 1,000, the price is $18. Hence, the total cost for Vendor B is $360,000.
Calculate the total cost for the Vendor C:
It is calculated by multiplying the price and the annual volume. It is given that the price is $21 for the volume up to 1,000 and $19 for the additional volume. Thus, price is $21 for the 1,000 units and $19 for additional 19,000 units. Hence, the total cost for Vendor C is $382,000.
At the annual volume of 20,000 units, Vendor B has the lowest total cost of ($360,000). Hence, it should be chosen from a cost standpoint.
b)

To determine: The range of the best alternative.
Introduction:Decision-making is the process that helps to make decision. It is the process of choosing a best alternative by evaluating many alternatives.
Answer to Problem 8P
Explanation of Solution
Given information:
A manager has to decide whether to purchase a product or produce it internally. Internal production consists of two processes. Variable cost and fixed cost of the first process is $17 and $200,000 respectively. Variable cost and fixed cost of the second process is $14 and $240,000 respectively.
There are three vendors available to purchase a product. Vendor A has a price of $20 per unit up to 30,000 units. Vendor B has a price of $22 per unit if the demand is 1,000 units or less and $18 for larger volumes. Vendor C has a price of $21 per unit for first 1,000 units and $19 per unit for additional units.
Cost function for each alternative if the annual volume is 1-1,000 units:
First internal process:
Second internal process:
Vendor A:
Vendor B:
Vendor C:
When considering the cost functions, Vendor A would exhibit less cost when compare to Vendor B and Vendor C. Vendor A should be preferred over other alternatives. The graph is as follows:
Cost function for each alternative if the annual volume is more than 1,000 units:
First internal process:
Second internal process:
Vendor A:
Vendor B:
Vendor C:
When considering the cost functions, Vendor B would dominate Vendor A and Vendor C. Hence, Vendor A and Vendor C should be eliminated. The graph considering two internal processes and Vendor B is as follows:
Determine the value of Q by equaling two cost equations:
Equal the cost function of second internal process and Vendor B to determine the value of Q.
Calculate the total cost of first internal process:
Substitute the value Q in the cost equation of first internal process. Hence, the total cost is $1,220,000.
Calculate the total cost of second internal process:
Substitute the value Q in the cost equation of second internal process. Hence, the total cost is $1,080,000.
Calculate the total cost of Vendor A:
Substitute the value Q in the cost equation of Vendor A. Hence, the total cost is $1,200,000.
Calculate the total cost of Vendor B:
Substitute the value Q in the cost equation of Vendor B. Hence, the total cost is $1,080,000.
Calculate the total cost of Vendor C:
Substitute the value Q in the cost equation of Vendor C. Hence, the total cost is $1,142,000.
Inference:
- Vendor A should be preferred when the purchasing quantity ranges from 1 to 1,000 units.
- Vendor B should be preferred when the purchasing quantity ranges from 1,001 to 59,999 units.
- There would indifferent between Vendor B and second internal process if the quantity is 60,000 units.
- Second internal process should be preferred if the quantity is more than 60,000 units.
First internal process and Vendor C are never best.
Want to see more full solutions like this?
Chapter 5 Solutions
Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences)
- Sarah Anderson, the Marketing Manager at Exeter Township's Cultural Center, is conducting research on the attendance history for cultural events in the area over the past ten years. The following data has been collected on the number of attendees who registered for events at the cultural center. Year Number of Attendees 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 You have been hired as a consultant to assist in implementing a forecasting system that utilizes various forecasting techniques to predict attendance for Year 11. a) Calculate the Three-Period Simple Moving Average b) Calculate the Three-Period Weighted Moving Average (weights: 50%, 30%, and 20%; use 50% for the most recent period, 30% for the next most recent, and 20% for the oldest) c) Apply Exponential Smoothing with the smoothing constant alpha = 0.2. d) Perform a Simple Linear Regression analysis and provide the adjusted…arrow_forwardRuby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 70 units and is valued at $90 per unit. Inbound shipments from vendor 1 will average 390 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 2 weeksweeks. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. Part 2 a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $enter your response here.arrow_forwardSam's Pet Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: > Demand 75 bags/week > Order cost = $52.00/order > Annual holding cost = 20 percent of cost > Desired cycle-service level = 80 percent >Lead time = 5 weeks (30 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)arrow_forward
- Yellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 2,250 rolls. The cost per roll is $625, and the annual holding cost is 20 percent of the cost. Each order costs $75. a. How many rolls should Yellow Press order at a time? Yellow Press should order rolls at a time. (Enter your response rounded to the nearest whole number.)arrow_forwardPlease help with only the one I circled! I solved the others :)arrow_forwardOsprey Sports stocks everything that a musky fisherman could want in the Great North Woods. A particular musky lure has been very popular with local fishermen as well as those who buy lures on the Internet from Osprey Sports. The cost to place orders with the supplier is $40/order; the demand averages 3 lures per day, with a standard deviation of 1 lure; and the inventory holding cost is $1.00/lure/year. The lead time form the supplier is 10 days, with a standard deviation of 2 days. It is important to maintain a 97 percent cycle-service level to properly balance service with inventory holding costs. Osprey Sports is open 350 days a year to allow the owners the opportunity to fish for muskies during the prime season. The owners want to use a continuous review inventory system for this item. Refer to the standard normal table for z-values. a. What order quantity should be used? lures. (Enter your response rounded to the nearest whole number.)arrow_forward
- In a P system, the lead time for a box of weed-killer is two weeks and the review period is one week. Demand during the protection interval averages 262 boxes, with a standard deviation of demand during the protection interval of 40 boxes. a. What is the cycle-service level when the target inventory is set at 350 boxes? Refer to the standard normal table as needed. The cycle-service level is ☐ %. (Enter your response rounded to two decimal places.)arrow_forwardOakwood Hospital is considering using ABC analysis to classify laboratory SKUs into three categories: those that will be delivered daily from their supplier (Class A items), those that will be controlled using a continuous review system (B items), and those that will be held in a two bin system (C items). The following table shows the annual dollar usage for a sample of eight SKUs. Fill in the blanks for annual dollar usage below. (Enter your responses rounded to the mearest whole number.) Annual SKU Unit Value Demand (units) Dollar Usage 1 $1.50 200 2 $0.02 120,000 $ 3 $1.00 40,000 $ 4 $0.02 1,200 5 $4.50 700 6 $0.20 60,000 7 $0.90 350 8 $0.45 80arrow_forwardA part is produced in lots of 1,000 units. It is assembled from 2 components worth $30 total. The value added in production (for labor and variable overhead) is $30 per unit, bringing total costs per completed unit to $60 The average lead time for the part is 7 weeks and annual demand is 3800 units, based on 50 business weeks per year. Part 2 a. How many units of the part are held, on average, in cycle inventory? enter your response here unitsarrow_forward
- assume the initial inventory has no holding cost in the first period and back orders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method. What is the total cost? ENTER your response is a whole number (answer is not $17,000. That was INCORRECT)arrow_forwardRegular Period Time Overtime Supply Available puewag Subcontract Forecast 40 15 15 40 2 35 40 28 15 15 20 15 22 65 60 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit 20 units $100 $150 $200 Carrying cost per unit per month 84arrow_forwardassume that the initial inventory has no holding cost in the first period, and back orders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method. The total cost is? (enter as whole number)arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPurchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning


