Jump to content
Mechanical Engineering

Recommended Posts

I used to teach a course at university on process optimization. There are several simple problems that can be solved using Excel. For example, it takes so long to produce X and a different time to produce Y and another time to switch over from one to the other. If you must produce a total of Z, what is the optimal approach? The Tom's cracker factory is less than a mile from my house. [Sadly, they have since closed )-;] They made cheese and also peanut butter crackers on the same machines and it takes a while to switch over. There is also a factory in town that makes plastic door mats and also special mats to use at the driving range to whack golf balls. That is also done on the same machine. Shutting the machine down and bringing it up again wastes $15,000; so the decision is not made lightly. I have attached a few spreadsheets, of course, one of them must be McDonalds Big Mac and fries!

AutoAssembly.xls cabinets.xls carsales.xls mcdonalds.xls WhittWindowCo.xls

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Join Mechanical Engineering network

    Join us (login) to get full access : Please sign up to connect and participate.

    To download files...please login

  • Create New...