User Account

All Pages

Monthly costs for the chain of lasala restaurants

Assignment Help Basic Computer Science
Reference no: EM131053956

Tutorial 3 Production Test 3 Instructions

Eva Lorraine needs to analyze the monthly costs for the chain of LaSala restaurants that she manages. She has created a spreadsheet in Excel but is unsure as to how to create formulas. She has done most of the formatting work on the spreadsheet but needs your help in figuring out the numbers.

Calculating the Costs

1) Start Excel and open Production Test 3 Spreadsheet.

2) Save the spreadsheet as Sales Analysis.

3) Use the TODAY function to enter the current date in cell A2.

4) Use the fill handle to complete the months of the year from February to June.

5) Select the range B4:G10, use the Quick Analysis tool to enter the SUM function to calculate the total for each month, and then widen the columns so the totals are visible.

6) In cell H4, use the SUM function to calculate the total revenue for January through June's revenue for Chicago, and then copy the formula for the other restaurant locations and for the total in row 11.

7) Format the range H4:H11 with the Accounting Number format and verify that the total is $816,479.00.

8) In cell B14, enter the correct function for calculating the average for January through June's revenue based on the values in the range H4:H10.

9) In cell B15, enter the correct function for calculating the minimum amount listed for January through June's revenue based on the values in the range H4:H10.

10) In cell B16, enter the correct function for calculating the maximum amount listed for January through June's revenue based on the values in the range H4:H10.

11) Revise the formula in cell I4 to make cell B17 an absolute reference, and then copy the formula for the remaining cities and for the total row.

12) Change the value in cell B17 to 15%; widen columns as needed.

13) In cell J4, enter the formula to add cells H4 and I4, copy the formula to cell J11, and then apply the Accounting Number format and widen the column.

14) In cell K4, use the VLOOKUP function to enter a ranking for the total incell J4. Use the table in the range D14:E18 as the array. Note that you must make the cell addresses in the table absolute by pressing the F4 function key. Copy the VLOOKUP formula to cell K10.

15) In cell L4, use the IF function to enter "Yes" if the value in cell J4 is greater than or equal to $100,000 and "No" if the value is less than $100,000.

16) In cell H11, use Goal Seek to set the value in cell H11 to 900,000 by changing the value in cell B4 (the January sales for Chicago).

17) Widen columns as needed.

18) Enter the new sales for Chicago in January in cell B18. Remember to enter the cell address, not the value.

19) Format the worksheet in Landscape orientation and scale the sheet to print all columns on one page.

20) Insert a heading with your name on the left, the filename centered, and the sheet name on the right. Use codes when possible.

21) Insert a footer with the page number and number of pages (Page # of #). Use codes when possible.

22) Save your file and submit it to your instructor

Reference no: EM131053956

Questions Cloud

What advice to you have for someone like me looking to do : You're asking for insight and advice, so prepare some genuine questions you have about the industry, the job, and/or the individual's background.  Often, opening questions will spur a longer conversation but it's good to have some other questions pre..
Data marts and data mining : What are the steps necessary to create a data mart? Why are data marts and data mining helpful?
Identify describe four trends in the macro environment : Identify and briefly describe four trends in the macro/market environment that will have or recently hand an influence on the selected industry
What is a minimal set of functional dependencies : What is a minimal set of functional dependencies?
Monthly costs for the chain of lasala restaurants : Eva Lorraine needs to analyze the monthly costs for the chain of LaSala restaurants that she manages. She has created a spreadsheet in Excel but is unsure as to how to create formulas. She has done most of the formatting work on the spreadsheet bu..
Overly zealous in advertising its products : 2. What are some of the unethical issues that may arise from a firm's procurement activities? Are you aware of any of these issues from your personal experience or businesses you are familiar with?
Give a counterexample to illustrate this point : Give a counterexample to illustrate this point.
Healthcare financial management association : The Healthcare Financial Management Association (HFMA) identified 10 key revenue cycle performance measures. Choose three of the following performance measures/benchmarks identified by the HFMA. , indicate how improvement in the benchmark enhances..
Question regarding the running argument : Write a program that reads in information for two runners in a race and swaps their information if necessary so that the runner with the faster time is stored in a variable called winner and the other is stored in a variable called loser. There ar..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Implement a double-ended priority queue

1. Generalize the preceding exercise to obtain a k-d heap, in which each item can have k individual keys. You should be able to obtain the following bounds: insert in O(log N), deleteMin in O(2k log N), and buildHeap in O(kN). 2. Show that the k-d he..

  Find out product stream temperature and volume

Find out the product stream temperature and volume required to carry out reaction in a CSTR at 50 % conversion in adiabatic mode of operation.

  Write the definition of a class player containing

Write the definition of a class Player containing: An instance variable name of type String , initialized to the empty String. An instance variable score of type int , initialized to zero.

  Example of an actual data warehouse

Find an example of an actual data warehouse. For this example, describe the content, purpose, user access methods, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) - (make sure that your ..

  What are the critical points other than cost

They have a series of staff that work on different projects in different parts of the country and are looking to provide them with office automation, such as email, word processing and spreadsheet capabilities, as well as online storage for their ..

  How might a change control system help

How might a change control system help?

  The myths of innovation

1. Scott Berkun's book, The Myths of Innovation, holds that many of the popular images of how innovation works do not hold up when scrutinized closely. He examines ten innovation stereotypes, and demonstrates how they generally do not hold true.

  Prepare presentation slides on the security solution

Prepare presentation slides on the security solution you would recommend. Show why your solution provides the best level of security. Assess the cost and the required resources of your solution.

  Evaluating options and developing resolutions

Provide an overview of tasks and key work activities (meetings, training, presentations, etc.) in which you were engaged during the week, with sufficient detail for your instructor to understand what you were involved in.

  Why would anyone use hexadecimal or octal nowadays

What types of data formats are there? Why are there so many? Can you tell from looking at a string of bits exactly what the data represents?

  Draw the logic diagram for a circuit that resolves priority

Q:  "Draw the Logic diagram for a circuit that resolves priority among eight active-low inputs, 10_L-17_L, where 10_L has the highest priority.

  Why are computer systems so vulnerable

Is security a technical issue? A business issue? Both? Support your answer. (Hint: Read Kim Nash, "Why Technology Isn't the Answer to Better Security,"CIO www cio com October 15, 2008.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd