"What if" analysis: Notable Web Site Design
Not what you're looking for?
Notable Web Site Design is one of the largest Web site design and Web site hosting companies in the Midwest. The company generates revenue from Web site design and selling Web site hosting space on their Web servers. A fixed percentage of the total net revenue is spent on administrative, equipment, marketing, payroll, and production expenses. A bonus is expensed if the total net revenue for the quarter exceeds $14,000,000. The company's projected receipts and expenditures for the next four quarters are shown in Table 3-20.
With this data, you have been asked to prepare a worksheet similar to Figure 3-87 on page
EX 210 for the next management team meeting. The worksheet should show total net revenues, total expenditures, and operating income for each quarterly period. Include a 3-D Pie chart on a separate sheet that shows the quarterly income contributions to the annual operating income.
What-If Analysis, Charting, and Working with Large Worksheets Excel Chapter 3 EX 223
During the meeting, one manager lobbied to reduce marketing expenditures by 1.25% and
payroll costs by 2.75%. Perform a what-if analysis reflecting the proposed changes in expenditures.
The changes should result in an operating income of $22,425,581 for the year. Using the original assumptions shown in Table 3-20, another manager asked to what extent marketing would have to be reduced to generate an annual operating income of $21,000,000. Marketing would to be reduced from 13.50% by 1.92% to 11.58%.
Purchase this Solution
Solution Summary
A what if analysis for a notable web site design is provided.
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.