{"product_id":"airbnb-welcome-basket-planner","title":"Airbnb Welcome Basket Checklist \u0026 Planner Spreadsheet – Items by Guest Type, Basket Cost, Suppliers, Par Stock, Budget vs Actual, No Canva","description":"\u003cp\u003e\u003cstrong\u003eWelcome Basket Planner\u003c\/strong\u003e is an Excel and Google Sheets workbook that plans the welcome basket you leave for your guests: what goes in it for each type of guest, what it costs, who you buy it from, what to reorder and how your spending compares with your budget. Pick a guest type and the basket list builds itself with the cost per basket and the cost per night.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eNo Canva needed.\u003c\/strong\u003e This is a planning spreadsheet, not a set of printable tags or labels: it works behind the basket, so you stop overbuying and never run out of the things guests use. It is a plain spreadsheet with no macros and no add-ons. Yellow cells are for typing, gray cells hold the formulas. It works in Excel, Google Sheets and Numbers.\u003c\/p\u003e\n\u003ch3\u003eWhat is inside (7 sheets)\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eBasket Builder\u003c\/strong\u003e - a yellow guest type dropdown (Families, Couples, Business, Pet owners, Long stay, Standard) that pulls the item list for that type with quantity, unit cost, line cost and supplier, plus cost per basket, cost per night, cost against a target and the cost of the baskets you are packing.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eItems by Guest Type\u003c\/strong\u003e - a matrix of 32 sample items with category, unit cost, supplier and the quantity per basket for each of the six guest types. Every line cost is quantity x unit cost and the column totals are the basket cost per guest type, with a target and an under-or-over check.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSupplier List\u003c\/strong\u003e - ten sample suppliers with what they supply, order method, lead days, minimum order, last order total and notes. It counts the basket items each supplier covers and checks your Par Stock order against their minimum.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePar Stock\u003c\/strong\u003e - on hand, reorder level and par level for 20 items. Reorder quantity is MAX(0, par - on hand), the reorder cost is calculated and the status reads Order now or OK.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSeasonal Swaps\u003c\/strong\u003e - 16 sample swaps across four seasons with the cost change per basket and the Standard basket cost with each season's swaps.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBudget vs Actual\u003c\/strong\u003e - 12 months of baskets given, budget per basket, budget total, actual spend, variance, status and a column chart, with month names built from one start-month cell.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead Me\u003c\/strong\u003e - how to set up the workbook, every formula in plain words and tips for Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSample data is included (made-up items, suppliers and 12 months of baskets), so every number and chart shows a real result from the first click. Replace it with your own in about 30 minutes.\u003c\/p\u003e\n\u003ch3\u003eFiles you receive\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eWelcome-Basket-Planner.xlsx - editable workbook\u003c\/li\u003e\n\u003cli\u003eWelcome-Basket-Planner.pdf - printable overview of every sheet\u003c\/li\u003e\n\u003cli\u003eSTART-HERE-How-to-Edit.pdf - editing guide for Excel, Google Sheets and Numbers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eHow it works\u003c\/h3\u003e\n\u003col\u003e\n\u003cli\u003eDownload the ZIP after checkout.\u003c\/li\u003e\n\u003cli\u003eOpen the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.\u003c\/li\u003e\n\u003cli\u003eOn Items by Guest Type, replace the sample items, costs and quantities with yours.\u003c\/li\u003e\n\u003cli\u003ePick a guest type on the Basket Builder, then keep Par Stock and Budget vs Actual up to date.\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003ch3\u003eFAQ\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eDo I need Canva?\u003c\/strong\u003e No. This is a spreadsheet, not a design file. It does not contain gift tags or labels.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCan I add my own guest types?\u003c\/strong\u003e The six guest types are built in. You can rename them in the column headings of Items by Guest Type and the dropdown on the Basket Builder.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDoes it work in Google Sheets?\u003c\/strong\u003e Yes. Upload the file and open it with Google Sheets. The formulas avoid add-in functions.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAre the prices real?\u003c\/strong\u003e No. They are examples so you can see the sheet working. Type your own prices.\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eLicense:\u003c\/em\u003e personal and single-business use. Please do not resell or redistribute the files. Template only, not legal, tax or financial advice; have a local professional review your numbers. Airbnb, VRBO and Booking.com are trademarks of their respective owners; this product is not affiliated with or endorsed by them.\u003c\/p\u003e","brand":"Welcome Desk Co.","offers":[{"title":"Default Title","offer_id":68054987047164,"sku":"WDC-B8-054","price":4.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/welcome-basket-planner__01-hero.jpg?v=1793533894","url":"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-welcome-basket-planner","provider":"Welcome Desk Co.","version":"1.0","type":"link"}