Відео

Thanks! I’m glad it was helpful

Thanks!

Thank you!

Glad you like it!

Thanks for the feedback

Sorry, I cannot. The templates are easy enough to set up yourself quickly.

There is a whole playlist there for you!

You could crash D by 4 as long as you crash E by 2 as well. I illustrate it this way to show that after D is crashed twice you now have two critical paths.

I did make a mistake there and the crash cost of B should be $600 instead of $400 but it doesn’t affect the final solution since B never gets crashed. Thanks for pointing out the error and hope this helps.

Prego!

Congratulations!

Thanks!

You’re welcome!

Hi there. That green line has the least amount of variation compared to the others and is the closest to the actual results than the others. Hope this helps.

You’re welcome! Good luck on your midterm!

I don’t have one right now but you should be able to easily duplicate it by calculating the absolute deviation for each forecast |actual - forecast| and then averaging them all to get the MAD. Do the same for the absolute percentage error |(actual - forecast)/actual| and averages them all for MAPE Hope this helps

I’m not sure what you mean by the “fastest duration”. Perhaps you mean the shortest possible time and that would be determined when you have crashed all paths and you might end up with more than one critical path. When you have multiple critical paths a you must be able to crash each by the same time to keep crashing to get to the shortest possible or project completion time (duration).

Hi there. Yes, since the results of the function is numeric you should be able to apply regression analysis unless you end up in a circular loop where you intend to use the regression results in the function which you then use in the regression. Give it a try and see what you get!

Thanks bro!

You’re most welcome!

The fixed capacity costs of the operation don’t change so they are not relevant to the alternatives. This scenario compares different variable cost alternatives. Hope this helps. Mark

Sorry for the delay Processing Time only accounts for the time the item is actively worked on. Flow Time includes all the time the item spends in the system, combining active work time and any idle or waiting time. Hope this helps

Hi there, Well if you don’t know the normal cost you have to then be told the incremental cost to crash otherwise you can’t solve the problem. Hope this helps. Mark

Hi there, That’s a great question. The days of closing the doors for inventory are pretty much gone and is very much a holdover from the days where we didn’t have live perpetual inventory systems. The disruption to sales by shutting down doesn’t make sense anymore so companies now use cycle counting where inventory is counted on a regular basis (sometimes daily in some operations I have seen) where certain inventory classes and items are randomly selected for counting. Over the course of a year all the inventory would end up being counted but instead of all at one, regularly in smaller chunks over the year. Cycle counting is also approved by auditors and allows for more frequent counting of high value items. Hope this helps!

You’re welcome!

Thanks!

Because the requirement specifically asks for options based on hiring and firing and holding production steady. Other options such as using overtime are possible but wasn’t the requirement here.

You’re very welcome!

You’re welcome!

You’re welcome!

Hi there. Sorry I’m unable to provide tue file. The data is simple enough for you to duplicate in a blank worksheet, however.

You're welcome!

@@The_Business_Doctor 😊

Thanks!

Hi Armando, That's a good question, but the centre of gravity model is not intended to be used for more than one centre of gravity (which would be like having two suns in the solar system!). If you're looking to add two distribution centres to a network, presumably each is intended to support a specific geographic region so I think you would want to look at the entire network and decide which ones to group together (such as northern region and southern region) and then use the model to find the centre of gravity for those regions separately. Each DC could conceivably act as a backup for the other region incase something happens to one (say it blows up or something), but it won't be in an optical location. Mark

Go for it!

Thanks. Yes there are many ways to solve a problem like this. I did it this way for a particular reason to demonstrate that particular Excel function.

You’re welcome! Good luck on your test!