Our Services

Get 15% Discount on your First Order

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

November 30, 2024

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.

accounting

Share This Post

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

Related Questions

QUESTIONMar 02, 2019In your Fraud Examination Casebook with Documents textbook, read Case 1: Fraudulent Financial Statements (pp. 5-19). Perform Exercise 1

QUESTIONMar 02, 2019In your Fraud Examination Casebook with Documents textbook, read Case 1: Fraudulent Financial Statements (pp. 5-19). Perform Exercise 1 – Fraudulent Financial Statements (Larsen Convenience Store), In your Fraud Examination Casebook with Documents textbook, read Case 1: Fraudulent Financial Statements (pp. 5-19). Perform Exercise 1 – Fraudulent Financial Statements (Larsen Convenience

QUESTIONMar 02, 2019In your Fraud Examination Casebook with Documents textbook, read Case 1: Fraudulent Financial Statements (pp. 5-19). Perform Exercise 1

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at least 80% of the accounts receivable balance outstanding at December 31, 2016, has been resolved (e.g., collected, written off or returned). As of May 31, 2017,

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the assignment requirements. Note: P1 below is the abbreviation for Part 1 of the TechWear Case Study Assignment. The same abbreviation pertains for subsequent Modules, too. TechWear Case Study Parts I

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Evolutionary Analysis of Beak Size in Darwin’s Finches Data on galapagos bird beak size over time has provided important insights into the evolutionary

Evolutionary Analysis of Beak Size in Darwin’s Finches Data on galapagos bird beak size over time has provided important insights into the evolutionary dynamic’s of Darwin’s finches, a group of spices distinguished by their various beak shape and size. These finches, whi live on the Galapagos Island, shows extraordinary varity

Financial Overview and Break-Even Analysis of Bremend Ltd.Bremend Ltd is a maker of computer stands with unique financial characteristics that affect its

Financial Overview and Break-Even Analysis of Bremend Ltd.Bremend Ltd is a maker of computer stands with unique financial characteristics that affect its profitability. The company’s fixed costs are $500,000, regardless of production amount. Each computer stand sells for $120, with a variable cost of $70 per unit. This yields a

Assignment Type: Essay (any type) Service: Writing Words: 3 pages / 800 words (Double spacing) Education Level: Undergraduate Language: English

Assignment Type: Essay (any type) Service: Writing Words: 3 pages / 800 words (Double spacing) Education Level: Undergraduate Language: English (US) Assignment Topic: Accounting Tools and Techniques Subject: Accounting Sources: 4 sources required Citation Style: APA 6th edition Instructions: How does managerial accounting contribute to strategic decision-making in modern organizations, and why is

Data extractions are often difficult to read. So, convert the data extractions to a more understandable Excel schedule: Start with the data contained in

Data extractions are often difficult to read. So, convert the data extractions to a more understandable Excel schedule: Start with the data contained in the extraction labeled: Data Extraction 203 Tony Edits Download Data Extraction 203 Tony Edits(Jan Feb Mar 2016)

Title: Exploring Global Inequality through the Dollar Street Project. Word Count: The essay to consists of approximately 1,900-2,100 words. Formatting

Title: Exploring Global Inequality through the Dollar Street Project. Word Count: The essay to consists of approximately 1,900-2,100 words. Formatting Style: Font and Size: Times New Roman, 12-point font Headings and Subheadings: Bold for headings (e.g., Introduction, Visual and Quantitative Analysis, Socioeconomic Analysis, Conclusion) and italicized for subheadings (e.g., Low-Income

It seems like you’re asking about purchasing or obtaining an AASP license plate assignment. However, I need a bit more context to provide a precise answer.

It seems like you’re asking about purchasing or obtaining an AASP license plate assignment. However, I need a bit more context to provide a precise answer. Here are a few clarifications that might help: 1. **AASP**: Are you referring to a specific organization, agency, or program? If so, what does

Evaluating the Net Present Value (NPV) of Drug Abuse Sciences (DAS) Investment in a Cure for Drug and Alcohol Addiction Drug and alcohol addiction is a

Evaluating the Net Present Value (NPV) of Drug Abuse Sciences (DAS) Investment in a Cure for Drug and Alcohol Addiction Drug and alcohol addiction is a significant issue in the United States, with approximately 14 million Americans affected. The federal government estimates that these addictions cost the U.S. economy $300

ABC Manufacturing Co. is considering implementing a new production process that would require an initial investment of $500,000 in specialized equipment.

ABC Manufacturing Co. is considering implementing a new production process that would require an initial investment of $500,000 in specialized equipment. The equipment has an expected useful life of 5 years with no salvage value and would be depreciated using the straight-line method. The new process is expected to increase

Create a Strategic Plan for a Fire Dpartment: You are a newly promoted fire chief in the department you have began at the beginning of your professional

Create a Strategic Plan for a Fire Dpartment: You are a newly promoted fire chief in the department you have began at the beginning of your professional journey. Throughout the years you have seen many good ideas, met many great people, and generally, have had a great career. Society and emergency

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild”

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild” is a coming-of-age story, raising provocative questions about sex roles, self-sacrifice, colonization, and species- interdependence. How does this theme of the coming-of-age story function throughout the short story?

Academic Counseling Assessment Desuсrіption: Educational institutions are evaluated on student outcomes, especially academic achievement. As such, school

Academic Counseling Assessment Desuсrіption: Educational institutions are evaluated on student outcomes, especially academic achievement. As such, school counselors are tasked with supporting students in the area of academic development through the enhancement of knowledge, skills, and attitudes. The school counselor’s role in academic development focuses on fostering safe and inclusive learning

Our Services

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

Share This Post

Related Questions

QUESTIONMar 02, 2019In your Fraud Examination Casebook with Documents textbook, read Case 1: Fraudulent Financial Statements (pp. 5-19). Perform Exercise 1

QUESTIONMar 02, 2019In your Fraud Examination Casebook with Documents textbook, read Case 1: Fraudulent Financial Statements (pp. 5-19). Perform Exercise 1

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at

Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Evolutionary Analysis of Beak Size in Darwin’s Finches Data on galapagos bird beak size over time has provided important insights into the evolutionary

Financial Overview and Break-Even Analysis of Bremend Ltd.Bremend Ltd is a maker of computer stands with unique financial characteristics that affect its

Assignment Type: Essay (any type) Service: Writing Words: 3 pages / 800 words (Double spacing) Education Level: Undergraduate Language: English

Data extractions are often difficult to read. So, convert the data extractions to a more understandable Excel schedule: Start with the data contained in

Title: Exploring Global Inequality through the Dollar Street Project. Word Count: The essay to consists of approximately 1,900-2,100 words. Formatting

It seems like you’re asking about purchasing or obtaining an AASP license plate assignment. However, I need a bit more context to provide a precise answer.

Evaluating the Net Present Value (NPV) of Drug Abuse Sciences (DAS) Investment in a Cure for Drug and Alcohol Addiction Drug and alcohol addiction is a

ABC Manufacturing Co. is considering implementing a new production process that would require an initial investment of $500,000 in specialized equipment.

Create a Strategic Plan for a Fire Dpartment: You are a newly promoted fire chief in the department you have began at the beginning of your professional

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild”

Academic Counseling Assessment Desuсrіption: Educational institutions are evaluated on student outcomes, especially academic achievement. As such, school

Place Your Order Now!

Calculate the price of your order

Use Our 6 Free Tools