Letuscaters 2011 P&L financial statement via excel spreadsheet provided. Note that this year's sales exceeded 800,000. Let x= catering sales and our revenue equation is R(x)=m_rx where slope of the revenue equations is m_r. Plug in the numbers and you get 89,938.01=m_r(811,458.75) then solve for m_r=89,238.01/811,458.75=.11 or 11%. This was commission received from the restaurant for each order we gave them.1. You are calculating the cost function for the business in 2011. Just a reminder the cost function is defined as C(x)=m_cx+b where the slope m_c is the variable cost and b is the fixed cost. Group all the expenses in either a fixed cost or variable cost bucket. A cost is variable if it depends on catering sales and if it does not depend on our catering sales then it is not a fixed cost.2. From the model calculate the break0even sales number per month. Note the numbers in the spreadsheet are for the complete year.3. Calculate the profit function. Also as a business owner u want to make more profit. ways to do that decrease cost with same revenue or increase the revenue more than you increase cost. using the cost, revenue sand profit equation, come up with ideas to increase profit. Upto five ideas accepted. Must present how much cost adds to the model and how much revenue must this sales person bring into the company to increase profits. So, assume a salary you will pay this person using your equations to figure out how much extra "catering sales" your new employee must bring in to pay for themselves. Show work and calculations.1. Increase revenue by hiring a salesperson. I will pay them 3000 per month. (then show your calculations using this 3000$ cost on how much catering sales the salesperson must bring in to cover their cost).

The excel spreadsheet :

Transcribed Image Text:

Fic H5 1 2 3 5 6 7 8 9 Auto D 10 11. 12 13 14 15 16 1/ 18 19 15 70 21 22 23 24 25 26 27 20 29 30 31 32 333 31 35 37 28 39 40 41 42 43 AA Letuscate: December 2011 Financial Statements project (3) Protected view Formulas Data Review View Hep Home Insert Page Layout PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to ecit, it's safer to stay in Protected View A B C D Ready Ordinary IncomerExpense Income Catering Sales Total Income Cast of Goods Sold Total COGS Payment to Restaurant Net Revenue Expense American Express Merchant Fees Amortization Expense Answering Service Bank Service Charges Bookkeeping Fe E Browne Punta warda Customer sere Salary Cellular Phone Computer Equipment Constant Contact Fax Expenses Google AdWords be Authorize.net Process Fee Meals and Entertainment Visa Mastercard Merchant Fees Office Supplies Parking Expense Postage and Delivery Printing and Reproduction Accounting and legal Salesforce.com Temarketing Telephone Expanse AR Sales Person Commiss Total Exper Travni apa Wehehe Development Cont Web Hosting Pront Cash Flow YTD Inc Stat Type here to search F Jan-Dec 11 811.458.75 811,45875 777 770 14 74 722,220.74 80.230.01 17,456.79 12,363.00 349.80 150.00 3,604:57 890031 29,457.13 2,421 84 370 38 38258 476 20 18.28 927.06 560.04 7.529.67 657.51 121.50 724.98 140.50 849.95 297.00 4,350.00 881.38 2,400 25 197 36 3,000.00 88.00 20,2 -10,000 79 7,302.21 G O HI A C n J 11 K 7 L Search Enable Edling M N 0 P. & Q R 5 T U V W X nicholas legendhunter Y Z AA X NI Share Comments AB 400 AC T 1 0 10:35 AM 12/5/2020 AD x 100% Fic H5 1 2 3 5 6 7 8 9 Auto D 10 11. 12 13 14 15 16 1/ 18 19 15 70 21 22 23 24 25 26 27 20 29 30 31 32 333 31 35 37 28 39 40 41 42 43 AA Letuscate: December 2011 Financial Statements project (3) Protected view Formulas Data Review View Hep Home Insert Page Layout PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to ecit, it's safer to stay in Protected View A B C D Ready Ordinary IncomerExpense Income Catering Sales Total Income Cast of Goods Sold Total COGS Payment to Restaurant Net Revenue Expense American Express Merchant Fees Amortization Expense Answering Service Bank Service Charges Bookkeeping Fe E Browne Punta warda Customer sere Salary Cellular Phone Computer Equipment Constant Contact Fax Expenses Google AdWords be Authorize.net Process Fee Meals and Entertainment Visa Mastercard Merchant Fees Office Supplies Parking Expense Postage and Delivery Printing and Reproduction Accounting and legal Salesforce.com Temarketing Telephone Expanse AR Sales Person Commiss Total Exper Travni apa Wehehe Development Cont Web Hosting Pront Cash Flow YTD Inc Stat Type here to search F Jan-Dec 11 811.458.75 811,45875 777 770 14 74 722,220.74 80.230.01 17,456.79 12,363.00 349.80 150.00 3,604:57 890031 29,457.13 2,421 84 370 38 38258 476 20 18.28 927.06 560.04 7.529.67 657.51 121.50 724.98 140.50 849.95 297.00 4,350.00 881.38 2,400 25 197 36 3,000.00 88.00 20,2 -10,000 79 7,302.21 G O HI A C n J 11 K 7 L Search Enable Edling M N 0 P. & Q R 5 T U V W X nicholas legendhunter Y Z AA X NI Share Comments AB 400 AC T 1 0 10:35 AM 12/5/2020 AD x 100%

Answer rating: 100% (QA)

To calculate the cost function for the business in 2011 we need to identify which expenses are fixed costs and which are variable costs Fixed costs do ... View the full answer