Business

posted by .

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)

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Accounting

    Max Stevenson owns a local drug store. During the past few years, the economy has been experiencing a period of high inflation. Stevenson has had the policy of withdrawing cash from his business equal to 80% of the company's reported …
  2. Finance

    Innovation Company is thinking about marketing a new software product. Upfront cost to market and develop the product are $5 million. The product is expected to generate profits of $1 million per year for 10 years. The company will …
  3. computers

    Scenario: You have been employed as the IT Director for the ABC Company. The company comprises 15 employees and it has not upgraded its computer system since 1996. Project: The President of the Company has asked you to replace the …
  4. marketing

    Your team has been hired by ABC company’s senior management to conduct a research project. The company has 40 employees and has been in business for 25 years. The company offers sales & service on all sizes of new Xerox copiers. …
  5. business communication 1

    crystal agreed to serve on a company's advisory board and now has to contact them to say she cannot attend a scheduled meeting where she was to be one of the several key speakers. what should she do?
  6. operations management

    Best Wheels Bicycle Company is looking to automate production of a framing component and will need to purchase new frame fabrication machinery. The company has narrowed the selection to 2 machines that have a useful life of 3 years. …
  7. Business Communication

    Crystal agreed to serve on a company's advisory board and now has to contact them to say she cannot attend a scheduled meeting where she was to be one of several key speakers. What should she do?
  8. math

    From one year to the next the profits of Company a increased from $ 350,000 to $ 425,00 . During that same time period,Company B profits increased from $ 725,000 to $ 950,00 . How much more was company B percent in profits than company …
  9. business

    You have recently learned that the company where you work is being sold for $275,000. The company’s income statement indicates current profits of $10,000 which have yet to be paid out as dividends. Assuming the company will remain …
  10. finance

    Innovation Company is thinking about marketing a new software product. Upfront cost to market and develop the product are $5 million. The product is expected to generate profits of $1 million per year for 10 years. The company will …

More Similar Questions