Reference no: EM131275383
A futon manufacturer makes two types of wood futon bed frames, Model A and Model B. The wood used for the frame is purchased from two sources, Supplier 1 and Supplier 2. To keep quality of the product high and consistent the manufacturer requires that each bed frame be made entirely out of the wood from either Supplier 1 or Supplier 2. Supplier 1 can supply a total of 7,500 board feet of wood and Supplier 2 can supply 10,000 board feet in the coming season. Due to the difference in quality, the amount of wood required to produce a frame is different. Model A requires either 10 board feet of wood from Supplier 1 or 20 board feet from Supplier 2, while Model B requires either 5 board feet of wood from Supplier 1 or 8 board feet from Supplier 2. Model A can be sold for $500 each and Model B for $300. Answer the following questions independently.
a. Formulate a spreadsheet model; and determine how the company can maximize its revenue. That is, specify how many units of each model to make and How much wood to purchase for each model from each supplier. What is the total revenue?
b. To attract different types of customers, the company wants to keep Model A between 25% and 40% of the total production. Modify the model and resolve the problem. Also generate a sensitivity analysis report for later use. Determine the new optimal (wood) purchase and (bed frame) production plan.
c. The material and processing costs per board foot of wood from Supplier 1 and Supplier 2 are $6 and $5, respectively. Finishing cost for each unit of Model A is $40 and for Model B is $80. Formulate the problem to maximize the total profit.
d. From question a, generate a parameter analysis report to show how the optimal solution and the total revenue are affected by the change of the price for Model A, ranging from $100 to $1500 with an increment of $50. How many different optimal solutions have appeared in that range of price for Model A? Show the range of price for each optimal solution.
e. For question b, generate a sensitivity analysis report. If the wood available from the two suppliers decreases by 1000 board feet each, will you be able to compute the impact of the total revenue from the report? Why or why not? What would the impact be? Would the optimal solution change?
|
Proceeds immediately to purchase the tract of property
: A real estate developer has the option to purchase a tract of land near a proposed ‘supermall’ location. Her vision is to design a ‘planned’ community that integrates the neighborhood with the shopping and recreational opportunities of the new mall. ..
|
|
Understanding learning-consequences of behavior
: "Understanding Learning" Please respond to the following: Analyze two (2) of the four (4) consequences of behavior, and illustrate an incidence where a combination of those two (2) would occur together.
|
|
What will the court do with the cash
: Mary Miser tells Gloria Goodytwoshoes that she is going to give her $1,000 cash. She will leave it in a safety deposit box which has Mary's and her husband's name on it. Mary puts a written statement in the box which says, "This entitles Gloria to th..
|
|
Organizational development and strategy
: "Organizational Development (OD) and Strategy" Please respond to the following: • Appraise the importance of the OD field in terms of its benefits in increasing business performance. • Compare and contrast the internal levels of change and resistance..
|
|
Formulate spreadsheet model
: A futon manufacturer makes two types of wood futon bed frames, Model A and Model B. The wood used for the frame is purchased from two sources, Supplier 1 and Supplier 2. Formulate a spreadsheet model; and determine how the company can maximize its re..
|
|
Discuss individual and team rewards
: Locate a minimum of 2 peer-reviewed articles that discuss individual and team rewards. Provide a summary of the article and share how the conflict was resolved. State whether you agree or disagree with team rewards. Support your views with peer-revie..
|
|
Draw the decision tree all options-payoffs-probabilities
: Mark is considering opening a bookstore in a town center, and he has begun an analysis of the situation. There are two possible sites under consideration. One is relatively small, while the other is large. Draw the Decision Tree (show all options, pa..
|
|
Use what you have learned about forecasting
: Gave an example to illustrate how you might use what you have learned about forecasting. Explain why a forecast is needed and how you would go about developing an appropriate forecast for the situation. Specific numbers or calculations are not requir..
|
|
The first step in the human resource planning process
: The first step in the human resource planning process is. Imagine that you manage a car dealership affiliated with one of the big three U.S. automakers. Given the increasing complexity and variety of today's automobiles, it's impossible to train your..
|