Question

1 Approved Answer

Posted on Jul 18, 2024

PLEASE SHOW EXCEL FORMULAS! Leather Goods LLC is in need of advice. In this week's assignment you'll need to help the managers make short-term (product

image text in transcribed PLEASE SHOW EXCEL FORMULAS!

Leather Goods LLC is in need of advice. In this week's assignment you'll need to help the managers make short-term (product mix tab) and long-term (capital projects tab) decisions in Excel. Complete the Excel workbook and all schedules in their entirety. All information needed is provided in the workbook. Ensure all formatting is correct ($ signs, commas, decimals, etc.) before submission. If you have questions, please refer to the Excel Rubric or reach out via email. Thank you! C K L M D R 1 LI V Z La Ceues LLC pruutensable du har trent procust missfallen, werdepan buskes. They wil thar prsutbuwurstallation but to send in the curring mython Ilhas para hytter diosand other propria populate thalidominternah tersranhelathe Beast mare deciding taste their tan preneurther premium products at thepop-up space. The company accountant has provided the following information A 10 12 13 Per item Standard .. 12.50 $ AM SPM Abies ANA Pronttinn Vargin Premium 134.00 53.00 16 18 19 Asleitura durres, mantar marts. In the sum of the pop-up. Latha de Lleid wilderd partner premium parcerranih. Delclata expontribution argind in the preparat inginerAttrin. Temir operating in what products and Leather Gadalli hepp 21 22 23 3-Namih Period Standard Premium Expected a by Le Vendas Contributin nard Cols nating room 25 26 27 28 29 30 31 Recommend Prod.clox Pop Up Le GOUS LLC2020 incore.stewno. 35 nahieran Contribution My Finc Fired Coats pering Incom Wskandar Tips Www flashpacker Total 23.115.40 HD 2729,20 7.312,200 2 ans, 20 4.872,00 2089300 791,600 2.695, 22 7.567.321 2025,000 2,037,000 1.890909 4,992.900 $ 2,055,300 S (265,2001 S 304,321 S 2,574,421 Preureditert restaurier Gauck LLC www.la drop the walls prestlin Talalalts will not bewerbumperdib. Workender Rygs Wallets Rackpacker Tata 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 CI Sales Variabl:Costs Contribution Marin Fis Counting income letter Concertom prol in this decidis II Cring room. Mnyumend the campur dropslither party? ? Product Mix Capital Pro ocis | + H NDP B T D V W 7 MA ARN Levher GooCugate of matto Nauticapital t Therahtower the year nechajte than Project Leather Goods LC managers areconsidering other inepurses Toolter purses they will need to inves: 588.000 in a new machinery to produce and . $a Sel cursa Theapc.dahifowatom tesis of pures is $10.003. 9 10 11 12 13 Project - Leather Good Luc managers are considering espanding the prod.ction of weekend bags. To and the volume of weekerder bewill need to impea 594,000 to open their currently line. The annual capito chinflows from the aditional so'wedi derbis$15,000. Project C-air God Luc merger wondering in there will requires capital out of $220,000. The unul Fonneschieram then in the real pis $12.00 15 16 17 1B Prolert & Project Project 20 21 22 25 74 25 26 27 28 29 Cap al Outla 12/31/22 12/31/23 12/11/14 17/11/31 17/11/26 12/31/27 12/31,28 12/31/29 12/31/10 12/51/5 : Postres IRSUNS Pnerima IFA Show za 21 32 33 34 35 36 317 a which praw do you recomand Listhauds LLE simir? ? 39 40 41 42 43 44 45 AG 47 48 P 50 Product Mix Capital Projects + Heady IP I + 100% % Leather Goods LLC is in need of advice. In this week's assignment you'll need to help the managers make short-term (product mix tab) and long-term (capital projects tab) decisions in Excel. Complete the Excel workbook and all schedules in their entirety. All information needed is provided in the workbook. Ensure all formatting is correct ($ signs, commas, decimals, etc.) before submission. If you have questions, please refer to the Excel Rubric or reach out via email. Thank you! C K L M D R 1 LI V Z La Ceues LLC pruutensable du har trent procust missfallen, werdepan buskes. They wil thar prsutbuwurstallation but to send in the curring mython Ilhas para hytter diosand other propria populate thalidominternah tersranhelathe Beast mare deciding taste their tan preneurther premium products at thepop-up space. The company accountant has provided the following information A 10 12 13 Per item Standard .. 12.50 $ AM SPM Abies ANA Pronttinn Vargin Premium 134.00 53.00 16 18 19 Asleitura durres, mantar marts. In the sum of the pop-up. Latha de Lleid wilderd partner premium parcerranih. Delclata expontribution argind in the preparat inginerAttrin. Temir operating in what products and Leather Gadalli hepp 21 22 23 3-Namih Period Standard Premium Expected a by Le Vendas Contributin nard Cols nating room 25 26 27 28 29 30 31 Recommend Prod.clox Pop Up Le GOUS LLC2020 incore.stewno. 35 nahieran Contribution My Finc Fired Coats pering Incom Wskandar Tips Www flashpacker Total 23.115.40 HD 2729,20 7.312,200 2 ans, 20 4.872,00 2089300 791,600 2.695, 22 7.567.321 2025,000 2,037,000 1.890909 4,992.900 $ 2,055,300 S (265,2001 S 304,321 S 2,574,421 Preureditert restaurier Gauck LLC www.la drop the walls prestlin Talalalts will not bewerbumperdib. Workender Rygs Wallets Rackpacker Tata 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 CI Sales Variabl:Costs Contribution Marin Fis Counting income letter Concertom prol in this decidis II Cring room. Mnyumend the campur dropslither party? ? Product Mix Capital Pro ocis | + H NDP B T D V W 7 MA ARN Levher GooCugate of matto Nauticapital t Therahtower the year nechajte than Project Leather Goods LC managers areconsidering other inepurses Toolter purses they will need to inves: 588.000 in a new machinery to produce and . $a Sel cursa Theapc.dahifowatom tesis of pures is $10.003. 9 10 11 12 13 Project - Leather Good Luc managers are considering espanding the prod.ction of weekend bags. To and the volume of weekerder bewill need to impea 594,000 to open their currently line. The annual capito chinflows from the aditional so'wedi derbis$15,000. Project C-air God Luc merger wondering in there will requires capital out of $220,000. The unul Fonneschieram then in the real pis $12.00 15 16 17 1B Prolert & Project Project 20 21 22 25 74 25 26 27 28 29 Cap al Outla 12/31/22 12/31/23 12/11/14 17/11/31 17/11/26 12/31/27 12/31,28 12/31/29 12/31/10 12/51/5 : Postres IRSUNS Pnerima IFA Show za 21 32 33 34 35 36 317 a which praw do you recomand Listhauds LLE simir? ? 39 40 41 42 43 44 45 AG 47 48 P 50 Product Mix Capital Projects + Heady IP I + 100% %