Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Using Data Analytics to Determine Costs to Be Used in a Special-Order Analysis For this case, you will use selling price and cost data to determine if a special order from a customer should be accepte

Using Data Analytics to Determine Costs to Be Used in a Special-Order Analysis

For this case, you will use selling price and cost data to determine if a special order from a customer should be accepted. Donut House wants to examine if it should accept a special order by a customer to purchase a large order of donuts; however, the customer wants the donuts to contain the company’s logo, which will require an additional cost. 

Daily average unit selling prices and current unit costs to produce are provided. Unit costs vary depending on toppings and labor to produce even though all doughnuts are sold for the same unit price. Donuts with special toppings sell in approximately the same daily sales mix, and the special order will be sold in the same sales mix. As such, the company has decided to use average costs for the most recent month. Fixed costs are allocated to units based on direct labor costs. Demand for regular sales will not be affected if the special order is accepted. The average number of units sold each day does not differ significantly. 

Use the following template:

  • Module 3 CTA Excel File TemplateDownload Module 3 CTA Excel File Template

Requirements

Use the provided Excel file, which include the special order Information to perform the following:

  1. Determine the monthly average unit selling price, unit variable cost, unit allocated fixed, and average unit contribution margin.
  2. Prepare a special-order analysis using the average amounts as calculated in part 1.
  3. Should Donut House accept the special order based on your analysis? Explain why. Are there any qualitative considerations that Donut House should make prior to accepting the order? Be specific and creative in your answer here. It is important to recognize there are generally always qualitative and quantitative considerations making these types of decisions.

Submit the provided Excel spreadsheet containing your answers to each of the above requirements. Use Excel functions to make any required calculations described in the requirements. Post your completed Excel spreadsheet containing your answers for your instructor to grade.

Also, post a double-spaced Word file including your name, date, course number and information, and Question 3. above in bold type with your answer directly below the question. Include references if required to support your qualitative considerations analysis.

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