Question: A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes

A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketing restrictions require that the number of chairs produced be at least twice the number of desks produced. There are 2000 units of wood available.
a. Use Solver to maximize the company’s profit.
b. Confirm graphically that the solution in part a maximizes the company’s profit.
c. Use SolverTable to see what happens to the decision variables and the total profit when the availability of wood varies from 1000 to 3000 in 100-unit increments. Based on your findings, how much would the company be willing to pay for each extra unit of wood over its current 2000 units? How much profit would the company lose if it lost any of its current 2000 units?

Step by Step Solution

★★★★★

3.45 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

415-M-S-S-M (71).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Spectra Electronics manufactures five different models of telecommunications interface cards for desktop and laptop PCs. As summarized in Table 1, each of these devices requires differing amounts of...

A furniture company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 15,000 board feet of oak and 21,000 board feet of pine...

Based on your findings from Exercise 3, calculate the one and two-step ahead volatility forecasts. Construct a 95% interval forecast for the SP500 returns. Assume that the returns are conditionally...

Please Help! How do I fill out this table?? A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $400 to...

A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $250 to profit, and a chair contributes $145....

A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $400 to profit, a chair contributes $250. Marketing...

This week, we will practice applying concepts from Chapters 1 3 - 1 4 . Submit a Word document with your responses and be sure to also attach any relevant Excel files with your submission. Chapter 1...

After the productive team meeting, Fullsofts chief technology officer (CTO) wants further analysis performed and a high-level plan created to mitigate future risks, threats, and vulnerabilities. As...

Summarize all the cash flows that cannot be used in the capital budgeting process and explain the reasons.

For years you work as a grocery checker at a supermarket, and one day you are replaced by self-serve checkout stations. What type of unemployment is this? (A) Cyclical (B) Structural (C) Seasonal (D)...

7. Give two examples of long term assets that affected by investing activities.

Michael graduates from New York University and on February 1, 2016, accepts a position with a public accounting firm in Chicago. Michael is a resident of New York. In March, Michael travels to...

Anne works for a CPA firm as a secretary/receptionist and earns approximately $27,000 per year. About five years earlier, she had completed 70 credit hours at State U. To increase her career...

Pat is a participant in a qualified pension plan. She retires on January 1, 2016, at age 63, and receives pension payments beginning in January 2016. Her pension payments, which will be received...

Problems 6 & 8 Suppose a company has a preferred stock issue and a common stock issue. Both have just paid a $2 dividend. Which do you think will have a higher price, a share of the preferred or a...

The capital accounts for the firm are as follows: Common stock (2,100,000 shares at $5 par) Capital in excess of par* Retained earnings Net worth $10,500,000 3,000,000 26,500,000 $40,000,000 *The...

WACC AYY Inc. has a debt outstanding with a market value of $ 9 , 0 0 0 , 0 0 0 and 1 6 0 , 0 0 0 common shares currently trading at $ 4 6 each. The firm has a tax rate of 0 . 3 2 . The yield on the...