Intro and Conclusion ONLY

“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.”HERE’S PART OF THE ESSAY, JUST NEED A INTRO AND CONCLUSION DONE PLEASE: SEE BELOW FOR PART OF THE ESSAY::::The method in which overhead costs are applied to each product will affect the book profitability of trees and sod for Mr. Beridon. Traditional costing allocates overhead by looking at the number of labor hours associated with each product and applying an estimated overhead rate to each labor hour. This can produce overhead per product and per unit that is less accurate. ABC costing is a more detailed method of allocating overhead costs by breaking down each element of the overhead costs and determining what percent of that cost is associated with trees and what percent is associated with sod. In this case traditional costing makes trees look more profitable than ABC costing. The product margin per unit of trees under traditional costing is $8.51 while the profit margin per unit under ABC costing is ($0.28). Traditional costing for sod had the opposite effect. Traditional costing made sod look less profitable than under ABC costing. Under traditional costing sod had a profit margin per unit of $0.21. However, under ABC costing sod had a profit margin per unit of $0.26. The best argument for Mr. Beridon to cut the sod portion of his company is under the traditional costing method. Here, trees have a much greater profit margin per unit, $8.51, than sod, $0.21. However, both units are profitable. Furthermore, Mr. Beridon is able to produce many more units of sod than trees. This year, Mr. Beridon produced 1,556,851 units of sod compared to 8,909 units of trees. The total profit margin for sod is $331,292 compared to trees which is $75,785. Under traditional costing, it is difficult to argue that sod should be cut. This argument becomes weaker under ABC costing where sods profit margin per unit increase to $0.26 and total margin increases to $409,600. Mr. Beridon should cut the tree portion of his company under ABC costing. Under ABC costing, trees produce a negative profit margin per unit and in the aggregate. The profit margin of trees per unit under ABC costing is ($0.28) and the total profit margin is ($2,522). With this information, Mr. Beridon could decide to cut the tree portion of his business because it looses money. However, Mr. Beridon could determine that there are incidental benefits to keeping the tree portion of the business. Mr. Beridon references the fact that the trees and the sod come as “a package deal.” As a result, Mr. Beridon may receive more sod orders, which are profitable, by having a tree services that looses money.
acc_349_jeemp_template_week_2_v2.xlsx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Intro and Conclusion ONLY
Just from $13/Page
Order Essay

# produced and sold of each product
St. Augustine Sod in sq feet
Texas Pecan Trees
January February March
April
May
June
140,763 178256
85,948 177,005 145,800 159,626
789
987
456
456
867
680
July
August
September October November
December TOTAL
Total
116,407 130,832
62,790 132715
62081
164628 1,556,851 1,556,851
457
667
907
789
956
897
8,908
8,908
Basic Information
Trees
Units produced and sold
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
8,909
12.99
0.99
2.00
0.2
115,728
115,727.91
$
$
$
$
Sod
1,556,851
0.38
0.01
0.09
0.009
591,603 units
591,603.38
47,000
19,000
19,046
21,567
4,564
6,754
117,931
Estimated Total Direct Labor Hours
Predetermined Overhead Rate
327243.84 DO NOT ROUND
0.3603765315 DO NOT ROUND
Traditional Costing
Sales
Direct Materials
Direct Labor
Manufacturing Overhead
Product Margin
$
$
$
$
$
per unit
$
115,727.91
8,819.91
17,818.00
42,499.56
46,590.44
$
$
$
$
$
0.40 $
15,793.46
7.47
591,603.38
15,568.51
140,116.59
42,499.56 $
393,418.72
0.67
$115,727.91
$8,819.91
$17,818.00
13,304.84
$75,785.16
$8.51
$
$591,603.38
$15,568.51
$140,116.59
104,626.16 ##########
$331,292.12
$0.21
% of overhead costs by product
St. Augustine Sod in sq feet
Texas Pecan Trees year old trees
Overhead costs by product
St. Augustine Sod in sq feet
Texas Pecan Trees year old trees
St. Augustine Sod in sq feet
Texas Pecan Trees year old trees
Totals
Planting
20%
80%
Irrigating
20%
80%
Product Support
7%
93%
Planting
Irrigating
Product Support
$
9,400.00 $ 3,800.00 $
1,333.22
$ 37,600.00 $ 15,200.00 $
17,712.78
$ 47,000.00 $ 19,000.00 $
19,046.00
$9,400.00
$3,800.00
$1,333.22
$37,600.00
$15,200.00
$17,712.78
$47,000.00
$19,000.00
$19,046.00
Overhead
Planting
Irrigation
Product Support
Harvesting
Inspections
Property Taxes
TOTAL
47,000
19,000
19,046
21,567
4,564
6,754
117,931
ABC Costing:
Sales
Direct Materials
Direct Labor
Manufacturing Overhead
Product Margin
$
$
$
$
$
per unit
$
Trees
115,728.00
8,819.91
17,818.00
91,612.98
(2,522.89)
Sod
$ 591,603.00
$ 15,568.51
$ 140,116.59
26,318.02
$ 409,599.88
(45.87) $
1.44
Trees
$115,727.91
$8,819.91
$17,818.00
$91,612.98
$2,522.98
$0.28
Harvesting
40%
60%
$
$
$
Harvesting
8,626.80
12,940.20
21,567.00
$8,626.80
$12,940.20
$21,567.00
$
$
Sod
$591,603.38
$15,568.51
$140,116.59
26,318.02
409,600.26
$
0.26
Property Taxes
40%
60%
Inspections
10%
90%
Property Taxes
Inspections
TOTALS
$
2,701.60 $
456.40 $
26,318.02
$
4,052.40 $ 4,107.60 $
91,612.98
$
6,754.00 $ 4,564.00 $ 117,931.00
$2,701.60
$456.40
$26,318.02
$4,052.40
$4,107.60
$91,612.98
$6,754.00
$4,564.00
$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

Purchase answer to see full
attachment

GradeAcers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Order your essay today and save 15% with the discount code DISCOUNT15