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

Assets, thew amount of money investedin a retirement fund is an example of

thew amount of money investedin a retirement fund is an example of

Percentage of sales method - financial forecasting, Percentage of Sales Met...

Percentage of Sales Method - Financial Forecasting This method includes expressing various balance sheet items such are directly concerned to sales as a percentage of sales.

5 problem excel on time value concepts, How quickly could something like th...

How quickly could something like this be done? And how confidential is this? Has any student ever been caught using this service?

Agency relationship between auditors and shareholders, Agency Relationship ...

Agency Relationship between Auditors and Shareholders Shareholders appoint auditors as per the provisions of Section 159(1)-(6) of the Companies Act. The auditors are believed

Governmental and not for profit accounting - cafr, Obtain a copy of a Compr...

Obtain a copy of a Comprehensive Annual Financial Report (CAFR) for a state or local government for which you would have an interest. Answer the following questions regarding that

Explain about the new issue market, Explain about the New Issue Market OR P...

Explain about the New Issue Market OR Primary Market New issue market is the segment in which new issues are made. In new issue market, new issues may be made in 3 ways name

US Tsys, How often does the "on the run" tsy change?

How often does the "on the run" tsy change?

Primary markets - financial markets, Primary Markets - Financial Markets ...

Primary Markets - Financial Markets These are markets such deal along with securities that have been issued for the first moment. The money flows directly from transferor or t

Real Estate - Mortgage Prequalification, Bob and Jackie came to your bank s...

Bob and Jackie came to your bank seeking an FHA mortgage. They want to know how large a mortgage they would be qualified for and what the terms would be. Bob is a pastry chef (

Australi a, i ordered case study 1 susam and malcom. when i open the docume...

i ordered case study 1 susam and malcom. when i open the document is completely different, not the same case study an is only relivent in the usa not australia... do you have the c

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