Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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 describe and contrast the role of rfdc and rfid for

1. Describe and contrast the role of RFDC and RFID for logistics and supply chain applications. 2. Discuss the relative benefits of software purchase, use of third-party providers, and use of application service provider ...

Crypton electronics has a capital structure consisting of

Crypton Electronics has a capital structure consisting of 41% common stock and 59% debt. A debt issue of $100 0par value, 5.8% bonds that mature in 15years and pay annual interest will sell for $975. Common stock of the ...

1 distinguish between the two types of balloon mortgages2

1. Distinguish between the two types of balloon mortgages. 2. What is the difference between a permanent and temporary buydown mortgage? 3. Discuss the advantages and disadvantages found in shorter-term mortgage loans. 4 ...

Do the assigned questions using malimash incs 2014

Do the assigned questions using Malimash, Inc.'s 2014 financial data below: Malimash, Inc. 2014 Financial Data ($ millions) Income Statement Data Sales Revenue  $7,120.00 Depreciation  $230.00 Interest Expense  $10.00 Pr ...

1 why is cindy fratelli unprepared to play an ihr role2 how

1. Why is Cindy Fratelli unprepared to play an IHR role? 2. How can she prepare herself? 3. What areas of IHR will Cindy need to learn?

If the risk-free rate is 103 percent and the market risk

If the risk-free rate is 10.3 percent and the market risk premium is 4.6 percent, what is the required return for the market?

In november 2009 the government of north korea announced

In November 2009, the government of North Korea announced that it was replacing the existing currency with a new currency. The government would allow people to exchange only a limited amount of the old currency for the n ...

Determine which report format is bestfor each of the

Determine which report format is best. For each of the following scenarios, which report format would you choose and why? If you would use a primarily text-based report format, identify whether you would create a separat ...

Financial analysisyou have conducted a significant amount

Financial Analysis You have conducted a significant amount of research about how to analyze the financial health of a company. Now you are going to put all of your research and discussion into practice. Choose three rati ...

Question 1 when ranking security returns from highest

Question 1. When ranking security returns from highest return to lowest return, the data shows that the annualized returns are as follows: Large stocks, small stocks, long-term corporate bonds, long-term government bonds ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen