Question

In: Operations Management

Please solve in excel WA 339.94)              With a little thought you should be able to...

Please solve in excel

WA 339.94)              With a little thought you should be able to “eyeball” the solution.   However the question asks to develop a linear integer model to solve the problem. This can be set up in less than 10 minutes. INCLUDE ALL CONSTRAINTS.

An aged merchant of Baghdad was much respected by all who knew him. He had three sons, and it was a rule of his life to treat them equally. Whenever one son received a present, the other two each received a present of equal value. One day this worthy man fell sick and died, bequeathing all of his possessions to his three sons in equal shares. The only difficulty that arose was over the stock of honey. There were exactly 21 barrels. The old man left instructions that each son should not only receive an equal quantity of honey, but each son should receive exactly the same number of barrels, and no honey should be transferred from barrel to barrel on account of the waste involved. Now, as 7 of these barrels were full of honey, 7 were half full, and 7 were empty, this was quite a puzzle, especially because each brother objected to taking more than 4 barrels of the same description (full, half full, or empty). Develop an integer model to solve this puzzle.

Solutions

Expert Solution

We need to formulate the problem first. For this, we need to define the decision variables, and the objective function. Firstly we can denote the decision variable between two parameters

Xij where i={full, half, empty} and j={son1, son2, son3}

Xij denotes the number of barrels taken by each i and j values.

Our objective is to make sure that the honey is equally distributed and nothing is wasted. This means,

?Xij = 21

This is our objective function.

The constraints are

?Xison1 = ?Xison2 = ?Xison3

This means the number of barrels by each of them should be equal.

Xfullson1 + 0.5 * Xhalfson1 + 0 * Xemptyson1 = Xfullson2 + 0.5 * Xhalfson2 + 0 * Xemptyson2 = Xfullson3 + 0.5 * Xhalfson3 + 0 * Xemptyson3

This means that each of them receive same amount of honey

?Xison1,?Xison1,?Xison1 <= 4 where i={full, half, empty}

This means that each of them will not take more than 4 barrels of the same type

Xij >= 0

This means the number of barrels cannot be in negative

Now we can use excel and plot this model. The setup and the answer is shown in the image below.

Hope this helps. Cheers!


Related Solutions

Should auto insurance companies be able to force you to have a little black box type...
Should auto insurance companies be able to force you to have a little black box type device, or a similarly functioning smartphone app, that records your driving habits, or pay a penalty not to do so (or get a discount for using the device - in the end a penalty for not using, or a discount for using are basically the same)?
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You...
Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You want to retire on the day you have $1,000,000 is your savings account. You expect to earn 4 percent compounded monthly, on your money during your retirement. Your plan is to withdraw $4500 a month as retirement income from this account. How many years can you be retired until you run out of money? . Question 02: you are able to pay mortgage payments...
Solve in excel please, thank you It gives the data on the lifetime in hours of...
Solve in excel please, thank you It gives the data on the lifetime in hours of a sample of 100 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. a. Identify the null and the alternate hypotheses for this study. b. Can this lightbulb manufacturer claim at a significance level of 5% that its lightbulbs typically last more than 1000 hours?...
Prepare an amortization spreadsheet in Excel.  The sheet should be labeled, and I should be able to...
Prepare an amortization spreadsheet in Excel.  The sheet should be labeled, and I should be able to change purchase price, interest rate, or the other relevant factors and the spreadsheet should automatically update. As we discussed in class, spend some time labeling the spreadsheet and using proper cell references.  This is the first but not the last spreadsheet of this type, it is highly likely that elements of this spreadsheet will be helpful in subsequent assignments, so time spent here may mean...
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test...
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test XYZ company is considering a new machine that costs $300,000 and would reduce pre-tax manufacturing costs by $108,000 annually. XYZ would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The net operating working capital...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
Please solve this case in Excel,Many thanks! The Problem: You are the technology controller for a...
Please solve this case in Excel,Many thanks! The Problem: You are the technology controller for a mid-sized publicly traded company. You have been assigned to evaluate an investment in a new process that would cost $2.5 million. You have determined that the internal rate of return of the positive operating cash flows associated with the investment is 13.0%. On a market value basis, the firm's capital structure is as follows: Debt: 40%; Preferred Stock: 5%; Common equity: 55%; This capital...
Please identify those that are living or not. You should also be able to answer the...
Please identify those that are living or not. You should also be able to answer the included questions that follow your observation table that provide support for your observations and data. Observations & Data Specimen # Name of Specimen Living or Non-Living Reason 1 Starfish 2 Coral 3 Crayfish 4 Grasshopper 5 Lizard 6 Shark 7 Snail 8 Butterfly 9 Horseshoe Crab 10 Snake 11 Sponge 12 Earthworm 13 Rocket 14 Tornado 15 Car 16 Volcano 17 Rocks 18 Bacteria...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000.  In addition, the machine must be installed and tested.  The costs of installation and testing will amount to $10,000.  The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it)          The equipment will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT