User Account

All Pages

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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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