assignment

How To Shrink your Sales Forecast to Fit on One Page

You need to fit the customer name, 12 months of unit and currency forecasts, and a total on one page.

I know that you already know how to do this, but in case one of your classmates has forgotten, here are some suggestions:

1. Use Landscape, not Portrait

2. Drop the decimals

3. Narrow the column widths

4. Use thousands or millions or '000 or '000,000

5. If necessary, drop the currency symbol from every cell,

and nake sure that the currency is noted in the page title.

6. Decrease some of your font sizes (ie, customer name or titles) 7. Use the "fit" option under Print Preview

8. Reduce the side or top margins

Door Sales to Portugal (in units) 1 unit = 1 door

Customer	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Lisbon Lou's	0	0	0	0	0	0	30	30	30	30	30	30	180
Algarve Hardware	0	0	0	0	0	0	0	0	0	25	25	25	75
Fatima Fix-It	0	0	0	0	0	0	0	0	0	0	0	0	0
Others	0	0	0	0	0	0	0	0	0	0	0	0	0
TOTAL	0	0	0	0	0	0	30	30	30	55	55	55	255

Year 201X

Year 201Y

Customer	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Lisbon Lou's	30	30	50	50	50	50	50	75	75	75	75	75	685
Algarve Hardware	25	25	25	25	25	25	25	25	25	25	25	25	300
Fatima Fix-It	0	0	10	10	10	10	10	10	10	10	10	10	100
Others	0	0	0	0	0	0	0	0	0	0	0	0	0
TOTAL	55	55	85	85	85	85	85	110	110	110	110	110	1085

Year 201Z

Customer	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Lisbon Lou's	75	75	75	75	75	75	75	75	75	90	90	90	945
Algarve Hardware	25	25	25	25	50	50	50	50	50	50	50	50	500
Fatima Fix-It	10	25	25	25	25	25	25	25	25	25	25	25	285
Others	0	0	0	0	20	20	20	20	20	20	30	40	190
TOTAL	110	125	125	125	170	170	170	170	170	185	195	205	1920