Purchase Solution

Microsoft Excel

Not what you're looking for?

Ask Custom Question

You are Sam Vestering, manager of North American Distribution for Worldwide Enterprises. You are preparing a projected distribution revenue schedule for Marquee Productions' latest films Two by Two, to be released February 14, 2003. Create a new workbook that will estimate Worldwide's projected revenue using the following information (see Figure E1-5):

A. Preview cities receive the film on the Friday before the general release date and pay Worldwide Enterprises 1.25% of projected box office revenues.

B. General release cities pay Worldwide Enterprises 1% of projected box office revenues.

C. All projections are paid in U.S. dollars.

D. Include a total of the projected revenue for Worldwide Enterprises. (Hint: You may want to create this workbook by grouping the preview cities and the general release cities separately.

Figure E1.5

City Release Category Projected Box Office Sales in Millions
New York Preview 22.5
Phoenix General 12.3
Los Angeles Preview 31.8
Denver Preview 18.3
Miami General 22.5
Des Moines General 11.2
Wichita Preview 10.6
Boston General 19.4
Philadelphia General 21.6
Fort Worth General 19.4
Milwaukee General 17.8
Vancouver General 12.4
Winnipeg General 10.1
Toronto Preview 17.5
Montreal Preview 15.8

2. Make any formatting changes you think would improve the appearance of the workbook.

Attachments
Purchase this Solution
Solution Preview

I've gone through your two documents and made some corrections to your spreadsheet. Some of the ...

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • Capabilities of Excel

    Microsoft Excel is a spreadsheet application available from the Microsoft Office suite of products. (Microsoft, 2011).

  • MS Excel and Quattro Pro Application

    It is usually bundled in Microsoft Office suite that also contains the famous word processing Microsoft Word and slide presentation editor Microsoft Powerpoint. The latest version of Microsoft Excel is the 2007 version.

  • Research software licensing in general

    This version offers every Office application: Microsoft Office Word 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, Microsoft Office Outlook 2007 with Business Contact Manager, Microsoft Office Access 2007, Microsoft Office Publisher

  • Hypothesis Tests in Excel

    TEST #2 -Extrinsic variable by Position Type -State the null and an alternate statement for the test -Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test.

  • Calculation of Descriptive Statistics using the Excel

    This solution is comprised of a detailed explanation of descriptive statistics using the Microsoft Excel.

  • Typical Seasonal Demand for Summer Highs

    Compute the standard deviation in Microsoft Excel using the data (raw data from years 1-4) 2. Generate a normal distribution of the data using Microsoft Excel. 3. Compare the range with the standard deviation of the data.

  • Antitrust claim against Microsoft

    The actions taken by Microsoft were required to excel in a competitive marketplace.

  • PERT, CPM, Gantt, Work Breakdown Structures

    Cost calculations can be used by utilizing Microsoft Excel. Cost analysis can be also done by utilizing Microsoft Excel.

  • Interview one in business or research who uses Microsoft

    491829 Using Microsoft Excel, Word and Powerpoint Please help with the following posting. Interview someone who works in business or research on the Internet about the use of Microsoft Excel, Word, and PowerPoint in their business.

  • Frequency Distribution and a Z-scores using Microsoft Excel

    368240 Generate a Frequency Distribution and a Z-scores using Microsoft Excel How to Generate a Frequency Distribution and a Z-scores using Microsoft Excel?

View More Related Solutions