E Share CS Letuscater December 2011 Financial Statements project (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 2 day Working... na 100% $ % . .00 123- Arial BISA fx A B C D 8 PES ID- li 31 E F G H 1 K L M N o O R s T U V 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Expense American Express Merchant Fees Amortization Expense Answering Service Bank Service Charges Bookkeeping Fee Brownie Points Rewards Customer service Salary Cellular Phone Computer Equipment Constant Contact Fax Expenses Google AdWords Authorize.net Process Fee Meals and Entertainment Visa Mastiercard Merchant Fees Office Supplies Parking Expense Postage and Delivery Printing and Reproduction Accounting and legal Fees SalesForce.com Telemarketing Telephone Expense Sales Person Commission Travel Expense Website Development Costs Web Hosting Total Expense 17,436.79 VC 12,363.00 fc 343.80 FC 130.00 FC 3,694.97 FC 8,930.31 VC 29,457.13 FC 2,421.64 FC 370.36 FC 382.56 FC 476.28 VC 19.29 FC 927.55 VC 598.04 VC 7,529.67 VC 657.31 fc 121.50 FC 724.96 FC 140.59 fc 849.95 FC 297.00 VC 4,350.00 fc 881.39 fc 2,898.35 VC 197.36 fc 3,000.00 fc 99.00 fc 99,298.80 39 Profit -10,060.79 40 + = YTD Inc Stmt - C Assignment - Fal 2020 MATH 1 * College Algebra project is Fal: x C Bir Anayeire On A Real-wor* VRV - Home of risur Favorite Ch x + orie C:/Users/12245/Downloads College Algebra projects 20:20:11:20:16:2020202203pdr * Buck Dragon Ball Z Mul X mal gume 0 YT YouTube Maps M Gmail SESES85303835836. kemi & Sluiten. PSA Method Catul Overmath Seativi. Overwatch DPI Tool use oj College Algebra project for Fall of 2020 (3) pdf 1/2 Pro ConCorg professor Google and find out what it means. Of course, you can also ask me. Grade: The project is worth 40 points. With 25 points of extra credit. Specifics of the project In the first part of this project you reviewed the business of Letuscater.com and now it's now time to apply algebraic principles to analyze our financial statement. I will provide Letuscater's 2011 P&L financial statement via an excel spreadsheet. Note that this year is still when we were just doing this as a hobby but once we realized that our catering sales exceeded $800.000, I started to take this business seriously and worked to increase our profits. Before I did that, I performed an analysis to calculate our cost, revenue and profit functions. Let me get you started. Let x = catering sales and our revenue equation is R(x) = mx where slope of the revenue equations is m,. Plug in the numbers and you get 89,238.01 --(811,458.75) then solve for me 20 301.456.75 0.11 or 11%. This was the commission we 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) = mx + b where the slope me is the variable cost and b is the fixed cost. You will have to do research and group all the expenses in either a foed 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 a fixed cost 2. From the model calculate the break-even sales number per month. Note the numbers in the spreadsheet are for the complete year, 3. Calculate the Profit function. Extra Credit. As a business owner you want to make more profit. There are two ways to do that. Decrease cost with the same revenue or increase revenue more than you increase cost. Using the cost, revenue and profit equation, come up with ideas to increase profit. I will accept up to five ideas. The ideas are worth one point and the financial justification is worth the other four points. Here is a hint for all One idea to increase revenue is to hire a full-time sales person. That's worth one point you are welcome) but to get other four points you must present how much cast that 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 and use your equations to figure out how much extra 'catering sales' your new employee must bring in to pay for themselves. Type here to search O ES of 10:35 AM OSE & G 12/9/2020 Ansignment - Fal 2020 MATH 1 * Colinge Aigetre project is Fale C Buisme Anayeire On A Real-wor* VRV - Home of risur Favorite Ch x + orie C:/Users/12245/Downloads College 20Algebra%2Cproject color%20f31126206.20202041203pdr . * Apu Bukura Dragon Ball Z Muut malume TV ** Maps MG SISIS SEBES mis & Slucem SA Method Caul. Overwatch Smaili. Overwatch DP Tool @ puture ob College Algebra project for Full of 2020 (3).pdf 2 / 2 Tony Cosentino 11/10/2020 This project is due December 6, 2020 by 11:59pm. Please upload as a single pdf file. You will lose 10 points for each day that is late. Show your work on #1, which must include what expenses you decided are fixed and which ones you decided are variable. Also show your work on the calculations for all three items if you decide to do the extra credit, please use this template as your format 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.) Good Luck and again feel free to ask me questions. All the best Tony Cosentino Type here to search ES c 12/12 E Share CS Letuscater December 2011 Financial Statements project (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 2 day Working... na 100% $ % . .00 123- Arial BISA fx A B C D 8 PES ID- li 31 E F G H 1 K L M N o O R s T U V 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Expense American Express Merchant Fees Amortization Expense Answering Service Bank Service Charges Bookkeeping Fee Brownie Points Rewards Customer service Salary Cellular Phone Computer Equipment Constant Contact Fax Expenses Google AdWords Authorize.net Process Fee Meals and Entertainment Visa Mastiercard Merchant Fees Office Supplies Parking Expense Postage and Delivery Printing and Reproduction Accounting and legal Fees SalesForce.com Telemarketing Telephone Expense Sales Person Commission Travel Expense Website Development Costs Web Hosting Total Expense 17,436.79 VC 12,363.00 fc 343.80 FC 130.00 FC 3,694.97 FC 8,930.31 VC 29,457.13 FC 2,421.64 FC 370.36 FC 382.56 FC 476.28 VC 19.29 FC 927.55 VC 598.04 VC 7,529.67 VC 657.31 fc 121.50 FC 724.96 FC 140.59 fc 849.95 FC 297.00 VC 4,350.00 fc 881.39 fc 2,898.35 VC 197.36 fc 3,000.00 fc 99.00 fc 99,298.80 39 Profit -10,060.79 40 + = YTD Inc Stmt - C Assignment - Fal 2020 MATH 1 * College Algebra project is Fal: x C Bir Anayeire On A Real-wor* VRV - Home of risur Favorite Ch x + orie C:/Users/12245/Downloads College Algebra projects 20:20:11:20:16:2020202203pdr * Buck Dragon Ball Z Mul X mal gume 0 YT YouTube Maps M Gmail SESES85303835836. kemi & Sluiten. PSA Method Catul Overmath Seativi. Overwatch DPI Tool use oj College Algebra project for Fall of 2020 (3) pdf 1/2 Pro ConCorg professor Google and find out what it means. Of course, you can also ask me. Grade: The project is worth 40 points. With 25 points of extra credit. Specifics of the project In the first part of this project you reviewed the business of Letuscater.com and now it's now time to apply algebraic principles to analyze our financial statement. I will provide Letuscater's 2011 P&L financial statement via an excel spreadsheet. Note that this year is still when we were just doing this as a hobby but once we realized that our catering sales exceeded $800.000, I started to take this business seriously and worked to increase our profits. Before I did that, I performed an analysis to calculate our cost, revenue and profit functions. Let me get you started. Let x = catering sales and our revenue equation is R(x) = mx where slope of the revenue equations is m,. Plug in the numbers and you get 89,238.01 --(811,458.75) then solve for me 20 301.456.75 0.11 or 11%. This was the commission we 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) = mx + b where the slope me is the variable cost and b is the fixed cost. You will have to do research and group all the expenses in either a foed 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 a fixed cost 2. From the model calculate the break-even sales number per month. Note the numbers in the spreadsheet are for the complete year, 3. Calculate the Profit function. Extra Credit. As a business owner you want to make more profit. There are two ways to do that. Decrease cost with the same revenue or increase revenue more than you increase cost. Using the cost, revenue and profit equation, come up with ideas to increase profit. I will accept up to five ideas. The ideas are worth one point and the financial justification is worth the other four points. Here is a hint for all One idea to increase revenue is to hire a full-time sales person. That's worth one point you are welcome) but to get other four points you must present how much cast that 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 and use your equations to figure out how much extra 'catering sales' your new employee must bring in to pay for themselves. Type here to search O ES of 10:35 AM OSE & G 12/9/2020 Ansignment - Fal 2020 MATH 1 * Colinge Aigetre project is Fale C Buisme Anayeire On A Real-wor* VRV - Home of risur Favorite Ch x + orie C:/Users/12245/Downloads College 20Algebra%2Cproject color%20f31126206.20202041203pdr . * Apu Bukura Dragon Ball Z Muut malume TV ** Maps MG SISIS SEBES mis & Slucem SA Method Caul. Overwatch Smaili. Overwatch DP Tool @ puture ob College Algebra project for Full of 2020 (3).pdf 2 / 2 Tony Cosentino 11/10/2020 This project is due December 6, 2020 by 11:59pm. Please upload as a single pdf file. You will lose 10 points for each day that is late. Show your work on #1, which must include what expenses you decided are fixed and which ones you decided are variable. Also show your work on the calculations for all three items if you decide to do the extra credit, please use this template as your format 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.) Good Luck and again feel free to ask me questions. All the best Tony Cosentino Type here to search ES c 12/12