A manufacturer is going to produce four products. The relative data for production are listed below....

A manufacturer is going to produce four products. The relative data for production are listed below.

setup cost unit profit resource used

product 1 400 100 10

product 2 400 60 5

product 3 500 120 12

product 4 600 160 16

--The total resource available is 1000.

--product 2 and 4 are mutually competitive items, hence will not be produced at the same time.

--Product 1 will be produced only if product 3 is produced.

Try to establish the mathematical model for this problem to determine the production quantity of each product with total profit maximized. Solve it with Excel.

Expert Solution

orchestra answered 1 year ago

A company is able to produce four products and is planning its production mix for the...

A company is able to produce four products and is planning its production mix for the next period. Estimated cost, sales, and production data follow: Product W X Y Z ₤ ₤ ₤ ₤ Selling Price/unit 29 36 61 51 Labour (@ ₤ 5/hr) 15 10 35 25 Material (@ ₤ 1/kg) 6 18 10 12 Contribution ₤8 ₤8 ₤16 ₤14 Resources/Unit ₤ ₤ ₤ ₤ Labour (hours) 3 2 7 5 Materials (Kgs.) 6 18 10 12 Maximum...

MARKETING Listed below are four different products in various stages of the product life cycle. What...

MARKETING Listed below are four different products in various stages of the product life cycle. What marketing strategies would you suggest to these companies? A - Remotely operated appliances such as lighting, heating & air conditioning units, or coffee makers – Introductory Stages B - Hewlett-Packard tablet computers—growth stage C - Canon digital cameras—maturity stage, D - handheld manual can openers—decline stage.

Cranston Corporation makes four products in a single facility. Data concerning these products appear below: Products...

Cranston Corporation makes four products in a single facility. Data concerning these products appear below: Products A B C D Selling price per unit $ 42.30 $ 50.00 $ 37.60 $ 33.50 Variable manufacturing cost per unit $ 20.80 $ 30.70 $ 21.00 $ 19.90 Variable selling cost per unit $ 2.70 $ 2.10 $ 1.00 $ 2.40 Milling machine minutes per unit 3.30 4.10 2.60 1.30 Monthly demand in units 1,000 4,000 3,000 3,000 The milling machines are potentially...

Use the data in the table below for this week’s assignment Production (millions of vehicles) MANUFACTURER...

Use the data in the table below for this week’s assignment Production (millions of vehicles) MANUFACTURER Year 1 Year 2 Year 3 Year 4 Year 5 TOYOTA 8.04 8.53 9.24 7.23 8.56 GM 8.97 9.35 8.28 6.46 8.48 VOLKSWAGEN 5.68 6.27 6.44 6.07 7.34 HYUNDAI 2.51 2.62 2.78 4.65 5.76 Instructions: Input the data into an SPSS work sheet. Make sure that all your variables are labelled appropriately (Need to show how to properly set up the variables for charting...

Special Journal problem: Four days of sales data for the campusbookstore are listed below. Design...

Special Journal problem: Four days of sales data for the campus bookstore are listed below. Design a cash sales journal in a spreadsheet to record this data so each day is a SINGLE row. Use column headings to indicate the items to record and whether an entry in that column is a debit or credit. Also be sure to include a miscellaneous debit and credit columns with an accompanying column for the account number. Which columns would you total? What...

6. The assets listed below are going to be liquidated to finance an acquisition. Consider their...

6. The assets listed below are going to be liquidated to finance an acquisition. Consider their one-year liquidation value to be fair market value. Asset Face value Current One-year Liquidation value Liquidation value PACCAR stock 80,000 70,000 77,500 Safeco bonds 40,000 36,000 39,000 Treasury bonds 25,000 25,000 25,000 A.Calculate the one-year liquidity index for these securities. B.What does your answer mean for the bank? 7. If a bank manager was certain interest rates were going to rise within...

Production planning is the systematic and strategic design of production processes that can produce products and...

Production planning is the systematic and strategic design of production processes that can produce products and deliver services quickly, precisely, and efficiency that achieve a set of common objectives. The principle objective of this process is to stay competitive. A successful process design has to take into account the appropriateness of the process to overall organization objective. Process design requires a broad view of the whole organization and should not have a myopic outlook. And the process should deliver customer...

Listed below are 20 lengths (in minutes) of randomly selected movies. (a) Construct a relative frequency...

Listed below are 20 lengths (in minutes) of randomly selected movies. (a) Construct a relative frequency histogram to represent the data. Use six classes with a class width of 11, and begin with the first interval class [89, 100), and the second interval class [100, 111), and so on. 90, 92, 94, 94, 95, 96, 105, 108, 110, 116, 117, 119, 119, 120, 125, 132, 132, 136, 149, 154 (b) Calculate the sample mean and the sample standard deviation. (c)...

A drug manufacturer uses two production facilities to produce a pain reliever. The amount of the...

A drug manufacturer uses two production facilities to produce a pain reliever. The amount of the active ingredient of the drug in the capsules at the two facilities, X1 and X2, are normally distributed random variables. The desire of the quality control manager is that the population mean amounts of the active ingredient in the capsules, μ1 and μ2, be equal. Recent tests on small samples have indicated a noticeable increase in the amount of the active ingredient in capsules...

This exercise must be completed on the four subscales below, and you should, therefore, produce four...

This exercise must be completed on the four subscales below, and you should, therefore, produce four reliability analyses. Subscale 1 (Fearof statistics): items 1, 3, 4, 5, 12, 16, 20, 21 Subscale 2 (Peerevaluation): items 2, 9, 19, 22, 23 Subscale 3 (Fearof computers): items 6, 7, 10, 13, 14, 15, 18 Subscale 4 (Fear of mathematics): items 8, 11, 17

Question