2.6. This is your lucky day. You have just won a $20,000 prize. You are setting...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2.6. This is your lucky day. You have just won a $20,000 prize. You are setting aside $8,000 for taxes and partying expenses, but you have decided to invest the other $12,000. Upon hearing this news, two different friends have offered you an opportunity to become a partner in two different entrepreneurial ventures, one planned by each friend. In both cases, this investment would involve expending some of your time next summer as well as putting up cash. Becoming a full partner in the first friend's venture would require an invest- ment of $10,000 and 400 hours, and your estimated profit (ignoring the value of your time) would be $9,000. The cor- responding figures for the second friend's venture are $8,000 and 500 hours, with an estimated profit to you of $9,000. However, both friends are flexible and would allow you to come in at any fraction of a full partnership you would like. If you choose a fraction of a full partnership, all the above figures given for a full partnership (money investment, time investment, and your profit) would be multiplied by this same fraction. Because you were looking for an interesting summer job anyway (maximum of 600 hours), you have decided to partici- pate in one or both friends' ventures in whichever combination would maximize your total estimated profit. You now need to solve the problem of finding the best combination. d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, and the objective cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve this model. 2.6. This is your lucky day. You have just won a $20,000 prize. You are setting aside $8,000 for taxes and partying expenses, but you have decided to invest the other $12,000. Upon hearing this news, two different friends have offered you an opportunity to become a partner in two different entrepreneurial ventures, one planned by each friend. In both cases, this investment would involve expending some of your time next summer as well as putting up cash. Becoming a full partner in the first friend's venture would require an invest- ment of $10,000 and 400 hours, and your estimated profit (ignoring the value of your time) would be $9,000. The cor- responding figures for the second friend's venture are $8,000 and 500 hours, with an estimated profit to you of $9,000. However, both friends are flexible and would allow you to come in at any fraction of a full partnership you would like. If you choose a fraction of a full partnership, all the above figures given for a full partnership (money investment, time investment, and your profit) would be multiplied by this same fraction. Because you were looking for an interesting summer job anyway (maximum of 600 hours), you have decided to partici- pate in one or both friends' ventures in whichever combination would maximize your total estimated profit. You now need to solve the problem of finding the best combination. d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, and the objective cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve this model.
Expert Answer:
Answer rating: 100% (QA)
Spreadsheet Model for Investment Problem Data Cells Investment per full pa... View the full answer
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these accounting questions
-
"This is your lucky day. You have just won a $20,000 prize. You are setting aside $8,000 for taxes and partying expenses, but you have decided to invest the other $12,000. Upon hearing this news, two...
-
This is your lucky day. You have just won a $10,000 prize. You are setting aside $4,000 for taxes and partying expenses, but you have decided to invest the other $6,000. Upon hearing this news, two...
-
1. Read the following article about the new circle with disney product and answer the following questions. in doing so, take on the role as the marketing manager responsible for the product and...
-
What is meant by the terms brain drain and reverse brain drain?
-
Consider the following task broken down into 5 MTM elements: What is the total time for the task? TMUs 14.2 3.5 10.6 Code in MTM Books Reach to tool box Grasp a tool Separate tool R12D BG1 AP2 by...
-
Obtain the phase trajectories for a system governed by the equation \[\ddot{x}+0.4 \dot{x}+0.8 x=0\] with the initial conditions \(x(0)=2\) and \(\dot{x}(0)=1\) using the method of isoclines.
-
An analyst predicted last year that the stock of Logistics, Inc., would offer a total return of at least 10 % in the coming year. At the beginning of the year, the firm had a stock market value of...
-
In this youtube video ( https://www.youtube.com/watch?v=-_2mj1pwveo ) by David Kwong, He points out that for a magician to be successful they have to control the environment and everything they are...
-
2. (a) Perform the following operation involving four-bit 2's complement numbers and indicate whether arithmetic overflow occurs. Check your answers by converting to decimal sign and magnitude...
-
Is the public debt (unbalanced budget) bad? Improve, adjust, or completely change your original answer by discussing the pros and cons of debt based on what we learned. For example, - What negative...
-
Before recording adjusting entries on December 31, the Store Supplies account had a $1,900 debit balance, while a physical count of the supplies showed $300 of unused supplies on hand. Prepare the...
-
Can you give me a format for creating a loan product for a small business including its credit and collection policy? Kindly explain to me how to do these parts?
-
How do Calculate the total cost of ownership per unit and Supplier Performance Index of Kong Pulp & Paper Mills (KPPM), and Bonn Paper Company (BPC) for the two following options: (i)Standard...
-
A stock's rate of return in year 1 is 0.1, in year 2 is 0.3, and in year 3 is 0.2. What is the stock annual arithmetric average return? A stock's rate of return in year 1 is 0.2, in year 2 is -0.1,...
-
In the following situation, decide whether you would use a personal interview, telephone survey, or self-administered questionnaire. Give your reasons. A survey of financial offers of the Fortune 500...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
Determine the state of stress at point \(A\) on the cross section of the post at section \(a-a\). Indicate the results on a differential element at the point. 5ft 400 lb a 1.5 ft 300 lb a 2.5 in. 2...
-
The rod has a diameter of \(40 \mathrm{~mm}\). Determine the stress components that act at point \(B\), and show the results on a volume element located at this point. 1500 N 300 mm 600 N 100 Nm 800...
-
Determine the state of stress at point \(B\) on the cross section of the post at section \(a-a\). Indicate the results on a differential element at the point. 5 ft 400 lb 1.5 ft 300 lb a a 2.5 in.- 2...
Study smarter with the SolutionInn App