Philly Roasters Coffee Shop Case Study
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
Philly Roasters Coffee Shop Case Study
Abby Gold finger has a headache. It is 6 months since she acquired the Philly Roasters coffee shop on Walnut Street in Philadelphia. It has taken her all this time to learn the nuts and bolts of the business so that she now feels comfortable making plans for improving performance. Unfortunately, in the six months, sales have been declining versus the same period a year ago, and below the level she assumed when she bought the business. She has made successful business investments in the past, and is determined to make a resounding success of Philly Roasters. However, she has no experience in foodservice operations nor in managing a largely cash business.
Abby’s plan is to manage the shop herself initially, improve its performance over the next 12 months and then hire a seasoned manager who will allow her to step back and look for another venture.
In 2016, (prior to Abby purchasing the business) the financial results of Philly Roasters were as follows:
$’000s Cash sales Credit card sales Total Gross Receipts $300 $400 $700 Card company payments 8 8 Net Sales 300 392 692 COGS (variable costs plus wastage) 100 133 233 Gross Profit 200 259 459 Selling & Admin Costs 275 Operating Profit 184 Interest expense 8 Earnings before taxes 176 Taxes 44 Net Income 132 Note: the owner’s remuneration is not included in SG&A expenses. SG&A includes the employment costs of the baristas (wages and benefits), rental expense for the shop and equipment and other general expenses.
The store is open from 7:00 am to 8:00 pm seven days a week. There are 2 staff on site at all times, with a total complement of 4 full time employees. The working schedule rotates over time so that the employees take turns to work early, late, weekends etc. On average each employee is working 46 hours a week. The owner is present during busy periods.
It is September 1st 2017, and time for Abby to go to the bank and request a continuation of the line of credit that Philly Roasters has been using to manage cash flow ups and downs. To get ready for the meeting she must prepare an income statement and cash flow budget for the 4th quarter including monthly budgets for October, November and December. Following are the key assumptions that Abby will use for the budget based on her observations since acquiring the business:
Sales $ 55,000 per week of which 45% are cash sales and 55% are credit card sales
Credit card sales are collected from the bank at the end of the month following the sale (e.g. august credit card sales are collected at the end of September)
Cost of goods sold same % sales as full year 2016
Barista wages $12 per hour plus 35% benefit costs payable end of each work week
Real estate rent $ 4000 per month payable first day of month
Equipment rental $ 3000 per month payable end of month
Supplies $1000 per month payable 20 days after month end
Marketing $ 6000 in December only payable in December
Interest rate on credit line 6% per annum payable monthly in arrears
Tax rate 25% of pre-tax income payable, payable 30 days after quarter end.
Philly Roasters maintains a 4 week inventory of coffee, cups, lids and carrying trays based on next month’s forecast sales. These items are bought for cash from a cash and carry supplier.
Abby estimates that October 1st balances will be:
Cash balance $ 5000
Receivable from credit card banks $35,000
Materials inventory $ 18,000
Total assets $ 58,000
Payables $ 1000
Income tax payable $ 12,000
Outstanding balance on line of credit $20,000
Shareowners equity $ 25,000
Total liabilities and shareowners’ equity $ 58,000
Required:
Prepare the following budgets for each month October, November, December and the full quarter in an easily readable form in excel with proper use of formulae and formatting:
(a)Prepare a receipts and disbursements cash flow forecast. How much does the shop need to borrow at the end of each month?
(b)Prepare a budgeted income statement
(c)Prepare a budgeted balance sheet at December 31st
Make sure your answers are highlighted. Formatting is as important as the correct answer for this project. You will hand in spreadsheet(s) on the due date presented and printed clearly and labeled appropriately. Each budget needs to fit on one printed page. You must use formulae, no plugging answers.
*****FORMATTING: This should be done in excel, in spreadsheet form. It can be multiple excel files, or multiple sheets in 1 excel file. Formulas must be used for calculations where necessary, no plugging in numbers. You can copy and paste the excel sheets here if you cannot upload the excel file, formulas also included.
Additional problem info that may be helpful: Roasters has $ 20,000 of debt from the credit line. If there was zero cash flow this balance would remain the same and interest expense would be 6% divide by 12 times 20,000 per month. You should find that there is positive cash each month and this can be used to pay down the debt. Therefore, the interest will decline each month. You should develop a reasonable methodology for calculating interest each month.
Philly Roasters Coffee Shop Case Study
RUBRIC
QUALITY OF RESPONSE NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
CLICK ON THE LINK HERE: https://www.perfectacademic.com/orders/ordernow
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!!