1. There is a BOM: analyze the usage according to the BOM, check the inventory, and formulate a "purchase requisition".
2. No BOM: directly apply for the required products, submit to superiors for review and approval, and submit to the purchasing department to purchase products.
1:SUM function (mathematics)
In daily work and study, SUM is an extremely widely used function and can be learned as an entry-level function.
2:Sum with qualified cells
The sum of merged cells has always been a troublesome problem for novices.
Select the cell range D2:D13, then enter the formula in the formula edit bar: =SUM(C2:C13)-SUM(D3:D14), and then press Finish.
3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
The purchase approval form is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the purchase approval form, download it quickly.SWOT analysis,Kindergarten morning inspection record sheetIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works