Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 workers 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.

As an alternative to estimating costs with the information above, Toby has collected some cost data over the past year (costs and pounds of fertilizer spread by month see below and attached). Please use both methods (account analysis and regression) to estimate variable and fixed costs to complete the analysis (one sheet for comparison, one for the actual regression, please).

Use the same process as previous HW with an input area, and calculations done by formula within Excel (including cell references). Separate and label the parts of the calculation as Variable costs (VC), Contribution Margin (CM), Fixed Cost (FC) as you calculate the annual breakeven (BE) point for fertilizer (in pounds), how many pounds must be spread to earn a target profit of $1,000, and what is the margin of safety on that target profit. How many pounds must be sold (spread) if Toby wants a margin of safety of 10% of sales? Is there any additional information you would like 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance

Authors: Charles Francis Bastable

1st Edition

1375520083, 978-1375520089

More Books

Students also viewed these Finance questions

Question

=+13.5. Show of real functions f and g that f(w) + g(w)

Answered: 1 week ago

Question

1. Identify three approaches to culture.

Answered: 1 week ago

Question

2. Define communication.

Answered: 1 week ago