Auki

excel expert needed for a quick work

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.

Assignment:

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

worksheet).

Chart One –”Monthly Product Revenue” – this will show the monthly revenue

for each of your five products for the entire year.

2

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.

Demand Rate:

Taidot: kirjanpito, Liiketoiminta-analyysi, Excel, Matlab ja Mathematica, Microsoft Office

Näytä lisää: work from home excel projects, excel work from home, get paid to make excel spreadsheets, freelance excel work uk, home based excel jobs, excel spreadsheet jobs from home, excel jobs from home part time, online excel job home based, expert seo services with a track, excel expert needed in dubai, excel expert needed, design a very simple logo similar to pepsi logo must be clever quick work needed 2 day max timeline super easy job all bids acce, data analysis excel expert needed, photoshop expert needed quick job, wordpress security expert needed quick job

Tietoa työnantajasta:
( 181 arvostelua ) Calcutta, India

Projektin tunnus: #17341098

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön

royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Lisää

₹300 INR / tunti
(56 arvostelua)
5.1
bchandra1955

Yes will be done in Rs 6000/- I will take 15 hours to finish.........................................................................

₹400 INR / tunti
(73 arvostelua)
5.9
carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have Microsoft certifications in .Net development and sql server. I also hav Lisää

₹277 INR / tunti
(25 arvostelua)
4.9
edgardiaz70

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

₹250 INR / tunti
(31 arvostelua)
4.8
Mfaisalshahzad00

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis Lisää

₹1111 INR / tunti
(8 arvostelua)
3.1
salimmurshed1111

i can do this, have a lot of experience and can bring a good result for you..... i will take the cheap rate but good service for you................ very much interested for this project............ and want to build a Lisää

₹111 INR / tunti
(3 arvostelua)
1.8
iamtahirmalik

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

₹111 INR / tunti
(1 arvostelu)
1.1
surendramuduli

we are highly expertise on data entry work and currently working one of our usa client for BL creation UPS and RL website for their warehouse buisness last [login to view URL] talk to us, we will start work on it straight a Lisää

₹111 INR / tunti
(0 arvostelua)
0.0
₹277 INR / tunti
(0 arvostelua)
0.0