90.2K

Verified Solution

Link Copied!

just a Word document explaining which Excel tools you would use and why.

Current State of Affairs at Billington Bakery

Billington Bakery currently generates $450,000 in yearly revenue. Cost of goods sold average 50% of revenue. The bakery has the following equipment expenses: Two industrial mixers purchased at a cost of $3,500 each with a useful life of 5 years and a salvage value of $500 each. Two industrial convection ovens purchased at a cost of $3,000 each with a useful life of 5 years and a salvage value of $250 each. One large industrial refrigerator purchased for $5,000 with a useful life of five years and a salvage value of $500. The bakery employs a full time baker and two part time front counter workers. The baker is paid $35,000 per year. Both counter workers work 52 weeks a year. One works 20 hours per week and is paid $9 per hour. The other works 30 hours per week and is paid $12 per hour. Monthly rent for the building in which the bakery is located costs $1,800 per month. Bakery income is subject to the following taxes:

Taxes Annual Income Tax Rate $0-$50,000 17% $50,001-$75,000 20% $75,001-$100,000 28% $100,001-$150,000 30% $150,001-$250,000 33% Above $250,001 38% Taxes Annual Income Tax Rate $0-$50,000 17% $50,001-$75,000 20% $75,001-$100,000 28% $100,001-$150,000 30% $150,001-$250,000 33% Above $250,001 38%

Answer & Explanation Solved by verified expert

See Answer