Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Toby wants to calculate her COGS for a fertilizing job she did last week. She used 4 0 pounds of fertilizer that she bought in
Toby wants to calculate her COGS for a fertilizing job she did last week. She used pounds of fertilizer that she bought in bulk $ for pounds It took her employee hours to spread the fertilizer she is paid $hour with the motorized spreader. Toby paid $ for the spreader three years ago and it is estimated to last years or pounds. To get to the job site, a company truck and trailer was used cost: $ expected to last years or miles, the site visit was miles, round trip This was the only use of the truck, trailer, and spreader for that day. Additional employee costs include: payroll tax direct labor and $ per year in workers compensation insurance indirect labor You may assume an employee works hours per year. Toby uses the spreader approximately days per year whereas the truck is used about days per year, use these to apportion costs.
Use an Input area, and calculations done by formula within Excel including 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 straightline depreciation method with the units of production method. Your work should be professionally presented.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started