Managerial Acoounting - Spreadsheet Practice
Not what you're looking for?
Alexandra Patel, the manager of the food and Lodging division at Winter Wonderland, has hired you as a consultant to help her examine her division's performance under several different circumstances.
1. Type the following format into a spread sheet to compute the Food and Lodging Divisions's actual return on investment and residual income. Match your data entry to the rows and column shown in the attachment. Review Problem. (Hint: When entering the formulas, type = in front of the formula in the cell. Then the spreadsheet will know to compute the answer. Remember to format each cell for the type of numbers it holds, such as percentage, currency, or general.)
2. Patel would like to know how the figures would change if Food and Lodging desired ROI of 40 percent and average assets invested of $10,000,000. Revise your spreadsheet from 1 to compute the division's return on investment and residual income under those conditions.
3. Patel also wants to know how the figures would change if Food and Lodging had a desired ROI of 30 percent and average assets invested of $12,000,000. Revise your spreadsheet from 1 to compute the division's return on investment and residual income under those conditions.
4. Does the use of formatted spreadsheets simplify the computation of ROI and residual income? Do such spreadsheets make it easier to do "what-if" analyses?
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Operations Management
This quiz tests a student's knowledge about Operations Management