Considering the above, mathematically formulate the freight loading plan for the Noyina as an LP model. Implement the formulation in Excel following the goals and guidelines for good spreadsheet design and solve using solver. Generate the answer and sensitivity reports. Then answer the following questions in Section B assuming each question as independent of the other questions unless explicitly referred to. Case I: AAD Supply OperationsThe Australian Antarctic Division (AAD) manages and delivers Australia's Antarctic Program. Threeyear-round research stations, Casey, Davis, and Mawson are maintained in Antarctica to run scientificand logistical operations together with a station at the sub-Antarctic Macquarie Island. Each year theAAD charters ships and vessels for resupply and transport operations to these station bases.https://www.antarctica.gov.au/about-us/In the current season Southern Lights Logistics (SLL) operates an ice strengthened cargo ship the"Noyina" for resupply operations and critical cargo delivery for the AAD.Dave Ellis is managing cargo operations of the Noyina in its current resupply voyage at the Port ofHobart in Tasmania. The AAD wants to transport four cargo types (C1 - C4) in relation to the fourclassified categories "General Cargo", "Dangerous Goods", "Scientific Support" and "Personal Effects"respectively aboard the vessel as follows.Cargo Type|૪૪૪૪Amount Available(tons)4800250012001700Cargo TypeC1C2C3C4If the vessel departs the port of Hobart on time as scheduled, Southern Lights Logistics (SLL) canachieve the following profit margins over the four cargo types. However, any delay will affect thesevalues on the order of 10% reduction in profit per day that the vessel is delayed due to associatedcosts. Dave is confident that the ship can depart with one day delay due to an ongoing maintenanceissue.Volume per ton (cubicfeet)50357065Profit per ton ($)75556585Dave is preparing the loading plan and can decide to load any amount or all the available cargo forAAD. However, the Noyina has the following capacity restrictions in relation to its four cargo holds. Cargo HoldForward HoldCenter (Port) HoldCenter (Starboard) HoldRear HoldWeight Capacity (tons)3000300030004000Volume Capacity (cubic feet)170,000100,000105,000180,000More than one AAD cargo type can be transported in the same hold. However, balance considerationshave enforced the following conditions to be applied.Forward cargo hold weight must be within 15% of the rear cargo hold weight. The center cargo holdsmust cumulatively hold between 45% to 55% of the total weight that is freighted on board the vessel.

Objective Functions and Constraints: Based on the given details, the objective…

Business

Operations Management

Considering the above, mathematically formulate the freight loading plan for the Noyina as an LP model. Implement the formulation in Excel following the goals and guidelines for good spreadsheet design and solve using solver. Generate the answer and sensitivity reports.

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.3SD: Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling...

See similar textbooks

Similar questions

Avion, Inc. Susan Dey and Bill Mifflin, procurement managers at Avion, Inc., sat across from each other and reviewed a troubling performance report concerning a key supplier, Foster Technologies. The report detailed the deteriorating performance of Foster Technologies in the areas of material quality and on-time delivery. At this point, Kevin ODonnell, another procurement manager, entered the room. What parts of the supply chain are most closely involved with the situation in this case? What is the responsibility of each part in order to maintain a smooth flow of material?
Avion, Inc. Susan Dey and Bill Mifflin, procurement managers at Avion, Inc., sat across from each other and reviewed a troubling performance report concerning a key supplier, Foster Technologies. The report detailed the deteriorating performance of Foster Technologies in the areas of material quality and on-time delivery. At this point, Kevin ODonnell, another procurement manager, entered the room. Explain the role of performance measurement in managing supply chain activities.
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?
Avion, Inc. Susan Dey and Bill Mifflin, procurement managers at Avion, Inc., sat across from each other and reviewed a troubling performance report concerning a key supplier, Foster Technologies. The report detailed the deteriorating performance of Foster Technologies in the areas of material quality and on-time delivery. At this point, Kevin ODonnell, another procurement manager, entered the room. Why can changes within a supply chain disrupt the normal flow of goods and services within a supply chain?
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?
For over 25 years, NZY, a Gourmet Candy manufacturing company, has been at the forefront of luxury confectionery with products distributed and stocked by hundreds of retailers across the country. In 2021, NZY plans an ambitious expansion to grow their business further using IT platforms and plans to scale up their business to sell customers directly through ecommerce platforms. The company has been using ERP for years for internal management of its services and has an in-house IT team to support various functions. However, the owner of NZY knows that if the company wants an expansion of its business, they need to outsource a few of their business processes. Now, please answer the following.If you are asked to recommend a type of electronic commerce service provider for NYZ, which type (Basic e-commerce vs. mall-style e-commerce) would you recommend, and why?