Completed

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.

The Business Idea:

• 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

data) to help you determine the impacts to the business.

• 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

See more: work values, work in design, which graph to use for data, excel, microsoft, type of graphs, type of accounting system, tool design concepts, to do business, test scenarios template, test excel expert, template for test scenarios, starting accounting business, restaurant accounting system, reformat data, new hr concepts, need of marketing information system, need help marketing a small business, need expert excel help, need business to do

About the Employer:
( 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