ZuoTi.Pro
Question
please explain how to get the sales revenue at breakeven and the sales revenue at target profit (the gray boxes)! :)

131 Center $ . % Xv fx ) Conditional Format Forming as a St Launch Shipping and handling ---- 40.3951 94 11 1 523.4117647 se
Multiproduct Breakeven point: -in units Sales revenue at breakeven Product #1 53.78151261 Product #2 40.33613445 Total 94.117
CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis tha
Directions You have been hired by Jake to build a CVP model that will help him understand the impact of business conditions o
- Merge & Center Formatting as Table Styles Format L M N O P Q R S T U V W 3) Complete the pro rorma Civ income statement for
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1
Multi-product breakeven point Product #1 Product #2 Total
- in units 53.78151261 40.33613445 94.11764706
Sales revenue at breakeven 1075.630252 1613.445378 2689.07563
(breakeven units * Selling Price per unit) (53.78151261 * 20) (40.33613445 * 40)
Multi-product Target Profit point Product #1 Product #2 Total
- in units (Note) 326.3235294 203.0882353 529.4117647
Sales revenue at Target Profit 6526.470588 8123.529412 14650
(Target Profit units * Selling Price per unit) (326.3235294 * 20) (203.0882353 * 40) (4050+1600+9000)
(Total Variable cost + Total Fixed cost + profit)


Note:

Let the total units of product 1 be 'x'
Let the total units of product 2 be 'y'
20x+40y = 14650
x+y = 529.4117647
y = 529.4117647-x
20x+40(529.4117647-x) = 14650
20x+21176.470588-40x = 14650
21176.470588-20x = 14650
20x = 21176.470588-14650
20x = 6526.470588
x = 326.3235294
y = 529.4117647-x
y = 529.4117647-326.3235294
y = 203.0882353
0 0
Add a comment
Know the answer?
Add Answer to:
please explain how to get the sales revenue at breakeven and the sales revenue at target...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • CVP Modeling project The purpose of this project is to give you experience creating a multiproduct...

    CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on the client's financial position. Your goal will be to use Excel in such a way that any changes to the assumptions will correctly ripple through the entire profitability analysis. If executed properly, the client should be able to use this spreadsheet over and over, using different "what if" assumptions....

  • I got the first 4 steps done. Just need to know what formulas from the data...

    I got the first 4 steps done. Just need to know what formulas from the data to use for steps 5,6, and 7. Step #1 ASSUMPTIONS Launch-it S10.00 Product #1: Sales price per unit Variable costs per unit: 1.00 2.00 1.00 4.00 Purchase Price Shipping and HandlingS Sales Comission Total variable cost per unit 200 Monthly volume Treat-Time $30.00 Product #2: Sales price per unit Variable costs per unit: 7.00 8.00 3.00 18.00 Purchase Price Shipping and Handling Sales Comission...

  • CVP Modeling project Directions The purpose of this project is to give you experience creating a...

    CVP Modeling project Directions The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on the client's financial position. Your goal will be to use Excel in such a way that any changes to the assumptions will correctly ripple through the entire profitability analysis. You have been hired by Jake to build a CVP model that will help him understand the impact of...

  • Jake's Pet Supplies: Please see highlighted Table yellow portion: Need: Multiproduct Breakeven point: in units and...

    Jake's Pet Supplies: Please see highlighted Table yellow portion: Need: Multiproduct Breakeven point: in units and sales revenue at break even and target profit point for Product 1, Product 2 and the totals Land it $6.00 60% Jake's Pet Supplies Pro Forma Contribution Margin Income Statement For the month ending June 30 ASSUMPTIONS Product 31: Launch-it Sales price per unit $10.00 Variable costs per unit: Sales comission $1.00 Purchase price $1.00 Shipping and handling Total variable cost per unit $4.00...

  • How is breakeven point determined for the answer to After taking business classes, Jake, an avid...

    How is breakeven point determined for the answer to After taking business classes, Jake, an avid dog-lover, decided to start selling unique pet supplies at trade shows. He has two products:   Product 1:   "Launch-it"-   a tennis ball thrower that will sell for $10. Product 2: "Treat-time"- an automatic treat dispenser that releases a treat when the dog places his paw on the pedal.   The treat dispenser will sell for $30. Costs:    Jake has hired an employee to work the trade...

  • PLEASE help! the paper are the instructions to fill in the boxes in the excel sheet...

    PLEASE help! the paper are the instructions to fill in the boxes in the excel sheet eating a multiproduct profitability fthis project is to give the effects of changing business conditions on the The purposes can be used to deters will be to use Excel such a way that any changes to the Excel CVP Modeling project The purpose of this project is to give you experience creating a mi analysis that can be used to determine the effects of...

  • Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the...

    Mastery Problem: Target Income and Margin of Safety Target Income and Margin of Safety At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may...

  • Target Income and Margin of Safety At the break-even point, sales and costs are exactly equal....

    Target Income and Margin of Safety At the break-even point, sales and costs are exactly equal. However, the goal of most companies is to make a profit. When a company decides that it wants to earn more than the break-even point of income, it must define the amount it thinks it will realistically make. By modifying the break-even equation, the sales required to earn a target or desired amount of profit may be computed. Complete the following: If a company...

  • (generate an incremental contribution margin of $38,500)? 2-44 Multiproduct breakeven analysis, target profit, taxes Johnson Company...

    (generate an incremental contribution margin of $38,500)? 2-44 Multiproduct breakeven analysis, target profit, taxes Johnson Company manufactures a sin- gle product called the Gripper. Patients, under the direction of physiotherapists, use the Gripper to restore, to the extent possible, normal hand functions. The Gripper has the following per-unit revenue and costs: Revenue $20 Direct materials cost. Direct labor cost Variable overhead Contribution margin per unit $6 Johnson Company has fixed manufacturing costs of $1 million per year and fixed general,...

  • APPLY THE CONCEPTS: Target income (number of units sold) Suppose a business has pricing and cost...

    APPLY THE CONCEPTS: Target income (number of units sold) Suppose a business has pricing and cost information as follows:: Price and Cost Information Amount Selling Price per Unit $10.00 Variable Cost per Unit $5.00 Total Fixed Cost $100 For the upcoming period, the company wishes to generate operating income of $400. Given the cost and pricing structure for the company’s product, how many units must the company sell to attain its target income? Remember that the basic equation for calculating...

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