27. Monitor the daily production plan
A worksheet is used to monitor daily production. The target is defined as 1,500 pieces per day. To calculate the percentage produced of the daily goal, perform the following steps.
To monitor daily production:
1. Select cell B1 and enter the predefined target: 1500.
2. Select cells C4:C11 and type the following formula: =B4/$B$1.
3. Press <-Ctrl+Enter->.
4. From the Format menu, select Cells and the Number tab.
5. Choose Percentage from Category.
6. Set Decimal places to 2.
7. Click OK.
Watch the Video Tutorial - https://www.youtube.com/watch?v=Y2D6n7BrbbY
Hope You Like This Tutorial - Give Comments
No comments:
Post a Comment