Question

Oakton Manufacturing makes two types of rocking chairs specifically designed for men and women known as...

Oakton Manufacturing makes two types of rocking chairs specifically designed for
men and women known as the His and Hers models. Each chair requires four legs
and two rockers but differing numbers of wooden dowels. Each His chair requires
four short dowels and eight long dowels while each Hers chair requires eight short
dowels and four long dowels. Each His chair contributes $10 in profit while each
Hers chair contributes $12. The company has 900 legs, 400 rockers, 1,200 short dowels, and 1,056 long dowels available. The company wants to maximize its profit while also ensuring that it makes at least half as many His chairs as Hers chairs.

(a) Build a table that shows the capacity usage breakdown and profit contribution of the two products.

(b) Formulate a linear optimization model for this problem. (Such as the model on slide 16 of the "9.2" slides – that slide is not numbered, but it’s the one after slide 15.)

(c) Build a spreadsheet representation of the model, and then solve it using Solver. Identify the production amounts of each product and total profit at the solution point. In other words, report how many of each type of chair they should produce and how much profit that will generate. Keep the Solver solution as part of your spreadsheet.

Homework Answers

Answer #1

there is one constraint left

x - 0.5y >= 0

but it does not change the solution

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Vollmer Manufacturing makes 3 components for industrial uses. The components are processed on two machines, a...
Vollmer Manufacturing makes 3 components for industrial uses. The components are processed on two machines, a shaper and a grinder. Component 1 requires 6 minutes on the shaper and 4 minutes on the grinder. Component 2 requires 4 minutes on the shaper and 5 minutes on the grinder. Component 3 requires 4 minutes on the shaper and 2 minutes on the grinder. The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time available in its cutting and sewing department, 150 hours available in its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
TOMS SHOES –Case Study Founded in 2006 by BLAKE MYCOSKIE, TOMS Shoes was an American footwear...
TOMS SHOES –Case Study Founded in 2006 by BLAKE MYCOSKIE, TOMS Shoes was an American footwear company based in Santa Monica, California. Although TOMS Shoes was a for-profit business, its mission was more like that of a not-for-profit organization. The firm’s reason for existence was to donate to children in need one new pair of shoes for every pair of shoes sold. Blake Mycoskie referred to it as the company’s “One for One” business model. While vacationing in Argentina during...
During the trial, lawyers for the accused said that the men believed that the accounting decisions...
During the trial, lawyers for the accused said that the men believed that the accounting decisions they made were appropriate at the time, and that the accounting treatment was approved by Nortel’s auditors from Deloitte & Touche. Judge Marrocco accepted these arguments. Marrocco added he was “not satisfied beyond a reasonable doubt” that the trio (i.e., Dunn, Beatty, and Gollogly) had “deliberately misrepresented” financial results. Given the facts of the case, do you believe Judge Marrocco’s decision was justified? Explain....
Sunshine Enterprises Case Study “I think the waiter wrote in an extra $25 tip on my...
Sunshine Enterprises Case Study “I think the waiter wrote in an extra $25 tip on my Sunshine Café bill after I received and signed my credit card receipt,” Mr. Mark Otter said to the restaurant manager, Brad Gladiolus. “Mr. Otter, mail me a copy of the restaurant receipt and I’ll investigate,” responded Mr. Gladiolus. “I don’t have the receipt—I lost it—but I have my monthly credit card statement,” replied Mr. Otter. Mr. Gladiolus hesitated, then said, “Mr. Otter, I don’t...
The Business Case for Agility “The battle is not always to the strongest, nor the race...
The Business Case for Agility “The battle is not always to the strongest, nor the race to the swiftest, but that’s the way to bet ’em!”  —C. Morgan Cofer In This Chapter This chapter discusses the business case for Agility, presenting six benefits for teams and the enterprise. It also describes a financial model that shows why incremental development works. Takeaways Agility is not just about the team. There are product-management, project-management, and technical issues beyond the team’s control. Lean-Agile provides...
How can differential analysis be applied here to determine if it would be profitable to invest...
How can differential analysis be applied here to determine if it would be profitable to invest in new equipment to increase capacity for a constrained resource? KRAYDEN’S CYCLE COMPONENTS INTRODUCTION: COMPANY, PRODUCT, AND SUPPLY CHAIN Krayden’s Cycle Components (KCC) is a high-end specialty fabricator that manufactures one product with many variants. The basic product is known as a rolling chassis, a key component used in manufacturing motorcycles. While there are variations across the industry, a rolling chassis typically consists of...
QUESTION 1 1. Brianna is trying to increase her chances of being promoted to vice president...
QUESTION 1 1. Brianna is trying to increase her chances of being promoted to vice president by working to build good work relationships with other managers outside her own department. Brianna's behavior should be viewed as dysfunctional politics. functional politics. coercive power. functional influence. 2 points QUESTION 2 1. The Gingerbread Factory has a separate unit that makes their chocolate crunch cookies and another unit that is completely responsible for all operations in producing their ginger snap cookies. The Gingerbread...
1. The failure of the new supply chain system affected Nike adversely. What were the reasons...
1. The failure of the new supply chain system affected Nike adversely. What were the reasons for the failure and how did the breakdown harm Nike? 2. What are the important elements to be kept in mind while implementing a new system in an organization? What is the importance of a good working relationship between partners and the sharing of responsibility in implementing critical projects? What mistakes did Nike and i2 make? 3. comment on the lessons learned and the...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...