Question

In: Accounting

Toby wants to calculate her COGS for a fertilizing job she did last week. She used...

Toby wants to calculate her COGS for a fertilizing job she did last week. She used 40 pounds of fertilizer that she bought in bulk ($1,000 for 2,000 pounds). It took her employee 1.5 hours to spread the fertilizer (she is paid $15/hour) with the motorized spreader. Toby paid $4,000 for the spreader three years ago and it is estimated to last 10 years or 10,000 pounds. To get to the job site, a company truck and trailer was used (cost: $40,000 expected to last 10 years or 200,000 miles, the site visit was 30 miles round trip). This was the only use of the truck, trailer, and spreader for that day. Additional employee costs include 10% payroll tax and $730 per year in worker’s compensation insurance. You may assume an employee works 2000 hours per year.

Construct a balance sheet and income statement and include calculations done by formula within Excel (include cell references). Separate and label the parts of the calculation as Direct Material (DM), Direct Labor (DL), or Overhead (OH). Please make two calculations comparing the straight-line depreciation method with the units of production method.

Solutions

Expert Solution

Cost Of Goods Sold (COGS) $
Direct Material ( $ 1,000 / 2,000 ) x 40 pounds                        20.00
Direct Labor ( 1.5 hours x $ 15 per hour )                        22.50
Overhead costs;
spreader ( $ 4,000 / 10,000 pounds) x 40 pounds                        16.00
Truck and trailer ( $ 40,000 / 200,000) x 30 miles                          6.00
Payroll tax ( $ 22.50 x 10% )                          2.25
worker’s compensation insurance ( $ 730 / 2,000 hours) x 1.5 hours                          0.55
Total costs                        67.30

Related Solutions

Toby wants to calculate her COGS for a fertilizing job she did last week. She used...
Toby wants to calculate her COGS for a fertilizing job she did last week. She used 40 pounds of fertilizer that she bought in bulk ($1,000 for 2,000 pounds). It took her employee 1.5 hours to spread the fertilizer (she is paid $15/hour) with the motorized spreader. Toby paid $4,000 for the spreader three years ago and it is estimated to last 10 years or 10,000 pounds. To get to the job site, a company truck and trailer was used...
Toby wants to perform some CVP analysis on fertilizing jobs. On one job, she used 40...
Toby wants to perform some CVP analysis on fertilizing jobs. On one job, she used 40 pounds of fertilizer that she bought in bulk ($1,000 for 2,000 pounds). It took her employee 1.5 hours to spread the fertilizer (she is paid $15/hour) with the motorized spreader. Toby paid $4,000 for the spreader three years ago and it is estimated to last 10 years. To get to the job site, a company truck and trailer was used (cost: $40,000 expected to...
Diabetic Toby Warbet quit her secretarial job last year because of physical problems, including blurred vision...
Diabetic Toby Warbet quit her secretarial job last year because of physical problems, including blurred vision and a general loss of sensation. Such was her desperation that when she heard about an unproven treatment that might help her, she decided to borrow $20,000 from relatives to pay for it . . . “Even if the chances are one in a million, I was hoping I would be the one,” says the Livingston, NJ resident. How might you measure the value...
Toby used 40 pounds of fertilizer that she bought in bulk ($1,000 for 2,000 pounds). It...
Toby used 40 pounds of fertilizer that she bought in bulk ($1,000 for 2,000 pounds). It took her employee 1.5 hours to spread the fertilizer (she is paid $15/hour) with the motorized spreader. Toby paid $4,000 for the spreader three years ago and it is estimated to last 10 years or 10,000 pounds. To get to the job site, a company truck and trailer was used (cost: $40,000 expected to last 10 years or 200,000 miles, the site visit was...
Tamara has 80 hours per week that she can allocate to work or leisure. Her job...
Tamara has 80 hours per week that she can allocate to work or leisure. Her job pays a wage rate of $20 per hour, but Tamara is being taxed on her income in the following way. On the first $400 that Tamara makes, she pays no tax. That is, for the first 20 hours she works, her net wage (what she takes home after taxes) is $20 per hour. On all income above $400, Tamara pays a 75% tax. That...
Tamara has 80 hours per week that she can allocate to work or leisure. Her job...
Tamara has 80 hours per week that she can allocate to work or leisure. Her job pays a wage rate of $20 per hour, but Tamara is being taxed on her income in the following way. On the first $400 that Tamara makes, she pays no tax. That is, for the first 20 hours she works, her net wage (what she takes home after taxes) is $20 per hour. On all income above $400, Tamara pays a 75% tax. That...
Stacey is single and took her first ever job last year. She has been diligently saving...
Stacey is single and took her first ever job last year. She has been diligently saving and has $10,000 in a regular savings account. She has another account with enough money to manage the next three months of expenses. Stacey is interested in buying a new car. The car dealer told her that her credit score was not high enough to be eligible for the 0% finance offer and she simply cannot understand why. She pays all of her bills...
CONTRACT LAW Mary wants to buy a car; she goes to her local used car dealership...
CONTRACT LAW Mary wants to buy a car; she goes to her local used car dealership and is very interested in a used 2016 VW Eos. She asks the car salesman if the car has ever been in an accident. The car salesman doesn't know whether the car has been in an accident, but assures Mary that it has never been. If the car has in fact been in an accident and Mary buys the car, the salesman's statements may...
wants to get rid of her stock. She offers to sell it to her friend. The...
wants to get rid of her stock. She offers to sell it to her friend. The stock will not pay dividend for the next 5 years.  After year 5, the stock will pay a dividend of $3, and dividend is expected to grow at 30% in year 6, 30% in year 7, and thereafter, the stock will grow at 5%.  If the risk free is 7%, the market risk premium is 8% and a beta of 1.25.  What is the current stock price?  
Deborah Smith wants to go on a cruise to celebrate her 60th birthday. She wants to...
Deborah Smith wants to go on a cruise to celebrate her 60th birthday. She wants to know how much she needs to deposit today in savings account that pays 6% interest, compounded quarterly, in order to accumulate $5,000 for the cruise in five years. She should use a table for the: Multiple Choice Future Value of an Ordinary Annuity of $1 Future Value of an Annuity Due of $1 Present Value of $1 Present Value of an Ordinary Annuity of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT