Mega Plantation is a company with about five years of experience in oil palm plantation. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mega Plantation is a company with about five years of experience in oil palm plantation. The company headquarters is in northern Perak. Mega Plantation has an estate which is divided into 7 sectors. Each sector needs a group of workers to carry out oil palm field operations such as harvesting, weeding, applying fertilizer, transporting fresh fruit bunches, etc. The number of workers needed for each sector from Monday to Sunday is shown in the following table. Mon Tue Wed Thu Fri Sat Sun Start on Monday Start on Sector 1 Sector 2 Sector 3 5 6 6 6 3 8 5 Tuesday Start on Wednesday Start on Thursday Start on Friday Start on Saturday Start on Sunday 3 6 2 6 9 Off day Off day 5 6 6 3 Off day Off day 4 9 3 8 6 A worker will need to work for five consecutive days and then rest for two days. If a worker starts. working on Monday, then the worker will work on Monday, Tuesday, Wednesday, Thursday, and Friday. Saturday and Sunday are off days for that worker. The following table shows the working days and off days of workers. Monday Tuesday Wednesday Thursday Friday Sector 4 Sector 5 Sector 6 Sector 7 5 4 Off day Off day 4 8 5 5 7 3 6 7 6 8 7 4 7 5 Off day Off day 7 8 10 5 8 Saturday Sunday Off day off day Off day 9 7 5 6 11 4 8 Off day Off day off day Assuming that you are the estate manager who needs to decide the number of workers for each day in a week. You must make sure that the number of workers is minimum and sufficient to cover the operations in all the 7 sectors. a. Formulate a linear programming model for this problem. b. Use a software package based on the simplex method (e.g., Excel Solver) to solve the problem. Mega Plantation is a company with about five years of experience in oil palm plantation. The company headquarters is in northern Perak. Mega Plantation has an estate which is divided into 7 sectors. Each sector needs a group of workers to carry out oil palm field operations such as harvesting, weeding, applying fertilizer, transporting fresh fruit bunches, etc. The number of workers needed for each sector from Monday to Sunday is shown in the following table. Mon Tue Wed Thu Fri Sat Sun Start on Monday Start on Sector 1 Sector 2 Sector 3 5 6 6 6 3 8 5 Tuesday Start on Wednesday Start on Thursday Start on Friday Start on Saturday Start on Sunday 3 6 2 6 9 Off day Off day 5 6 6 3 Off day Off day 4 9 3 8 6 A worker will need to work for five consecutive days and then rest for two days. If a worker starts. working on Monday, then the worker will work on Monday, Tuesday, Wednesday, Thursday, and Friday. Saturday and Sunday are off days for that worker. The following table shows the working days and off days of workers. Monday Tuesday Wednesday Thursday Friday Sector 4 Sector 5 Sector 6 Sector 7 5 4 Off day Off day 4 8 5 5 7 3 6 7 6 8 7 4 7 5 Off day Off day 7 8 10 5 8 Saturday Sunday Off day off day Off day 9 7 5 6 11 4 8 Off day Off day off day Assuming that you are the estate manager who needs to decide the number of workers for each day in a week. You must make sure that the number of workers is minimum and sufficient to cover the operations in all the 7 sectors. a. Formulate a linear programming model for this problem. b. Use a software package based on the simplex method (e.g., Excel Solver) to solve the problem.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
A small grocery' store needs the following number of cashiers during each day of a normal week for day (8 a.m. to 4 p.m.) and evening (4 p.m. to midnight) shifts. The store prefers to employ...
-
1. The Swift Corporation wants to schedule the following seven-job problem to be processed on two machines A and B. Each job must be processed by two machines A and B, first on machine A and then...
-
Yara Clothing (Yara), a retail store at the mall, hires a number of employees to work 7 days a week. Yara owes its employees wages for the period of December 27, 2020 to January 9, 2021 (14 days) for...
-
Factor each polynomial. 125k - 64k 4
-
The 3 4-m side of an open tank is hinged at its bottom A and is held in place by a thin rod BC. The tank is to be filled with glycerine, whose density is 1263 kg/m3. Determine the force T in the rod...
-
Outdoor Luggage Inc. makes high-end hard-sided luggage for sports equipment. Data concerning three of the companys most popular models appear below. Required: 1. The total time available on the...
-
Inventory Costing: Weighted Average Cost CORNERSTONE 6.6 Refer to the information for Cornerstone Exercise 6-20 above. The company uses a perpetual inventory system. \section*{Required:} Calculate...
-
A manufacturer of microwaves has discovered that male shoppers have little value for microwaves and attribute almost no extra value to an auto-defrost feature. Female shoppers generally value...
-
Down Under Boomerang, Inc. is considering a new three-year expansion project that requires an initial fixed asset investment of $4,200,000. The fixed asset will be depreciated straight-line to zero...
-
Kenmare Architects Ltd. (KAL) was incorporated and commenced operations on January 1, 2014. Sheila Kenmare, the company's only employee, consults with various clients and uses expensive equipment to...
-
ABC Partnership is a multi-partner partnership that owned several parcels of real estate that had increased in value since ABC acquired the parcels, and ABC intended to sell those parcels of real...
-
What is the main difference between core and supplemental ecological indicators? Provide an example of each.Would it be useful to have all production site managers to report to top management on a...
-
The Peter Paint Company makes water- and oil-based paints for houses. Recently, the firm has been investigating other opportunities. One possibility is producing finger paints for children. Finger...
-
What assumptions underlie ecological accounting? Consider whether one assumption behind ecological accounting and reporting is more important than the other assumptions.
-
How might low-quality information in ecological statements be improved? In your answer, name two specific institutional mechanisms.
-
After an extensive cost-benefit analysis, Mercy General Hospital has made a decision to outsource its ambulance operations to a private company. The administration has narrowed down its decision to...
-
-/1 !!! View Policies Current Attempt in Progress Bonita Co. is considering purchasing a machine that will produce annual savings of $22600 at the end of the year. Bonita requires a 10% rate of...
-
Graph one period of each function. y = 4 cos x
-
Does Cool Company have a foreign currency transaction if it sells goods in Canadian dollars to a U.S. company and Cool's functional currency is the Canadian dollar? Explain.
-
Campbell Ltd. invested in a joint venture by providing cash of $160,000. Campbell obtained a 22% interest in the joint venture based on its contribution. During the year, the joint venture earned...
-
Identifying the entities to be included in the reporting entity is a critical part of public sector financial reporting. Required (a) Explain some inherent challenges faced in defining the reporting...
-
Understanding learning curve tables Foom Corporation's Arcade Electronic Division just completed assembly of 15 Android Invasion video games. The direct labor cost of the 15th unit was $93.38. The...
-
Labor schedule with learning curve Collagum Company has negotiated a contract to construct 8 rocket motors for a utility company. The contract price is for 200 percent of total labor-related cost of...
-
Use of learning curve table and formula A team of six technicians required 150 hours to assemble a new type of radar receiver. By the time they completed assembly of 18 such receivers, they had...
Study smarter with the SolutionInn App