Business Stats/Information Systems Excel Checking the work I've done!!
tvassignment_check_sheet.xls
Sheet1
|
|
| | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Total |
| Revenue: |
| Pizza | 47010.60 | 47715.76 | 48431.50 | 49157.97 | 49895.34 | 50643.77 | 51403.42 | 52174.48 | 52957.09 | 53751.45 | 54557.72 | 55376.09 | 613075.17 |
| Chicken Wings | 15135.12 | 15362.15 | 15592.58 | 15826.47 | 16063.86 | 16304.82 | 16549.40 | 16797.64 | 17049.60 | 17305.34 | 17564.92 | 17828.40 | 197380.30 |
| Salads | 16052.40 | 16293.19 | 16537.58 | 16785.65 | 17037.43 | 17292.99 | 17552.39 | 17815.67 | 18082.91 | 18354.15 | 18629.47 | 18908.91 | 209342.74 |
| Fries | 7032.48 | 7137.97 | 7245.04 | 7353.71 | 7464.02 | 7575.98 | 7689.62 | 7804.96 | 7922.04 | 8040.87 | 8161.48 | 8283.90 | 91712.06 |
| Sodas | 7644.00 | 7758.66 | 7875.04 | 7993.17 | 8113.06 | 8234.76 | 8358.28 | 8483.65 | 8610.91 | 8740.07 | 8871.17 | 9004.24 | 99687.02 |
| Monthly Revenue | 92874.60 | 94267.72 | 95681.73 | 97116.96 | 98573.72 | 100052.32 | 101553.11 | 103076.40 | 104622.55 | 106191.89 | 107784.76 | 109401.54 | 1211197.30 |
| Expenses: |
| COGS | 56749.06 | 57600.29 | 58464.30 | 59341.26 | 60231.38 | 61134.85 | 62051.87 | 62982.65 | 63927.39 | 64886.30 | 65859.60 | 66847.49 | 740076.44 |
| Rent | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 2750.00 | 33000.00 |
| Phone | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 320.00 | 3840.00 |
| Electricity | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 675.00 | 8100.00 |
| Insurance | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 850.00 | 10200.00 |
| Advertising | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 900.00 | 10800.00 |
| Hourly Wages | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 5644.80 | 67737.60 |
| Salaries | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 5083.33 | 61000.00 |
| Loan Payment | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 968.97 | 11627.60 |
| Total Expenses | 73941.16 | 74792.39 | 75656.40 | 76533.36 | 77423.48 | 78326.95 | 79243.97 | 80174.75 | 81119.49 | 82078.40 | 83051.70 | 84039.59 | 946381.64 |
| Income Before Tax | 18933.44 | 19475.33 | 20025.34 | 20583.60 | 21150.24 | 21725.37 | 22309.13 | 22901.65 | 23503.06 | 24113.48 | 24733.07 | 25361.95 | 264815.66 |
| Tax | 2461.35 | 2531.79 | 2603.29 | 2675.87 | 2749.53 | 2824.30 | 2900.19 | 2977.21 | 5405.70 | 5546.10 | 5688.61 | 5833.25 | 44197.19 |
| Net Income | 16472.10 | 16943.53 | 17422.04 | 17907.73 | 18400.70 | 18901.07 | 19408.95 | 19924.44 | 18097.35 | 18567.38 | 19044.46 | 19528.70 | 220618.47 |
| Cash Flow | 36747.10 | 53690.63 | 71112.68 | 89020.41 | 107421.11 | 126322.18 | 145731.13 | 165655.57 | 183752.92 | 202320.30 | 221364.77 | 240893.47 |