please use excel Alvarez and Takamine are two Japanese guitar companies that share a distribution and logisticshub for handling and shipping guitar orders to a major online retailer in North America.Uncorrelated Demand and related data profiles for each of four guitar products at the OsakaGlobal Distribution Center are listed below. Any shipment has a common order cost of $300 tothe retailer's North American warehouse. Show the cost savings that could be achieved ifpackaging and shipping services could be aggregated for the four products listed below if thecompany spends $10,000 per year (every 12 months) to stage the facility for this function.Should the companies proceed with the plan to perform this type of service based on youranalysis? Please report lot sizes, order frequency (flow time), and costs for both independentordering and joint ordering conditions to justify your analysis.Forecast Demand(Monthly)Product-specificorder costRequired annualrate of return(h=15%)Unit costA2204Prestige10,000$1000Na$1500RG550Genesis15,500$1000Na$700ArtistPro8,500$1500Na$1100ES-445Premier3,650$1750Na$1800

Economic order quantity (EOQ) The order quantity that helps the firm to minimize the total inventory…

Answered: Alvarez and Takamine are two Japanese…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
The Summer Outdoor Furniture Company produces wooden lawn chairs. The annual demandfrom its store customers is 17,400 chairs per year. The transport and handling costs are $2,600each time a shipment of chairs is delivered to stores from its warehouse. The annual carryingcost is $3.75 per chair. The company is thinking about relocating its warehouse closer to its customers, which would reduce transport and handling costs to $1,900 per order but increase carrying costs to $4.50 per chair per year. Should the company relocate based on inventory costs?
OPMFORMULA is a medium-sized baby formula production plant in Boston, Massachusetts. The company has been in business for over 20 years, mainly producing baby formula for infant nutrition industry and selling the formula exclusively through its distribution network across the United States. Over the years, OPMFORMULA gradually expanded its production capacity and consumer base. However, over the past 24 months, the company has been faced with an unprecedented and unanticipated increase in demand, which has cleared out its storage facilities and exceeded its production capabilities. At this time, the demand continues to be extremely high. The company has an existing storage facility, specifically designed for long-term storage of baby formula (controlled climate, humidity, etc.), which can be converted to a new production line. The new production line would increase the existing manufacturing capabilities by 50%. However, this would require a substantial investment in remodeling of the…
OPMFORMULA is a medium-sized baby formula production plant in Boston, Massachusetts. The company has been in business for over 20 years, mainly producing baby formula for infant nutrition industry and selling the formula exclusively through its distribution network across the United States. Over the years, OPMFORMULA gradually expanded its production capacity and consumer base. However, over the past 24 months, the company has been faced with an unprecedented and unanticipated increase in demand, which has cleared out its storage facilities and exceeded its production capabilities. At this time, the demand continues to be extremely high. The company has an existing storage facility, specifically designed for long-term storage of baby formula (controlled climate, humidity, etc.), which can be converted to a new production line. The new production line would increase the existing manufacturing capabilities by 50%. However, this would require a substantial investment in remodeling of the…
A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It carries seven items in inventory: three raw materials, two work-in-process items, and two finished goods. The following table contains last year’s average inventory level for each item, along with its value. a. What is the average aggregate inventory value? b. How many weeks of supply does the firm maintain? c. What was the inventory turnover last year? Category Part Number Average Level Unit Value Raw materials Work-in-process Finished goods 1 2 3 4 5 6 7 15000 2500 3000 5000 4000 2000 1000 $3.00 5.00 1.00 14.00 18.00 48.00 62.00
A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It carries seven items in inventory: three raw materials, two work-in-process items, and two finished goods. The following table contains last year’s average inventory level for each item, along with its value. a. What is the average aggregate inventory value? b. How many weeks of supply does the firm maintain? c. What was the inventory turnover last year?
discuss how a company can use the internet, collaborative forecast , supply contracts and everyday low pricing to cope with the bullwhip effect
Way Cheap has 16 warehouses, 12 have stock inventory of 50,000 and 4 have stock inventory of 100,000. a. What is their current total safety stock, and what will be their new required safety stock if they reduce to a total of 9 warehouses? b. If instead of 9, they drastically decreased from 16 to 4 warehouses, what would be their new safety stock level? c. As a supply chain consultant, what would you counsel Way-Cheap are potential downsides of drastic warehouse downsizing, to be contrasted against the benefit from decreased safety stock requirements? Plz send answer fast I will upvote
Dr Pepper bottles soft drinks that it distributes to retail outlets from ten warehouses in USA. A single bottling plant is located in Seattle. The product is shipped from the plant to the warehouses via trucks each of which possibly travels more than one warehouse in a trip. Dr Pepper outsources the transportation of the products to a third-party trucking company, DHL. DHL charges a fix fee of $500 plus a variable free of $0.80 per miles per a trip of a truck. For instance; if the length of a truck’s trip is 600 miles, then DHL charges 500 + 600*0.80 = $980 to Dr Pepper. The capacity of each truck is 36 pallets but transportation fee does not change if the all capacity is used or not. In a particular day the demands of the warehouses are as listed in the following table. Use Savings method to find the number of routes (trucks) needed, warehouses on the routes, and the sequence the truck should serve the warehouses based on the real distance matrix given below (assume the warehouses are…
Mike Larry is the Procurement manager at Coastal Supplies CC supplying general goods to the coastal towns. For some time, there stock levels have been low compared to the demand. Mega Wholesalers is offering to start supplying bulk goods to Coastal Supplies CC. As the procurement manager, Mike Larry has to make a decision to buy from Mega wholesalers. Note that the decision to buy or not to buy rests on Larry alone. How should Larry go about to decide?
company sources from hundreds of suppliers and is considering the aggregation of inbound shipments to lower costs. The company decides to aggregate three suppliers per truck. The common truckload shipping order cost, S = $2020 per truck, along with supplier-specific order costs, s1 = $114, s2 = $90, s3 = $100 per pickup. Average annual demand from each supplier is, demand per product, D1 = 9160, D2 = 10216, D3=18466 units. Each unit cost per product is, C1 = $98, C2 = $87, C2 = $20, and the company incurs a holding cost of 19 percent. What is the optimal order frequency, if the company decides to aggregate three suppliers per truck?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

SEE MORE TEXTBOOKS