I am having problems with traditional costing portion of this spreadsheet. Can you determine if I am on the right path and help me to finish this out. I am so lost. I have the paper portion done, but need help with this spreadsheet. I have team members but they have yet to help me on anything.

Team Assignment, Part 2 Due Mar 20, 11:59 PM POINTS 8 Team Paper Resource: Jeemp Template. 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 Jeemp 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. Write a 700- to 1,050-word paper analyzing Jeemp Farms and what data and information you will consider. Include the following: Describe any factors that could skew your results. In other words, explain if there is one method of costing that could make a product look more favorable than it really is. Justify whether Mr. Beridon should cut the sod portion of his company. Justify whether Mr. Beridon should cut the tree portion of his company instead. Describe other methods of analysis you could use to help you come to a decision. Describe any other qualitative or quantitative factors or changes to Mr. Beridon's business that might be relevant to Jeemp Farms as they make the decision as to whether to use ABC and whether to cut sectors. Determine any additional information you would need to have before making a recommendation. Format your assignment to APA standards. Click the Assignment Files tab to submit your assignment as a Microsoft Word document. Introduction Describe any factors that could skew your results. In other words, explain if there is one method of costing that could make a product look more favorable than it really is. (reference needed) # produced and sold of each product St. Augustine Sod in sq feet Texas Pecan Trees January February March April May 140,763 178256 85,948 177,005 145,800 789 987 456 456 867 June July August September October November December TOTAL 159,626 116,407 130,832 62,790 132715 62081 164628 1,556,851 680 457 667 907 789 956 897 8,908 Basic Information Trees Selling Price Per Unit Direct Materials Per Unit Direct Labor Per Unit Direct Labor Hours Per Unit Estimated Annual Production and Sales $ $ $ Estimated Overhead (last year's numbers) Planting Irrigation Product Support Harvesting Inspections Property Taxes TOTAL per unit 12.99 $ 0.99 $ 2.00 $ 0.2 1,556,851 0.38 0.01 0.09 0.009 8,908 units 47,000 19,000 19,046 21,567 4,564 6,754 117,931 Estimated Total Direct Labor Hours Predetermined Overhead Rate Traditional Costing Sales Direct Materials Direct Labor Manufacturing Overhead Product Margin Sod 311,450.37 DO NOT ROUND 14.95 DO NOT ROUND $ $ $ $ 20,223,494.49 $ 1,541,282.49 $ 3,113,702.00 $ 3,385.04 89.08 801.72 77% 74% 10.00 $ 0.28 Predetermined Overhead Rate 0.99 2 2.99 1556851 4654984.49 0.01 0.09 0.1 8908 890.8 4654984.49+890.80 / 311450.37 Per Unit Product Margin Product Margin / Unit 12.99 0.99 2 10 76.98% 0.38 0.01 0.09 0.28 73.68% % of overhead costs by product St. Augustine Sod in sq feet Texas Pecan Trees year old trees Planting 20% 80% Overhead costs by product St. Augustine Sod in sq feet Texas Pecan Trees year old trees Planting $ 9,400.00 $ $ 37,600.00 $ Overhead Planting Irrigation Product Support Harvesting Inspections Property Taxes TOTAL ABC Costing: Sales Direct Materials Direct Labor Manufacturing Overhead Product Margin per unit Irrigating Product Support 20% 7% 80% 93% Irrigating Product Support 3,800.00 $ 1,333.22 15,200.00 $ 17,712.78 47,000 19,000 19,046 21,567 4,564 6,754 117,931 Trees Sod $ 3,385.04 $ 20,223,494.49 $ 89.08 $ 1,541,282.49 $ 801.72 $ 3,113,702.00 $ 117,931.00 117,931.00 Harvesting Property Taxes Inspections 40% 40% 10% 60% 60% 90% Harvesting Property Taxes Inspections $ 8,626.80 $ 2,701.60 $ 456.40 $ $ 12,940.20 $ 4,052.40 $ 4,107.60 $ TOTALS 26,318.02 91,612.98 $ 117,931.00 Estimated Overhead (last year's numbers) Planting 47,000 Irrigation 19,000 Product Support 19,046 Harvesting 21,567 Inspections 4,564 Property Taxes 6,754 TOTAL 117,931