Business

1. (TCO 9, 2, 3, 7) You have worked for an electronics company for the past three years. You have been assigned the responsibility to create a workbook presenting profits and losses at the company's end of year meeting. It is critical for the workbook to include a documentation sheet along with sheets indicating profits and losses from four locations (i.e., Chicago, Dallas, Sacramento, and Tampa Bay). Given this information discuss your approach to address each question below. 

A - The final analysis includes profit and losses, What If analysis, and Scenarios. What types of recommendations could you provide in the documentation sheet based on this information?  Also, what approach could you use to summarize all four locations in one sheet?
B - You will need to customize the spreadsheet so organization is critical. What approach would you use to ensure the workbook is setup correctly for your presentation?
C - There are many ways to depict the yearly trends for each location. Please explain at least two types of charts you could use to present yearly profits and losses?
D - You have to rely on a few employees within the organization to complete your workbook. To do this the workbook has to be sent electronically to each employee. How would you protect the integrity of the formulas and structure if the workbook is sent to several employees to enter data? Also, what approach would you use to track the revisions sent by each employee.
(Points: 40)

  1. 👍 0
  2. 👎 0
  3. 👁 149
  1. It would appear that this is a test or part of exam. We do not DO the work for you but HELP when you ask specific questions.

    Here are some Business Tutorials you might like to bookmark:

    http://www.google.com/search?q=Business+Tutorials&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

    Sra

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. professional ethics in engineering

    Rachel works as a Quality Assurance Engineer at a large electronics company. She is responsible for the final testing of her company’s servers and is part of a team which decides when new products will be shipped to distributors

    asked by mohammed on April 4, 2018
  2. STATISTICS HELP!!!!!

    Bender Electronics buys keyboards for its computers from another company. The keyboards are received in shipments of 175 boxes, each box containing 30 keyboards. The quality control department at Bender Electronics first randomly

    asked by Jess on October 24, 2014
  3. Healthcare Finance

    Metropolis Health System has received a wellness grant from the charitable arm of an area electronics company. The grant will run for twenty-four months, beginning at the first of the next fiscal year. Two therapists and two

    asked by Brenda on July 18, 2012
  4. English

    Select the correct verb tense used in the sentences below That company has been making surfboards since the 1960's present perfect progressive present progressive*** past perfect progressive past progressive We had been listening

    asked by Morgan on May 20, 2016
  5. English

    1. Which mood is used in the following sentence? When will the tickets go on sale? a. indicative****** b. imperative c. conditional d. interrogative Please select the correct verb tense that is used in the sentences below. 2. That

    asked by girly girl on April 29, 2018
  1. Statistics

    Bender Electronics buys keyboards for its computers from another company. The keyboards are received in shipments of 75 boxes, each box containing 30 keyboards. The quality control department at Bender Electronics first randomly

    asked by Alli on October 24, 2014
  2. Statistics

    The manager of the customer service division of a consumer electronics company was interested in determining whether customers who had purchased a DVD player over the past 12 months were satisfied with their products. Using the

    asked by Patrice on October 27, 2012
  3. Programming

    Develop a Java application that will determine the gross pay for each of three employees. The company pays “straight line” for the first 40 hours worked by each employee and pays “time and a half” for all hours worked in

    asked by jm on November 9, 2016
  4. Math

    The following data give the number of keyboards assembled at the Twentieth century electronics company for a sample of 25 days. 45, 52, 48,41,56,46,44,42,48,53,51,53,51,48,46,43,52,50,54, 47,44,47,50,49,52 a.calculate the values

    asked by Marquita on October 12, 2017
  5. Physics

    A liter of water is used to cool some electronics. If 1000 J of heat is given off by the electronics, by what temperature does the water increase? One liter of water has a mass of 1 kg and a specific heat of 4.184 J/(g °C). I can

    asked by Sean on April 26, 2015
  6. Math

    An electronics store is selling personal CD players. The regular price for each CD player is $90. During a typical two weeks, the store sells 50 units. Past sales indicate that for every $1 decrease in price, the store sells five

    asked by Haseeb on April 12, 2020

You can view more similar questions or ask a new question.