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

Explain the impact of revenue sources and expenditures on

Explain the impact of revenue sources and expenditures on budget building. Minimum of 250 words with a scholarly reference.

To which market index would you refer to see how well the

To which market index would you refer to see how well the stock market is performing? Why? Why do you think the movements of the Dow and the S&P 500 are highly correlated?

Nbspq1 nbspgiven the following assumptions construct cash

Q1.  Given the following assumptions, construct cash flows on both a de-levered and leveraged basis.  Make sure to label each clearly.  Project involved is a petrochemical plant. Indicate whether you agree that it could ...

You are looking to buy a car you can afford 430 in monthly

You are looking to buy a car. You can afford $430 in monthly payments for four years. In addition to the loan, you can make a $1,200 down payment. If interest rates are 7.50 percent APR, what price of car can you afford? ...

An important source of temporary cash is trade credit which

An important source of temporary cash is trade credit, which does not actually bring in cash, but instead slows its outflow. Vendors often provide discounts for early payment. What is the formula to determine the effecti ...

Q1 an on-line retailing firm conducts a study into the

Q1. An on-line retailing firm conducts a study into the number of on-line purchases of footwear made during all of last year. The study wants to determine the proportion of Australians over the age of 25 who purchase foo ...

Write the word or phrase that best completes each statement

Write the word or phrase that best completes each statement or answers the question. Solve the problem. Round dollar amounts to the nearest dollar. Use the straight-line method to complete the depreciation table for a co ...

Tips capital returnconsider a 400 tips with an issue cpi

TIPS Capital Return Consider a 4.00% TIPS with an issue CPI reference of 183.60. At the beginning of this year, the CPI was 190.70 and was at 199.60 at the end of the year. What was the capital gain of the TIPS in percen ...

Assume that the production of cement also produces a

Assume that the production of cement also produces a substantial amount of air pollution and that a technology is available that can lower the pollution but with somewhat higher production costs for the cement. Because o ...

What is the relationship between the money growth rate and

What is the relationship between the money growth rate and a business cycle recession?

  • 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