Tutorvo

The Room Budget: Spend by Room, Must-Have Share, Delivery Dates and a Budget Chart

Lesson 8 of 816 minLab

This lesson is part of the course

In this lesson

You total the shopping list by room with SUMIFS, find the share of the budget that the must-have items take, turn lead times in working days into delivery dates with WORKDAY and chart the spend per room.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. The Floor Plan: Room Areas, Furniture Footprints and Free Floor SpaceLab14 min Locked
  2. Clearances: Walkways and Seating Gaps against Guidelines, Three-Level Flags and Viewing DistanceLab15 min Locked
  3. Rug Sizing: Floor Borders, the Largest Standard Size, Front Legs On and Floor ShareLab14 min Locked
  4. Curtains: Fullness, Fabric Widths, Cut Lengths with Pattern Repeat and Fabric CostLab16 min Locked
  5. Wallpaper: Strips per Wall, Cut Lengths with Repeat, Strips per Roll and Rolls to OrderLab16 min Locked
  6. The Kitchen Work Triangle: Distances from Coordinates, Leg Flags and the Total CheckLab15 min Locked
  7. Art and Gallery Walls: Nail Heights, Group Widths, Proportions and Equal SpacingLab14 min Locked
  8. The Room Budget: Spend by Room, Must-Have Share, Delivery Dates and a Budget ChartLab16 min Locked