My Lemonade Phase Three SpreadSheet
We had to run a lemonade stand for thirty days with a start of three dollars in assets, and record our statistics. It took a lot of focus and concentration to accomplish everything. Depending on the day would determine how much money you would make each day and what your cost was to make one cup of lemonade. If I had a rainy day, I would not make any money and tend to lose money because some days I would get no customers. On the ninth day of the lemonade project I didn't make lemonade so I can save my money so I do not go out of business. I did not make any lemonade for 5 consecutive days. This spreadsheet is important to put in my portfolio because it took a lot of critical thinking and problem solving to determine how much lemonade I should
…show more content…
It also demonstrates how I know how to use spreadsheets and make graphs. This was not an easy assignment either because there was a lot of glitches going on with google that we had to deal with. Next time I do something like this again, I will try to work around all of the glitches and find out how to solve them and show them to my fellow classmates. The strengths of my spreadsheet is that everything is centered and looks neat and organized. Another one of my strengths is my pie chart showing my distribution of sales, because I can see what I need to spend more or less of if I was to do this project again. Lastly is my line chart because it shows how I did over the thirty days, and where my mistakes were in my gross and net profit. The weaknesses of my artifact were mainly my money managing. Some days I spent too much on advertising and I did not make enough cups of lemonade to gain a profit. My biggest loss in profit was a dollar and a penny. That's a thirty seven percent loss! That made me have to come to a standstill some days because I
This way we are able to analyze the business’ strengths, weaknesses, opportunities, and threats. We next look at the operations, the financials and marketing plan to see where the company is exceling and where they are struggling. We provide
Finally, there is total assets turnover, which shows how efficient managers are using assets to generate revenue. It will allow Whole foods to
7.4 General Assumptions General Assumptions Year 1 2 3 Short Term Interest Rate 9.5% 9.5% 9.5% Long Term Interest Rate 10.0% 10.0% 10.0% Federal Tax Rate 33.0% 33.0% 33.0% Provincial Tax Rate 5.0% 5.0% 5.0% Personnel Taxes 15.0% 15.0% 15.0% 7.5 Profit and Loss Statements Proforma Profit and Loss (Yearly) Year 1 2 3 Sales $407,778 $440,400 $475,632 Cost of Goods Sold $40,778 $44,040 $47,563 Gross Margin 90.00% 90.00% 90.00% Operating Income $367,000 $396,360 $428,069 Expenses Payroll $198,500 $227,115 $257,268 General and Administrative $25,200 $26,208 $27,256 Marketing Expenses $2,039 $2,202 $2,378 Professional Fees and Licensure $5,219 $5,376 $5,537 Insurance Costs $1,987 $2,086 $2,191 Travel and Vehicle Costs $7,596 $8,356 $9,191 Rent and Utilities $20,000 $21,000 $22,050 Miscellaneous Costs $4,893 $5,285 $5,708 Payroll Taxes $29,775 $34,067 $38,590 Total Operating Costs $295,209 $331,695 $370,169 EBITDA $71,791 $64,666 $57,900 Federal Income Tax $23,691 $18,656 $16,642 Provincial Income Tax $3,590 $2,827 $2,522 Interest Expense $8,738 $8,131 $7,468 Depreciation Expenses $4,107 $4,107 $4,107 Net Profit $31,666 $30,944 $27,160 Profit Margin 7.77% 7.03%
Cool Moose Creamery Incremental Income Statement New Triple Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Sales $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 Cost of Goods Sold 1336 1336 1336 1336 1336 1336 1336 Gross Margin 8,664 8,664 8,664 8,664 8,664 8,664 8,664 Depreciation 285.71 1,714.29 1,714.29 1,714.29 1,714.29 1,714.29 1,714.29 Refrigerator Expense 150 Delivery expense 150 Installation Expense 650 Utilities 350 350 350 350 350 350 350 Wages 2,239.95 2,109.15 2,109.15 2,109.15 2,109.15 2,109.15 2,109.15 Interest Expense 594 662.5705 504.3456 334.6827 152.7547 8.241626 0 Opportunity Cost 2,415 2,415 2,415 2,415 2,415 2,415 2415 Total Expense 7,834.98 7,251.01 7,092.78 6,923.12 6,741.19 6,596.68 6,588.44 Net Income $829.02 $1,412.99 $1,571.22 $1,740.88 $1,922.81 $2,067.32 $2,075.56 Disadvantages: a) Customers will reduce buy scooped ice
SOURCE: On Sunday, January 3, 2016 at approximately 1900 hours, I received a telephone call from Sgt. John Sanzone, who told me there was a drive by shooting that had just occurred. Sgt. Sanzone assigned me as the CSI lead on this case.
I wake up from another one of my bad dreams and look over to see if Sodapop is still asleep. He’s gone. I decided to go see if Darry was home. He is gone too. I am completely alone and I just noticed that it is in the middle of the night.
Goal Number One I didn’t know it yet, but the way I viewed the game of lacrosse was about to change drastically. It was a normal day for me. I was in eighth grade, and I was getting ready for school.
Flashback to my junior year. I sat quietly in my AP Lang class as my teacher, Mrs. Fisher, announced that the reading competition between the language arts classes called for the book count for September. She stood at the board, marker in hand, staring out expectantly at her large class. Hands shot up across the classroom, and my own nervous hand rose up to join them. Mrs. Fisher happily chalked up the small fortune of books that our class had read.
Life sucks... all of my friends don 't talk to me anymore. I might as well just kill myself. There 's no point in living if you don 't have friends. It 's not my fault!
Assignment: Portfolio Income & costs and profit measures of performance Alibaba.com is a China’s B2B e-commerce company which owns a U.S. IPO that worth $25 billion has become the largest B2B e-commerce company in the world in just a few years and barely anyone expect the company can achieve this results so successful. Referring to the Appendix A, the income of Alibaba has been increasing from year 2010 to 2014. This is because of there has a few key factors of success that carried out by the founder of Alibaba.com, Jack Ma to operate the e-commerce business in the global marketplace.
In order to, analyze the company’s performance, we will closely focus on financial performance which is the degree to which financial objectives have been accomplished. This process measures the result of the overall financial health of the company over a period. The most efficient and effective metrics we choose were the improving operating income and return on equity and increasing sales, earning per share. Firstly, our sales have gradually increased in every single period, despite the minor changes in initiatives.
“This is great news!” he exclaimed. “That means only three more rounds of victory, and you’ll win the championship!” I smiled falsely in return, not wanting Lark to know about my discomfort or worry. I wouldn’t tell him about Barrett.
Budgeted Sales – Break-even Sales = 3,261,868 – 2600000 = 661868 Margin of safety (percentage) =( Margin of safety(value))/(Budgeted Sales) ×100 = 661868/3261868 ×100 =20.29% Break-even chart
Section 4 Findings and recommendations (a) Evaluate the effectiveness of the revenue cycle McDonald’s is apparently one of the biggest giants in the fast food industry, and this role simply proves that they did really well in their internal management. Therefore, we are going to evaluate the effectiveness of McDonald’s in term of revenue cycle. Initially, there is a lists of complaints available online about McDonald’s, as the accuracy of ordering process should be improve due to employees often process incorrect orders or even misplace the customer orders.