Toby wants to perform some CVP analysis on fertizing jabs. On one representative job she used 40 pounds of fertilizer that she bought in bulk 151,000 for 1.000 pounds). It took her employee 1.5 hours to spread the fertilizer (she is paid S15 hour) with the motorized spreader. Toby pod $4.000 for the spreader these years ago and it is estimated to last 5 years. To get to the job site a company truck and trailer was used cost $40,000 expected to last 10 YEAHS). 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 25sume an employee works 2.000 hours per year on various tasks (nol exclusively on fertilizing) and straight line deprecation. Toby currently charges her customers $3.00 per pourd to spread fertilizer. As an alternative to estimating costs with the information above. Toby has collected some cost data over the past your costs and pounds of ferlizer spread by month see below). Please use both methods (accent analysis and regression to estimate variable and fixed costs to complete the analysis (one Excel sheet for comparison, one Excel Sheet for the actual regression in the same Workbook please) Use the same process as previous W with an input area and calculations done by formulas within Excel including sell references). Separate and label the parts of the calculation as Variable costs (VC), Contribution Margin (CM). Fixed Cost (F04 as you calculate the annuakeven (BE) paint 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 this larget profit. How many pounds must be sold ispreads of Toby wants a margin of safety of 10% of sales? Please round all calculations to 2 decimals places Job Units Costs A 200 10360 B 150 10100 250 10550 450 10750 E 350 10600 300 10406 77 m O O 200 10350 H 250 10590 375 10480 425 10700 175 10300 100 10520 For the CVP calculations based on separating VC & FC with Account Analysis, what is the margin of safety, in dollars, for a target profit of $1.000? Toby wants to perform some CVP analysis on fertizing jabs. On one representative job she used 40 pounds of fertilizer that she bought in bulk 151,000 for 1.000 pounds). It took her employee 1.5 hours to spread the fertilizer (she is paid S15 hour) with the motorized spreader. Toby pod $4.000 for the spreader these years ago and it is estimated to last 5 years. To get to the job site a company truck and trailer was used cost $40,000 expected to last 10 YEAHS). 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 25sume an employee works 2.000 hours per year on various tasks (nol exclusively on fertilizing) and straight line deprecation. Toby currently charges her customers $3.00 per pourd to spread fertilizer. As an alternative to estimating costs with the information above. Toby has collected some cost data over the past your costs and pounds of ferlizer spread by month see below). Please use both methods (accent analysis and regression to estimate variable and fixed costs to complete the analysis (one Excel sheet for comparison, one Excel Sheet for the actual regression in the same Workbook please) Use the same process as previous W with an input area and calculations done by formulas within Excel including sell references). Separate and label the parts of the calculation as Variable costs (VC), Contribution Margin (CM). Fixed Cost (F04 as you calculate the annuakeven (BE) paint 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 this larget profit. How many pounds must be sold ispreads of Toby wants a margin of safety of 10% of sales? Please round all calculations to 2 decimals places Job Units Costs A 200 10360 B 150 10100 250 10550 450 10750 E 350 10600 300 10406 77 m O O 200 10350 H 250 10590 375 10480 425 10700 175 10300 100 10520 For the CVP calculations based on separating VC & FC with Account Analysis, what is the margin of safety, in dollars, for a target profit of $1.000
