Find out maximum demand for medium model , Finance Basics

A company that manufactures electrical appliances is looking at one of its lines (washing machines), where it offers three different levels of specification: Basic which sells for £250, Medium which sells for £450 and Luxury which sells for £700. The production of each machine goes through four different stages and you have been provided with the following data table:





Cost per hour

Max. Available


1.5 hours

3 hours

7 hours


6,500 hours


5 hours

8 hours

14 hours


18,000 hours


2.5 hours

4.5 hours

8 hours


8,500 hours


2 hours

2 hours

2 ½ hours


5,200 hours







The marketing department has also done some market research and believes demand for each of the models is limited to 1,450 units of the basic model, 900 of the medium and 750 of the luxury. You are required to:

1. Formulate this problem as a linear program and use Excel's Solver to arrive at a solution, identifying what is the maximum profit the company can achieve in the washing machine product line.

2. How would your answer change if the following happened:

a. Maximum demand for Medium model was 1,000; OR

b. Maximum available Assembly hours were 9,500.

3. Write a report with a recommended production and marketing plan for the company.

Posted Date: 3/18/2013 4:18:37 AM | Location : United States

Related Discussions:- Find out maximum demand for medium model , Assignment Help, Ask Question on Find out maximum demand for medium model , Get Answer, Expert's Help, Find out maximum demand for medium model Discussions

Write discussion on Find out maximum demand for medium model
Your posts are moderated
Related Questions
Functions of Central Depository System or CDS 1. Immobilization of securities that is removal of physical movement of securities. 2. Dematerialization that is removal of ph

Consider a binomial model of a risky asset with the parameters r = 0:06, u = 0:059, d = 0:0562, S 0 = 100, T = 1, 4t = 1=12. Note that u and d are monthly effective rates of retur

main function of the insurance market

Relationships and interactions among money, bond, stock and mortgage markets

Marginal cost of finance This is cost of new finances or additional cost a company has to pay to raise and use additional finance is given by: (Total cost of marginal finan

Disadvantage of Joint Stock Companies Difficult to reconstruct the capital Many formalities in forming the company Heavy initial capital outlay. Loss of secrec

1) Calculate the yield to maturity of a 7-year $1,000 par value bond with an annual coupon rate of 7.5% and a current price of $1,125. Provide the spreadsheet solutions for both an

Forms of Business Organizations The term business is wide in meaning. It includes all human activities made for the sake of earning profits through the process of production of

Dividend yield or Gordon's Model This model is used to determine the cost of various capital components in particular: Cost of equity - K e Cost of preferenc