# Chapter 7

Satisfactory Essays
What-If Analysis

Project Description:
In the following project, you will perform What-IF Analysis to calculate budget information for your University’s Valentine’s Day formal.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
2 Use Goal Seek to achieve a \$0 balance by changing the ticket price per person. 6
3 Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E 3
4 Enter references to the total income, total expenses, and balance formulas in that order for a one-variable data table in Cell F2, Cell G2, Cell H2 respectively. 3
5 Apply custom number formats to make the formula references appear as the following: F2- Revenue, G2 – Expenses, H2 – Balance. 3
6 Create a one-variable data table for the range E2:H18 using the number of attendees as the Column input cell. Format the results with Accounting Number Format with two decimal places. 7
7 Copy the number of attendees substitution values from the one-variable data table, and then paste the values starting in cell E22. 4
8 Type \$50 in cell F21 and complete the series of substitution values from \$50 to \$100 at \$10 increments. 2
9 Enter the reference to the balance formula (C34) in the Cell E21 for a two variable data table, then complete the table using cell B9 as the row input cell and B4 as the column input cell. Format the results with Accounting Number Format with two decimal places. 7

## You May Also Find These Documents Helpful

• Satisfactory Essays

Chapter Seven Customer‐Driven Marketing Strategy: Creating Value for Target Customers Chapter 7- slide 1 Customer-Driven Marketing Strategy: Creating Value for Target Customers Topic Outline • Market Segmentation • Market Targeting • Differentiation and Positioning Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall Chapter 7- slide 2 Market Segmentation Market segmentation is the process that companies use to divide large heterogeneous markets into small markets…

• 1293 Words
• 6 Pages
Satisfactory Essays
• Good Essays

Managerial Accounting, Spring 2013 Read chapter 7, complete the following which are DUE March 3, 2013 Complete all Questions as marked on page 301 (7-1 through 7-10). Also the following problems sets should be completed in excel. Chapter 7, (page 308) Problem 7-9 Questions 7-1 In what fundamental ways does activity-based costing differ from traditional costing methods such as job-order costing as described in Chapter 3? a) Nonmanufacturing as well as manufacturing costs may be assigned to…

• 1066 Words
• 5 Pages
Good Essays
• Good Essays

Chapter 7 Business Ethics Fundamentals LEARNING OUTCOMES After studying this chapter, you should be able to: 1. Describe how the public regards business ethics. 2. Define business ethics and appreciate the complexities of making ethical judgments. 3. Explain the conventional approach to business ethics. 4. Analyze economic, legal, and ethical aspects by using a Venn model. 5. Enumerate and discuss the four important ethics questions. 6. Identify and explain three models of management…

• 2285 Words
• 10 Pages
Good Essays
• Powerful Essays

1. Which of the following statements is CORRECT?a. The constant growth model takes into consideration the capitalgains investors expect to earn on a stock.STATEMENT A is true because the expected growth rate is also the expected capitalgains yield.b. Two firms with the same expected dividend and growth rates must alsohave the same stockprice.c. It is appropriate to use the constant growth model to estimate a stock 'svalue even if itsgrowth rate is never expected to become constant.d. If a stock has…

• 1492 Words
• 6 Pages
Powerful Essays
• Good Essays

Chapter 7 1.Identify the reason for conducting marketing research. Marketing research is the process of defining a marketing problem and opportunity, systematically collecting and analyzing information, and recommending actions. Marketer conduct marketing research to reduce the risk of and thereby improve marketing decision, also, it can be used to help a firm develop its sales forecasts. Marketing research must overcome many difficulties and obtain the information needed so that marketers…

• 880 Words
• 3 Pages
Good Essays
• Satisfactory Essays

Chapter 7 Australia’s Healthcare System 1. Summarise the five primary responsibilities of the federal government with regards to the health system. -The management and funding of Medicare -The management and funding of the pharmaceuticals Benefit Scheme (PBS) -The regulation of private health insurance -The development and regulation of health policy and legislation -The management of national health programs 2. a. Define Medicare. - Medicare is Australia's universal health insurance scheme…

• 430 Words
• 2 Pages
Satisfactory Essays
• Good Essays

Chapter 7 David Connor 1. The ____________ motor is the most common motor used in hermetically sealed units. a. Capacitor-start, induction run b. Repulsion-start, induction run c. Induction run d. Induction run two phase and polyphase 2. Of the four listed motors, which is the most commonly used on external drive, belt driven compressors? e. Induction two-phase and polyphase.…

• 533 Words
• 3 Pages
Good Essays
• Powerful Essays

CHAPTER 7 The Summary of Findings, Conclusions and Recommendation Based on the information presented in this feasibility study, it is recommended that the oyster mushroom chips business be pursued. The findings of this feasibility study show that the proposed business did not suffer any losses in the first four years of their operations. Summary of Findings This part summarizes the findings that were garnered in the whole duration of the feasibility study. The Marketing Aspect 1. The business…

• 2042 Words
• 6 Pages
Powerful Essays
• Satisfactory Essays

Woodly Biennescar Chapter 7 Interpret the role of electrons, electron carriers, and ATP in energy metabolism Electron carriers are used for soluble that moves electron from one molecule to another. Electron aids in the gradual, stepwise release of the energy from oxidation, rather than rapid combustion. ATP power the activities that requires work --- one of the most which is movement. Explain the purpose of oxygen in respiration Without oxygen, cellular respiration could not occur because oxygen…

• 594 Words
• 2 Pages
Satisfactory Essays
• Good Essays

CHAPTER 7 THE VALUATION AND CHARACTERISTICS OF BONDS PROBLEMS Assume all bonds pay interest semiannually. Finding the Price of a Bond – Example 7.1 (page 306) 1. The Altoona Company issued a 25-year bond 5 years ago with a face value of \$1,000. The bond pays interest semiannually at a 10% annual rate. a. What is the bond's price today if the interest rate on comparable new issues is 12%? b. What is the price today if the interest rate is 8%? c. Explain the results…

• 8505 Words
• 35 Pages
Good Essays