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

  Suppose that twin oaks four year bond had seminannual

twin oaks health center has a bond issue outstanding with a coupon rate of 7 percent and four years remaining until

  What is globalization why has globalization become so

1.what is meant by foreign exchange risk? what specific problems does foreign exchange present in an organization? how

  How many choppers would you have to sell to break even if

you and your friends are thinking about starting a motorcycle company named apple valley choppers. your initial

  What are the implications of a higher interest rate

What is it worth if the discount rate increases to 6% because of some risk? Show your calculation. What are the implications of a higher interest rate?

  Hopes to open a rustproofing shop

A retired auto mechanic hopes to open a rustproofing shop. Customers would be local new-car dealers. Two locations are being considered, one in the center of the city and one on the outskirts. The central city location would involve fixed monthly ..

  Computation of future annual receipts considering inflation

Computation of future annual receipts considering inflation rate and what annual income should he plan to receive in the first year of retirement in order to maintain the purchasing power on $20,000

  What is the bond yield to maturity

Bond Matures A bond that matures in 10 years sells for $925. The bond has a face value of $1,000 and an 8 percent annual coupon. Refer to Bond Matures. What is the bond's yield to maturity?

  Project k costs 65000 its expected cash inflows are 15000

project k costs 65000 its expected cash inflows are 15000 per year for 8 years and its wacc is 10. what is the

  Special committee of securities and exchange commission

1. Roll's critique of tests of the CAPM shows that if the index portfolio is ex post efficient, it is mathematically impossible for abnormal returns, as measured by the empirical market line, to be statistically different from zero.

  Discuss empowerment and empowerment theory

Discuss Empowerment and Empowerment Theory, The Strengths Perspective, and Resiliency and why this focus is a vital concept in the Generalist Practice.

  Question regarding the aftertax cost of debt

The company's pretax cost of debt (as an APR) is ______%? If the tax rate is 35 percent, the aftertax cost of debt (as an APR) is_______%

  Difference between a fee-for-service plan

Determine a key difference between a fee-for-service plan and an episode of care payment plan, and indicate the plan that you believe to be most advantageous for the majority of patients. Provide support for your rationale.

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