### 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?

#### Compute enterprise-value-to-ebitda

Companys appropriate enterprise-value-to-EBITDA and enterprise-value-to-EBITA multiples - compute enterprise-value-to-EBITDA and enterprise-value-to-EBITA for Companies 1 and

#### Do you think that grassos compensation was excessive

Do you think that Grasso's compensation was excessive and feel that a portion of the compensation should be repaid and Who is hurt by excessive compensation and are there othe

#### Calculate eoq

Lott manufacturing, Inc. has been ordering parts for its production proces in lots of 10,000 units. Each order costs the firm \$50 to place and holding costs per unit aver \$3.

#### What is the debt-equity ratio

A firm wants a sustainable growth rate of 3.13 percent while maintaining a 27 percent dividend payout ratio and a profit margin of 6 percent. The firm has a capital intensity

#### Making monthly deposits into a savings account

Julie wishes to begin making monthly deposits into a savings account which earns 5% interest annually. If she intends to have saved \$8,500 by the end of 3 years, how much must

#### John jones is buying a house

John Jones is buying a house for \$100,000. John can get a loan for 95% of the purchase price at 8% with monthly payments for a 25-year term. What would his payments be if he b

#### What is the optimal order quantity

Question 1 Omar Haaris receives 5000 tripods annually from Top-Grade Supplier to meet his annual demand. Omar runs a large photographic outlet, and the tripods are used primar

#### What is tedís expected wealth

Ted is considering an investment project that will give him a wealth of W = 50 if the plan is successful and a wealth of 25 if it fails. The local bank will sell him a certiÖc