Toby wants to perform some CVP analysis on fertilizing jobs. On one job, she used 40 pounds
Question:
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 last 10 years). This was the only use of the truck and trailer that day. Additional employee costs include 10% payroll tax and $730 per year in worker’s compensation insurance. You may assume an employee works 2,000 hours per year on various tasks (not exclusively on fertilizing). Toby currently charges her customers $2.12 per pound to spread fertilizer.
Toby has collected some cost data over the past year (costs and pounds of fertilizer spread by month – per the table below).
1) Use account analysis to estimate variable and fixed costs to complete the analysis.
2) Use regression to estimate variable and fixed costs to complete the analysis.
3) Use calculations done by formula within Excel (including cell references).
4) Separate and label the parts of the calculation as Variable costs (VC), Contribution Margin (CM), Fixed Cost (FC) as annual breakeven (BE) point for fertilizer (in pounds) is calculated.
5) How many pounds must be spread to earn a target profit of $1,000?
6) What is the margin of safety on that target profit?
7) How many pounds must be sold (spread) if Toby wants a margin of safety of 10% of sales?
8) Is there any additional information that can be made when making these calculations?
Month | Units | Costs |
Jan | 200 | 5360 |
Feb | 150 | 5408 |
Mar | 250 | 5510 |
Apr | 450 | 5704 |
May | 350 | 5550 |
Jun | 300 | 5405 |
Jul | 200 | 5305 |
Aug | 250 | 5509 |
Sep | 375 | 5458 |
Oct | 425 | 5700 |
Nov | 175 | 5300 |
Dec | 100 | 5250 |
Employment Law for Business
ISBN: 978-0077347383
6th Edition
Authors: Dawn Bennett Alexander, Laura p Hartman