# The Interior Design Business Owner: companion files

Julian R. Sterling

## What is here

- IDBO_1_Projects_and_Fees.xlsx (Chapters 3 and 4; Projects and Fees workbook of Appendix A): sheets Inputs, Projects, Fees, Comparison, then Checks. Projects signed by type and size (21 then 22), the fee lines ($418,273 then $573,924 of design fees), a single room's flat fee per actual hour ($111.11 then $124.44, $147.24 with change orders) and a whole home billed hourly against a percentage of its trade cost.
- IDBO_2_Hours_and_Utilization.xlsx (Chapters 5, 6 and 11; Hours and Utilization workbook): sheets Inputs, Hours by phase, Available hours, Commercial project, then Checks. Budgeted and actual hours by phase, design hours by type and by phase (2,976.7 then 3,694.6), the hours available and utilization (58.9 percent then 61.4 percent), and Harlowmere Suites read apart ($106.67 an actual hour).
- IDBO_3_Products_and_Markup.xlsx (Chapters 7 and 8; Products and Markup workbook): sheets Inputs, Purchase orders, Summary, Vendor rebate, then Checks. A medium room's purchase orders from trade cost to client price ($28,000 to $36,400), product sales and product margin ($446,985 then $469,580), and the Darrowind Trade Furnishings rebate ($4,785 then $11,180).
- IDBO_4_Deposits_and_Logistics.xlsx (Chapters 9 and 10; Deposits and Logistics workbook): sheets Inputs, Deposit ledger, Custom order, Logistics ledger, then Checks. The deposit ledger month by month against cash (127.8 percent then 77.4 percent at 30 September), a medium room's custom order under the old and the new deposit rule, and the logistics ledger (-$51,553 then $393 net of charges).
- IDBO_5_Cash_and_Decisions.xlsx (Chapters 12, 14 and 15; Cash and Decisions workbook): sheets Inputs, Cash, Receiving warehouse, Fee-only test, then Checks. Cash less the line and customer deposits (-$53,648 then $172,574), revenue by quarter, the receiving warehouse against a space of its own ($54,660 against $78,148), and the fee-only test (-$208,543 a year) beside a second senior designer ($177,550), both projections.
- IDBO_6_Profit_and_Value.xlsx (Chapters 13 and 16; Profit and Value workbook): sheets Inputs, Income statement, SDE, Planning range, then Checks. Both income statements ($169,235 then $312,153 of net income) and the bridge between them, seller's discretionary earnings ($297,149 then $446,913) and the founder's planning range ($715,061 to $983,209).
- IDBO_Design_Studio_Owner_Checklists.docx: the 8 checklists of Appendix B, editable (The letter of agreement; The product proposal and quote; The purchase order and deposit; Receiving and inspecting deliveries; Installation day; Closing a project; The monthly review; Preparing a sale).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 17 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In IDBO_1_Projects_and_Fees.xlsx, on Inputs, type your own single-room fee and the overrun factor your time entries show: the fee earned per actual hour moves at once.
2. In IDBO_4_Deposits_and_Logistics.xlsx, on Inputs, type your own month-end deposits and cash: the Deposit ledger shows how much of the bank balance is clients' money.

To use a workbook on your own studio, fill the yellow column from your signed letters of agreement, the time entries of your project management system, vendor invoices and the purchase order log, the deposit ledger, freight, receiving and installation bills, the bank statements and the accounting system, in the order Appendix A gives, and keep a copy with the case column for comparison. Set your conventions with your outside CPA first: when a fee and a product sale become revenue, and how money received before installation day is shown. The workbooks are separate files with no link between them.

## A word of caution

Ivenhart Interiors, LLC, the town of Ashvenley, its founder, designers and project assistant, its clients, the builder, the hotel, the vendor, the workroom and the receiving warehouse are fictional. Fees, hourly rates, hours, trade costs, markups, rebates, wages, rents, rates and multiples are teaching assumptions, not market norms or recommendations, and no figure implies a style, color, material or layout choice. Whether a project needs a licensed designer, whether a fee or a product carries sales tax, whether deposits are client money and whether a rebate must be disclosed are questions for counsel, your outside CPA and your state's agencies. No real studio, brand, vendor, workroom, warehouse, platform or software is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
