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

Example of stock market index, Example of Stock Market Index The follo...

Example of Stock Market Index The following six companies constitute the index of democratic republic of Kusadikika.             Company  A  B

Smsi and s&p, The financial data is of little value in its raw form. Howeve...

The financial data is of little value in its raw form. However, the same may be analyzed and be put in the form more meaningful to the recipients. This is normally done by using va

Characteristics of investment - venture capitalists, Characteristics of Inv...

Characteristics of Investment - Venture Capitalists Venture capitalists, will just invest in a company whether there is a reasonable chance such the company will be successful

Income statement, how ca i calculate the common stock dividends in the inco...

how ca i calculate the common stock dividends in the income statement if it is not mentioned

State the determinants of return, State the Determinants of Return T...

State the Determinants of Return Three major determinants of the rate of return expected by investor are: (i) Time preference risk-free real rate. (ii) Expected rate o

Debentures and bonds, how can debentures be explained in class in term of g...

how can debentures be explained in class in term of game, role play etc....?

Calculate the average daily stock cost, Question: Unsatisfactory contro...

Question: Unsatisfactory control of spare parts in a particular mechanical workshop is resulting in high carrying costs for some items and high stock-out costs for others. A st

T accounts, Accounting Exercise AVM 386 Fall 2014 Misty Mark, an infamous ...

Accounting Exercise AVM 386 Fall 2014 Misty Mark, an infamous archer, decided to open an archery business called Bows and Biceps. The following is a list of transactions for Bows

Evaluating financial statements, WHat are the expected rates of reimburseme...

WHat are the expected rates of reimbursement for this time frame for each player ?

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