Question
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
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%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started