Explore BrainMass

"What if" analysis: Notable Web Site Design

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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%.

© BrainMass Inc. brainmass.com October 25, 2018, 7:27 am ad1c9bdddf

Solution Summary

A what if analysis for a notable web site design is provided.

See Also This Related BrainMass Solution

Google Organizational and Industry Analysis Report

Describe and evaluate the effectiveness of Google's approach to business strategy; that is, how is Google creating a sustainable competitive advantage?

Describe Google's core products and business model?the basis upon which the firm makes money. Analyze the dual strategy that Google employs to execute its business model.

Review Google's mission statement and the values that are described in the case study. Analyze how Google applies the strategy and principle of options valuation to create share holder value.

Analyze how Google is competing. Conduct a high-level financial review.

Synthesize how the dual strategy is implemented in the user base, core market (search engine) and movement into adjacent technological areas.

Analyze Google's industry environment using Porter's Five Forces Model. Consider Grant's postulation of a sixth force. Identify the forces Google leverages to gain competitive advantage and/or alter the industry structure.
Identify and analyze Google's key resources and capabilities. Consider their core products and management capabilities. How does Google leverage its technical resources to achieve new product development leadership capability?

Articulate one or more strategic issues related to the degree to which Google has aligned its mission and capabilities to its business strategy and its ability to create a sustained competitive advantage.

Describe and evaluate the effectiveness of Google's corporate strategy-that is, where is Google focusing to sustain its competitive advantage?

Describe Google's organizational structure and management systems. Address how functions within the company are organized differently and identify the organizational theory that drives organizational design changes in response to industry changes.

Describe the basis of Google's competitive advantage. Explain the generic strategy (cost or differentiation or hybrid) that Google employs to achieve a competitive advantage.

Evaluate Google's corporate diversification strategy into new products and businesses.

Assess whether diversification creates value for Google shareholders; use Porter's three essential tests to evaluate:
- Video sharing (YouTube).
- Browsers (Chrome).
- Mobile phone operating systems (Android).

Articulate one or more strategic issues related to Google management's ability to coordinate organizational activities and/or corporate diversification into new products.

View Full Posting Details