Business Stats/Information Systems Excel Checking the work I've done!!

tv
assignment_check_sheet_update.xls
Home>Business & Finance homework help>Economics homework help>Business Stats/Information Systems Excel Checking the work I've done!!

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 48157 48880 49613 50357 51112 51879 52657 53447 54249 55062 55888 56727 628028
Chicken Wings 15135 15362 15593 15826 16064 16305 16549 16798 17050 17305 17565 17828 197380
Salads 17199 17457 17719 17985 18254 18528 18806 19088 19375 19665 19960 20260 224296
Fries 7032 7138 7245 7354 7464 7576 7690 7805 7922 8041 8161 8284 91712
Sodas 7644 7759 7875 7993 8113 8235 8358 8484 8611 8740 8871 9004 99687
Monthly Revenue 95168 96595 98044 99515 101008 102523 104061 105621 107206 108814 110446 112103 1241103
Expenses:
COGS 57391 58252 59126 60013 60913 61827 62754 63695 64651 65620 66605 67604 748450
Rent 2750 2750 2750 2750 2750 2750 2750 2750 2750 2750 2750 2750 33000
Phone 320 320 320 320 320 320 320 320 320 320 320 320 3840
Electricity 675 675 675 675 675 675 675 675 675 675 675 675 8100
Insurance 850 850 850 850 850 850 850 850 850 850 850 850 10200
Advertising 900 900 900 900 900 900 900 900 900 900 900 900 10800
Hourly Wages 7812 7812 7812 7812 7812 7812 7812 7812 7812 7812 7812 7812 93744
Salaries 5083 5083 5083 5083 5083 5083 5083 5083 5083 5083 5083 5083 61000
Loan Payment 969 969 969 969 969 969 969 969 969 969 969 969 11628
Total Expenses 76750 77611 78485 79372 80272 81186 82113 83055 84010 84980 85964 86963 980762
Income Before Tax 18417 18984 19559 20143 20735 21337 21947 22567 23196 23834 24482 25140 260342
Tax 3315 3417 3521 3626 3732 3841 3951 4062 4175 4290 4407 7039 49375
Net Income 15102 15567 16039 16517 17003 17496 17997 18505 19021 19544 20075 18101 210966
Cash Flow 35377 50944 66983 83500 100503 117999 135996 154501 173521 193065 213141 231241