Class excel project


Ray’s Pizzeria

“food so good, makes you wanna slap yo momma”

Preface Warning:

Read the instructions carefully and provide what is being requested. To be a quality employee means you can follow directions.

A new client of yours, Tom Cruize, wants to open a small diner selling pizzas, chicken wings, salads, french fries, and sodas.

He is planning to open the diner on the 1st of July, 2013.

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 file called “Diner Template Summer 2013” for 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.

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 worksheet).

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: where are graphs used, what is graphs, what business to start using excel, what are graphs used for, what are graphs for, template for creating a business plan, start your own small business, start up costs template, start up consultant, startup business consultant, starting a small business plan, spreadsheet consultant, project startup plan, pro-e project, microsoft project template, microsoft excel spreadsheet, microsoft consultant, i want to be a consultant, it sales consultant, independent label business plan template, independent business plan, french fries business plan, excel spreadsheet consultant, Excel pro, excel budget template

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #4264434

1 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_23% %project_currencyDetails_sign_sub_24% tähän työhön


Hi! I would be glad to help you with this project. Please check my private message that would follow this one for further information. Thank you.

$250 USD 7 päivässä
(6 arvostelua)