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

The importance of tax, Discuss business taxes and their importance in finan...

Discuss business taxes and their importance in financial decisions

#title.ASF, Ask questioAustralian’s Speleological App Projectn #Minimum 100...

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

High potential venture, High Potential Venture An organization begins w...

High Potential Venture An organization begins with the intent of growing quickly to annual sales of at least $30 to 50 million in 5 years. It also has the potential to have a f

Cash management techniques, Cash Management Techniques The basic strat...

Cash Management Techniques The basic strategies that must be employed via the business firm in managing its cash are as: i) To pay account payables as behind as possible wi

Example of replacement of assets, Example of Replacement of Assets Est...

Example of Replacement of Assets Estate Developers purchased a machine five years ago on a cost of £7,500.  The machine had a probable economic life of 15 years at the moment

End of Chapter Problems, The Audiology Department at Randall Clinic offers ...

The Audiology Department at Randall Clinic offers many services to the clinic''s patients. The three most common , along with cost and utilization data, are as follows: Service Var

Fixed income securities, Fixed income security can be defined as the ...

Fixed income security can be defined as the financial obligation of an entity (known as the issuer), which promises to pay a specified amount of money on a pre-sp

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

Agency relationship between government and the shareholders, Agency Relatio...

Agency Relationship between Government and the Shareholders Shareholders and via extension, the company they own operate within the environment requiring the charter or licens

Calculate yield to maturity - annual & semi annual payment, 1) Calculate th...

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

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