How the business can be viable or profitable

Assignment Help Accounting Basics

Reference no: EM131974871

Question: "DECISION MAKING USING DATA/INFORMATION

Students will be given a new small business idea selling specific products to customers. Using Microsoft Excel, students will develop data models to simulate an application that provides business information through data for decision making. Students will build the Excel to model the business operation, formulate the data into information, utilize the information to analyze scenarios, and draw conclusions for the business concept.

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 hours (or via a video for online students). It is highly recommended you attend all classes (or review the video) to obtain the skills and understanding to complete this assignment.

The Business Idea:

• You are planning to open a small electronic store selling three electronic products.

You 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

• Marketing Model

• HR Model

• Accounting Model

• "Graph & Charts"

Instructions: • For each sheet, the cell colored in yellow are decision variable cells. Within these cells, users of your excel data model will be able to change the values contained within it. Decision variables are decision points that a decision maker, as a potential owner of this simulated business, may decide and/or test so the model will generate calculated results to help determine how this business can be viable or profitable.

• 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 the decision values entered into the decision variable cells.

• For all decision variables and calculated value cells, you are to make sure the formatting of the cell is correct. Example: if the cell represents a percentage, it should be formatted to %.

• You are not to rearrange and/or reformat the layout within each sheet. The one exception is you are free to design your graphs in the last sheet as long as it meets the requirement stated in the template. "

Information related to above question is enclosed below:

Attachment:- Spring2018StudentTemplate1.rar

Reference no: EM131974871

Questions Cloud

Discuss what you find most interesting : This weeks discussion comes from NPR's Planet Money Podcast. Warehouse stores (Costco, Sam's club etc) fundamentally changed the way people shopped.

Identify three components of your states emergency plans : Identify three components of your state's emergency plans that relate directly to your field of work or the field of work you aspire to get into.

Evidence to conclude that the average score : If the national average was 600, is there enough evidence to conclude that the average score has decreased? Use a p-value and 5% significance.

How the brands are alike and how they differ : How the brands are alike and how they differ? A preliminary analysis of any gaps that exist in the portfolio that might lead to opportunities to add to brands.

How the business can be viable or profitable : For each sheet, the cell colored in yellow are decision variable cells. Within these cells, users of your excel data model will be able to change the values.

Standard deviation for the number of people : Find the standard deviation for the number of people with the genetic mutation in such groups of 800.

Represents the 40th percentile of returns : Consider the Normal model ?N(0.03?,0.048?) for the returns of these mutual funds.

Probability of no hurricanes next? year : Assume that major hurricanes are independent of each other and that the mean number of hurricanes per year has not changed.

Estimate the family life insurance needs : Use the easy method to estimate the family’s life insurance needs.

User Account

All Pages