Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I don't understand what they are asking in number 4. Directions: Complete the Part 1 by putting formulas into the cells as requested Complete Part

image text in transcribedimage text in transcribed I don't understand what they are asking in number 4.

Directions: Complete the Part 1 by putting formulas into the cells as requested Complete Part 2 by analyzing qualitative factors. Part 1: Quantitative Analysis Joseph A. Bobcat Company operates a chain of men's clothing stores that sells 10 different styles of inexpensive men's suits with identical unit costs and selling prices. A unit is defined as one suit. Each store has a manager who is paid a fixed salary Individual sales people receive a fixed salary and a sales commission. Bobcat Co. is considering opening another store that is expected to have the revenue and cost relationships show in Exhiblt A EXHIBITA Unit data (per sult) Annual Fixed Costs 160.00 45,00 $200,000 $50,000 $25,000 320,000 Selling price per unit Variable cost per unit en Salaries Advertising Other fixed costs $120.00 Cost of suits Sales commission Variable cost per unit S128.00 Tax rate 40% Plan 2 increase Fixed cost by: 80,000 1 Using the information in Exhibit A, create a contribution margin income statement for each sales level below. Also calculate break-even revenues, the margin of safety, and operating leverage. To receive full credit, yellow cells should contain only cell references and no numbers. Units Sold 9,000 10,000 11,000 12,000 13,000 Revenue $1,440,000 $ 1,600,000 $ 1,760,000 $ 1,920,000 $ 2,080,000 Variable costs 1,152,000_1.280,000 1,408,000 1,536,000 1,664,000 Contribution margin $ 288,000 320,000 $ 352,000 $ 384,000 $ 416,000 320,000 S 320,000 64,000 96,000 -19,20038,400 $ 57,600 Fixed costs S320,000 320,000 S320,000 32,000 Operating Income $ (32,000) $ After-tax Income (32,000) $ GRADING 1 point for correct AT income Break-even Revenues 1,600,000 $ 1,600,000 $ 1,600,000 1,600,000 1,600,000 -160,000 $ 320,000 $ 480,000 4.33 Margin of Safety(160,000)$ Operating Leverage 1 point for correct Break-even Revenues 1 point for correct Margin of Safety 1 point for correct Operating Leverage calculation 11.00 6.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Coffee Plus Math Equal To Audit

Authors: Marina Peters

1st Edition

B08BDSDFR6, 979-8654153418

More Books

Students also viewed these Accounting questions

Question

6. Describe why communication is vital to everyone

Answered: 1 week ago