User Account

All Pages

Spreadsheet mpodelling and decision analysis

Assignment Help Finance Basics
Reference no: EM13836889

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: EM13836889

Questions Cloud

Report on malaysia hotel environment : Prepare the report on Malaysia hotel environment
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

Reviews

Write a Review

Finance Basics Questions & Answers

  Determine the future value as of the last payment of an an

Perpetuity 1 has cash flows at periods 1 through infinity and a value at period 0 of 7021.43 using an interest rate of 14%. Perpetuity 2 has the same cash flows, but starts at a later date. Its value at period 0, using the same 14% interest rate, is ..

  Explain decision making on the basis of the net present

Explain decision making On the basis of the net present value criterion and annual expenses of feeding and housing the baboon would be $4,000

  What is the total value of the terminal year non-operating

The firm's marginal tax rate is 40 percent, and the project's cost of capital is 14 percent. What is the total value of the terminal year non-operating cash flows at the end of Year 3? Round it to a whole dollar, and do not include the $ sign.

  Construct a 95 confidence interval for the proportion of

in a survey 200 people were asked to identify their major sources of news information 110 stated that their major

  Comprehensive personal financial plan

Create a comprehensive personal financial plan based upon current and future financial needs. This plan must include the following:

  A bond that pays interest annually yields a rate of return

a bond that pays interest annually yields a rate of return of 7.75 percent. the inflation rate for the same period is 4

  You are considering an investment in a aaa-rated us

you are considering an investment in a aaa-rated u.s. corporate bond but you are not sure what rate of interest it

  Favorable and unfavorable trends and significant events

The favorable and unfavorable trends and significant events or uncertainties in the areas of liquidity, capital resources, and the results o operations can all be found in the management discussion and analysis section of the annual report.

  Compute profitability index for each of the three projects

Comparing Investment Criteria. The treasurer of Amaro Canned Fruits, Inc. has projected the cash flows of projects A, B, C as follow.

  Review the financial statements analyse the current

review the financial statements analyse the current financial state of anthonys orchard and evaluate the impact of a

  What should the price of abbot stock be

The last dividend paid by Abbot Labs was $1.00. Abbot's growth rate is expected to be a constant 8% for three years, after which the growth rate is expected to be 10%. Investors require a return of 16% on stocks like Abbot. What should the price o..

  The new clubs will also require an increase in net working

mcgilla golf has decided to sell a new line of golf clubs. the clubs will sell for 733 per set and have a variable cost

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd