what are the solutions?

what is the solution?

Required information Excel Analytics 05-02 (Static) Cost-Volume-Profit Relationships [LO5-1, L05-2, L05-3, LO5-4, L05-5, LOS-7, L.O5-9] Iyndia Company is a merchandiser that sels a total of 15 prodscts to its customers. The company provided the following information from last year: Last year, Lyndia's tosal foeed expenses and net oserating income were $3,000,000 and 51,223,070, respectively, The company would like your assistance in developing sone financial projections for thils year. Click here for a brief futoriat on Soul Sexk a Hazith clickheret for a a becief tutorial on Chartin in Evish Click here for a brief tulonie on Condinats I formatiom in Excs. Excel Analytics 05-02 (Static) Part 3 shown in rows 3 and 20 hold constare. S0, at shown in ceir o3t, ty changing the unit sales in ces 914 ) b. What are the dollar sales required to treak even? c. What was the company/s macgin of ralety lavt year? 4. Reler to the original deta tin other words, retum cet 04 to its arghal value of 150000 untby Assume the sales mix holids constant and the company plans to inciease the seling prices of all products by 52 . ptre focis on cell cis to input this projection! a. Uning Coal Seek, calculate the total unit soles required to break even is your answer greater than less than of equal to the answer you obeined in requement 3a ? b. How s. the whount in cel B23 calculoted? c. Wiy does the contribution margh rato shown in cell 229 difler toon the coeresponding percentage fon lat year, as shown in cell d. Shoudd the conshoy increase ats selling pices by 5: thas year? Lyndia Compary is a merchandiser that sells a total of 15 products to its customers. The company provided the following information from last year: Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The company would like your assistance in developing some financial projections for this year. Click here to download the Excel template, which you will use to answer the questions that followz Click here for brief tutarial on Goal Seek in Excel. Click here for a a brief tutoria on Charts in Excel Glick here for a brief tutorial on conditional Formartang in Excel. 3. Refer to the original data (in other words, return celi Qt5 to its original value of 0% ) and assume the sales mix percentages (os shown in rows 3 and 21 ) hold constant. o. Using Goal Seek, calculate the total unit sales required to break even, (Hint Instruct Goal Seek to obtain a net operating income of \$0, as shown in cell Q31, by changing the unit sales in cell Q14) b. What are the dollar sales required to break even? c. What was the company's margin of safety last year? 4. Reler to the original data (in other words, retorn cell Q14 to its original value of 150,000 units). Assume the sales mix holds constant and the company plans to increase the selling prices of all products by 5% (Hint Focus on cell 916 to inyut this projection) a. Using Goal Seek, calculate the total unit sales required to break even. is your answer greater than, less than, or equal to the answer you obtained in requirement 3a ? b. How is the amount in cell 823 calculated? c. Why does the contribution margin ratio shown in cell R29 daffer from the corresponding percentage from last year, as shown in cell R9? d. Should the company increase its selting prices by 5% this year? Using Goal Seek, calculate the total unt saten riquired to break even. (tint; tncevet coal Seck to cbtan a nut operating. income of s0, as shown in cet 031 , by charging the unit salies in cell 214. ) Required information Excel Analytics 05-02 (Static) Cost-Volume-Profit Relationships [LO5-1, L05-2, L05-3, LO5-4, L05-5, LOS-7, L.O5-9] Iyndia Company is a merchandiser that sels a total of 15 prodscts to its customers. The company provided the following information from last year: Last year, Lyndia's tosal foeed expenses and net oserating income were $3,000,000 and 51,223,070, respectively, The company would like your assistance in developing sone financial projections for thils year. Click here for a brief futoriat on Soul Sexk a Hazith clickheret for a a becief tutorial on Chartin in Evish Click here for a brief tulonie on Condinats I formatiom in Excs. Excel Analytics 05-02 (Static) Part 3 shown in rows 3 and 20 hold constare. S0, at shown in ceir o3t, ty changing the unit sales in ces 914 ) b. What are the dollar sales required to treak even? c. What was the company/s macgin of ralety lavt year? 4. Reler to the original deta tin other words, retum cet 04 to its arghal value of 150000 untby Assume the sales mix holids constant and the company plans to inciease the seling prices of all products by 52 . ptre focis on cell cis to input this projection! a. Uning Coal Seek, calculate the total unit soles required to break even is your answer greater than less than of equal to the answer you obeined in requement 3a ? b. How s. the whount in cel B23 calculoted? c. Wiy does the contribution margh rato shown in cell 229 difler toon the coeresponding percentage fon lat year, as shown in cell d. Shoudd the conshoy increase ats selling pices by 5: thas year? Lyndia Compary is a merchandiser that sells a total of 15 products to its customers. The company provided the following information from last year: Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The company would like your assistance in developing some financial projections for this year. Click here to download the Excel template, which you will use to answer the questions that followz Click here for brief tutarial on Goal Seek in Excel. Click here for a a brief tutoria on Charts in Excel Glick here for a brief tutorial on conditional Formartang in Excel. 3. Refer to the original data (in other words, return celi Qt5 to its original value of 0% ) and assume the sales mix percentages (os shown in rows 3 and 21 ) hold constant. o. Using Goal Seek, calculate the total unit sales required to break even, (Hint Instruct Goal Seek to obtain a net operating income of \$0, as shown in cell Q31, by changing the unit sales in cell Q14) b. What are the dollar sales required to break even? c. What was the company's margin of safety last year? 4. Reler to the original data (in other words, retorn cell Q14 to its original value of 150,000 units). Assume the sales mix holds constant and the company plans to increase the selling prices of all products by 5% (Hint Focus on cell 916 to inyut this projection) a. Using Goal Seek, calculate the total unit sales required to break even. is your answer greater than, less than, or equal to the answer you obtained in requirement 3a ? b. How is the amount in cell 823 calculated? c. Why does the contribution margin ratio shown in cell R29 daffer from the corresponding percentage from last year, as shown in cell R9? d. Should the company increase its selting prices by 5% this year? Using Goal Seek, calculate the total unt saten riquired to break even. (tint; tncevet coal Seck to cbtan a nut operating. income of s0, as shown in cet 031 , by charging the unit salies in cell 214. )