A company in the agribusiness sector owns a large property to meet the demand for the M types of grains it grows. The demand for grain i is estimated at a maximum of ui tons and its market price is pi for each ton of grain i. The land is subdivided into N cultivation zones, each of which has a total of hj hectares that allow all types of grain to be cultivated simultaneously if necessary. There is an estimate of the yield of each crop represented by an amount of tons rij per hectare for grain i in cultivation zone j. Explain all the assumptions you deem necessary. The model must be solved using Excel Solver. You must generate a report documenting all the work done. Consider the following information:

A company in the agribusiness sector owns a large property to meet the demand for the M types of grains it grows. The demand for grain i is estimated at a maximum of ui tons and its market price is pi for each ton of grain i. The land is subdivided into N cultivation zones, each of which has a total of hj hectares that allow all types of grain to be cultivated simultaneously if necessary. There is an estimate of the yield of each crop represented by an amount of tons rij per hectare for grain i in cultivation zone j. Explain all the assumptions you deem necessary. The model must be solved using Excel Solver. You must generate a report documenting all the work done. Consider the following information:

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section5.3: Assignment Models

Problem 12P

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?
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?
Cost Allocation; Cost Shifting In the last several years, airlines have succeeded in boosting profits by adding fees for previously free services such as in-flight snacks and meals, checked baggage,priority boarding, and other services. These fees have caused some shifts in customer behavior,as more airline passengers bring their own snacks on the airline and pack a smaller bag that isacceptable for “carry-on.” By using carry-on luggage, the airline customer can save $25 or more inbaggage-checking fees. This situation has resulted in a cost shifting for passengers, airlines, and airport security. As the number of checked bags decreases, the cost of baggage handling for the airlinesdecreases (and revenues increase for those bags that are checked). In contrast, the costs and delaysin security checkpoints increase as security personnel must check additional carry-on bags, causingdelays for passengers and the need for additional security personnel to handle the increased numberof carry-on…
19) What is the EBM, if total basic employment is 128,500 and total employment is 350.000? 20) What does the EBM indicate in question 19? 21) Based on question 19, If the population is 798,112, what is the PER. 22) What does the PER indicate?
Neil and Joan a Missile and sister duo own a small dry cleaning business. NeJoWe Cleaners! provides several services to its customers: dry cleaning of clothes and household linen, laundry, ironing, repair work and clothing alterations. They currently have 5 locations across the capital city, with the sixth location being that of the main office were most of the cleaning and laundry is carried out. NeJoWe has been in business for about ten years and believe that personal contact with customers, operational efficiency, fast and quality work has given them the edge in building the business. A key feature of their customer service is soliciting feedback from customers about their service quality, this they were able to do in person on their daily deliveries as one or the other travelled around to each location on a daily basis. These trips would also give them the opportunity to physically check on what was happening in each location and have formal and informal talks with the…
Neil and Joan a Missile and sister duo own a small dry cleaning business. NeJoWe Cleaners! provides several services to its customers: dry cleaning of clothes and household linen, laundry, ironing, repair work and clothing alterations. They currently have 5 locations across the capital city, with the sixth location being that of the main office were most of the cleaning and laundry is carried out. NeJoWe has been in business for about ten years and believe that personal contact with customers, operational efficiency, fast and quality work has given them the edge in building the business. A key feature of their customer service is soliciting feedback from customers about their service quality, this they were able to do in person on their daily deliveries as one or the other travelled around to each location on a daily basis. These trips would also give them the opportunity to physically check on what was happening in each location and have formal and informal talks with the…
Neil and Joan a Missile and sister duo own a small dry cleaning business. NeJoWe Cleaners! provides several services to its customers: dry cleaning of clothes and household linen, laundry, ironing, repair work and clothing alterations. They currently have 5 locations across the capital city, with the sixth location being that of the main office were most of the cleaning and laundry is carried out. NeJoWe has been in business for about ten years and believe that personal contact with customers, operational efficiency, fast and quality work has given them the edge in building the business. A key feature of their customer service is soliciting feedback from customers about their service quality, this they were able to do in person on their daily deliveries as one or the other travelled around to each location on a daily basis. These trips would also give them the opportunity to physically check on what was happening in each location and have formal and informal talks with the…
Brewery Ipana Oy has found some potential long-time partners in the restaurant business. To optimize the supply chain, the company is negotiating for contracts that would allow all production in the coming years to be sold to these partners. The contracts aim to shift production to 20 liter barrels of beer, which would become the sole product of Ipana Oy. In case the negotiations are successful, Ipana Oy estimates its typical year would look as follows: the quantity shipped to the customer is 18000 units at a price of 300 €/unit. The gross profit percentage is 40 % and the yearly fixed costs are 1500000 €. (Additional text: The variable cost per unit [€/unit] for products that would be produced in the scenario above is 180 [€/unit].) Question: Calculate the critical sales price in the estimate [€/product].
Examples of a feasibility study in transporation.