Using Data Analytics to Analyze Data $$ DA$5\mathrm{.}1$ Data analytics can be used to determine costs to be used in a special order analysis.$$ Problem$$ 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 units 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 of regular sales will not be affected if the special order is accepted. The average number of units sold each day does not differ significantly.$$ Special order information: $$ Number of donuts in the order $550$ Customer's desired unit price $$$$0\mathrm{.}85$ Expected unit logo cost $$$$0\mathrm{.}31$ Date Unit SP Average Unit VC Average Unit CM Average Allocated FC Unit Profit Margin $6/10\mathrm{.}9500\mathrm{.}4700\mathrm{.}4800\mathrm{.}1050\mathrm{.}3756/20\mathrm{.}9500\mathrm{.}4720\mathrm{.}4780\mathrm{.}1060\mathrm{.}3726/30\mathrm{.}9500\mathrm{.}4680\mathrm{.}4820\mathrm{.}1040\mathrm{.}3786/40\mathrm{.}9500\mathrm{.}4690\mathrm{.}4810\mathrm{.}1070\mathrm{.}3746/50\mathrm{.}9500\mathrm{.}4670\mathrm{.}4830\mathrm{.}1030\mathrm{.}3806/60\mathrm{.}9500\mathrm{.}4730\mathrm{.}4770\mathrm{.}1080\mathrm{.}3696/70\mathrm{.}9500\mathrm{.}4740\mathrm{.}4760\mathrm{.}1070\mathrm{.}3696/80\mathrm{.}9500\mathrm{.}4720\mathrm{.}4780\mathrm{.}1060\mathrm{.}3726/90\mathrm{.}9500\mathrm{.}4680\mathrm{.}4820\mathrm{.}1040\mathrm{.}3786/100\mathrm{.}9500\mathrm{.}4690\mathrm{.}4810\mathrm{.}1070\mathrm{.}3746/110\mathrm{.}9500\mathrm{.}4670\mathrm{.}4830\mathrm{.}1030\mathrm{.}3806/120\mathrm{.}9500\mathrm{.}4740\mathrm{.}4760\mathrm{.}1040\mathrm{.}3726/130\mathrm{.}9500\mathrm{.}4720\mathrm{.}4780\mathrm{.}1070\mathrm{.}3716/140\mathrm{.}9500\mathrm{.}4680\mathrm{.}4820\mathrm{.}1080\mathrm{.}3746/150\mathrm{.}9500\mathrm{.}4680\mathrm{.}4820\mathrm{.}1030\mathrm{.}3796/160\mathrm{.}9500\mathrm{.}4680\mathrm{.}4820\mathrm{.}1000\mathrm{.}3826/170\mathrm{.}9500\mathrm{.}4690\mathrm{.}4810\mathrm{.}1030\mathrm{.}3786/180\mathrm{.}9500\mathrm{.}4670\mathrm{.}4830\mathrm{.}1010\mathrm{.}3826/190\mathrm{.}9500\mathrm{.}4730\mathrm{.}4770\mathrm{.}1040\mathrm{.}3736/200\mathrm{.}9500\mathrm{.}4740\mathrm{.}4760\mathrm{.}1030\mathrm{.}3736/210\mathrm{.}9500\mathrm{.}4690\mathrm{.}4810\mathrm{.}1080\mathrm{.}3736/220\mathrm{.}9500\mathrm{.}4670\mathrm{.}4830\mathrm{.}1070\mathrm{.}3766/230\mathrm{.}9500\mathrm{.}4690\mathrm{.}4810\mathrm{.}1030\mathrm{.}3786/240\mathrm{.}9500\mathrm{.}4670\mathrm{.}4830\mathrm{.}1080\mathrm{.}3756/250\mathrm{.}9500\mathrm{.}4640\mathrm{.}4860\mathrm{.}1070\mathrm{.}3796/260\mathrm{.}9500\mathrm{.}4650\mathrm{.}4850\mathrm{.}1020\mathrm{.}3836/270\mathrm{.}9500\mathrm{.}4740\mathrm{.}4760\mathrm{.}1050\mathrm{.}3716/280\mathrm{.}9500\mathrm{.}4760\mathrm{.}4740\mathrm{.}1060\mathrm{.}3686/290\mathrm{.}9500\mathrm{.}4850\mathrm{.}4650\mathrm{.}1080\mathrm{.}3576/300\mathrm{.}9500\mathrm{.}4660\mathrm{.}4840\mathrm{.}1020\mathrm{.}382$ Instructions: $$ There are three parts to this problem. Use Excel to perform the following: a$.$ Determine the monthly average unit selling price, unit variable cost, unit allocated fixed, and average unit contribution margin.$$ b$.$ Prepare a special order analysis using the average amounts as calculated in part a$.$ c$.$ 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?