Accounting - Business Plan Report Friends Cafe - Assessment Answers

January 10, 2018
Author : Charles Hill

Solution Code: 1ABDI

Question: Accounting & Business Plan Report

This assignment falls under “Accounting & Business Plan Report” which was successfully solved by the assignment writing experts at My Assignment Services AU under assignment help service.

Accounting & Business Plan Report Writing

Task

  • Create a café and hire staff that has good communication and management skills so that we can quickly achieve profitability and sustain an attractive rate of return (30% minimum) to our investors.
  • Partnership (4 people)
  • Leased premises
  • Café would be located at a major street in the city near a major Railway Station.
  • We will offer variety of products (Coffee, cakes, Burgers and etc)
  • Make Changes According to Customers Taste
  • Produce high quality products
  • The Location is very important as its located in the main city and near a busy
  • station so there is large movement of people.
  • A relaxing environment for the customers
  • Upscale Interior
  • Low Prices
  • Promotion Offers

The assignment file was solved by professional International Accounting Experts and academic professionals at My Assignment Services AU. The solution file, as per the marking rubric, is of high quality and 100% original (as reported by Plagiarism). The assignment help was delivered to the student within the 2-3 days to submission.

Looking for a new solution for this exact same question? Our assignment help professionals can help you with that. With a clientele based in top Australian universities, My Assignment Services AU’s assignment writing service is aiding thousands of students to achieve good scores in their academics. Our Accounting assignment experts are proficient with following the marking rubric and adhering to the referencing style guidelines.

Solution:

EXECUTIVE SUMMARY

A business startup would succeed if the people who are engaged in setting up the business know exactly what they are doing and follow a pattern of schedule of work necessary to build the base. The base needs to be built on a robust plan which has its sight on acquiring a good number of customer with a good service menu coupled with competitive pricing and the plan is dependent upon a better and experienced supplier base. Thus there is a need to make sure that the idea is backed up by adequate planning starting from selection of a location, hiring competitive set up people who would be required to manage the operations, select suppliers who would then be needed to supply quality raw materials at reasonable prices so that the business remains competitive in the market in the face of existing other businesses.

Each and every project depends upon the financial metric to be sure of the success. For this to happen there shall be good market research being undertaken by the friend’s cafe partners to assess the market demand and pricing behavior. Asa market entrant, the friend’s café should look at disrupting the market with better pricing. And this exactly what the partners of the firm has intended to do.

BACKGORUND

Four friends (Riaz, zian, Tan and Tailin) have come together to start a new Start up business which would be setting up a café which would serve coffee and other items to customers in a busy business district near the railway station in Melbourne. The initial plan is to start the business with an intention of picking up customer, providing them with an opportunity to spend some time in the café and relax and that too within a pocket friendly environment. The café would measure at least 40 feet by 20-25 feet in size and can have arrangements for sitting 20 people at a time comfortably. For this they have seen a few locations and at least three locations are being scanned for their suitableness. One particular place has been deemed to be the most suitable for the first cafe as it has very good location overseeing the station and located on the frost floor corner of large office complex with two face open and has a large entrance. The place has adequate parking and other amenities which would be quite beneficial for many officegoers and travelers. Further the same building houses at least a few multinational offices, travel companies, a hotel on the 2nd and 3td floor and many other shops in the ground floor. Also there is big departmental store in the same floor which would help in attracting customers daily.

The 4 partners are willing to contribute an initial sum of $10,000 each for the venture. The rest of the funds needed for the business would be collected from short term bank loan and other creditors. The aim is to generate 30% return for the investors - partners in the initial years and look for expansion as soon as the first café stabilizes in terms of customer satisfaction and generates interest in the area. The premise currently being scouted would be leased for at least a period of 3-5 years.

MARKETING

Marketing is always at the heart of the success of a new business. It’s not the quality of service alone but the way customers are given an opportunity to come and experience the facilities – would eventually determine how successful a business becomes. For this the café aims at attracting coffee mad Australian commuters and travel people. The café plans to have a menu which is wide and would include a variety of coffees such as hot and cold coffees and cappuccinos etc. apart form cakes and breads. The products would be offered at the industry leading prices. The products would be leading in their respective categories with the café chain planning to hire experienced staffs who have worked with leading coffee brands in UK. This would help in the maintenance of service quality (Atrill, 2013).

Hoarding would be put at strategic places to let the customers know the location better and relaxing environment would be created for those visitors who would be frequenting the café. Interior would be made as per modern tastes and the same would be designed by a leading designer in Melbourne. To top it all the prices would be at least 30% lower than what the competition offers. Further in it the initial stages those who become regular customers would be given loyalty cards (3-5% saving for those who would use the card) with a provision who spends more than $50 would be allowed to have discounts of 3-5% depending upon the meu they would choose to use (Datar, 2012).

OPERATIONS

The operations of new company or firm or a new shop like friend’s café is needed to be of top class to be able to attract customers. The staff of the café are trained and are being recruited from an experienced back ground. Their expertise in making good coffee and a variety of other projects are quite good. The production department would have three people of which the head chef would be an individual with more than 15 years of experience in the field (Duchac, 2011).

The restaurant café is basically a self-service joint and thus does not need a large no of people. keeping in mind the decorum and cleanliness that is required to be maintained across the time, there would be two helpers to look after the same. The Billing clerk would be appointed to look after dispensing cash and receiving payments and would be given the task of looking after the whole human resource. There would be security guard to look after the whole place. The detail of the human resource and the payment thereof is presented as follows:

Human Resource Requirement
number salary/month total salary /month
Operations Manager - Head of Kitchen 1 1,800 1,800
Kitchen Workers - assistant Chefs 2 1,000 2,000
Billing clerk 1 1,000 1,000
Helpers 2 600 1,200
Security personnel 1 600 600
$6,600

The plan is to keep the salary bill under control in the beginning, however in the case of customer footfall increasing in the future the staff would be paid a 10% increase in coming ears and the partners have agreed in principle to employ more number of personnel if required and if the situation demand so.

FINANCIAL PROJECTIONS

FINANCIAL FORECASTS

START UP COST SUMMARY

The café would require substantial investment in the beginning as the same would built to have feel of an upscale café and no compromise would be made as to maintenance of quality service offerings. The raw materials for all the coffee and other offerings would be procured from experienced suppliers having procurement form south America and Jamaica. Such suppliers have been identified. Talks are on regarding supply prices and quantity discounts and soon a 3-year deal would be mad with them (Dyson, 2007). They would require to supply materials with a lead time of 3-4 days. The funds which would be needed are sated as follows:

$
Lease Mortgage -Advance Payment 60,000
Lease Rent 3,000
Furniture’s and Fixtures 45,000
Kitchen Equipment (ovens) 75,000
Interior Decoration 8,500
Initial charges to be paid for interior Decorator 2,500
Electrical Equipment 2,500
Billing Machine /Computer 3,500
$200,000

As shown above the initial cost of starting the café would be $200,000 which is agreed to be contributed by the 4 partners ($100,000) and the balance fund of $100,000 form a lender. The Lender has agreed to provide the loan @ 6% per annum. The interest would be paid annually on the loan.

For further expansion in the coming years the partners have agreed to use the profit or cash inflows and borrow form the bank at a lower interest rate. Banks can lend to this kind of cafes at 4.5% after the café is at least 6 months old and has an operational cash flow to show (Dyson, 2007).

SALES / SERVICE REVENUE BUDGET

The café would serve three different varieties of coffee and each type would include 5 different tastes. Further each taste would include three different sizes. For uniformity the prices would be made uniform in the beginning and lower than what the competing firms offer currently.

Sales Budget: Monthly Estimates
Price ($) Estimated Demand/day working Days Estimated Revenue ($)
Café Cappuccino 6 20 30 3600
Hot Coffee 6 25 30 4500
Ice cream 7 20 30 4200
Strawberry cakes 10 20 30 6000
Fruit Punch with Coffee 6 25 30 4500
Cold Coffee 6 25 30 4500
Ethiopian Coffee 7 25 30 5250
Strawberry Smoothie 6 25 30 4500
Coffee Latte 7 25 30 5250
Burgers 2.5 35 30 2625
Ice Tea 2.5 20 30 1500
Other Cakes 8 25 30 6000
Total monthly Estimated Revenue 52,425

The monthly sales estimations are approximately $52,425 initially and it is expected to go up in the coming year as words spread and the café would add more items to the menu. More varieties of the same items would also be added. Sandwiches of different varieties and pancakes can be added to the menu in the coming year. In the second year the revenue is expected to touch $65,000 and increase would be approximately 25-30% per annum. Current annual sales in first year thus amount to $629,100. Due to promotional deals and combos which would be introduced there would be an estimated discount of approximately 2% and after the discounts the net Annual revenue would be expected to $616,518 (Eisen, 2013).

In the next two years (year 2 and 3 ) the Revenue and discounts would be as follows:

Year 1 Year 2 Year 3
Gross Revenue $629,100 $786,375 $982,969
Discounts (2%) $12,582 $15,728 $19,659
Net Revenue $616,518 $770,648 $963,309

COST OF SALES ESTIMATION

Cost of sales are estimated to be around 50% of the total revenue generated by the cafe including materials and wages etc. most of the raw materials required would be procured from a single supplier who is capable of supplying the same as he was in business of the last 10 years and knows the business well. The supplier agreement has been to pay of the purchase in the immediate next month. The whole purchase would be on credit and raw materials would cost approximately 40% of sales in each month and year. The estimation of cost of sales is presented below for a monthly basis and for the first three years of operations (Elliott, 2014).

cost of sales estimations per month
Raw materials (35%) 18348.75
Labor charges /salary-chefs 3800
other production costs 1,450
total cost of sales 23598.75
Year 1 Year 2 Year 3
cost of sales (50%) $283,095.0 $353,868.75 $442,335.94
Gross Margin $333,423.0 $416,778.8 $520,973.4

Monthly cost of sales would be approximately 45% of the gross revenue and cost of sales would include raw materials cost, labor cost (those engaged in production) and other direct production costs. However, the gross margin is lower than 55% (53%) because of direct discounts given to customers on account of loyalty cards and combo deals. That consumes 2% of gross sales. The gross profit would be expected to be $333,423 in the year 1 and $416,778.8 in the year 2 and $520,973.4 in year 3.

SELLING AND ADMINISTRATIVE EXPENSES BUDGET

The selling and administrative expense budget is an important aspect of making the expense budget since the same can be quite substantial. Thus there shall be an attempt to minimize this budget through appropriate planning measures such reducing unnecessary labor expenses, reducing electricity bills etc. this segment for the friend’s café comprises of wages paid to office and support staff, electricity expenses, interest expenses, marketing and advertising expenses planned for the year and other miscellaneous charges (Hoggett, 2011). The same is presented as follows:

SELLING AND ADMINISTRATIVE EXPENSES BUDGET
per month (Yr 1) per month (year 2) per month

( Yr 3)

office wages 2,800 3000 3300
electricity charges 1,500 1500 1500
Advertising Expenses 600 650 650
Interest Expenses 500 333.33 167
Supplies 400 500 600
credit card collection fee 180 225 281
Miscellaneous expenses 300 350 500
Total Expenses 6,280 6,558 6,998
Year 1 Year 2 Year 3
Annual Selling /Admin Expenses 75,357.81 78,697.23 83,975.58

Office wages are expected to increase by approximate 8-10% each year. The interest expenses are expected to decline in year 2 and year 3 as the loan would be repaid ($20,000 annually over the next three years). Thus interest expense is expected to decline year 2 and year 3. However, as revenue is expected to increase by an estimated 25% each in the next two years the related expenses are expected to rise. Thus there are provisions for them in the selling and administrative budget. Such expenses would include Advertising Expenses, Supplies and Miscellaneous charges.

SCHEDULE OF COLLECTION FROM CUSTOMERS

As the café is run on a busy market, there is hardly any sale which is expected to be on credit. Most sales would be cash sales and some of the them would be paid through cards. The partners expect the payments by cards would comprise of approximately 70% of the same. This is why there is adequate provision for credit card and debit card collection machines. For the sales made through cards the realizing bank would be required to be paid .5% of the amount. This expense is included in the selling and administrative budget (Horngren, et al., 2011).

So the café would not have any accounts receivables or short term debtors. Thus the frim does not have any problem of providing credit to customers and provide them with a time period to pay. This solves the issue of bad debts. However, the café partners are willing to provide credit to those institutional customers which gives them bulk orders for parties and special occasions. Such customers might be given a credit period of 7 days. However, the same is not incorporated into the budget as no estimate is available for the same.

SCHEDULE OF PAYMENTS FOR PURCHASES

Raw materials would be procured from a single supplier who has agreed to supply all the required material on daily basis. Coffee beans and other raw materials which can be stored for longer days would be required to be supplied on a weekly basis. However other materials like milk and fresh ingredients would be supplied daily – early morning. The Supplier has agreed to give a credit of 30 days. This means payment to the supplier would be made in the second month. Thus at the end of the year, 1 month’s accounts payable would be shown in the books. The accounts payable would be 35% of monthly gross revenue (Weetman, 2013). The total purchases for the month and the accounts payable for the next three years are shown as below:

Year 1 Year 2 Year 3
Raw materials (35%) - monthly 18,349 22,936 28,670
total purchase of raw materials 220,185 275,231 344,039
Accounts Payable - end of year 18,349 22,936 28,670
total cash payment made to suppliers 201,836 270,644 338,305

Purchases of raw materials are calculated on a monthly basis which is 35% of the gross monthly revenue expected. So total raw materials purchased is monthly consumption multiplied by 12. At the end of the year one month’s payment is yet to be made and thus shown as accounts payable. So payment for December of year 1, would be made in January of the next year or year 2. Similarly, the total cash payment made to suppliers are calculated as 11 months payment for the first year. in the second and third year total cash payments made to suppliers equal 11 months’ current year payment plus 1 month’s payment for last year (Maynard, 2014).

CASH BUDGET

The cash flows of the Friends Café for the first year is presented as follows:

CASH BUDGET (first year) January Feb March April May June July Aug Sept Oct Nov Dec
Cash Balance 0 42,345 63,341 84,338 105,334 126,330 147,326 168,323 189,319 210,315 231,311 252,308
Capital Introduced 100,000 0 0 0 0 0 0 0 0 0 0 0
Loan Taken 100,000 0 0 0 0 0 0 0 0 0 0 0
Net Revenue 52,425 52,425 52,425 52,425 52,425 52,425 52,425 52,425 52,425 52,425 52,425 52,425
Total cash Received 252,425 94,770 115,766 136,763 157,759 178,755 199,751 220,748 241,744 262,740 283,736 304,733
Less:
purchase of kitchen Equipment 75,000 0 0 0 0 0 0 0 0 0 0 0
Lease Mortgage -Advance Payment 60,000 0 0 0 0 0 0 0 0 0 0 0
Lease Rent 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000
Furniture’s and Fixtures 45,000 0 0 0 0 0 0 0 0 0 0 0
Interior Decoration 8,500 0 0 0 0 0 0 0 0 0 0 0
Initial charges to be paid for interior Decorator 2,500 0 0 0 0 0 0 0 0 0 0 0
Electrical Equipment 2,500 0 0 0 0 0 0 0 0 0 0 0
Billing Machine /Computer 3,500 0 0 0 0 0 0 0 0 0 0 0
Payment to Supplier 0 18,349 18,349 18,349 18,349 18,349 18,349 18,349 18,349 18,349 18,349 18,349
payment of interest 500 500 500 500 500 500 500 500 500 500 500 500
payment of miscellaneous charges 300 300 300 300 300 300 300 300 300 300 300 300
purchase of supplies 400 400 400 400 400 400 400 400 400 400 400 400
Payment of electricity expenses 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Payment of wages and salaries 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600
Repayment of Loan 0 0 0 0 0 0 0 0 0 0 0 0
Advertising Expenses 600 600 600 600 600 600 600 600 600 600 600 600
credit card collection fee 180 180 180 180 180 180 180 180 180 180 180 180
Total cash payments made 210,080 31,429 31,429 31,429 31,429 31,429 31,429 31,429 31,429 31,429 31,429 31,429
Closing Cash Balance 42,345 63,341 84,338 105,334 126,330 147,326 168,323 189,319 210,315 231,311 252,308 273,304
less: Repayment of Loan 33,333
Closing Balance end of the Year 239,971

As can be seen form the above cash budget the monthly budgets are showing increase inclosing balances for each month of the first year which means the café is able to generate positive cash flows for most of the moths and at the end of the year the café has a cash balance of $239.971. the same can be sued to improve the menu, add new items and add amenities which might be need in the coming years. The partners can also be paid a dividend if the partners so desires (Wittman, 2011).

INCOME STATEMENT

The income statement of the Friends Café project is presented below:

Year 1 Year 3 Year 3
Gross Revenue for the Year 629,100 786,375 982,969
less: cost of sales 283,095 353,869 442,336
Gross Profit 346,005 432,506 540,633
less:
office wages 33,600 36,000 39,600
electricity charges 18,000 18,000 18,000
Advertising Expenses 7,200 7,800 7,800
Interest Expenses 6,000 4,000 2,004
Supplies 4,800 6,000 7,200
credit card collection fee 2,158 2,697 3,372
Miscellaneous expenses 3,600 4,200 6,000
Depreciation on Fixed Assets ( 25%) 30,875 30,875 30,875
sales Discount (2% of sales) 12,582 15,728 19,659
Total operating Expenses 118,815 125,300 134,510
Net income Before Tax 227,190 307,207 406,123
less:
Tax @ 30% 68157.06 92161.96 121836.9
Profit after taxes 159,033 215,045 284,286
Net Margin % 0.252795 0.273463 0.289212

The firm has been able to generate a gross margin of 53% after considering the discounts on sales and 55% if the same is not considered. In the year 1, the café is looking to generate a net margin of 25.27% which is good and the same is going to increase further in the next two years. So the project if implemented successfully and with the right intent, it would be able to generate a good amount of cash flow and profitability (Schroeder, 2013).

FUNDING NEEDS

The café needs an initial funding of $200,000 which is required to buy the fixed assets and make the necessary payments for decoration and other requirements. Of the same the partners have decided to invest $100,000 and the other half is borrowed at 6%. The partners have tied up with the supplier who have now agreed to provide a month’s credit thus eliminating too much working capital requirement.

IMPLEMENTATION TIME TABLE

The project if started Right away would take approximately 2 months to take effect. The partners would be required to enter into the leasing contract right away without wasting any time since the same would cost them the place. And finding a better place to start the project would be quite difficult. The interior designer has asked for four to six weeks’ time to make interior work and further 2 weeks would be needed to fix the furniture’s and kitchen equipment’s. The interior designer has agreed to employ a electricity work engineer to do the electricity fittings and this would save time. So the project would be up and running in three months’ time if the project is initiated right now.

CONCLUSION

The friend’s café project seems to be heading in the right direction. As the partners have taken the decision to start the project in the right time and have identified the right place for the same, they have a head start. Further the revenue projections are in the right directions. Because the project has found the right place the customer flow wouldn’t be a pressing issue. What the business has to do is to make the right menu and offer good quality product and ambience at a fair price. The cash budget and the income statement has indicated towards a profitable venture. Even of the venture is being intended to be started with a large debt, the cash flows are an indication that the repayment of the interest and the principal is not going to prove difficult. Further the project seems to generate adequate amount for the partners to start thinking about adding another branch. They shall plan ahead, use the additional cash flows and look for loans at a cheap rate. The signs are all towards a good beginning and time must not be wasted to initiate the same (Atrill, 2013).

This Accounting assignment sample was powered by the assignment writing experts of My Assignment Services AU. You can free download this Accounting assessment answer for reference. This solved Accounting assignment sample is only for reference purpose and not to be submitted to your university. For a fresh solution to this question, fill the form here and get our professional assignment help.

RELATED SOLUTIONS

Order Now

Request Callback

Tap to ChatGet instant assignment help

Get 500 Words FREE