Develop and calculate the NPV on an Excel Spreadsheet for the “Option 2 Plan”

/in /by
QUESTION
NOV 12, 2022

Develop and calculate the NPV on an Excel Spreadsheet for the “Option 2 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as we

  1. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 2 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as well as in the ‘Helpful Hints’ section of this document.  Interpret the drivers of the NPV and the implications to the broader business decision. (40 points)

i.      For example, the variable costs for Amber Ale is $122.063 per unit

  1. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 3 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as well as in the ‘Helpful Hints’ section of this document.  Interpret the drivers of the NPV and the implications to the broader business decision. (40 points)

i.      For example, the variable costs for Amber Ale is $122.063 per unit

  1. Add a summary table that compares all three plans and shows all major cost categories. (20 points)
  2. Let us consider a form of sensitivity analysis for this problem. Chose a variable (interest rate and time period cannot be used) and explore the impact on your plans. This question has two parts: (20 points)

IntroductionPositionWeakness of the companyImplementation

/in /by

The below-attached file need to be done (Use the WIR method) IntroductionPositionWeakness of the companyImplementation or effects of the outcomeRecommendationsconclusion please explain each and ever

The below-attached file need to be done

(Use the WIR method)

  1. Introduction
  2. Position
  3. Weakness of the company
  4. Implementation  or effects of the outcome
  5. Recommendations
  6. conclusion

please explain each and every point

Note: Maximum page limit: 8 pages double spaced, excluding title page and references

The below-attached file need to be done (Use the WIR method) IntroductionPositionWeakness of the companyImplementation or effects of the outcomeRecommendationsconclusion please explain each and ever

The below-attached file need to be done

(Use the WIR method)

  1. Introduction
  2. Position
  3. Weakness of the company
  4. Implementation  or effects of the outcome
  5. Recommendations
  6. conclusion

please explain each and every point

Note: Maximum page limit: 8 pages double spaced, excluding title page and references

Topic 3 DQ1 Doctoral learners

/in /by

Please respond with at least 250 words citation and reference. to each question 1. Topic 3 DQ1 Doctoral learners must learn to evaluate the resources at their disposal and make informed decisions rega

Please respond with at least 250 words citation and reference. to each question

1.

Topic 3 DQ1

Doctoral learners must learn to evaluate the resources at their disposal and make informed decisions regarding the necessity of continued or associated study on a given topic. Evaluation of reading materials can be challenging, but a researcher should always start with peer reviewed publications as the foundation to any research project. Why is the peer review of academic literature important ? How is peer reviewed literature distinguished from other forms of literature? Why is this distinction important to doctoral level research?

2.

Topic 3 DQ2

My Topic for research is going to be Accounting.

This is your first class in your doctoral journey, but it is never too early have a conversation about what topic you would like to research. Some of you may have no idea of what you would like to explore, while others are absolutely certain you know exactly what you will be researching. In all likelihood, the specific topic that you are considering right now is not the topic you will ultimately research once you begin working with committee.

Finding a dissertation topic is much more than researching a topic with which you have an interest or passion. Your topic will originate as a very broad concept that will be narrowed to a specific topic as you read extensively the empirical research surrounding your concept. To justify a research project such as the dissertation, there must be not only a need for the research but also a space in the literature that the proposed research can fill.

When identifying a researchable topic, there are a few things that should be considered:

  • Is it interesting to you?
  • Is it interesting to anyone else?
  • Is it defined as a need in literature?
  • Is it original?
  • Is it feasible?
  • Is it within your range of competence?
  • Is it ethical?
  • Does it align with your program of study?

Whether a topic is feasible is an important consideration. In what ways, can you insure that your topic is feasible? How do you know when a topic needs to be narrowed to something more specific in order to be feasible? How does your proposed broad concept align with your program of study ? How will researching a topic based on your concept contribute to your field of study? Explain.

ACC 202 Milestone Three: Actual Costs and Revenue Data Appendix

/in /by

Need help with homework: I have completed everything except the “variances” tab. it most show the formulas in the excel worksheet.

ACC 202 Milestone Three: Actual Costs and Revenue Data AppendixAt the end of the first month of opening your business, you calculate the actual operating costs of the business and the income you earned. You also notice and document the difference in what you budgeted for certain materials and labor against the actual amounts you spent on the same.

For your statement of cost of goods sold, use the following data regarding the actual costs incurred by the business over the past month:

  • Materials purchased: $20,000
    • Consumed 80% of the purchased materials
  • Direct labor: $8,493
  • Overhead costs: $3,765

Note: Assume that the beginning materials and ending work in process are zero for the month.

Use the following revenue and cost information for the income statement. Note that the revenue you use will depend on the pricing level options you chose in Milestone Two. Also, assume that after accounting for weekends and other holidays, there were 20 business days in the first month of operation. For example, if you chose a sales price of $20 per collar, the actual number of collars sold in the month was 33 per day or 33 x 20 = 660 per month.

The other costs incurred by the business include:

  • General and administrative salaries
    • Receptionist: $1,950
  • Office supplies: $200
  • Other business equipment: $150

VarianceAt the end of the month, you find that the labor and materials spent on manufacturing collars was different from what you estimated:

  • The collar maker had to work nine hours a day instead of eight due to an increased demand for collars.
  • Because of the increased demand, the hourly rate you paid your employee for making the collars increased to $16.50.
  • An increase in the cost of raw material led the direct material cost per collar to increase to $10.
  • However, you also made and sold 60 more collars than you expected to sell in the month.

You now need to determine the variance in the materials and labor cost from what you estimated in Milestone Two based on the market research data.

2