Question: i need to create a start up cost projection with an excel spread sheet using these directions: The spreadsheet contains a title. SIMBook Excel Chapter

i need to create a start up cost projection with an excel spread sheet using these directions: The spreadsheet contains a title. SIMBook Excel Chapter 1- SLO 1.2 & 1.4
1
The spreadsheet contains row and column headings. SIMBook Excel Chapter 1- SLO 1.2 & 1.4
1
The spreadsheet contains a minimum of 10 rows with entries listing various types of items (electricity, rent, inventory, advertising, salaries, etc...) You cannot enter the same number for all items/rows unless it is a fixed monthly expense, such as rent). The minimum number of 10 rows does NOT count a formula. SIMBook Excel Chapter 1-1.2,1.4 & 1.5
5
The spreadsheet contains a minimum of 4 columns - use the example in Excel SIMbook 2(months of the year, years, quarters, etc..) NOT counting a formula. SIMBook Excel Chapter 1-1.2,1.4 & 1.5
2
The spreadsheet contains a minimum of (1) each of the following formulas: AVERAGE, MAX, MIN and SUM; the minimum number of formulas is 4(each correct formula is worth 2 points). SIMBook Excel Chapter 1-1.3 & SIMBook Excel Chapter 2-2.1 & 2.5
8
An appropriate chart. SIMBook Excel Chapter 3-3.1,3.2,3.3,3.5 & 3.6
3
The chart type and information presented in the chart is an accurate representation of the data not misleading; watch the monetary increments used for the y-axis, make certain they correspond with your costs, they should provide an accurate view SIMBook Excel Chapter 3-3.1,3.2,3.3,3.5 & 3.6
2
Chart includes and contains a title and all data is labeled (e.g. horizontal and vertical axis labels, pieces of pie are labeled, etc...). SIMBook Excel Chapter 3-3.3
2
The spreadsheet tab title is customized to read Startup Costs. SIMBook Excel Chapter 1-1.5
1
Total Possible Points:
25
it is about a restaurant called natures kitchen and it needs to be done on an excel shest

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!