Modelling Problem Using Excel
Not what you're looking for?
A company that makes bikes wants to maximize profit over the next five months.
Materials for each bike costs $600.
Both humans and machines are needed to produce each bike.
Each human can work on up to 100 bikes per month.
Each machine can work up to 200 bikes per month.
TetraCon, Inc. has 4 humans and no machines.
Each human costs $6000 a month. It costs $2500 to hire a human, $1000 to fire a human. Hiring's and firings may take place at the beginning of each month.
Machines must be bought either at the beginning of January or March and costs $15000 each. Machines can be sold at the beginning of April for $12000, but at least one Machine must be owned at the end of May.
The demand for bikes in each of the next five months is as follows:
January: 600
February: 500
March: 400
April: 300
May: 600
At the end of each month TetraCon, Inc. incurs an inventory cost of $50 per bike.
Each bike is sold for $790.
Ignore the value of time.
Purchase this Solution
Solution Summary
The solution is attached as a Word report as well as an Excel spreadsheet.
Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.