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

Define the term - right issues, Define the term - Right Issues If an...

Define the term - Right Issues If an existing company intends to raise extra funds, it can do so by borrowing or b issuing new shares. One of the most general methods for a

Required barrels of water per day, In the present case, we need to take a d...

In the present case, we need to take a decision about implementing one of the available two options, based on various factors. The available two options are either to complete a se

Islamic banking, what is the exact nature of IDB sukuk

what is the exact nature of IDB sukuk

Shareholders - measuring business performance, Shareholders - Measuring Bus...

Shareholders - Measuring Business Performance Shareholders Actual owners are interested in the company's both short and long term survival.  For this cause they will need

Hedging at Porsche, 1. Should Porsche hedge its foreign exchange risks? 2...

1. Should Porsche hedge its foreign exchange risks? 2. How does Porsche hedge its foreign exchange risk? 3. What is the best hedging strategy? 4. How did Porsche build its Vo

Requirements for raising loan, Requirements for Raising Loan Requireme...

Requirements for Raising Loan Requirements for Raising Loan are as follow: a) Subsidiaries of the company and History. b) Qualifications, ages, and names of the company's dire

Investment analysis, Investment Analysis Any type of company will inve...

Investment Analysis Any type of company will invest finance for the sake of deriving a return that is useful for four main purposes as: 1. To reward the owners or shareholder

Finance applicatios and theory, Zoeckler Mowing & Landscaping''s year-end 2...

Zoeckler Mowing & Landscaping''s year-end 2012 balance sheet lists current assets of $436,500, fixed assets of $551,500, current liabilities of $417,900, and long-term debt of $317

Development banks and financial institutions, Development Banks and Financi...

Development Banks and Financial Institutions There are some sectors in the economy such may not secure adequate funds from commercial banks for different motives. a) May re

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