You need to make sure that you re-do the rental order by working with the customer or may have to cancel the order. The red colored cells indicate days when assets will not have enough inventory to cover the rental orders. Here is a screenshot of Available Quantity. Also, you can choose to see Available Quantity or Rented Quantity. You can choose any start date for this calendar view. The Calendar sheet provides a flexible and useful calendar that shows the availability of rental assets over 31 days. Check availability – Rental Assets – Window longer than 90 days Step 3: Calendar is populated automatically This availability calculator can handle rental windows of up to 90 days long. Check availability of Rental Items – Not enough Inventory If the available quantity is negative, that indicates that there is not enough inventory. For example, you can enter contact information of the customer.Īt the top of the Orders sheet is a simple availability calculator, which will provide the quantity available to rent for a specific asset given the rent out and return dates. Use the Notes column to keep track of any information related to the order. Enter Rent Out Date (date when the asset needs to be given to customer) and Return Date (date when asset will be returned by the customer). When you begin, Rented Out will be 0 and all the items will be In Stock.Įnter Rental orders in Orders sheet Rental Inventory Tracker – Enter rental orders detailsĮnter Order Number, Order Date, Asset being rented and Quantity being rented. The last two columns are automatically calculated. Enter Rental Equipment or Rental Assets ItemsĮnter Asset Name, Description and # of Items you have of each asset. Step 2: Configure the input entriesĮnter the list of assets or equipment in the Assets sheet. Once copied, it can also be shared with your colleagues to collaborate as needed. You can save the copy in your own google drive for your use. The calendar is populated automatically.Ĭlick on the link above and then make a copy of the sheet as shown in the screenshot below.Make a Copy and save this template in your Google Drive.Rental Inventory Tracker in Google Sheets How to Use Rental Inventory Tracker Google Sheets Template Premium Attendance Report (Google Sheet).Group Shared Expense Calculator (Excel).Google Sheets Calendar Template – Google Sheets Calendar 2023 or any year.Excel Calendar Template – Excel Calendar 2023 or any year.Fitness & Weight Loss Tracker Excel Template.RSI Relative Strength Index (Google Sheet).Exponential Moving Average Crossover (Excel).India Stock Market Tracker (Google Sheet).Simple Moving Average Screener (Google Sheet).Kanban Board Task Tracker (Google Sheet).Resource Capacity Planner (Google Sheet).Rental Inventory Tracker (Google Sheet).Manufacturing Inventory Tracker (Google Sheet)). Manufacturing Inventory Tracker (Excel).Inventory and Sales Manager (Google Sheet).Retail Inventory Tracker (Google Sheet).Retail Business Manager Pro (Google Sheets).Manufacturing Business Manager (Google Sheet).Small Business Finance Manager (Google Sheet).Employee Annual Bonus Planner (Power BI).Employee Annual Bonus Planner (Google Sheet).Salary Structure Calculator (Google Sheet).PTO Balance for Salaried (Google Sheet).PTO Manager for Salaried (Google Sheet).Learning & Development Dashboard (Google Sheet).Learning & Development Dashboard (Excel).Compliance Training Dashboard (Google Sheet). Free Recruitment Tracker (Google Sheet).Recruitment Tracker Dashboard (Google Sheet).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |