Holiday and Outdoor Lighting Season Stock Planner

Holiday and Outdoor Stock Plan

Budget summary

• Budget: 6,000.00
• Suggested spend: 2,106.00 on the priced items below
• Difference: 3,894.00 unspent
• Icicle lights are not in the total because no cost was given. See the open questions.

| Item | Sold last year | On hand | Suggested order | Unit cost | Line cost | Action |
|---|---|---|---|---|---|---|
| Warm white 100ct mini strings | 180 | 40 | 160 | 3.50 | 560.00 | Reorder |
| C9 outdoor sets | 90 | 25 | 74 | 11.00 | 814.00 | Reorder |
| Light timers | 40 | 0 | 48 | 6.50 | 312.00 | Reorder |
| Solar pathway 4 packs | 60 | 30 | 36 | 9.00 | 324.00 | Reorder |
| Icicle lights | 20 | 15 | 7 | not given | not priced | Reduce |
| Smart plugs | 0 | 0 | 12 | 8.00 | 96.00 | New |

Total of priced lines: 560.00 + 814.00 + 312.00 + 324.00 + 96.00 = 2,106.00. Budget 6,000.00 minus 2,106.00 = 3,894.00 unspent.

How the numbers were worked out (expected sales, plus 10 percent cushion, minus on hand)

• Mini strings: 180 + 18 = 198. Minus 40 on hand is 158. Your case size is 10, so we rounded up to 160, which is 16 cases. You ran out around Dec 5, so some sales were likely lost. If you want to cover that, we can raise the cushion.
• C9 sets: 90 + 9 = 99. Minus 25 on hand is 74. You gave no case size, so we kept 74.
• Timers: 40 + 4 = 44. Minus 0 on hand is 44. Your case size is 12, so we rounded up to 48, which is 4 cases. You sold out by Nov 28, so sales may have been lost.
• Pathway lights: 60 + 6 = 66. Minus 30 on hand is 36. You gave no case size, so we kept 36. Sell the 30 leftover packs first.
• Icicle lights: 20 + 2 = 22. Minus 15 on hand is 7. They sold slowly, so we marked this Reduce. We can drop them completely if you prefer.
• Smart plugs: customers asked, but there is no sales history, so the formula does not apply. We recommend a small test of 12, which is 2 cases of 6. 12 x 8.00 = 96.00.

Order-by dates (shelves set Nov 1)

• Supplier A (mini strings, C9 sets, 3 weeks): order by Oct 11 at the latest. We recommend ordering sooner to leave room for delays.
• Supplier B (timers, pathway lights, 2 weeks): order by Oct 18 at the latest.
• Supplier B (smart plugs): no lead time given, so no order-by date yet. See the open questions.

What was trimmed
Nothing was trimmed, since the plan is well under budget.

Notes for staff

• Check each box for whether the product is rated for indoor or outdoor use, and put that on the shelf tag.
• Do not tell customers how many strings can be connected together. Point them to the box and instructions.
• For wiring questions or permanent outdoor installs, send customers to a licensed electrician. Confirm any local rules locally.

Weekly watch list

• Mini strings: check every week from Nov 1. We recommend reordering if under 40 on hand.
• Timers: check every week. We recommend reordering if under 12 on hand.
• Pathway lights: check every two weeks. We recommend reordering if under 10 on hand.
• Smart plugs: if the first 12 sell in two weeks, we recommend reordering one case.

Open questions

• What is Supplier B's lead time for smart plugs? We need it to give an order-by date.
• What does an icicle light set cost you? We need it to price that line.
• Are the 30 leftover pathway packs in good, sellable condition?
• Do you want to raise the cushion on mini strings and timers to cover sales you may have lost?
• You have 3,894.00 unspent. Do you want to add lines you did not list, such as net lights, extension cords, replacement bulbs, or flood lights?