3.5 fashion business
duty13
Salesforecastingandgraphsforstudents112.xlsxSTART UP EXPENDITURE
| START UP EXPENDITURE | ||||||
| EXPENSE TYPE | COST | COMMENTS | ||||
| OFFICE | Expense type | Cost | ||||
| computer / laptops | Office | £0 | ||||
| printer | Website | £0 | ||||
| desk and chairs | Branding | £0 | ||||
| stationary | Production | £0 | ||||
| rent | creation | £0 | ||||
| utilities | Marketing | £0 | ||||
| software packages | ||||||
| SUB TOTAL | ||||||
| WEBSITE | ||||||
| website development | ||||||
| domain /email | ||||||
| legal costs / T&Cs | ||||||
| SEO | ||||||
| add ons and plug ins | ||||||
| SUB TOTAL | ||||||
| BRANDING | ||||||
| Brand development | ||||||
| Trademark protection | ||||||
| packaging | ||||||
| business card | ||||||
| SUB TOTAL | ||||||
| PRODUCTION | ||||||
| fabric | ||||||
| CMT - Cut make and trim | ||||||
| trims | ||||||
| labels / packagaing | ||||||
| testing | ||||||
| UNIT SUB TOTAL | ||||||
| sampling | ||||||
| PRODUCT TOTAL | ||||||
| CREATION | ||||||
| Photography costs | ||||||
| models | ||||||
| make up artist | ||||||
| studio hire | ||||||
| post production | ||||||
| SUB TOTAL | ||||||
| MARKETING | ||||||
| press release | ||||||
| influencers | ||||||
| ads on insta/ tik tok etc | ||||||
| newspapers/ magazine ads | ||||||
| launch event | ||||||
| press samples/ influencers | ||||||
| SUB TOTAL | ||||||
| FINAL TOTAL | ||||||
| TASK: | ||||||
| 1. Input all your anticipated start up expenditure on the spreadsheet | ||||||
| 2. Use auto sum to work out your sub total | ||||||
| 3. Write a formula to add up all your sub totals | ||||||
| 4. Copy the sub total amounts into the table above | ||||||
| 5. Create a bar chart using the 'quick analysis tool' (highlight the data and then right click) | ||||||
| 6. Double the amount spent for manufacture and see what happens to the graph |
SALES FORECASTING
| SALES FORECASTING | Online sales | |||||||||||||||
| JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL | ||||
| Year 1 2023 | SALES | units | 0 | |||||||||||||
| % pn | 0% | |||||||||||||||
| SALES VALUE | Value | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Year 2 | SALES | units | 0 | |||||||||||||
| % pn | 0% | |||||||||||||||
| SALES VALUE | Value | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Year 3 | SALES | units | 0 | |||||||||||||
| % pn | 0% | |||||||||||||||
| SALES VALUE | Value | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||
| Selling price | £25 |
CASH FLOW
| MONTHLY CASH FLOW | |||||||||||||||||||
| PRE START | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | CLOSING | ||||||
| INCOME | Starting Balance | ||||||||||||||||||
| Year 1 | Wholesale | Year one Fixed costs | Value | ||||||||||||||||
| retailer sales | wages x 1 | -£2,000 | |||||||||||||||||
| online sales | rent | -£500 | |||||||||||||||||
| loan | interest | -£100 | |||||||||||||||||
| personal | rates | -£150 | |||||||||||||||||
| investor | Utility | -£50 | |||||||||||||||||
| Total CASH INFLOW | 0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | Total | -£2,800 | ||||
| OUT GOINGS | COST OF PRODUCT | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||||||
| fabric | |||||||||||||||||||
| trims | Year two fixed costs | Value | |||||||||||||||||
| CMT | wages x 2 | -£4,000 | |||||||||||||||||
| packaging | rent | £550 | |||||||||||||||||
| Total COST | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | interest | -£100 | |||||
| EXPENSES | rent | rates | -£175 | ||||||||||||||||
| utilities | Utility | -£55 | |||||||||||||||||
| staff salaries | Total | -£3,780 | |||||||||||||||||
| website | |||||||||||||||||||
| Branding | |||||||||||||||||||
| office suppliers | Year Three Fixed costs | Value | |||||||||||||||||
| promotion/ marketing/ advertising | wages x 4 | ||||||||||||||||||
| events | w/h space | ||||||||||||||||||
| tax | |||||||||||||||||||
| loan repayments | |||||||||||||||||||
| Total EXPENSES | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| Closing Balance | 0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||
| Year 2 | INCOME | Starting Balance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||
| Wholesale | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| retailer sales | |||||||||||||||||||
| online sales | Year Four Fixed costs | Value | |||||||||||||||||
| loan | |||||||||||||||||||
| personal | |||||||||||||||||||
| investor | |||||||||||||||||||
| Total CASH INFLOW | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| OUT GOINGS | COST OF PRODUCT | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||||||
| fabric | |||||||||||||||||||
| trims | |||||||||||||||||||
| CMT | |||||||||||||||||||
| packaging | Year Five Fixed costs | Value | |||||||||||||||||
| Total COST | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| EXPENSES | rent | ||||||||||||||||||
| utilities | |||||||||||||||||||
| staff salaries | |||||||||||||||||||
| website | |||||||||||||||||||
| office suppliers | |||||||||||||||||||
| advertising | |||||||||||||||||||
| events | |||||||||||||||||||
| tax | |||||||||||||||||||
| loan repayments | |||||||||||||||||||
| Total EXPENSES | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| Closing Balance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||||||
| Year 3 | INCOME | Starting Balance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||
| Wholesale | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| retailer sales | |||||||||||||||||||
| online sales | |||||||||||||||||||
| loan | |||||||||||||||||||
| personal | |||||||||||||||||||
| investor | |||||||||||||||||||
| Total CASH INFLOW | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| OUT GOINGS | COST OF PRODUCT | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | ||||||
| fabric | |||||||||||||||||||
| trims | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| CMT | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| packaging | |||||||||||||||||||
| Total COST | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| EXPENSES | rent | ||||||||||||||||||
| utilities | |||||||||||||||||||
| staff salaries | |||||||||||||||||||
| website | |||||||||||||||||||
| office suppliers | |||||||||||||||||||
| advertising | |||||||||||||||||||
| events | |||||||||||||||||||
| tax | |||||||||||||||||||
| loan repayments | |||||||||||||||||||
| Total EXPENSES | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |||||||
| Closing Balance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
