Please include formulas!!! I will like your response! Thanks!

The Coco Lamela Company (CLC) owns the global rights to sell a very fragle glass ornament called "Jack Wileherria Tears". The cont of goode sold for the omaments are shown on the second page CLC sets its selling pricss so that each unit sold returns a seventy-flve percent grost margin. Data meaniling product costs, and atministratlan and selling expenses for the past twelve months have bees sccumulated in order develop a bodget estimate for an upcoming month. Coco lamela's Marketing Department has reviewed this data and could not reach a conchaslon as to what is the most appropriate independent variable for predicting variable and mixed costs. These costs may be dependent on labor hours, unit sales, or distance shlppedMarketing fust doesn't lonow since they never had to take this actounting course. It is up to you to flgure this out. Requires: Nore: Hanse have the data from the second page of thit asignment and your work for Requifmments A-C on a single worksthet. A. Get the information from the second page into your Exoel werlbook Analyze the data to deternine the behavior of each cost The variable and mixed costs mag he dependent on labor hours, unit sales, or distance shipped. Use Excel's RSQ function to determibe what the cost driver is for variable compenent of those costs that are variable or mixed. So, you will have to run the RSQ function three times for each of the costs. B. After the cost driver is determined for each of the mined or varlable costs you will aeed to determine the cost elements asing the Bxcel sLOPE and INTERCEPT functons using that cost drtver. C. The Gnce Lamela Company wants to estimate profitability for the upcoining moent. The following estimates are to be used: unit sales: 70,500 ; total labor hours vorked: 93,000 hoser, distance shipped: 322,000 milles Firs, prepare a Contritwation Format fncoime Statement far the upcoming month. Next, conatruct a Tradieional tnoome Statement for the upceming month. Male certain to present each cost/expense itemseparately on its ows line-do not aggiegate the costs. determise the Break- Eves-Point for the company and then prove it with a costribution format income statement. Delete the Thaditional incoene Statement from this tab's worksteet - you will only aeed the Costributias Format verilon for Requirement D, Next, for thase mixed or variable costa that this worksheet using your BEP usits as the variable cost driver. If done correctly the Net Operating Income should be sera. Naetble Cont Detwers \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Month & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 \\ \hline \multicolumn{13}{|l|}{ Cont Drwers: } \\ \hline \begin{tabular}{l} Distance \\ Shipped \end{tabular} & 425,000 & 420000 & 450,000 & 375.000 & 550,000 & 510,900 & 562,000 & 176,000 & 476,000 & 980,000 & 784,000 & 356,000 \\ \hline Labor Hours & 62,000 & 75,000 & 70,000 & 72,580 & $5,000 & 76,000 & 58,900 & 64,300 & 90,000 & 54,000 & 60,500 & 98,000 \\ \hline Units Sold & 35,000 & 37,500 & 38,000 & 14,000 & 5a,000 & 55,000 & 29,000 & 33,000 & 36,000 & 50000 & 56,000 & 50000 \\ \hline \end{tabular}