Spreadsheet Project

This project will emphasize personal finance problems. All questions in the spreadsheet project should be answered in MyFinanceLab.

In addition to answering the Spreadsheet Project questions in MyFinanceLab, you will submit a spreadsheet showing your work. Each problem should be answered on a clearly labeled separate worksheet of a spreadsheet. Answers should be formatted in a manner that makes the answers clear and easy to read. Each of the following Excel functions should be used to calculate at least one of the answers: FV, PV, PMT, RATE, NPER, NPV, AVERAGE, STDEV, and IRR. Calculating the answers elsewhere and typing or pasting them into the spreadsheet is unacceptable. When turned in, the spreadsheet project should be a single file readable in Microsoft Excel

Fixed Costs Homework 06, business and finance homework help

Quiz

Question 1 (1 point)

 Question 1 Unsaved

Tory Company sells a single product. Troy estimates demand and costs at various activity levels as follows:

Units Sold Price Total Variable Costs Fixed Costs
120,000 $48 $3,000,000 $1,000,000
150,500 $45 $3,510,000 $1,000,000
160,000 $40 $4,000,000 $1,000,000
180,000 $35 $4,500,000 $1,000,000
200,000 $30 $5,000,000 $1,000,000

How much profit will Troy have if a price of $45 is charged?

Question 1 options:

Save

Question 2 (1 point)

 Question 2 Unsaved

The Falling Snow Company is considering production of a lighted world globe that the company would price at a markup of 0.25 above full cost. Management estimates that the variable cost of the globe will be $66 per unit and fixed costs per year will be $240,000.

Assuming sales of 1,200 units, what is the full selling price of a globe with a 0.25 markup?

Question 2 options:

Save

Question 3 (1 point)

 Question 3 Unsaved

A company believes it can sell 6,000,000 of its proposed new optical mouse at a price of $11.00 each. There will be $8,000,000 in fixed costs associated with the mouse. If the company desires to make a profit $2,000,000 on the mouse, what is the target variable cost per mouse?

Question 3 options:

Save

Question 4 (1 point)

 Question 4 Unsaved

Wizard Corporation has analyzed their customer and order handling data for the past year and has determined the following costs:

Order processing cost per order

 $7

Additional costs if order must be expedited (rushed)

 $10.00

Customer technical support calls (per call)

 $12

Relationship management costs (per customer per year)

 $1200

In addition to these costs, product costs amount to  75% of Sales.

In the prior year, Wizard had the following experience with one of its customers, Chester Company:

Sales

 $15,500

Number of orders

 160

Percent of orders marked rush

 70%

Calls to technical support

 80

Required:

Calculate the profitability of the Chester Company account.

Question 4 options:

Save

Question 5 (1 point)

 Question 5 Unsaved

When a firm adds a predetermined percentage to the cost of its product for pricing purposes, it is called:

Question 5 options:

demand pricing

cost-plus pricing

cost plus demand pricing

Save

Question 6 (1 point)

 Question 6 Unsaved

PowerDrive, Inc. produces a hard disk drive that sells for $175 per unit. The cost of producing 25,000 drives in the prior year was:
   
Direct material $625,000
Direct labor 375,000
Variable overhead 125,000
Fixed overhead 1,500,000
Total cost $2,625,000
At the start of the current year, the company received an order for 3,600 drives from a computer company in China. Management of PowerDrive has mixed feelings about the order. On the one hand they welcome the order because they currently have excess capacity. Also, this is the company’s first international order. On the other hand, the company in China is willing to pay only $135 per unit.
What will be the effect on profit of accepting the order?

Question 6 options:

Save

Question 7 (1 point)

 Question 7 Unsaved

Another name for menu-based pricing is:

Question 7 options:

Customer profitability pricing

Profit maximizing pricing

Activity-based pricing

Save

Question 8 (1 point)

 Question 8 Unsaved

A company has $45 per unit in variable costs and $1,200,000 per year in fixed costs. Demand is estimated to be 106,000 units annually. What is the price if a markup of 40% on total cost is used to determine the price?

Question 8 options:

Save

FIN 640 Milestone One

Can anyone help with the excel sheet and paper? Attached is grading rubric and the beginning of excel worksheet. Not sure if I did the first company correct or not?

First, visit Morningstar and other bond resources from the Module Three Reading and Resources area of your course to retrieve stock and bond
information for each of the following companies:
 Apple, Inc. (AAPL)
 Caterpillar (CAT)
 Consolidated Edison (ED)
 Northern Trust (NTRS)
 Macy’s (M)
Using the portfolio analysis template, provide the specified data to explain the company’s growth period (revenues, earnings market share, etc.).
Finally, in a 2- to 3-page paper, discuss the five-year history of each company by visiting the respective websites and databases covering the firm and industry.
The paper should briefly discuss the products and services produced by each company that were major contributors to the company’s success. It should also
discuss each company’s strengths given the competitive nature of the industry. Based on the financial items and key ratios of the company that you have
researched, include a brief discussion of the company’s valuation. (Hint: The Key Ratios on the Morningstar website list competition and industry ratios and
could be downloaded directly into Excel for easier comparison.) You should also identify the key stakeholders, particularly common stakeholders, in the
company.

short essay 250 words

Poem selections from Dien Cai Dau:

  1. “To Have Danced with Death”
  2. “Saigon Bar Girls, 1975”
  3. “‘Missing in Action”
  4. “Losses”
  5. “Facing It”

Purpose: To analyze race and violence in relationship to the Vietnam War in Dien Cai Dau

Skills/knowledge practiced: Textual analysis; close reading; writing with citations; use of textual evidence; developing argument; analysis of poetry and poetic language; following proper MLA formatting guidelines; paraphrasing quotes

Submission instructions: Please submit your 200-400 word response as a Word doc on Blackboard (no paper copies will be accepted). Every submission should include at least one quote from the text.

Grades will be based on the completeness of your submission (including textual quotes + sufficient word count length) as well as proper grammar/spelling and the depth of your critical analysis. Four points total:

  • 1 pt. for proper citation use;
  • 1 pt. for sufficient length;
  • 1 pt. for sufficient depth of content/engagement;
  • 1 pt. for proper assignment formatting.

Assignments should be formatted as follows: 12 pt. font, 1-inch margins, double-spaced with header, page numbers, Times New Roman font, Word Count listed, Works Cited page on separate page, submitted as Microsoft Word or PDF. This may seem like a lot but it is the golden standard for document preparation, and if properly followed will make your writing immediately more consistent and easier to read. See the following for an example: MLA Citation Template and Example.pdf

select a single poem above and analyze 2-3 of its poetic images. What does Komunyakaa’s imagery suggest about the particular nature of race and violence in the context of the Vietnam War? What insight does it give us regarding the international politics and racial ideology of the United States during that era?

Decision making is regarded as the cognitive process resulting in the selection of a belief or a course of action among several alternative possibilities

The best managers are always making decisions. Decision making is regarded as the cognitive process resulting in the selection of a belief or a course of action among several alternative possibilities. The process isn’t as easy as people think. Managers need to analyze each aspect before reaching a decision. Managerial decision making is one of the most critical processes in every organization. Successful and effective decision making has the potential for great benefit and great loss.

Overall, the decision-making process involves several important steps. Each step requires different tools and techniques.

The main steps in the decision-making process:

  1. problem identification
  2. information gathering
  3. analyzing the choices and brainstorming
  4. evaluation of the alternatives
  5. picking the best alternative
  6. executing the decision
  7. evaluating the results

Throughout the process managers must set a baseline to judge alternatives and decisions appropriately. The corporate culture and goals should also be considered along with ethical, societal, and legal aspects.

Exhibit 3.3 – The Phases of Decision Making states that the first phase is to identify and diagnose the problem and the second phase is to generate alternative solution.

For this forum, recall a decision you recently made at work and complete steps 1 – 6 in the phases of decision making (pg. 77).

Discussion: Study Question Proposal

Throughout this course, you will identify the steps in developing a research study. You will not be conducting the research or writing a full proposal; however, you will become familiar with the research process itself.

The research process contains many steps; the first is to identify a study question. Normally, a researcher will find a topic through personal or professional interest and direct it toward solving a problem. For the purpose of this course, you will select one of the topics presented below.

  • Childhood diabetes
  • Alcohol use in adolescents
  • Skin cancer in young women
  • Cardiovascular disease in the minority population
  • Long-term care for patients with Alzheimer’s disease
  • Cultural impact of posttraumatic stress disorder
  • Opioid crisis
  • Prescription drugs
  • Climate change
  • Breastfeeding

To prepare for this Discussion:

  • Select a topic to address from the list provided
  • Read Chapter 2 of your textbook on developing a study question
  • Read Chapter 1 of your textbook that deals with health research purposes
  • Navigate the AHRQ, CCPH, and RAND corporation websites in the Learning Resources to learn more about research and information specific to your chosen topic
  • Consider how you might develop a study question and move forward with the research process

By Day 4

Post a comprehensive response including the following:

  • A research topic written as a study question (See Chapter 2 in your textbook)
  • The purpose of the research, including how the project will further knowledge and extend theory (See the section Health Research Purposes in Chapter 1 of your textbook.)
  • Reason for selecting the topic (See Chapter 1 of your textbook.)
  • Define any terms that may have special meaning to the study itself (See the section Keywords in your textbook.)

Identify whether it exhibits the characteristics of Romanticism, Realism or Modernism, English homework help

Directions: Select one of the short stories from Module 3 that you did not already write about in Journal 6 and identify whether it exhibits the characteristics of Romanticism, Realism or Modernism. Describe how the story exemplifies that particular literary movement. Support your position with reference to at least two specific quotations or passages from the story. Required length: 300 – 400 words.

Readings and Resources

please see information below.

The subject of this paper is “The Energy Bar Industry” .

Conduct a thorough analysis of the energy bar industry’s customers, competitors, market, and environment from the perspective of PowerBar.

In particular, address the following issues:

a. How is the market segmented? What are the key customer motivations and unmet needs? What are the similarities and differences among the segments? How might a company link customer motivations to value propositions?

b. Identify the competitors. Who are the most direct competitors? The indirect competitors? Substitute products? What are the strategic groups?

c. Develop and justify a position on the issue of customer segmentation. What are the alternative views that may exist?

Deliverables and format:

Submit your answer in a Microsoft Word document.

Length: 5 pages

Font: Courier or New Times Roman: 12

Line Spacing: Double

cultural decision-making

This week’s discussion will focus on cultural decision-making using the case study “Brief Integrative Case 2.1: Coca-Cola in India” (p. 248) in International Management: Culture, Strategy, and Behavior.

This case focuses on the cultural differences of the U.S. company Coca- Cola and the country of India. In this situation, the people in the area around the Coca-Cola plant accused Coca-Cola of reducing the water levels, and more importantly, contaminating the water supply used for farming and personal consumption in their bottling process.

After reflecting on this situation involving cultural differences, as a leader, how might MNEs demonstrate their commitment to working with different countries like Saudi Arabia and respecting the cultural and natural environments of the country?

What types of decisions would you need to make? Would there be bias in the decision-making process? Can you give an example?

Direction

APA style

6-8 Paragraphs

2-3 references

Question Posted in below requirements

1. Identify what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding.

Also, provide a graduate-level response to each of the following questions:

a. California passes regulations that address pesticides. These regulations are much stricter on the use and production of pesticides than the federal regulations. Is this permissible under current law? What if California’s regulations are much less strict than the federal regulations?

b. Discuss the required elements of a valid contract analyzing when an agreement rises to the level of a legally enforceable contract and when it does not.

post should be at least 450+ words and in APA format (including Times New Roman with font size 12 and double spaced).

Please refer to this textbox: Jennings, M. M. (2017). Business: Its Legal, Ethical, and Global Environment (11th ed.). Cengage Learning

Note : no plagiarism please