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:

Process\Machine

Basic

Medium

Luxury

Cost per hour

Max. Available

Forming

1.5 hours

3 hours

7 hours

£5.50

6,500 hours

Machining

5 hours

8 hours

14 hours

£7.50

18,000 hours

Assembly

2.5 hours

4.5 hours

8 hours

£9.50

8,500 hours

Testing

2 hours

2 hours

2 ½ hours

£12.00

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
discuss the flow of fund in an open economy

according to given specialization take down an industry and investigate its managerial hierarchy to describe each of one of the managerial work level functioning

Ask questioAustralian’s Speleological App Projectn #Minimum 100 words accepted#

A compnay can arrange for a secured loan amounting to 150,000,000 for one year at an interest rate of 18% per annum based on the initial balance of the loan. The lender also imposs

Valuation of Share A number of parties are interested however in the value of shares and securities and that will include: Company shareholders, vendors and directors of

1. Using the variance-covariance matrix (∑) and the expected return vector (er) given in the appendix, calculate the set of weights that correspond to the portfolio that maximizes

Quetion1: You are earning 5.2 percent on a certificate of deposit. Inflation is running 3.5 percent. What is the real rate of return on your investment? Question2: Search for

Five years ago, you bought a house for $151,000, with a down payment of $30,000, which meant you took out a loan for $121,000. Your interest rate was 5.75% fixed. You would like to

Lock-Box System In a lock-box system, the customer sent the payments to a post office box. The post office box is emptied with the firm's bank at minimum once or twice all bus

WHy does most interbank currency trading worldwide involve the US dollar?"