Question

The company is considering ways to improve profitability by either stimulating sales volume or reducing variable costs. ThereProblem: Big Al Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has ha3. (25 pts) Create a copy of the Question 1 worksheet. Rename this copy Question 3. Using the Question 3 worksheet, constructInputs Response: Unit Sales Price Annual Fixed Cost Unit Variable Cost Quantity Made and Sold Calculations and Outputs Annual

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

Alternative 1 Alternative 2 (Sales increased (Variable cost by 35%) decreased by 20%) $32 $32 $95000 $95000 $16 $12.8 Unit sa3 Profit Quantity 5000 Sales 160000 320000 - 15000 10000 65000 480000 145000 15000 20000 640000 800000 960000 25000 30000 VarProfit 1200000 1000000 800000 600000 1025000 945000 865000 785000 705000 625000 545000 Profit 465000 385000 305000 225000 145

Add a comment
Know the answer?
Add Answer to:
The company is considering ways to improve profitability by either stimulating sales volume or reducing variable...
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
  • Problem: Big Al Plastics produces a variety of plastic items for packaging and distribution. One item,...

    Problem: Big Al Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has had a low contribution to profits. Last year, 20,000 units of container #145 were produced and sold. The selling price of the container was $32 per unit, with a variable cost of $16 per unit and a fixed cost of $95,000 per yoar. Using the "HW 4 Starting File" workbook in Blackboard, create and amend the workbook to do the following....

  • Problem: Big Al Plastics produces a variety of plastic items for packaging and distribution. One item,...

    Problem: Big Al Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has had a low contribution to profits. Last year, 20,000 units of container #145 were produced and sold. The selling price of the container was $32 per unit, with a variable cost of $16 per unit and a fixed cost of $95,000 per year. 2. (25 pts) Create a copy of the Question 1 worksheet in the same workbook. Rename this copy...

  • Question 1 Kelly's Karts, LLC reported the following data: Sales quantity 1,500 units; Sales $120 per...

    Question 1 Kelly's Karts, LLC reported the following data: Sales quantity 1,500 units; Sales $120 per unit; Variable costs $48 per unit; Fixed costs $93,000. What is total contribution margin? $93,000 $108,000 $180,000 $15,000 Question 2 2 pts Kelly's Karts, LLC reported the following data: Sales quantity 400 units; Sales $100 per unit: Variable costs $68 per unit; Fixed costs $6,000. They project a target profit of $4,000. What is target profit in units? 187.5 350.5 400 O 312.5 Question...

  • The Dean Company has sales of $118,000, and the break-even point in sales dollars of $75,520....

    The Dean Company has sales of $118,000, and the break-even point in sales dollars of $75,520. Determine the company's margin of safety percentage. Round answer to the nearest whole number. 36 % The Tom Company reports the following data. Sales $259,369 Variable costs 135,269 Fixed costs 51,100 Determine Tom Company's operating leverage. Round your answer to one decimal place. The Atlantic Company sells a product with a break-even point of 4,963 sales units. The variable cost is $101 per unit,...

  • Break-Even Sales and Cost-Volume-Profit Chart For the coming year, Cleves Company anticipates a unit selling price...

    Break-Even Sales and Cost-Volume-Profit Chart For the coming year, Cleves Company anticipates a unit selling price of $142, a unit variable cost of $71, and fixed costs of $418,900. Required: 1. Compute the anticipated break-even sales (units). units 2. Compute the sales (units) required to realize a target profit of $220,100. units 3. Construct a cost-volume-profit chart on paper assuming maximum sales of 11,800 units within the relevant range. From your chart, indicate whether each of the following sales levels...

  • PA5-4 Predicting predicting Cost Behavior, Calculating Contribution Marain and Contribution Margin Ratio, Calculating Profit asidio, Inc....

    PA5-4 Predicting predicting Cost Behavior, Calculating Contribution Marain and Contribution Margin Ratio, Calculating Profit asidio, Inc. produces one model of mountain bike. Partial information for the company LO follows: Cost Data Number of Bikes Produced and Sold 625 800 1,050 $125,000 Total costs Variable costs Fixed costs per year Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $581.25 Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio...

  • Chapter 2: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold Variable selling $6,000...

    Chapter 2: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold Variable selling $6,000 $600 $400 Variable administrative Fixed costs: Fixed selling $2,500 $1,500 Fixed administrative Enter a formula into each of the cells marked with a ? below Exhibit 2-9 Traditional Format Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling Administrative Net operating income Contribution Format Income Statement Sales Variable expenses: Cost of goods sold Variable selling Variable administration Contribution margin...

  • Break-Even Sales and Cost-Volume-Profit Chart For the coming year, Cleves Company anticipates a unit selling price...

    Break-Even Sales and Cost-Volume-Profit Chart For the coming year, Cleves Company anticipates a unit selling price of $94, a unit variable cost of $47, and fixed costs of $366,600. Required: 1. Compute the anticipated break-even sales in units. units 2. Compute the sales (units) required to realize income from operations of $183,300. units 3. Construct a cost-volume-profit chart, assuming maximum sales of 15,600 units within the relevant range. From your chart, indicate whether each of the following sales levels would...

  • Break-Even Sales and Cost-Volume-Profit Chart For the coming year, Sorkin Company anticipates a unit selling price...

    Break-Even Sales and Cost-Volume-Profit Chart For the coming year, Sorkin Company anticipates a unit selling price of $98, a unit variable cost of $49, and fixed costs of $396,900 Required: 1. Compute the anticipated break-even sales in units units 2. Compute the sales (units) required to realize income from operations of $196,000. units 3. Construct a cost-volume-profit chart, assuming maximum sales of 16,200 units within the relevant range. From your chart, indicate whether each of the following sales levels would...

  • Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1....

    Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio’s cost data table. 2. Calculate Presidio’s contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $650. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $650. Complete this question by entering your answers in the tabs below. Required...

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