Excel Solver Problem
Not what you're looking for?
Please give some feedback on setting up solver
Picnic Table Bench(separate) Armchair Chaise Lounge Available
Price $225 $225 $275 $300
Redwood (board Ft.) 22 6 7 8 4,500
Cedar (board ft) 12 4 4 0 3,600
12 inch fittings 18 4 0 2 2,250
8 inch fittings 12 4 6 6 2,075
Bolts 48 12 12 20 5,925
Labor(Hours) 20 5 8 12 4,800
Redwood costs $8 per board foot cedar costs $6 per board foot, 12 inch fittings cost $2.50 8 inch fittings cost $1.50 bolts cost $.50 the hourly wage rate and fringe benefits of the workers average $9.00 per hour.
Because of prior orders at least 50 benches and at least 40 chaise lounges must be produced. Use the excel Solver.
Purchase this Solution
Solution Summary
The expert examines solver problems for board foot cedar costs. Fringe benefits of the workers average $9.00 per hour are determined.
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
Motivation
This tests some key elements of major motivation theories.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Introduction to Finance
This quiz test introductory finance topics.