Ask Question, Ask an Expert


Ask Basic Finance Expert

Abotte Products produces three products, A, B, and C. The company can sell up to 300 pounds of each product at the following prices (per pound): product A, $10; product B, $12; product C, $20. Abotte purchases raw material at $5 per pound. Each pound of raw material can be used to produce either one pound of A or one pound of B. For a cost of $3 per pound processed, product A can be converted to 0.6 pound of product B and 0.4 pound of product C. For a cost of $2 per pound processed product B can be converted to 0.8 pound of product C.

Determine how Abotte can maximize its profit.

Determine how much of A to make, how much of A to reprocess into B and C, how much of B to make, and how much of B to reprocess into C. That would be 4 changing cells. Remember that how much you make won't always be how much you have to sell. If I make 200 pounds of A but reprocess change 50 pounds, I will only have 150 pounds of A to sell (200 less the 50 reprocessed) but I get some B and C to sell.

Here are some check figures:

If I make 20 pounds of A and 20 pounds of B, I should use 40 pounds of raw material. Then if I convert half of each, I should have these quantities to sell:

Product A 10
Product B 16
Product C 12

The profit with this plan would be: $282

Hint: The optimal profit I got was: $6,975

Create a spreadsheet in excel. Run Solver to get the optimal result.


Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M928423

Have any Question? 

Related Questions in Basic Finance

1 assume that you are mr hegarty the ceo of mebel-doran

1) Assume that you are Mr. Hegarty, the CEO of Mebel-Doran. What will you do now? What avenues are open to you? Is Mebel-Doran ethically responsible for anything in this transaction? Should they be legally responsible? S ...

Part afor the following exercise complete the calculations

Part A For the following exercise, complete the calculations below. Evaluate different capital investment appraisal techniques by completing the calculations shown below: Bongo Ltd. is considering the selection of one of ...

Some contend that the passage of the ibbea is having little

Some contend that the passage of the IBBEA is having little effect on the banking industry. What is the basis of their argument? On what date were banks allowed to branch across state lines by merging with a bank in a di ...

Feds control of inflation assume that the feds primary goal

Fed's Control of Inflation : Assume that the Fed's primary goal is to reduce inflation. How can it use open market operations to achieve this goal? What is a possible adverse effect of such action by the Fed (even if it ...

Assignment- tvm- tth classbullsubmit using assignment tab

Assignment- TVM- T/Th class • Submit using Assignment tab in eLearning by uploading your completed excel file. • Open a new (fresh) excel workbook to perform you calculations. • You are allowed only one submission, so pl ...

Assume a constant supply of loanable funds when government

Assume a constant supply of loanable funds. When government deficit spending leads to increases in the demand for loanable funds, do interest rates always rise? Explain. (Hint: Consider the role of expectations.)

Careers in financeuse the internet and or strayer resource

Careers in Finance Use the Internet and / or Strayer Resource Center to research career options within the field of finance. Consider the Bureau of Labor Statistics Website, and the Websites of finance professional assoc ...

What are some of the factors that determine the spread

What are some of the factors that determine the spread between the bid and asked price? If the bid- asked spread narrows, what does this mean?

Global interaction among yield curves assume that the yield

Global Interaction among Yield Curves : Assume that the yield curves in the United States, France, and Japan are flat. If the U.S. yield curve suddenly becomes positively sloped, do you think the yield curves in France a ...

In excercises 17-36 assume that a randomly selected subject

In excercises 17-36, assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph and find th ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate