# need an excel expert to do work in finance

DECISION MAKING USING DATA/INFORMATION – Microsoft Excel Assignment 70 points

Students will use excel as a tool to help make decisions of a new small business selling specific products. Using Microsoft

Excel, students will develop data models and formulas to simulate an information system that provides business information for

strategic decision making. Students will utilize Excel to create and capture data, formulate the data into information, utilize the

information to analyze scenarios, and draw business conclusions.

Your final Microsoft Excel project workbook (file) will include the following worksheets (tabs). Specific instructions, concepts,

expectations, and demo will be provided during scheduled class session. It is highly recommended that you attend all classes to

obtain the skills and understanding to complete this assignment.

• Fast food restaurant offering four specific type of items.

Your will be provided an Excel Template as a starting point. The Excel Template will contain the following sheets (Tabs)

which you are to make functional as instructed in class:

• Configuration – Setup Variables

• Marketing Model – Sales & Marketing

• HR Model – Human Resources

• Cash Flow Model - Accounting

• Graph & Charts – Executive Reports

Instructions:

• For each sheet, the cell colored in blue are decision variable cells. Within these cells, users of your excel model will

be able to change the values contained within it. Decision variables are decision points that you, as a potential owner of

this simulated business, may decide and/or test so the model will generate calculated results (information from the

• For each sheet, the cell colored in gray are calculated values. Within these cells, you are expected to develop

formulas so the sheet can yield correct calculated results based on your decisions entered into decision variable (blue)

cells.

• For all decision variable and calculated value cells, you are to make sure the formatting of the cell is correct. Example

if the cell represent a percentage it should be formatted to %, and if is a dollar is should be presented with \$.

• You are not to rearrange and/or reformat the layout within each sheet provided to you as the assignment template. The

exception is you are free to design your graphs in the last sheet as long as it meets the requirement stated in the

template.

Skills: Excel, Java, Microsoft Office, SQL, Word

( 121 reviews ) Calcutta, India

Project ID: #9517497

## Awarded to:

suporteideacorp

Hello, my name is Ramon Alonso, I am Director of a solutions company. My company has over 10 highly trained employees in the following areas: -Web Site development and SEO; -Development of mobile and desktop applic More

₹111 INR / hour
(1 Review)
0.4

## 8 freelancers are bidding on average ₹202/hour for this job

LumiNysis

We at LumiNysis are the expert in MS Excel and automation across industries and are able to covert any data into useful results

₹100 INR / hour
(1 Review)
0.7
ipianochan

Good in math (main job architecture) and good in Microsoft Office Softwares (specialy in excel, was a previous bookkeeper at my uncle's business)..

₹166 INR / hour
(2 Reviews)
0.4
AldebaranSystems

I am new here and taking my first steps in this website. I have completed 1 project so far with a 5-star rating. I have experience with Excel and coding in excel VBA. I have developed complex use-cases in Excel and can More

₹100 INR / hour
(0 Reviews)
0.0
₹277 INR / hour
(0 Reviews)
0.0
₹222 INR / hour
(0 Reviews)
0.0
novotjan85

Hi, I have had many experiences with financial and business plans. I have made more plans for credit unions or trade companies Every of my filess have good graphic design and can easily see important thongs. Whatever More

₹166 INR / hour
(0 Reviews)
0.0
tirthamaitra007

Hello, I have proficient experience in java and db development. I can help you in this project. Please inbox me for more discussion. Thanks, Tirtha.

₹188 INR / hour
(0 Reviews)
0.0
rra56100fe439f58

Hi, I am an excel teacher (see my profile for my IT teaching experience) for more than 10 years (both full time and part-time). I usually give many practice exercises to my students like this. For me this is not a d More

₹400 INR / hour
(0 Reviews)
0.0