The workbook in your comments opens up a different file. It opens a file with tabs titled: READ FIRST, Burrito, Jewelry, Potato Chips, and Exam Points.
A bicycle manufacturer produces a racing bicycle and a commuting bicycle. Long-term projections indicate a minimum expected demand of at least 100 racing and 80 commuting bicycles each day. However, they can produce no more than 200 racing and 170 commuting bicycles each day. To satisfy a shipping contract, they must produce a total of at least 200 bicycles each day. If each racing bicycle sold results in a $20 loss, but each commuting bicycle produces a $50 profit, how many of each type should they make daily to maximize net profits? I really need help solving this can you help please !!!!!!!!!!!
Demand can't always be met, check out the hours worked/available hours, only tech D has 1 hour left out of his total but he can't make anymore of produkt 2 since it takes him 3,5 hours - so yea sometimes demand can't be met :)
Great and comprehensive tutorial about Solver. The best I have seen!
You sir are a scholar and a saint. Was having issues with a final project and this video got me through it.
Thanks very much, very useful video.
The link for the file is invalid, I could not download the file. TT
The workbook in your comments opens up a different file. It opens a file with tabs titled: READ FIRST, Burrito, Jewelry, Potato Chips, and Exam Points.
If you want the best solution taking into account the distribution of excess staff, you can minimize: sum(Total staff + max(exess staff))
A bicycle manufacturer produces a racing bicycle and a commuting bicycle. Long-term projections indicate a minimum expected demand of at least 100 racing and 80 commuting bicycles each day. However, they can produce no more than 200 racing and 170 commuting bicycles each day. To satisfy a shipping contract, they must produce a total of at least 200 bicycles each day. If each racing bicycle sold results in a $20 loss, but each commuting bicycle produces a $50 profit, how many of each type should they make daily to maximize net profits?
I really need help solving this can you help please !!!!!!!!!!!
The Burrito exercise is something.
THANKS, THIS IS REALLY USEFUL....
For the shipping part, the make, does he have a formula? if yes, what is it?
well explained
Formula for calculating shipping costs for each?
In the chocolate bar problem you didnt make the demand. I wonder if the constraint should have been => demand ..
link to go to that page and read.
It appears that your solution did not end up meeting the demand on the "transistors" sheet. Was this supposed to happen?
Demand can't always be met, check out the hours worked/available hours, only tech D has 1 hour left out of his total but he can't make anymore of produkt 2 since it takes him 3,5 hours - so yea sometimes demand can't be met :)
Thanks for sharing Mark, file download link don't seem to be working
Updated
what do you do if its just demand?
That shouldn’t be a problem as long as the demand constraint is possible. What’s the scenario?
Well done, could you please share us the files
Sorry that it took me four months! I've added the file in the description
The link to the file doesn't work.
I wasn't able to reach the file either.