Wine Mail Order Distribution in South East England

Index

Main

1.0 Brief

1.1 Objective

2.0 Assumptions and rationale

2.1 Methodology

2.2 Cost determination

2.3 The Spreadsheet

3.0 Wine Box operational overview

3.1 Demand Model

3.2 Scenarios

4.0 Key Observations

4.1 Recommendations

4.2 Executive Summary

Tables

1. Variable costs (default model)

2. Fixed costs (default model)

Inserts

1. Budget (default model)

2. Break even sheet (default model)

3. The sensitivity sheet (default model)

4. Budget scenario 1

Appendix:

A Demand model

A 1.0. UK mail order wine business

A 1.1 Industry competition.

A 1.2 Industry trends

A 1.3 Market calculations

A 1.4 Assumptions

B Spread sheet

B1. Case: Wine Box Ltd

B2. Summary Cash Budget

B3. Break-even point & Target Profit

B4. Sensitivity Analysis

B5. Selected Scenarios

B6. Cost definitions

B7. Machinery

B8. AC520 Wine Box Project