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

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

1) Prepare the following consolidation and equity accounting entries for Purple Co. and its subseries and Associate for the year ended 31 December

1) Prepare the following consolidation and equity accounting entries for Purple Co. and its subseries and Associate for the year ended 31 December 20X5.                                                                 CJE1: Elimination of investment in Yellow Co.; Dr. share capital (Yellow Co.) $ 3,120,000 Dr. Retained Earnings (Yellow Co.) $ 3,510,000 Dr. Goodwill $ 1,560,000 Cr.

Handy Headphones is an Irish company that is manufacturing lightweight, flexible, Bluetooth[1] enabled and waterproof headphones. It is proving to be

Handy Headphones is an Irish company that is manufacturing lightweight, flexible, Bluetooth[1] enabled and waterproof headphones. It is proving to be very popular among people wanting to listen to music in the shower or while swimming on holiday or at community leisure centers lane swimming sessions (mainly because of their 159 price tag). Before the

Module 5: Discussion Forum In this week’s Required Readings from your course textbook, you have a specific and detailed example of hedging a forecasted for

Module 5: Discussion Forum In this week’s Required Readings from your course textbook, you have a specific and detailed example of hedging a forecasted foreign currency transaction to hedge an anticipated but not yet committed purchase of inventory using a foreign currency cash flow hedge (Case 3 on Pages 572-574) and hedging an unrecognized foreign

Hsjusbsbsbdhdhene

Hsjusbsbsbdhdhene sbsndndnjxjxjfkdjdjsisiiseiieiejrjdjiejeuieiejjeejgeygvwcwcwcxxqxfaajannsmsmsmsowlwbsvshsiwhejeowjsegheieududhtwiwowpwbwjeuebibjsiebuebeiebsuebwowbwiebeibsowbwo93hshshshhsbebsjsjshshdyehdhdhdrjrjdirbdjdjbdjdbejsebeiuwgdidhd8dbdbdjdbbdmmsjshejueusowowjw9qgwiehegeiehejeoejeiehe9ejejeheiehdidbsjduueehueehjeehsusjsienienbsgshduevgtwhwowpebdbjoabeheiwvueeksvejeenejdbuhdbeoe eiennejejejebsjisejeoejbdjdbebddonbsheeiejiejeijeje ejeieiehgeeiejeu9ewhe8hh

You should refer to the FASB Accounting Standards Codification (FASB ASC), specifically, when answering some of the questions below: For foreign-currency

You should refer to the FASB Accounting Standards Codification (FASB ASC), specifically, when answering some of the questions below: For foreign-currency related transactions, whether they are accounts receivable or accounts payable denominated in a foreign currency, describe briefly how such transactions are recorded and reported on the income statement when