Cookie Business Final Project Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to

Cookie Business Final Project

Now that your cookie business is well underway, you are going to use the knowledge that you have gained in this course to evaluate the financial information for the company. You will be creating a series of reports and analyzing the results using the templates provided to guide you through the project.

The learning objectives of this project are as follows:

Apply accounting concepts and standards to the creation of accounting information and reports.

Analyze accounting information used to make strategic business decisions.

Apply ethical behavior to accounting-related situations.

Make business decisions based on analyzing accounting data.

Using the Unit VII Final Project Template, prepare a four- to five-page written report (including spreadsheets) with at least three scholarly sources. Your report will provide the following information:

Introduction

Part 1: Based on the data presented in the Unit VII Spreadsheet Template in Excel (CM Breakeven tab):

Calculate the contribution margin (CM) for each of the three products sold at the cookie business.

Calculate the weighted average CM.

Calculate the breakeven point.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, etc.

Part 2: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Full Variable tab), complete the calculations listed below.

Calculate the value of ending inventory under full or absorption costing.

Calculate the value of ending inventory under variable costing.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results, and comment on which method you think is more helpful to managers and why.

Part 3: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Special Order tab), calculate the net increase or decrease in profit if they take the special order.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results and comment on if you think the cookie business should take on this special order of cookies for a wedding. Business has been slow the last few months, and the offer is less than the usual selling price for the cookies.

As part of your discussion, include both quantitative (based on the numbers) and qualitative (not based on numbers) factors that would go into the decision to take on the special order.

Part 4: Based on the data presented in the Unit VII Spreadsheet Template in Excel (IRR tab), calculate the internal rate of return (IRR) for the new equipment purchase.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Note: the PV Annuity table is provided for you. Discuss if you think the cookie business should accept or reject the purchase of the new equipment and why.

Additional information has come to your attention regarding the equipment purchase. One of the partner’s brother owns the company that sells the equipment and insists the equipment is needed. Discuss any ethical concerns you see with this type of transaction.

Part 5: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Cash Budget tab), calculate the cash receipts for the first quarter of this year.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.

Part 6: Based on the data presented in the Unit VII Spreadsheet Template in Excel (Variances tab), complete the following calculations.

Calculate the material variances.

Calculate the labor variances.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss your observations about the variances and ways to plan to improve any of the variances.

Conclusion and Recommendations

Summarize the key observations that you have made about the cookie business based on the calculations you have performed, and present any future recommendations.

Be sure to use APA formatting throughout, and reach out to the Writing Center or the Library for assistance with research, writing, and formatting. Include at least two resources from the CSU Online Library in your report.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Each student will submit a copy of his or her

 Each student will submit a copy of his or her resume and cover letter to the assignment area in BrightSpace. The goal of this assignment is to allow the student to begin preparing for their professional nursing career.  Grading will focus on the student’s ability to professionally present themselves. Please

6.3 Draft Industry Article You will build on the work

  6.3 Draft Industry Article You will build on the work that you started in your industry blog to craft an industry article. Key points for this assignment follow: Do not use the entire blog for your article – meaning it cannot simply be a cut & paste of the

  To prepare for this Assignment: Select an adult or older adult

  To prepare for this Assignment: Select an adult or older adult client with an obsessive-compulsive disorder you have seen in your practicum. In 3–4 pages, write a treatment plan for your client in which you do the following: Describe the HPI and clinical impression for the client. Recommend psychopharmacologic

Summarize the identified sources by creating a 3-5 minute PowerPoint®

Summarize the identified sources by creating a 3-5 minute PowerPoint® video presentation that highlights key events from the orgins of labor unions(1800s and prior).  Please be sure to speak to the following: Historical events that influenced unions and the labor movement during your specified time-frame Key figures that impacted the

This week, we further examined how to read scientific articles.

This week, we further examined how to read scientific articles. In addition, you should have a solid understanding of what constitutes experimental control (clearly established variables and a solid research question). MUST Read the article and USE ATTACHED ARTICLE. What is the purpose of the study? What is the independent

Numerous factors influence the five pricing strategies: premium, penetration, economy,

   Numerous factors influence the five pricing strategies: premium, penetration, economy, psychological, and promotional. Four critical criteria may influence the premium strategy’s selection. To begin, if the business wishes to imply superior quality. The resulting consumer perception might assist in elevating or maintaining the value of a premium brand. Second,

Apply research principles to the interpretation

Purpose This week’s graded topics relate to the following Course Outcomes (COs). CO 2: Apply research principles to the interpretation of the content of published research studies. (PO 4 & 8) CO 4: Evaluate published nursing research for credibility and significance related to evidence-based practice. (PO 4 & 8) CO

The four key users of financial statements are owners/managers, lenders,

 The four key users of financial statements are owners/managers, lenders, investors and governments. These users rely on financial statements to evaluate a company’s past financial performance as indicators in areas of profitability, liquidity, leverage, and efficiency; to create benchmarking matrixes; and to support future decision-making. Choose two companies in the

Survey Versus Questionnaire

Consider that while often regarded as synonymous, surveys and questionnaires are different types of instruments. What are the differences? Using the unit readings as well as resources available in the Capella library, locate one survey and one questionnaire that inquire about the same topic or subject matter, such as job

At each stage of development, culture can have a distinct

   At each stage of development, culture can have a distinct impact on basic aspects of life. Based on your reading thus far, describe how cultural influences impact development throughout the lifespan. Include the following aspects of life: Cognition (2-3 slides) Acceptance of cultural traditions (2-3 slides) Biological health (2-3 slides) Personality(2-3 slides)

The Golden Ratio is often denoted by the Greek letter

The Golden Ratio is often denoted by the Greek letter phi:  φ.  Its exact value is 1+5√2 which is approximately equal to 1.618. In this chapter, we saw how successive quotients of the Fibonacci Numbers get closer and closer to the Golden Ratio: 1/1=1, 2/1=2, 3/2=1.5, 5/3=1.67, 8/5=1.6, 13/8=1.625, 12/13=1.615, …