ZuoTi.Pro
Question

10. Goal Seek tes for bottled beer uppose that the set-up cost (Nonrecoverable Cost) is s50,000. addition, that variable labo
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Step 1 - Input the value as shown below.

Take note of the formulas.

Step 2 - Go to Data tab -> what if Analysis -> goal.

Here you will find 3 inputs
Set cell : The cell which we must change ( in this case it the profit that needs to change)
To value : The value to which the set cell must change (in this case to 27000)
By changing cell: The cell that must iterated to get the needed change (Here it is the number of crates.)

Put the input as shown below

We get the following
Revenue needed = 1155000
Crates Needed = 25667

Profit at breakeven is zero

0 0
Add a comment
Know the answer?
Add Answer to:
10. Goal Seek tes for bottled beer uppose that the set-up cost (Nonrecoverable Cost) is s50,000....
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

  • Part 1: Goal Seek Pampa Parts produces a single product, the NF-9. The product has a...

    Part 1: Goal Seek Pampa Parts produces a single product, the NF-9. The product has a unit variable cost of $70 and annual fixed costs of $343,200. Pampa is subject to a 20 percent tax rate. Suppose the NF-0 sells for $110 per unit. Using the Goal Seek function in Microsoft Excel, how many units of NF-9 must Pampa sell to earn an annual operating profit after taxes of $38,400? Now, suppose Pampa expects to sell 8,150 units of NF-9...

  • 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...

  • Problem 1: A company produces an item at a per-unit cost of $1000 and a fixed cost of $50,000. The selling pri...

    Problem 1: A company produces an item at a per-unit cost of $1000 and a fixed cost of $50,000. The selling price is a linear function of number of items demanded as follows: p = 15,000 - 200x, x5 80 A. Find the per-unit selling price when the demand is 30. B. Find the revenue function and find the revenue when the demand is 30. C. Find the cost function and find the cost when the demand is 30. D....

  • EXERCISES: Set A (continued) 30. Break-Even Point and Target Profit Measured in Units (Multiple Products a....

    EXERCISES: Set A (continued) 30. Break-Even Point and Target Profit Measured in Units (Multiple Products a. Start by calculating the contribution margin for each product Sweater contribution margin- Jacket contribution margin- per unit per unit Then, calculate the weighted average contribution margin per unit: Weighted average contribution margin per unit = ) + ( b. The break-even point in units is calculated as: c. Break-even point in units for each product is: Sweater Jacket Total units (= units (= units...

  • Question 1 Shannon’s distributes its beer through a wholesaler, Miller of Denton. The retail selling price...

    Question 1 Shannon’s distributes its beer through a wholesaler, Miller of Denton. The retail selling price for a six pack of its typical craft beer is $12.00. The retailer’s cost per six pack is $8.00. The wholesaler sells the beer to the retailer for this price. Shannon’s sells a six pack to the wholesaler for $5.40. Shannon’s variable costs of production, packaging, and distribution are $3.60 per six pack. Shannon’s has the following annual fixed operating and marketing costs: Marketing...

  • High-Low Method The manufacturing costs of Ackerman Industries for the first three months of the year...

    High-Low Method The manufacturing costs of Ackerman Industries for the first three months of the year follow: Total Costs Units Produced January $1,900,000 20,000 units February 2,250,000 27,000 March 2,400,000 30,000 Using the high-low method, determine (a) the variable cost per unit and (b) the total fixed cost. Round all answers to the nearest whole dollar. a. Variable cost per unit b. Total fixed cost Contribution Margin Lanning Company sells 160,000 units at $45 per unit. Variable costs are $27...

  • QUESTION ONE A. Suppose the marginal cost and marginal revenue (in ¢000) for a product produced...

    QUESTION ONE A. Suppose the marginal cost and marginal revenue (in ¢000) for a product produced by a company is estimated to be MC = q +35 MR = 560 + 22q-q? Where q is the quantity produced and the firm's break-even is 5 units per week You are Required to 1. determine the total cost and the total revenue function in terms of q. (6 marks) II. estimate the output at which profit is maximize (6 marks) III. calculate...

  • 1. Sales Mix and Break-Even Sales Dragon Sports Inc. manufactures and sells two products, baseball bats...

    1. Sales Mix and Break-Even Sales Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs are $468,000, and the sales mix is 60% bats and 40% gloves. The unit selling price and the unit variable cost for each product are as follows: Products Unit Selling Price Unit Variable Cost Bats $60 $50 Gloves 150 90 a. Compute the break-even sales (units) for both products combined. units b. How many units of each product,...

  • Cost-Volume-Profit Analysis Randy Rajoub is evaluating a business opportunity to sell cookware of trade shows. Mr....

    Cost-Volume-Profit Analysis Randy Rajoub is evaluating a business opportunity to sell cookware of trade shows. Mr. Rajoub can buy the cookware ar a wholesale cost of 5270 per ser. He plans to sell the cookware for $350 per se. He estimates fixed costs such as pane fare, booth rental cost and lodging to be 55,600 per trade show, Required a. Determine the number of cookware sets Mr. Rajoub must sell at a trade show to break even (zero profit or...

  • Check my workCheck My Work button is now enabled Item 10 Item 10 1.4 points Item...

    Check my workCheck My Work button is now enabled Item 10 Item 10 1.4 points Item Skipped Exercise 5-17 Break-Even and Target Profit Analysis [LO5-4, LO5-5, LO5-6] Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $50 per unit. Variable expenses are $32 per stove, and fixed expenses associated with the stove total $108,000 per month. Required: 1. What is the break-even point in unit sales and in dollar sales? 2. If the...

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