I JUST NEED FORMULAS

PLEASE HELP

The Coco Lamela Compasy (CLC) owns the global rights to sell a very fraglle glass ornament called "Jack Wilshere's Tears". The cost of gpods sold for the ornaments are showa on the second page CIC seta lits selling prices so that each unit sold returns a seventy-five percent gross margin. Data regarding preduct costs, and administratlon and seling expenses for the paet twelve menths have been accumulated in onder develop a budget estimate for an upoeming month. Coco lamela's Marketing Department has reviewed this data and could not reach a conclution as to what is the most appropriate independeat vartable for predicting varlable and mixed costs. These costs magy be dependent on labor hours, unit sales, or distance shipped Marketing just doesn't know since they never had to take this accounting course. it is up to you to figure this out. REQTIRED: Note Please have the data from the second page of chit asignment and your work for Requirements A - C an a single warkahent. A. Get the information from the second page into your Excol workbook Analyze the data to determine the behavior of each cost. The variable and miked couts mag be dependent on labor hours, uait sales, er distance shipped. Use Excel's RSQ function to determine what the cost driver is for variable coeaponent of those costs that are variable or mitxed. Sa, you will have to nin the RsQ fuaction three timer for each of the costs. n. Mter the cost driver is determined for each of the mixed or variable coats you will noed to determine the cost elements using the Excel SH.OPE and INTERCEYT functions using that cost driver. C. Ne Coco Lanela Compary wasts to estimate prefitability for the upooiming month. The following estimates are to be usedt unit sales: 70,500 ; total labor boun worked: 93000 bours distance shipped: 322,000 miles First, prepare a Contribution Fermat lncoene Statement for the upcoming momth. Next, construct a Traditional focome Satement for the upconing month. Makir certain to present each cost/expense iten separately on iss own line - do not apgregente the costs. liggarding the seling price, this stould first be calculated on a per unit basis, thes use the Rouvo function to limit this amount to a whole dollar amount. D. For this portion of the assiegment you must first duplicate the worksheot for Requirenent C. Name this new tab "Hequirement Dr. Your goal in this part af the asigenenat is to did rot have Units Sold as their cost driver recalculate as if they did use Units as the Independect Varialle (cost driwer) ard determine the flared and variable cost components. The nent tep is to determine the CM and then calculate the flreak Piven Point in units. Make sure that this cell is Jabled and obvinas. Finally, update the Coetributiea Farmat inceene Sratemeot in Fatable cont DAwers \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Manth & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 \\ \hline \multicolumn{13}{|l|}{ Cait Driven: } \\ \hline \begin{tabular}{l} Ditsance \\ Shleped \end{tabular} & 225,000 & 420000 & 450,000 & 375,000 & 550,000 & 510,900 & 562,000 & 176,000 & 476,000 & 980,000 & 784,000 & 35,000 \\ \hline Labor Houss & 02,000 & 75,000 & 70,000 & 72,580 & 85,000 & 76,000 & $8,900 & 64,360 & 90,000 & 54,000 & 60,500 & 98,000 \\ \hline Units Sold & 15,000 & 17,500 & 38,000 & 34000 & 58,000 & 55,000 & 29,000 & 33,000 & 36,000 & 59,000 & 56,000 & 50,000 \\ \hline \begin{tabular}{l} ACTUNL MONT \\ (aSO) \end{tabular} & Ir costs & +8 & & 1= & & & & & & & & \\ \hline \begin{tabular}{l} Coit of \\ Coods Sold \end{tabular} & 500,000 & 1,050,000 & 1,064,000 & 952000 & 1.624,000 & 1,540,000 & 812000 & 934,000 & 1,004,000 & 1,652,000 & 1,561,000 & 1,400,000 \\ \hline Rovertanes & 1s3,7sa & 154375 & 154,500 & 153,500 & 159,500 & 158,750 & 152,250 & 153,250 & 154,000 & 159750 & 159,000 & 157,500 \\ \hline \begin{tabular}{l} Selling 8 \\ Commissiona \end{tabular} & 200,750 & 219,375 & 221,500 & 204.500 & 306,500 & 293,750 & 183,250 & 200,250 & 213,000 & 310,750 & 298,000 & 272500 \\ \hline Mernin Cord & 1,750,500 & 2,075,500 & 1,950,500 & 2,015,000 & 2,x25400 & 2,100,500 & 1,673,000 & 1,808,000 & 2,450,500 & 1,550,500 & 1.713 .000 & 2,650,500 \\ \hline Stivelise & 237,500 & 251,250 & 254000 & 232,000 & 364,000 & 347,500 & 204,500 & 226,500 & 243,000 & 369,500 & 353,000 & 120,000 \\ \hline cos & 371250 & 862,500 & 915,000= & rearso & 1000000 & 1,021,575 & 1,111,000 & 415,500 & 960,500 & 1,842,500 & 1,490,500 & 750,500 \\ \hline \end{tabular}