Question

In: Statistics and Probability

A & B manufactures and sells two types of products to a number of customers. The...

A & B manufactures and sells two types of products to a number of customers. The resources are as follows:

Material Type	Product X	Product Y	Available
Material P	8	10	31,250
Material Q	10	5	20,000
Direct Labour	4	5	17,500

Maximum sales(demand) for X is 1000 units and Y 3000 units.Contribution margin X $96 and Y $110

Formulate a linear programme

Solve in excel

Write a brief report to explain the analysis

Expert Solution

The linear programming based on above information can be formulated as follows:

Let the number of product X be x and number of product Y be y.

Maximize Z = 96x + 110y

Subject to constraints:

8x + 10y < = 31250

10x + 5y < = 20000

4x + 5y < = 17500

Step 1: Put the data onto the spreadsheet

Step 2: Define the Objective Function Constraint

Step 3: Define the material P constraint

Step 4: Define the Material Q constraint

Step 5: Define the Direct Labor Constraint

Step 6: Go to data --> solver

Step 7: Select the data

Step 8: Click Solve

As per the output, the maximum profit is $ 349583.3 at 729 units of Product X and 2541 units of Product Y.

orchestra answered 1 year ago

Suppose a monopoly sells to two identifiably different types of customers, A and B. The inverse...

Suppose a monopoly sells to two identifiably different types of customers, A and B. The inverse demand curve for group A is PA= 20-QA, and the inverse demand curve for group B is PB= 20-2QB. The monopolist is able to produce the good for either type of customer at a constant marginal cost of 4, and the monopolist has no fixed costs. If the monopolist is unableto price discriminate (no reselling), (1) what arethe profit maximizing price and quantity, and...

2.) A company manufactures two types of products, A and B. The unit revenues are $2...

2.) A company manufactures two types of products, A and B. The unit revenues are $2 and $3, respectively. Two raw materials M1 and M2, used in the manufacture of the two products have daily availabilities of 4 and 6 units, respectively. One unit of A uses 1 unit of M1 and 1 unit of M2, and one unit of B uses 1 unit of M1 and 2 units of M2. a) Formulate a linear programming model and obtain the...

A Company manufactures and sells two products: A and B. The following table shows the information...

A Company manufactures and sells two products: A and B. The following table shows the information relating to these products: A B Total Selling price per unit $20 $40 Variable cost per unit $10 $20 Total Fixed costs $80,000 Required: If Sales mix is 2 :3 for A and B respectively, calculate the breakeven point in units and in dollars for each of the two products.

Pepper’s Products manufactures and sells two types of chew toys for pets, Squeaky and Silent. In...

Pepper’s Products manufactures and sells two types of chew toys for pets, Squeaky and Silent. In May, Pepper’s Products had the following costs and revenues: Pepper's Products Income Statement For the Month of May Squeaky Silent Total Sales revenue $ 149,000 $ 170,000 $ 319,000 Direct materials 19,000 22,000 41,000 Direct labor 80,000 20,000 100,000 Overhead costs Administration 20,000 Production setup 45,000 Quality control 15,000 Distribution 20,000 Operating profit $ 78,000 Pepper’s Products currently uses labor costs to allocate all...

A Company is selling two products A and B. It sells the two products at the...

A Company is selling two products A and B. It sells the two products at the prices of AED 190 and 230 respectively. The finance department estimated the fixed cost for both products A and B as AED 2400 and 2550 and the variable cost to make a unit of each product is AED 70 and 60 respectively. Compute the number of units the company must sell to Break-Even from each product? Compute the total revenue at these Break-Even Points?...

Pepper’s Products manufactures and sells two types of chew toys for pets—Squeaky and Silent. In May,...

Pepper’s Products manufactures and sells two types of chew toys for pets—Squeaky and Silent. In May, Pepper’s Products had the following costs and revenues. Pepper's Products Income Statement For the Month of May Squeaky Silent Total Sales revenue $ 145,000 $ 155,000 $ 300,000 Direct materials 19,000 18,000 37,000 Direct labor 70,000 30,000 100,000 Overhead costs Administration 20,000 Production setup 64,000 Quality control 15,000 Distribution 20,000 Operating profit $ 44,000 Pepper’s Products currently uses labor costs to allocate all overhead...

Two shops A and B attract two types of customers: price-sensitive customers, who shop at the...

Two shops A and B attract two types of customers: price-sensitive customers, who shop at the lower-priced shop, and time-sensitive customers, who shop at whichever shop is on their side of the street. A customer of either type purchases on average 10 goods. Assume there are 800 price-sensitive customers and 500 time-sensitive customers buying goods on any given day. The wholesale price the shop pay per good is $3. For simplicity, assume that they can charge $3.50, $4.00, or $4.50...

Koppenhaver Products, Inc., has a Relay Division that manufactures and sells a number of products, including...

Koppenhaver Products, Inc., has a Relay Division that manufactures and sells a number of products, including a standard relay that could be used by another division in the company, the Electronics Division, in one of its products. Data concerning that relay appear below: Capacity in units 86,000 Selling price to outside customers $ 63 Variable cost per unit $ 41 Fixed cost per unit (based on capacity) $ 10 The Electronics Division is currently purchasing 15,000 of these relays per...

Little Goose Products, Inc., has a Parts Division that manufactures and sells a number of products,...

Little Goose Products, Inc., has a Parts Division that manufactures and sells a number of products, including a beak that could be used by another division in the company, the Stuffed Animal Division, in one of its products. Data concerning that beak appear below: Parts Division Capacity in Units 50,000 Selling Price to outside customers $50 Variable cost per unit $34 Fixed cost per unit (based on capacity) $5 The Stuffed Animal Division is currently purchasing 12,000 of these beaks...

USM sells products it manufactures in the United States to unrelated foreign and U.S. customers who...

USM sells products it manufactures in the United States to unrelated foreign and U.S. customers who agree in a written installment debt obligation to pay the purchase price in installments over a period of 5 years. USM sells the installment obligations to Matterhorn for less than the unpaid principal balance on the obligations. Matterhorn either collects the obligations at maturity at face value or sells them to an unrelated party for more than it paid USM for them but less...