You spoke about scientific notation in few of your video tutorials. When you use solver and solve, some of the numbers shows in scientific notation. You can easily use the decimal point function in the top of excel moving it right or left and make it number rather than keeping it as scientific notation. Always loved your videos.. keep uploading more videos. Thanks a lot for the learning materials. Helps me a lot.
Hi Professor , Question on the holding cost formula - shouldn't we multiply the ending inventory * holding cost per unit per month * -1 . So that total cost will include holding cost as well.
In aggregate planning with backordering tutorial, when you ran solver, overtime hours appeared in scientific notation. During the preparation of the worksheet, you added available regular hours + overtime hours to calculate workers hours available. Overtime hours is a decision variable. So after running solver if the overtime hours appears in scientific notation, excel can not calculate the scientific notation. Therefore excel won't add available regular hours to overtime hours to calculate total workers hours available. What you could do is, you could have adjust the scientific notation by changing it in the decimal point option available in the top function menu bar. You highlight the overtime hours rows and then click on the decimal point function in the menu bar to the right and left. You can adjust it to the decimal point where excel can calculate all those overtime hours to the workers hours available. Thank you.
You spoke about scientific notation in few of your video tutorials. When you use solver and solve, some of the numbers shows in scientific notation. You can easily use the decimal point function in the top of excel moving it right or left and make it number rather than keeping it as scientific notation. Always loved your videos.. keep uploading more videos. Thanks a lot for the learning materials. Helps me a lot.
Hi Professor ,
Question on the holding cost formula - shouldn't we multiply the ending inventory * holding cost per unit per month * -1 . So that total cost will include holding cost as well.
In aggregate planning with backordering tutorial, when you ran solver, overtime hours appeared in scientific notation. During the preparation of the worksheet, you added available regular hours + overtime hours to calculate workers hours available. Overtime hours is a decision variable. So after running solver if the overtime hours appears in scientific notation, excel can not calculate the scientific notation. Therefore excel won't add available regular hours to overtime hours to calculate total workers hours available. What you could do is, you could have adjust the scientific notation by changing it in the decimal point option available in the top function menu bar. You highlight the overtime hours rows and then click on the decimal point function in the menu bar to the right and left. You can adjust it to the decimal point where excel can calculate all those overtime hours to the workers hours available. Thank you.
Can you post .xls file please ?