Please complete the spreadsheet and prepare approx 250 words discussing the last screenshot

AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A16 X fox o P Q 1 #produced and sold of each product 2 St. Augustine Sod in sq feet 3 Texas Pecan Trees 4 B D E F G H H J K L M N January February March April May June July August September October November December TOTAL 140,763 178256 85,948 177,005 145,800 159,626 116,407 130,832 62,790 132715 62081 164628 789 987 456 456 867 680 457 667 907 789 956 897 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Quantity Sold Traditional Costing ABC Costing Overhead + Ready 3 + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F29 fox A B C D E F H J K L M N O 1 Basic Information 2 Sod 3 4 5 Selling Price Per Unit 6 Direct Materials Per Unit 7 Direct Labor Per Unit 8 Direct Labor Hours Per Unit 9 Estimated Annual Production and Sales $ $ $ Trees 12.99 $ 0.99 $ 2.00 $ 0.2 0.38 0.01 0.09 0.009 units 10 11 Estimated Overhead (last year's numbers) 12 Planting 13 Irrigation 14 Product Support 15 Harvesting 16 Inspections 17 Property Taxes 47,000 19,000 19,046 21,567 4,564 6,754 117,931 18 TOTAL 19 20 21 DO NOT ROUND DO NOT ROUND 22 Estimated Total Direct Labor Hours 23 Predetermined Overhead Rate 24 25 Traditional Costing 26 Sales 27 Direct Materials 28 Direct Labor | Quantity Sold Traditional Costing Ready ABC Costing Overhead + 3 + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F29 X fox B D E F H J K L M N O 0.01 7 0.99 $ 2.00 $ 0.2 0.09 0.009 units 6 Direct Materials Per Unit $ Direct Labor Per Unit $ 8 Direct Labor Hours Per Unit 9 Estimated Annual Production and Sales 10 11 Estimated Overhead (last year's numbers) 12 Planting 13 Irrigation 14 Product Support 15 Harvesting 16 Inspections 17 Property Taxes 18 TOTAL 19 47,000 19,000 19,046 21,567 4,564 6,754 117,931 20 DO NOT ROUND DO NOT ROUND 21 22 Estimated Total Direct Labor Hours 23 Predetermined Overhead Rate 24 25 Traditional Costing 26 Sales 27 Direct Materials 28 Direct Labor 29 Manufacturing Overhead 30 Product Margin 31 32 per unit 33 | Quantity Sold Traditional Costing Screenshot saved The screenshot was added to your OneDrive. OneDrive ABC Costing Overhead + Ready + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X E23 X fox B D E F G H J K L M 7 Texas Pecan Trees year old trees 8 $ 9 10 47,000 19,000 19,046 21,567 4,564 6,754 117,931 11 12 Overhead 13 Planting 14 Irrigation 15 Product Support 16 Harvesting 17 Inspections 18 Property Taxes 19 TOTAL 20 21 ABC Costing: 22 Sales 23 Direct Materials 24 Direct Labor 25 Manufacturing Overhead 26 Product Margin 27 28 per unit 29 Trees Sod 30 31 32 33 34 Quantity Sold Traditional Costing ABC Costing Overhead + Ready 3 + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 fic Estimated Overhead (last year's numbers) D E F H | J K L M N O P O R S A B C 1 Estimated Overhead (last year's numbers) 2 Planting 47,000 3 Irrigation 19,000 4 Product Support 19,046 5 Harvesting 21,567 6 Inspections 4,564 7 Property Taxes 6,754 8 TOTAL 117,931 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Screenshot saved The screenshot was added to your OneDrive. OneDrive 26 27 28 Quantity Sold Traditional Costing ABC Costing Overhead Ready Average: 33694.57143 Count: 15 Sum: 235862 3 + 100% AutoSave Team 5 Assignment Week 4a (2) - Word Search Jacob Proctor File Home Insert Design Layout References Mailings Review View Help Share Comments X Cut Arial 10.5 AA Aa to E 21 LG Copy * Format Painter AaBbCcDc AaBbCcDc AaBbc Aabbcc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Gbc Replace Select Paste I B E DE Uab x, x? ADA Dictate Editor Clipboard Font Paragraph Styles Editing Voice Editor Mr. Beridon received your requests for information and returned data which you have compiled in an Microsoft Excel spreadsheet (see document template). He also said, "We grow sod and trees at Jesor Farms. We sell the sod mainly to home builders in the area, although we sell to some individuals who are purchasing square footages to re-sod their yard. Many home builders will purchase to sod an entire subdivision. They then may come back to us to purchase trees for the yards. It really is a package deal. For builders like that, we are a one-stop-shop. In most cases, however, we sell the trees to orchards and some individuals. The purchaser is responsible for all shipping costs related to their product." "Our production process is different for each product. For sod, we plant the seed, irrigate, cut, and roll the sod and then transport it. For the trees, we plant the root stock, graft the tree, water until a particular maturity and then dig it up and sell it. We inspect the plants as needed to make sure we are producing a quality product that is disease-free." "We have delayed purchasing some machinery that reduces time for the planting of the trees because it is a large up-front cost and we don't want to have a huge outlay of cash if our profits keep going down." "The grass does not require as much irrigation as the trees, as it is at a lower elevation than the tree acres and is closer to the creek; it gets a lot of the run off." "Historically, we have always been able to sell everything we produce. Hopefully, that will continue since Houston is expanding rapidly." Compute the product costs for the sod and trees under traditional and ABC costing using the Microsoft Excel spreadsheet. Discuss whether Leemr Farms should install an ABC accounting system, continue with the existing traditional accounting system, or continue with the traditional accounting system with periodic ABC analysis to evaluate product profitability. Please sign up for the topics that you will be resourcing and writing about for week 4 team assignment. Information need by Friday September 4, 2020. Also review the excel spreadsheet related to this Page 1 of 1 368 words C) Focus 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A16 X fox o P Q 1 #produced and sold of each product 2 St. Augustine Sod in sq feet 3 Texas Pecan Trees 4 B D E F G H H J K L M N January February March April May June July August September October November December TOTAL 140,763 178256 85,948 177,005 145,800 159,626 116,407 130,832 62,790 132715 62081 164628 789 987 456 456 867 680 457 667 907 789 956 897 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Quantity Sold Traditional Costing ABC Costing Overhead + Ready 3 + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F29 fox A B C D E F H J K L M N O 1 Basic Information 2 Sod 3 4 5 Selling Price Per Unit 6 Direct Materials Per Unit 7 Direct Labor Per Unit 8 Direct Labor Hours Per Unit 9 Estimated Annual Production and Sales $ $ $ Trees 12.99 $ 0.99 $ 2.00 $ 0.2 0.38 0.01 0.09 0.009 units 10 11 Estimated Overhead (last year's numbers) 12 Planting 13 Irrigation 14 Product Support 15 Harvesting 16 Inspections 17 Property Taxes 47,000 19,000 19,046 21,567 4,564 6,754 117,931 18 TOTAL 19 20 21 DO NOT ROUND DO NOT ROUND 22 Estimated Total Direct Labor Hours 23 Predetermined Overhead Rate 24 25 Traditional Costing 26 Sales 27 Direct Materials 28 Direct Labor | Quantity Sold Traditional Costing Ready ABC Costing Overhead + 3 + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F29 X fox B D E F H J K L M N O 0.01 7 0.99 $ 2.00 $ 0.2 0.09 0.009 units 6 Direct Materials Per Unit $ Direct Labor Per Unit $ 8 Direct Labor Hours Per Unit 9 Estimated Annual Production and Sales 10 11 Estimated Overhead (last year's numbers) 12 Planting 13 Irrigation 14 Product Support 15 Harvesting 16 Inspections 17 Property Taxes 18 TOTAL 19 47,000 19,000 19,046 21,567 4,564 6,754 117,931 20 DO NOT ROUND DO NOT ROUND 21 22 Estimated Total Direct Labor Hours 23 Predetermined Overhead Rate 24 25 Traditional Costing 26 Sales 27 Direct Materials 28 Direct Labor 29 Manufacturing Overhead 30 Product Margin 31 32 per unit 33 | Quantity Sold Traditional Costing Screenshot saved The screenshot was added to your OneDrive. OneDrive ABC Costing Overhead + Ready + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X E23 X fox B D E F G H J K L M 7 Texas Pecan Trees year old trees 8 $ 9 10 47,000 19,000 19,046 21,567 4,564 6,754 117,931 11 12 Overhead 13 Planting 14 Irrigation 15 Product Support 16 Harvesting 17 Inspections 18 Property Taxes 19 TOTAL 20 21 ABC Costing: 22 Sales 23 Direct Materials 24 Direct Labor 25 Manufacturing Overhead 26 Product Margin 27 28 per unit 29 Trees Sod 30 31 32 33 34 Quantity Sold Traditional Costing ABC Costing Overhead + Ready 3 + 100% AutoSave Off HD acc349_r6_jeemp_template - Protected View O Search Jacob Proctor JP File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 fic Estimated Overhead (last year's numbers) D E F H | J K L M N O P O R S A B C 1 Estimated Overhead (last year's numbers) 2 Planting 47,000 3 Irrigation 19,000 4 Product Support 19,046 5 Harvesting 21,567 6 Inspections 4,564 7 Property Taxes 6,754 8 TOTAL 117,931 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Screenshot saved The screenshot was added to your OneDrive. OneDrive 26 27 28 Quantity Sold Traditional Costing ABC Costing Overhead Ready Average: 33694.57143 Count: 15 Sum: 235862 3 + 100% AutoSave Team 5 Assignment Week 4a (2) - Word Search Jacob Proctor File Home Insert Design Layout References Mailings Review View Help Share Comments X Cut Arial 10.5 AA Aa to E 21 LG Copy * Format Painter AaBbCcDc AaBbCcDc AaBbc Aabbcc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Gbc Replace Select Paste I B E DE Uab x, x? ADA Dictate Editor Clipboard Font Paragraph Styles Editing Voice Editor Mr. Beridon received your requests for information and returned data which you have compiled in an Microsoft Excel spreadsheet (see document template). He also said, "We grow sod and trees at Jesor Farms. We sell the sod mainly to home builders in the area, although we sell to some individuals who are purchasing square footages to re-sod their yard. Many home builders will purchase to sod an entire subdivision. They then may come back to us to purchase trees for the yards. It really is a package deal. For builders like that, we are a one-stop-shop. In most cases, however, we sell the trees to orchards and some individuals. The purchaser is responsible for all shipping costs related to their product." "Our production process is different for each product. For sod, we plant the seed, irrigate, cut, and roll the sod and then transport it. For the trees, we plant the root stock, graft the tree, water until a particular maturity and then dig it up and sell it. We inspect the plants as needed to make sure we are producing a quality product that is disease-free." "We have delayed purchasing some machinery that reduces time for the planting of the trees because it is a large up-front cost and we don't want to have a huge outlay of cash if our profits keep going down." "The grass does not require as much irrigation as the trees, as it is at a lower elevation than the tree acres and is closer to the creek; it gets a lot of the run off." "Historically, we have always been able to sell everything we produce. Hopefully, that will continue since Houston is expanding rapidly." Compute the product costs for the sod and trees under traditional and ABC costing using the Microsoft Excel spreadsheet. Discuss whether Leemr Farms should install an ABC accounting system, continue with the existing traditional accounting system, or continue with the traditional accounting system with periodic ABC analysis to evaluate product profitability. Please sign up for the topics that you will be resourcing and writing about for week 4 team assignment. Information need by Friday September 4, 2020. Also review the excel spreadsheet related to this Page 1 of 1 368 words C) Focus 100%