Purchasing with Price Breaks. Universal Technologies, Inc. has identified two qualified vendors with the capability to supply certain of its electronic components. For the coming year, Universal has estimated its volume requirements for these components and has obtained price-break schedules from each vendor. (These are summarized as "all-units" price discounts in the table at the bottom of p. 333.) Universal's engineers have also estimated each vendor's maximum capacity for producing these components, on the basis of available information about equipment in use and labor policies in effect. Finally, because of its limited history with vendor A, Universal has adopted a policy that permits no more than 60 percent of its total unit purchases on these components to come from vendor A. a. What is the minimum total cost for Universal's purchases? b. In the optimal solution to part (a), which purchases are made at discounted prices?

Purchasing with Price Breaks. Universal Technologies, Inc. has identified two qualified vendors with the capability to supply certain of its electronic components. For the coming year, Universal has estimated its volume requirements for these components and has obtained price-break schedules from each vendor. (These are summarized as "all-units" price discounts in the table at the bottom of p. 333.) Universal's engineers have also estimated each vendor's maximum capacity for producing these components, on the basis of available information about equipment in use and labor policies in effect. Finally, because of its limited history with vendor A, Universal has adopted a policy that permits no more than 60 percent of its total unit purchases on these components to come from vendor A. a. What is the minimum total cost for Universal's purchases? b. In the optimal solution to part (a), which purchases are made at discounted prices?

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...

See similar textbooks

Similar questions

Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
Determine an A-B-C classification for these items:Item Unit Cost Annual Volume (00)1 $100 252 80 303 15 604 50 105 11 706 60 857 10 60b. Find the EOQ given this information: D = 4,500 units/year, S = $36, and H = $10 per unit per year. I just need help with part b.
a. Determine an A-B-C classification for these items:Item Unit Cost Annual Volume (00)1 $100 252 80 303 15 604 50 105 11 706 60 857 10 60b. Find the EOQ given this information: D = 4,500 units/year, S = $36, and H = $10 per unit per year.c. Find the economic production quantity given this information.D = 18,000 units/year, S = $100, H = $40 per unit per year, p = 120 units per day,and u = 90 units/day
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?
2. (Quantity Discount) County Hospital orders syringes from a hospital supply firm. The hospital expects to use 40,000 per year. The cost to order and have the syringes delivered is $800. The annual carrying cost is $1.90 per syringe because of security and theft. The hospital supply firm offers the following quantity discount pricing schedule. Qty 0-9,999 10,000-19,999 20,000-29,999 30,000-39,999 40,000-49,999 50,000+ Price $ 3.40 $ 3.20 $ 3.00 $ 2.80 $ 2.60 $ 2.40 What is best order quantity for syringes that minimize total cost?
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 If the owner of Birka Styles & Co is an optimist, how many lots should the manager order?
12.27 Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the accompanying table. Annual usage is 2,400 valves; order cost is $10 per order; and annual inventory holding costs are $3.33 per unit. Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? PX VENDOR A QUANTITY 1-49 50-74 75-149 150-299 300-499 500+ VENDOR C QUANTITY 1-99 100-199 200-399 400+ PRICE $35.00 34.75 33.55 32.35 31.15 30.75 PRICE $34.50 33.75 32.50 31.10 VENDOR B QUANTITY 1-74 75-149 150-299 300-499 500+ PRICE $34.75 34.00 32.80 31.60 30.50 VENDOR D QUANTITY 1-199 200-399 400+ PRICE $34.25 33.00 31.00
Why do we use "Specifications or bill of material" in the dependent inventory model?
3. Fortnex is a company that assembles small household appliances including coffee makers, toasters, and food mixers. The parent company of Fortnex has been concerned about the rising product cost of the finished products, which has led to reduced profit margins. One of the demands of the parent company has been to review the inventory management practices of Fortnex. Two areas which Fortnex is currently investigating are economic order quantity EOQ and ABC analysis. Perform the following. (i) At present the company purchases copper wire for a certain appliance under economic order quantities based on the information given in Table 3-1. The supplier of copper wire is proposing a discount of 5% of unit price if Fortnex purchases in lot sizes of 1000 kg. rather than the calculated EOQ. Determine if Fortnex should take advantage of the price discount. Justify your response. For a particular series of referenced products, the number of units used a year, and the unit cost are as shown in…
4) Rane Brake Linings gathered information for its brake lining components as presented in the table below. How would the firm classify these items according to an ABC classification system? Initial Information Part # Unit Cost Annual Demand 10 10 200 11 30 125 12 9 100 13 12 5000 14 50 195 15 6 300 16 100 70
Year Cost of Good Sold Beginning Inventory (In Pesos) Ending Inventory (In Pesos) 1 503,425 10,300 12,400 2 643,056 12,400 11,200 3 690,432 11,200 10,670 4 734,509 10,670 11,200 5 758,734 ? 10,987 REQUIRED Determine the inventory turnover for year 5. Determine the number of days the finished goods stay in inventory in Year 1. There was no improvement in inventory turnover in Year 5 compared to Year 1. This statement is not correct. Write YES or NO for the answer
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round individual dollar volumes to two decimal places. Also round percentage of dollar volume to two decimal places.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar % of Dollar Volume Volume 1289 360 4.00 2347 300 4.00 1,200 36.20 2349 120 2.50 300 9.05 2363 75 1,50 2394 60 1.75 105 3.17 2395 35 2.00 6782 20 1.15 23 0.69 7844 12 2.05 24.6 0.74 8210 5 1.60 8310 7 2.00 14 0.42 9111 3.00 18 0.54 3,315.1 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number…