Find out maximum demand for medium model , Finance Basics

Assignment Help:

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.


Related Discussions:- Find out maximum demand for medium model

Compute the payback period - example, Compute the Payback Period - Example ...

Compute the Payback Period - Example Cedes restriction has the following details of two (2) of the future production plans. Just one of these machines will be purchased and su

Modern methods of capital projects, what are the modern methods of evaluati...

what are the modern methods of evaluating capital projects? how they different from old methods?

what is their average aggregate inventory value, 1. The Marlin Company ope...

1. The Marlin Company operates 50 weeks a year, and its cost of goods sold last year was $1,500,000. The firm carries six items in inventory: three raw materials, two work-in-proce

Benefits ordinary share capital - financing, Benefits Ordinary Share Capita...

Benefits Ordinary Share Capital - Financing Benefits of using ordinary share capital in the financing They facilitate projects particularly long-term projects since they

IS LM, After carefully reading all the available information, prepare a two...

After carefully reading all the available information, prepare a two page (double-spaced) essay and answer the following questions: Assume that we have the following data: C=100+0.

What are the advantages of listing on stock exchange, What are the Advantag...

What are the Advantages of Listing on Stock Exchange (i) Detailed information about company is available. (ii) Information increases activity of purchase and sale of the sec

Trial and error method, Trial and Error Method a) Select any rate of i...

Trial and Error Method a) Select any rate of interest on random and employ it to compute NPV of cash inflows. b) If rate selected produces NPV lower than the cost, want a l

Example of baumol's model, Example of Baumol's Model ABC Ltd. creates ...

Example of Baumol's Model ABC Ltd. creates cash payments of Shs.10, 000 per week.  The interest rate at marketable securities is 12 percent and every moment the company sells

Acceptance rule of irr, Acceptance Rule of IRR IRR will accept a ventu...

Acceptance Rule of IRR IRR will accept a venture if its IRR is higher than or equivalent to the minimum required rate of return such is usually the cost of finance also recogn

Potential investors - measuring business performance, Potential Investors -...

Potential Investors - Measuring Business Performance Potential investors These parties are interested in a company in total both on long and short term basis in particula

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd