CIS110 HW: Spreadsheet
The Suburban Community News is a free paper that is published once weekly. For $3.00 you can place an advertisement to buy or sell just about anything.The paper relies completely on the advertising of local businesses for its revenue. You have been asked to prepare a worksheet, based on the figures provided by your manager (Table A). Include a chart that illustrates the net incomes. The paper's senior-level managers hope to increase private advertising revenues by 3% per month, thus bringing in $3,893.40 in April; $4,017.00 in May; and $4,202.40 in June. Expanding the paper's service area, however, will increase Marketing by 5%, Payroll by 3%, and Production Costs by 11%. Create and format the worksheets, and hand in a floppy disk (
news.xls).Table A
Revenues: |
|||
April |
May |
June |
|
Private Ads |
3,780.00 |
3,900.00 |
4,080.00 |
Real Estate Ads |
4,265.21 |
4,724.25 |
4,838.40 |
Business Ads |
953.65 |
1,082.00 |
1,221.02 |
Expenses: |
|||
Marketing |
15% |
||
Payroll |
38% |
||
Production Costs |
16% |