A new client of yours, Blanche Greene, wants to open a small diner selling
calamari, oysters, fried shrimp, catfish sandwiches, salads, French fries, and
sodas. He is planning to open the diner on the July 1, 2018.
You, as an independent consultant, have been hired to develop a cash pro forma
budget for his business venture (note: this is a spreadsheet that helps forecast
income and expenses over a period of time). It can be used to plan for and manage
the business if done correctly.
Using Microsoft Excel, construct a monthly proforma cash budget for your client for
the first year of operations.
Use the attached Excel Template - “Excel Assignment Diner Template” as your
starting point. This is the file that must be downloaded and used as the basis for
your assignment. Do not make any changes to this pre-designed template
except to add your information for the diner.
Do not use a template from a previous semester – this is considered academic
dishonesty and will be subject to disciplinary action.
Place the finished cash pro forma on a worksheet labeled “Cash ProForma".
Place all your case assumptions data on a separate worksheet. Label the
worksheet "Assumptions" (note: each piece of data must appear in its own cell on
the Assumption sheet).
Place your start-up costs on a third worksheet labeled "Startup Costs"
Create two additional worksheets for your recommendations. Label one worksheet
“Beer Recommendation”, label the other “Entertainment Recommendation”.
Appropriate Charts (graphs): You will be creating two separate charts so create and
label two additional worksheets for the charts (each chart will be in its own
Chart One –”Monthly Product Revenue” – this will show the monthly revenue
for each of your five products for the entire year.
Chart Two – “Total Product Net Income” - You want to track the total product net
income for the year to determine any trends or projections in product sales.
Make sure both charts are formatted correctly (i.e. appropriate title, legend where
appropriate, data series properly labeled) and they are appropriate for business use.
Information needed to complete assignment:
Calamari, Oysters, Fried shrimp, Catfish sandwiches, Salads, French fries, and sodas.
Product Selling Prices:
Oysters on half shell will sell for $8.25 each (dozen)
Fried Shrimp will sell for $10.25 (dozen)
Calamari will sell for $4.95 an order
Catfish Sandwich will sell for $5.95
Salads will sell for $4.50 each
Fries sell for $1.25 per order
Sodas sell for $1.25 a bottle
Cost of Goods Sold:
The Catfish sandwich ingredients (fried catfish, cheese, sauce, bun etc.)
cost $3.15 per sandwich.
Calamari cost per order $1.90.
The fresh Shrimp cost $7.19 per order from the supplier.
Oysters (sauce, lemon, oysters) cost $5.19 per order.
Salad ingredients (lettuce, tomatoes, cheese, etc.) cost $1.23 per salad serving
Frozen fries and oil average to $.67 per order
Sodas cost about $.7 per 16 oz. bottle
The building rent is $2775 per month.
Phone will cost about $220 per month.
Electricity should cost about $775 a month.
Insurance will be $850 a month.
7 freelancere byder i gennemsnit ₹366/time for dette job
Hello. I am Edgar Díaz. I am Urban Planner With a MBA and Specialist in Project Management (PMI). I have experience in accounting and bookkeeping. I am AIPB, AAA, ACCA student
Hey. I read your project details and I am interested in your project so please message me and we discuss about the project. Thank You, Tahir M. ........