Question

Please show in Excel! book store sells jackets for $20 each. The variable cost per jacket...

Please show in Excel!

book store sells jackets for $20 each. The variable cost per jacket is $22 and at curre rs annual sales of 50,000 jackets, the stoe earns $78,000 before taxes on jackets. How much are the fixed xosta of productinv jackets?

Price:
VC Per Unit:
Quantity:
Profite:
Sales:
Fixed Cost:

0 0
Add a comment Improve this question Transcribed image text
Answer #1

E18 fx A B D E F 1 2 Amount 3 1000000 4 Particulars Sales Less: Variable Cost Less: Fixed Cost Earning before Interest and taunction Library Derined Names Formula Auditing D13 А B D E F 1 2 3 4 Particulars Sales Less: Variable Cost Less: Fixed Cost E

Add a comment
Know the answer?
Add Answer to:
Please show in Excel! book store sells jackets for $20 each. The variable cost per jacket...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A North Face retail store in Chicago sells 120 jackets per week. Each jacket costs the...

    A North Face retail store in Chicago sells 120 jackets per week. Each jacket costs the store $100 and the company has an annual holding cost of 25 percent. The fixed cost of a replenishment order (including transportation) is $100. The store currently places a replenishment order every month for 500 jackets. What is the annual holding cost? What is the annual ordering cost? What is the annual total cost including the purchasing cost? If the retail store wants to...

  • Southwest U's campus book store sells course packs for $16 each. The variable cost per pack...

    Southwest U's campus book store sells course packs for $16 each. The variable cost per pack is $10, and at current annual sales of 60, 000 packs, the store earns $85, 000 before taxes on course packs. packs? 17. How much are the fixed costs of producing the course a. $125, 000 b. $182, 250 c. $202, 500 d. $275, 000 e. $385,000

  • 37. Southwest U's campus book store sells course packs for $16 each. The variable cost per...

    37. Southwest U's campus book store sells course packs for $16 each. The variable cost per pack is $10, and at current annual sales of 60,000 packs, the store earns $75,000 before taxes on course packs. How much are the fixed costs of producing the course packs? a. $125,000 b. $182, 250 c. $202,500 d. $225,000 e. $385,000 a $125,000 16x69009 = 969,000 3:3262,500 9687000- (lox 697000)-75281000

  • razier Company sells women's ski jackets. The average sales price is $272 and the variable cost...

    razier Company sells women's ski jackets. The average sales price is $272 and the variable cost per jacket is $122. Fixed Costs are $1,247,000. I razier sells 14,700 jackets, the contribution margin will be: Multiple Choice $958,000 $2,205,000 $2.751400 $835,400

  • Scenario details Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They...

    Scenario details Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell their product through their online store. Jacket Frenzy is run by a team of three staff members: April, Beatrice, and Claudia. April and Beatrice work together to manufacture jackets. Claudia manages orders, sales and delivery. Team hours Most of the time, team members work the following shifts: April works 7.5 hours on Mondays, Tuesdays and Wednesdays; Beatrice works 7.5 hours on Thursdays...

  • The neighbourhood bookstore sells novels for $20 per unit. The cost to purchase one book is...

    The neighbourhood bookstore sells novels for $20 per unit. The cost to purchase one book is $10 The store has fixed costs per month of $2000 The store estimates that they can sell 300 books each month (a) Compute the break-even point in units (b) Compute the break even point in sales dollars (c) Compute the break-even point as a percent of capacity (a) The break-even point in units is books (Simplify your answer) (b) The break-even point in sales...

  • City Flower Store sells bouquets for $20 each. Its Cost of Goods Sold is entirely variable...

    City Flower Store sells bouquets for $20 each. Its Cost of Goods Sold is entirely variable at $12 per bouquet. The company's variable selling and administrative expenses are 8% and 5% of dollar sales, respectively. The company's fixed administrative expenses decreased 15% during Year 2 due to the addition of new software that streamlines the order and delivery process. The following is City Flower's income statement for year 1. $20,000 12,000 8,000 Sales Cost of Goods Sold Gross Margin Selling...

  • Dannica Corporation produces products that it sells for $40 each. Variable costs per unit are $25,...

    Dannica Corporation produces products that it sells for $40 each. Variable costs per unit are $25, and annual fixed costs are $360,000. Dannica desires to earn an after-tax (post-tax) profit of $150,000 for the year. The expected income tax rate is 20%. Required: Determine the sales volume in units required to earn the desired after-tax profit. Multiple Choice 30,180 Units 28,922 Units 34,000 Units NR NA The marketing manager of Benson Corporation has determined that a market exists for a...

  • If pole store has a variable cost ratio of 20% and sells poles for $6 each,...

    If pole store has a variable cost ratio of 20% and sells poles for $6 each, what is the contribution margin per pole?

  • 2. The Poncho Company sells ponchos at $60 each. The variable cost per unit is 50%...

    2. The Poncho Company sells ponchos at $60 each. The variable cost per unit is 50% of the sales price and the total fixed costs are $300,000. During the summer, the Poncho Company renovated its factory. As a result, its total fixed costs increased by another $96,000 and variable costs decreased to 40% of the sales price. Determine the breakeven point in units and dollars before and after the renovation, using the contribution margin technique. Units Dollars Breakeven before modernization:...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT