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.
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))
The Burrito exercise is something.
The link for the file is invalid, I could not download the file. TT
For the shipping part, the make, does he have a formula? if yes, what is it?
Formula for calculating shipping costs for each?
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 !!!!!!!!!!!
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.
Thanks very much, very useful video.
Well done, could you please share us the files
Sorry that it took me four months! I've added the file in the description
Thanks for sharing Mark, file download link don't seem to be working
Updated
THANKS, THIS IS REALLY USEFUL....
well explained
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 :)
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?
The link to the file doesn't work.
I wasn't able to reach the file either.