Question

Martin Enterprises needs someone to supply it with 118,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you've decided to bid on the contract. It will cost you $785,000 to install the equipment necessary to start production costs will be $415,000 per year, and your variable production costs should be $10.05 per carton. You also need an initial investment in net working capitalof $68,000.If your tax rate is 24 percent and you require a return of 12 percent on your investment, whar bid price should you submit?

Answer 1

$15.66 per carton

Explanation:

118,000 cartons of machine screws

equipment cost $785,000

depreciation per year = $785,000 / 5 = $157,000

fixed manufacturing costs $415,000 per year

variable costs per carton = $10.05 x 118,000 = $1,185,900

initial investment in net working capital $68,000

tax rate 24%

discount rate 12%

price per carton?

initial investment = -$853,000

CF₁ = [(R - $1,600,000 - $157,000) x 0.76] + $157,000 = 0.76R - $1,178,320

CF₂ = [(R - $1,600,000 - $157,000) x 0.76] + $157,000 = 0.76R - $1,178,320

CF₃ = [(R - $1,600,000 - $157,000) x 0.76] + $157,000 = 0.76R - $1,178,320

CF₄ = [(R - $1,600,000 - $157,000) x 0.76] + $157,000 = 0.76R - $1,178,320

CF₅ = [(R - $1,600,000 - $157,000) x 0.76] + $157,000 + $68,000 = 0.76R + $1,110,320

$853,000 = (0.76R - $1,178,320) / 1.12 + (0.76R - $1,178,320) / 1.12² + (0.76R - $1,178,320) / 1.12³ + (0.76R - $1,178,320) / 1.12⁴ + (0.76R + $1,110,320 ) / 1.12⁵ = 0.6786R - $1,052,071.43 + 0.6059R - $939,349.49 + 0.541R - $838,704.90 + 0.483R - $748,943.66 + 0.4312R + $630,025.39

$853,000 = 2.7397R - $4,209,094.87

$5,062,094.87 = 2.7397R

R = $5,062,094.87 / 2.7397 = $1,847,682.18

total revenue = $1,847,682.18

revenue per carton = $1,847,682.18 / 118,000 = $15.6583 = $15.66