Purchase Solution

total purchase price

Not what you're looking for?

Ask Custom Question

1) Develop an LP model for the problem.

2) Solve the LP model using Solver in excel

I have posted problem below:

Questions

Acme Mexico City purchases two products (Product 1 and Product 2) that it stocks from three different vendors (Vendor A, Vendor B and Vendor C). The suppliers have limited capacity, and no one supplier can meet all of demand of Acme Mexico City. In addition, the vendors charge different prices for the products as shown in the table below:

Vendor's Price
Product A B C
1 $12 $13 $14
2 $10 $11 $10

Each vendor has a limited capacity in terms of the total number of products it can supply. However, as long as Acme Mexico City provides sufficiently advanced orders, each supplier can devote its capacity to product 1, product 2, or any combination of the two products, if the total number of units ordered is within its capacity. Vendor capacities are as follows.

Vendor A B C

Capacity 600 1000 800[1]

The demand at the Acme Mexico City store is 1000 units of product 1[2] and 800 units of product 2[3] .

The purchasing manager wants to determine an optimal buying plan [4] that would help determine how many of each product should be from each vendor. To help the purchasing manager:

Purchase this Solution
Solution Summary

Help is given to to minimize total purchase price.

Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

View More Free Quizzes
Related BrainMass Solutions

  • Determining the cheapest order policy in the given case

    of price=25%*16=$4 per unit per year Annual Holding cost=195*4=$780 Total inventory Cost=Purchase Cost+Total order cost+Annual holding cost=24960+40+780=$25780 It is cheapest to order 6-month supply.

  • Merger as a Purchase

    The difference between the purchase price and the net assets ( assets less liabilities) will be recorded as goodwill.

  • Expected and Actual Rates of Return on Stock

    total return on stock is: Expected return on stock = (Expected dividends during the holding period +Expected selling price - Purchase price of stock)/Purchase price of stock Therefore, the formula listed as Equation 9.2 would not produce the correct

  • Harbour Inc basket purchase of land, building, equipment: allocate purchase price

    70670 Purchase of land, building, equipment: allocate purchase price HARBOUR INC ACQUIRED LAND, BUILDING & EQUIPMENT AT A LUMP-SUM PRICE OF $1,840,000.

  • Calculating economic order quantity

    D =Total demand= 20000 units per year S = ordering cost=$40 per order Case-1 Price is $20 (ordered quantity is less than 500 units) P = Item purchase price = $20.00 per unit H=Holding cost per year=20% of $20=$4.00 EOQ=(2DS/H)^0.5=(2*20000*40

  • Rights issue

    Theoretical price of shares after the rights issue: 10 existing shares at the price of $50 $500 =10. x $50. 1 new share at the price of 40 $40 =1. x $40. 11 total shares have a value of $540 Therefore, value of one

  • How are bulk purchases, such as when all assets of a company

    The FMV is then multiplied by the difference between the total FMV of all assets and the total purchase price, as illustrated above.

  • Rate of return

    Rate of return= Total returns/Purchase price = (6+2)/50 16.00% 2. In the following year, the dividend was raised to $2.25.

  • Constraints

    Price in that month The total Purchase price is the sum of the number of bushels purchased in each month times the purchase price in that month Profit is total Selling price minus total Purchase price You may replace S4, ..., S10 by P4, ..., P10

  • Showing Journal Entries Purchase of Quicker

    The solution shows the journal entries purchase of Quicker. It calculates the book value, price and profits.

View More Related Solutions