Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Cookie Business Final Project Assignment objective: 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 inf

Cookie Business Final Project

Assignment objective: 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.

  1. Analyze accounting information used to make strategic business decisions.
  2. Apply ethical behavior to accounting-related situations.
  3. Make business decisions based on analyzing accounting data.

Length: Using the Unit VII Final Project Template, prepare a eight- to twelve-page written report (including spreadsheets).

References: A minimum of 3 peer-reviewed references are required, any additional resources used are required to be scholarly/academic in nature and found in the CSU Library. APA formatting is required be used for citations and references. Use this definition to define the term in the instructions. 

Definitions: Scholarly journals are sometimes called academic journals. The terms are often used interchangeably to describe the same type of publication. These types of publications are published by universities, academic institutions, professional associations, and commercial enterprises and are compiled by scholars, academics, and other subject authorities.

Details: 

First, start the paper with an abstract and introduction section per the assignment template provided above.

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.

End this paper with the key observations and present any future recommendations.

Submission: Save the submission as a Word document and upload the document to Blackboard.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of th

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of the file. Worksheet Problem 1 Gulf Coast Paddle produces paddleboards for retailers in the United States. The cost of

Therapeutic Meal Plan Presentation for Gastrointestinal Disorders NRG275 – NutritionAssignment Title: Therapeutic Meal Plan Presentation for Gastrointestinal DisordersDue Date: [Insert Date]Submission

Therapeutic Meal Plan Presentation for Gastrointestinal Disorders NRG275 – NutritionAssignment Title: Therapeutic Meal Plan Presentation for Gastrointestinal DisordersDue Date: [Insert Date]Submission Format: PowerPoint Presentation (.pptx or .pdf) Dear Students, You are required to create a PowerPoint presentation on therapeutic meal planning for gastrointestinal (GI) disorders. This assignment is designed to

Module 4 – SLPEthics and TrendsAssignment OverviewEthical Dilemma Understanding how to address ethical dilemmas in accounting, even if you’re not in the accounting department, is important for organiz

Module 4 – SLPEthics and TrendsAssignment OverviewEthical Dilemma Understanding how to address ethical dilemmas in accounting, even if you’re not in the accounting department, is important for organizational integrity. It ensures compliance, fosters transparency, and protects the company from legal and reputational risks. Ethical awareness supports responsible decision-making across all

Module 4 – CaseEthics and TrendsAssignment OverviewTrends The evolving role of AI in accounting automates tasks, reduces errors, and enhances decision-making, allowing non-accounting professionals to

Module 4 – CaseEthics and TrendsAssignment OverviewTrends The evolving role of AI in accounting automates tasks, reduces errors, and enhances decision-making, allowing non-accounting professionals to focus on strategic business activities. Big data enables faster, more accurate financial decisions, helping professionals interpret trends and optimize resource use. At the same time,

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and present a recommendation to help leadership make a loan decision. Collapse AllIntroduction This portfolio work project will

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real WorldA commodity is the focus of this case which uses real data for price fluctuations over 6 months. You

Module 1 – CaseEquilibrium, Supply and DemandAssignment Overview Supply and Demand in the Real WorldA commodity is the focus of this case which uses real data for price fluctuations over 6 months. You will research reasons for the changes and develop a multifaceted economic analysis. Case 1 Resources Introduction to

Coronado comlany produces 2 products, flower and planter. flower is a high-volume item totaling 20000 units annually. planter is low-volume item totalling only 6000 unites per year. flower requires 1

Coronado comlany produces 2 products, flower and planter. flower is a high-volume item totaling 20000 units annually. planter is low-volume item totalling only 6000 unites per year. flower requires 1 hour of direct labor for completion, while each unit of planter requires 2 hours. Therefore, total annual direct labor hours

Module 3 – CaseTransfer Pricing and Responsibility CentersAssignment OverviewTransfer Pricing In recent years, high-profile cases involving companies like Apple (Ireland, 2016), Amazon (Luxembourg. 20

Module 3 – CaseTransfer Pricing and Responsibility CentersAssignment OverviewTransfer Pricing In recent years, high-profile cases involving companies like Apple (Ireland, 2016), Amazon (Luxembourg. 2017), and Starbucks (UK, 2012) have highlighted the risks of using aggressive transfer pricing to minimize taxes. These companies faced public backlash and government scrutiny for shifting

Module 3 – SLPTransfer Pricing and Responsibility CentersAssignment OverviewBlock Chain Blockchain enhances financial transactions by providing transparent, secure, and immutable records, reducing in

Module 3 – SLPTransfer Pricing and Responsibility CentersAssignment OverviewBlock Chain  Blockchain enhances financial transactions by providing transparent, secure, and immutable records, reducing intermediaries and fraud risk. In accounting, it automates auditing, reduces errors, and increases transparency with real-time, tamper-proof data. Blockchain also plays a critical role in preventing financial fraud

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of th

Incremental Analysis Download the Unit VI Assignment Excel worksheet and complete the following problems on the worksheets. Each problem is designated by a worksheet in the tabs at the bottom of the file. Worksheet Problem 1 Gulf Coast Paddle produces paddleboards for retailers in the United States. The cost of

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting hel

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting help aid associations make tough choices in Haiti?Links to an external site. Issues in Accounting Education, 33(1), 17–28. Answer the following questions:

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting hel

Option #2: Can Management Accounting Help Aid Associations Make Tough Choices in Haiti?Read the following Case Study: Krumwiede, K. R., Paik, G. H., Walden, W. D. (2018). Can management accounting help aid associations make tough choices in Haiti?Links to an external site. Issues in Accounting Education, 33(1), 17–28. Answer the following questions:

Professional judgment frameworkAccounting for income taxes—valuation allowanceBackground Asbat Pharmaceuticals (Asbat) is a leading pharmaceutical company that has been in existence for 22 years. Asba

Professional judgment frameworkAccounting for income taxes—valuation allowanceBackground Asbat Pharmaceuticals (Asbat) is a leading pharmaceutical company that has been in existence for 22 years. Asbat has a calendar year-end and is audited annually. Asbat only operates in the United States and is not subject to state or local income taxation. Its