Spreadsheet mpodelling and decision analysis

Assignment Help Finance Basics
Reference no: EM13836888

Question1.   Sanderson Manufacturing produces ornate, decorative wood frame doors and windows. Each item produced goes through 3 manufacturing processes: cutting, sanding, and finishing. Each door produced requires 1 hour in cutting, 30 minutes in sanding, and 30 minutes in finishing.

Each window requires 30 minutes in cutting, 45 minutes in sanding, and 1 hour in finishing. In the coming week Sanderson has 40 hours of cutting capacity available, 40 hours of sanding capacity, and 60 hours of finishing capacity. Assume that all doors produced can be sold for a profit of $500 and all windows can be sold for a profit of $400.

a. Formulate an LP model for this problem.

b. Sketch the feasible region.

c. What is the optimal solution?

Question 2. American Auto is evaluating their marketing plan for the sedans, SUVs, and trucks they produce. A TV ad featuring this SUV has been developed. The company estimates that each showing of this commercial will cost $500,000 and increase sales of SUVs by 3%, but reduce sales of trucks by 1%, and have no effect of the sales of sedans. The company also has a print ad campaign developed that it can run in various nationally distributed magazines at a cost of $750,000 per title. It is estimated that each magazine title the ad runs in will increase the sales of sedans, SUVs, and trucks by 2%, 1%, and 4%, respectively. The company desires to increase sales of sedans, SUVs, and trucks by at least 3%, 14%, and 4%, respectively, in the least costly manner.

a. Formulate an LP model for this problem.

b. Sketch the feasible region.

c. What is the optimal solution?

Reference no: EM13836888

Questions Cloud

Case study-the personal touch : FedEx is an organization that never sleeps and for which every minute counts. Each business day the company's more than 275,000 employees and independent contractors handle an average of 6 million packages, using over 669 aircraft and 71,000 truck..
What was the original return on equity : What was the original return on equity
Assignment regarding the business plan : When venture capitalists are asked what they consider most carefully when deciding whether or not to fund a new venture, they consistently respond: "We are most concerned with the quality of the management team and the quality of the business plan..
Spreadsheet mpodelling and decision analysis : Spreadsheet mpodelling and decision analysis
Spreadsheet mpodelling and decision analysis : Spreadsheet mpodelling and decision analysis
Is there a best way to implement lean : Critically analyse the theory, concepts and models of operations and information management and demonstrate an understanding of the strategic importance of information management in global organisations - Is there a best way to implement lean
Did the company cooperate with investigations into the fraud : Whom did the courts and regulatory authorities hold responsible for the misstated financial statements? Did the company cooperate with investigations into the fraud? How did this affect the penalties imposed against the company
Under which policy will external financing be minimized : Under which policy will external financing be minimized
Describe the reason for wanting the pore pressure ratio : Describe the reason for wanting the pore pressure ratio, ru and the pore pressure coefficients A and B - Describe three methods of obtaining pore pressure values.

Reviews

Write a Review

Finance Basics Questions & Answers

  What will be the debt-to-equity ratio

What will be the debt-to-equity ratio after each contemplated restructuring?

  Compute the budgeted statement for iguana inc

Compute the following for Iguana, Inc., for the second quarter (April, May, and June). (Round your dollar amounts to 2 decimal places and your per unit amounts to the nearest whole number. Round intermediate calculations to 1 decimal place for direct..

  A companys fixed operating costs are 650000 its variable

a companys fixed operating costs are 650000 its variable costs are 2.45 per unit and the products sales price is 4.25.

  What is the inventory turnover rate

The Tourist Stop takes an average of 63 days to sell its inventory and an average of 1.5 days to collect payment on its sales. What is the inventory turnover rate?

  Is that investor risk-neutral or risk averse

The one-year risk-free rate is 10%. The corporation has hit on hard times, and the consensus is that there is a 20% probability that it will default on its bonds. If an investor were willing to pay $775 for the bond, is that investor risk-neutral ..

  The excel file restaurant sales provides sample information

The Excel file Restaurant Sales provides sample information on lunch, dinner, and delivery sales for a local Italian restaurant. Develop 95% confidence intervals for the mean of each of these variables, as well as for weekday and weekend sales. What ..

  Need to compute weighted average cost of capital for

need to compute weighted average cost of capital forinitial investment outlay of 30 million consisting of 25 million

  A question says to use the approximate formula

A question says to use the approximate formula

  How the bank would go about assessing risk

Discuss in a two-page document the details of how the bank would go about assessing risk and the probability of default prior to extending credit to the company.

  What yield on the chicago municipal bonds would make

If Treasury bonds yield 6%, and Carter's marginal income tax rate is 40%, what yield on the Chicago municipal bonds would make Carter's treasurer indifferent between the two? Answer 3.42% 3.60% 3.78% 3.97% 4.17%

  Calculation of retained earnings for the given year

Taylor Inc recently repurchased 5.6 million shares of common stock at a price of $43 per share. One plausible reason for this is that the company feels that its stock is overvalued at the current market price.

  How much would that investment be worth today

A) If you invested $1000 in the stock market in 1900, how much would that investment be worth today? B) If your investment in 1900 has grown to $1 million, how much did you invest in 1900?

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