Excel Solver Product Mix Maximizes Revenues
Not what you're looking for?
Stanley Furniture produces two types of china cabinets, First Provincial (FP) and Deluxe Modern (DM). Each cabinet goes through 3 departments: carpentry, painting and finishing. The following table contains relevant information on production times per cabinet produced, daily production capacities for each department and net revenue per cabinet produced. Woodstock has a contract with its distributor to supply at least 60 units of each type of cabinet per day. The company would like to determine a product mix to maximize daily net revenue.
Department
Carpentry Painting Finishing Net Revenue
hrs/cabinet hrs./cabinet hrs./cabinet $'s /cabinet
Cabinet type
FP 3 1.5 0.75 28
DM 2 1 0.75 25
Dept. capacity (hrs.) 360 200 125
Using Excel and the Excel Solver:
(a) What product mix maximizes daily net revenue, and what is daily net revenue?
(b) Stanley Furniture can purchase 30 additional hours of carpentry time for $20 per hour. Should the company purchase the additional time? Explain.
Purchase this Solution
Solution Summary
An Excel Solver examines the product mix maximization for revenues.
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Introduction to Finance
This quiz test introductory finance topics.