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:

Determine the monthly average unit selling price, unit variable cost, unit allocated fixed, and average unit contribution margin.
Prepare a special-order analysis using the average amounts as calculated in part 1.
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

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

Related Questions

Option #2: Fraud Risk Brainstorming at Tesla Read the following case study: Hess, M. F., & Andiola, L. M. (2018). Fraud risk brainstorming at Tesla Motors.Links to an external site.. Issues in Acc

Option #2: Fraud Risk Brainstorming at Tesla Read the following case study: Hess, M. F., & Andiola, L. M. (2018). Fraud risk brainstorming at Tesla Motors.Links to an external site.. Issues in Accounting Education, 33(2), 19–34. Case Requirements: Answer the following questions as a Presentation. Fraud risks related to revenue recognition at

The Association of Certified Fraud Examiners (ACFE) has excellent resources including: white papers from industry-leading companies on emerging trends in the fraud industry, tips to stay ahead of frau

The Association of Certified Fraud Examiners (ACFE) has excellent resources including: white papers from industry-leading companies on emerging trends in the fraud industry, tips to stay ahead of fraudsters, and industry-specific strategies to stay current in the forensic accounting and fraud examination professions. Review the free white papers from the ACFELinks to

Liabilities Our textbook tells us that liabilities are obligations of the entity or as defined by the FASB, “probable future sacrifices of economic benefits arising from present obligations of a parti

Liabilities Our textbook tells us that liabilities are obligations of the entity or as defined by the FASB, “probable future sacrifices of economic benefits arising from present obligations of a particular entity to transfer assets or provide services to other entities in the future as a result of past transactions

Using Excel, and using Excel functions and formulas to perform all necessary calculations, provide answers to items A, B, and C in the exercise. Submissions with only numbers and no formulas or functi

Using Excel, and using Excel functions and formulas to perform all necessary calculations, provide answers to items A, B, and C in the exercise. Submissions with only numbers and no formulas or functions will not receive credit for this assignment. Your submission must be neatly organized and must clearly present

Final Project Assignment InstructionsScenario Background: A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to

Final Project Assignment InstructionsScenario Background: A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on wh

Prepare either a 3–4 page report or a 12-slide presentation in which you analyze financial information and risks associated with an investment to expand an organization and make a recommendation on whether or not to invest in expansion. Collapse AllIntroduction This portfolio work project will help you to not only

In your course textbook, specifically in Chapter 10, page 10-33, read Exercise 28, Dexter Manufacturing In an appropriate level of detail, answer items 1 and 2 below. Required: Answer the following qu

In your course textbook, specifically in Chapter 10, page 10-33, read Exercise 28, Dexter Manufacturing In an appropriate level of detail, answer items 1 and 2 below. Required: Answer the following questions: How much in losses do you believe Dexter may have experienced on the current contract so far? How much more in

Selected Accounting Standard – Intangibles – Goodwill and other Crypto Assets (Subtopic 350-60) – crypto assets (ASU 2023-08) Select a converged, revised, or new accounting standard from the Financial

Selected Accounting Standard – Intangibles – Goodwill and other Crypto Assets (Subtopic 350-60) – crypto assets (ASU 2023-08) Select a converged, revised, or new accounting standard from the Financial Accounting Board (FASB) that has been issued within the last three years and that is of interest to you. Refer to

Option #2: Toshiba’s Creative Accounting for Construction Contracts Read the following case study: Dugar, A., Gujarathi, M. R. (2018). Toshiba’s creative accounting for construction contracts.Links to

Option #2: Toshiba’s Creative Accounting for Construction Contracts Read the following case study: Dugar, A., Gujarathi, M. R. (2018). Toshiba’s creative accounting for construction contracts.Links to an external site.. Issues in Accounting Education, 33(3), 117–134. Case Requirements: The FASB and the IASB have issued a joint standard on revenue recognition. Although the

Acme-Aviation Case Study In your course textbook, read Exercise 24, Acme-Aviation (AA) in Chapter 10, page 10-30. Then answer the following questions. You are an expert who has been hired by Acme Avia

Acme-Aviation Case Study In your course textbook, read Exercise 24, Acme-Aviation (AA) in Chapter 10, page 10-30. Then answer the following questions. You are an expert who has been hired by Acme Aviation to develop a damages estimate for them that you will defend in deposition and at trial, if necessary. Using

Conduct an Internet search for information on internal control and Sarbanes-Oxley Act. Discuss some of the advantages and disadvantages of the Sarbanes-Oxley Act. Include at least 5 Scholarly/peer rev

Conduct an Internet search for information on internal control and Sarbanes-Oxley Act. Discuss some of the advantages and disadvantages of the Sarbanes-Oxley Act. Include at least 5 Scholarly/peer reviewed APA citation and References.

Aurora Electric Case Study Aurora Electric has a contract with an agency of the Federal Government to provide electrical power to the agency for a five-year period. The contract stipulates, in part, t

Aurora Electric Case Study Aurora Electric has a contract with an agency of the Federal Government to provide electrical power to the agency for a five-year period. The contract stipulates, in part, that the power will be provided ‘at the lowest reasonable cost without compromising safety.’ In connection with this

Within the attached files, one contains the instructions and the other contains the excel template to complete it. I will do my best to answer any questions.

Case Study: Auditor at SM&AHere’s the role you are playing in this Case Study: You graduated from CSU Global with a Master of Professional Accounting degree. You earned your CPA credential from th

Case Study: Auditor at SM&AHere’s the role you are playing in this Case Study: You graduated from CSU Global with a Master of Professional Accounting degree. You earned your CPA credential from the state of Oklahoma; you applied and were accepted by the AICPA. After working in the field for

The Montana Movie Theater Company Case Study The Montana Movie Theatre Company (Montana) operates movie theaters in 15 different towns throughout Western Montana, including in Missoula, a city of 60,0

The Montana Movie Theater Company Case Study The Montana Movie Theatre Company (Montana) operates movie theaters in 15 different towns throughout Western Montana, including in Missoula, a city of 60,000 people with a major State University. Missoula, Montana, owns and operates five different movie theaters with a total of 38

The Montana Movie Theater Company Case Study The Montana Movie Theatre Company (Montana) operates movie theaters in 15 different towns throughout Western Montana, including in Missoula, a city of 60,0

Within the attached files, one contains the instructions and the other contains the excel template to complete it. I will do my best to answer any questions.