COCO LAMELA COMPANY Excel Assignment 33 The Coco Lamela Company (CC) was the global rights to sell a very fragile glass orament called "Jack Wilshere's Tears. The cost of goods sold for the names are shown on the second page. CLC sets its selling prices so that each uit sold returns a seventy-five percent gross marginha regarding productos, and a n d singepenses for the past twelve me here been accumulated in order develop a budget estimate for an upcoming month Coco La Mar Departamen t and could not reach condusion is to what is the most appropriate independent variable for predictinvariable and cost. The dependim o hou ni e die lipped- Marketing just 't know since they had to take this co m pte you to figure this out REQUIRID: A Get the information from the second page into your Excel workbook Analyze the data to determine the behavior of each cost you will determine what is the cost driver for those costs that are wartable and/or mixed. These come he dependent labor hours need to use Excel's RSQ functions ancesped e will B Once the cost driver is determined for each of the mind or w included in same way wed for requirement to the the SLOPE INTERCEPT functions. This can be 7.000 C The Coce Lamela Company was to estimate profitability for the upcoming month The following estimates are to be u ses 600 Whor hours word hours distances First, prepare a proforma corbution Form Start for the upcoming mo Next, constructa Traditional Income Statement for the upcoming month Make ceruin sentos pense l y on line de hosts Regarding the price this should it be calculated on with the the ROUNDunction limit this Law the not Law t he Tom from D. With Caca Lamela Company is head in the USA and conduct business indian (USD, the principe the company able to its investors Coco Lamela presents its financial information both in USD and British pound (GBP Ga http://www.ne.com/e m bed/ the the 19,2020 d . Do you wanted the factor into your spread the ROUND function to tha Using the proforma incomments that you could fe requirement as your input, c h i t p the fourth dem s GP and the sales amount on the b e was a whole number you some E sper there that will win the input You mustuse Ece for this case. All non-input cells will either reference another color bea calculated formulacemathers income statement as a " cy. Any variablecement that you discovers to be displayed to the decimal placm y com The amounts in the income statements shall be displayed in whole numbers. The purpose of this to force the c o st Rumber that by d o wn you create your out. Whether you were data that cand. Make a b anda tocat Use non ranges in your det section for the cost drivers and was whenever posle This worth t he While there you wan the your work Make sure to see who who who you that this completely Labour . 15.000 20000 95.000 1012. 10 91 COAS E OS 920 Advertising Seling & Commons 185.000 195.000 200/400 LUSSO 1. 16161 162 350 000 Packaging Expenses Shippinguperses 5000 45.000 445.000 . 005120539000 COCO LAMELA COMPANY Excel Assignment 33 The Coco Lamela Company (CC) was the global rights to sell a very fragile glass orament called "Jack Wilshere's Tears. The cost of goods sold for the names are shown on the second page. CLC sets its selling prices so that each uit sold returns a seventy-five percent gross marginha regarding productos, and a n d singepenses for the past twelve me here been accumulated in order develop a budget estimate for an upcoming month Coco La Mar Departamen t and could not reach condusion is to what is the most appropriate independent variable for predictinvariable and cost. The dependim o hou ni e die lipped- Marketing just 't know since they had to take this co m pte you to figure this out REQUIRID: A Get the information from the second page into your Excel workbook Analyze the data to determine the behavior of each cost you will determine what is the cost driver for those costs that are wartable and/or mixed. These come he dependent labor hours need to use Excel's RSQ functions ancesped e will B Once the cost driver is determined for each of the mind or w included in same way wed for requirement to the the SLOPE INTERCEPT functions. This can be 7.000 C The Coce Lamela Company was to estimate profitability for the upcoming month The following estimates are to be u ses 600 Whor hours word hours distances First, prepare a proforma corbution Form Start for the upcoming mo Next, constructa Traditional Income Statement for the upcoming month Make ceruin sentos pense l y on line de hosts Regarding the price this should it be calculated on with the the ROUNDunction limit this Law the not Law t he Tom from D. With Caca Lamela Company is head in the USA and conduct business indian (USD, the principe the company able to its investors Coco Lamela presents its financial information both in USD and British pound (GBP Ga http://www.ne.com/e m bed/ the the 19,2020 d . Do you wanted the factor into your spread the ROUND function to tha Using the proforma incomments that you could fe requirement as your input, c h i t p the fourth dem s GP and the sales amount on the b e was a whole number you some E sper there that will win the input You mustuse Ece for this case. All non-input cells will either reference another color bea calculated formulacemathers income statement as a " cy. Any variablecement that you discovers to be displayed to the decimal placm y com The amounts in the income statements shall be displayed in whole numbers. The purpose of this to force the c o st Rumber that by d o wn you create your out. Whether you were data that cand. Make a b anda tocat Use non ranges in your det section for the cost drivers and was whenever posle This worth t he While there you wan the your work Make sure to see who who who you that this completely Labour . 15.000 20000 95.000 1012. 10 91 COAS E OS 920 Advertising Seling & Commons 185.000 195.000 200/400 LUSSO 1. 16161 162 350 000 Packaging Expenses Shippinguperses 5000 45.000 445.000 . 005120539000