q1- Bunning Warehouse wants to balance the prices for selling 500 trees. Data is in the screenshot.Using Goal seek, what percentage of the trees should be sold at the highest price to achieve a $7,500 total profit? Total number of treesHighest PriceLowest Price500% sold with the highest priceNumber of treesTotal Profit40%200300Unit Price Unit Profit$60$18$30$9Profit$3,600$2,700$6,300

Total profits refer to the amount remaining with a company after it has paid all its liabilities. It…

q1- Bunning Warehouse wants to balance the prices for selling 500 trees. Data is in the screenshot. Using Goal seek, what percentage of the trees should be sold at the highest price to achieve a $7,500 total profit?

q1- Bunning Warehouse wants to balance the prices for selling 500 trees. Data is in the screenshot. Using Goal seek, what percentage of the trees should be sold at the highest price to achieve a $7,500 total profit?

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter11: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 11.16E

See similar textbooks

Related questions

Q: Choose the correct letter of answer Bautista Company produces and sells a particular home…

A: Meaning of Revenue Revenue is how much a company earns from selling a given quantity of a product.…

Q: Using Goal Seek/Solver and/or What-If Scenarios based on the below income statement, calculate the…

A: Presently net income is $947,815.56. You should know that in order to achieve a net income of…

Q: Consider the following information for a given business. Sale revenue =GHS40,000 VC per unit…

A: The contribution margin is computed by subtracting the variable cost from the sale revenue. The…

Q: Example 14: CVP Analysis Application: For example, sale price of one laptop is $500, sales…

A: According to the given question, we need to draw a graph using this information. Cost-volume…

Q: A tree provider to plant nurseries is trying to use customer lifetime value to determine the value…

A: Net present value is one of the technique used for product or process selection. Under this, cash…

Q: You have the following information: Sales= JD 300 000 Net profit margin= 20%. Required: Calculate…

A: Financial ratios are the measure of the financial performance of a business or a corporation and…

Q: A tree provider to plant nurseries is trying to use customer lifetime value to determine the value…

A: The net present value is the capital budgeting metric that considers the effect of time value of…

Q: A clothing company has determined that if the price of a T-shirt is K40, then 150 will be demanded…

A: When Price (P) = 40, Demand (Q) = 150 When Price (P) = 45, Demand (Q) = 100 Let the price demand…

Q: Samcor Limited manufactures tables. The following information was extracted from the budget for the…

A: Given that, Units produced and sold = 2,400 units Fixed manufacturing overheads = R216,960 Sales…

Q: A small company manufactures a certain item and sells it online. The company has a business model…

A: Every company exists to make a profit and achieve outcomes. In order to analyse profitability,…

Q: The Weighted Mean 2\ If a manufacturer buys 200 units at OMR 5 per unit from one supplier and 500…

A: The average unit cost is calculated as total cost of goods divided by number of units. The weighted…

Q: Q1. Murray furniture store sells couches as a retailer. The wholesale cost to them of their most…

A: Gross Profit is the difference between the Selling price of the good or service and all the expenses…

Q: alculate the total Marginal Income and Net Profit/Loss if all the tables are sold.…

A: "Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

Q: Using the information in the example we have been using, how much would net income be if the company…

A: Calculation of net income if company sold 500 bikes are as follows To know the net income from 500…

Q: (a) Build a spreadsheet model to calculate the profit/loss for a given demand. What is the demand?…

A: There are various costs which are incurred in business. These costs can be fixed costs, variable…

Q: Problem A

Q: Jan Slaugther Company produces and sells a particular home appliance. The variable cost (VC) per…

A: Profit Function: It is a business-oriented function. These two functions will be called as follows…

Q: The ingredients for your braised greens cost $1.32. You sell it for $4. What is your contribution…

A: Contribution Margin is difference of Sales & Variable costs. Contribution Margin = (Sales -…

Q: $6.22, Call long call and th

A: So you paid premium =For X1 = 35, P1=9.12, For X2 =40 Premium P2 Paid= 6.22 For X 3=45, Premium…

Q: Identify the activity ratio of a computer shop is its Cost of Goods Sold is P12 million and the…

A: Ratio Analysis: Ratio analysis is a process of determining the relationship between accounting…

Q: Find out the Profit volume ratio with the following data: Sales: $50000 Variable cost: $10000.

A: Profit volume ratio or P/V ratio is also known as contribution ratio shows the relationship between…

Q: If the demand equation is Q = 100-10P. find the consumer’s surplus when the consumer purchases 18…

A: Consumer surplus can be defined as the area of the triangle above the price and below the demand…

Q: he company has these parties of goods on hand: 10x1.000 TL; 20x900 TL; 10x800 TL; 10x700 TL. If 37…

A: Under LIFO method of Inventory valuation, most recent products added to a company's inventory is…

Q: Identify the activity ratio of a computer shop is its Cost of Goods Sold is P12 million and the…

A: Ratio analysis is the analysis of financial performance of the organization. Ratio analysis is done…

Q: Set up the final store example as a five-by-five two-person game. Assume that both stores combined…

A: Solution- Let suppose their is store A and store B. In the table below, A is on left facet…

Q: a. A retailer buys flowers at ₱1,400 per bouquet. She sells them for ₱2,000 per bouquet. How much is…

A: When the manufacturer sells products to the consumers, he adds a Markup to the cost price and then…

Q: Complete the formulas in the spreadsheet below. Select the correct VLOOKUP function in cell C8 to…

A: An incentive offered to a customer that leads to a reduced cost per unit of goods or materials…

Q: 3.1 3.2 3.3 Calculate the total Marginal Income and Net Profit/Loss if all the tables are sold. Use…

A: “Since you have posted a question with multiple sub-parts, we will provide the solution only to the…

Question

q1- Bunning Warehouse wants to balance the prices for selling 500 trees. Data is in the screenshot.

Using Goal seek, what percentage of the trees should be sold at the highest price to achieve a $7,500 total profit?

Total number of trees
Highest Price
Lowest Price
500
% sold with the highest price
Number of trees
Total Profit
40%
200
300
Unit Price Unit Profit
$60
$18
$30
$9
Profit
$3,600
$2,700
$6,300

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Calculate Profit from the following data:Sales: $40000Material cost: $10000Labour cost: $10000Fixed cost: $8000.
Selling price of 1000 and markup of 100% what is the cost price
Give typing answer with explanation and conclusion Item is canyon scanner sales prices $85 markup percent is 25%, what is the dollar markup and cost?
SCRUMPTIOUS CUPCAKESProfit and loss accountfor the year ended 30 April 20202020£SalesSales 220,000Cost of sales 120,000Gross Profit 100,000ExpensesSalaries 24,000Other Fixed cost 4,800Distribution 3,000Advertising 4,500Rent 13,200AHUtilities 3,600Other Cost 4,00057,100Operating Profit 42,900 SCRUMPTIOUS CUPCAKESBalance Sheetas at 30 April 20202020£Fixed assetsIntangible assets -Tangible assets 35,000Investments -35,000Current assetsStocks 3,000Debtors 10,000Cash at bank and in hand 6,30019,300Written ReportsCreditors: amounts falling duewithin one year (11,300)Net Current Assets 8,000Total assets less currentliabilities 43,000Net Assets 43,000Capital and reservesCalled up share capital 100Profit and loss account 42,900Shareholders' funds 43,000 please calculate the folliwing ratios: Profitability Ratios – Gross Profit Margin, Net Profit Margin and ROCE● Liquidity – Current Test and Acid Test● Gearing● Activity/Performance – Stock Turnover, Debtors’ Collection Period and AssetTurnover…
Find out BEP in units and value with the following data:Fixed cost - $50000Variable cost - $40 per unitSelling Price - $80 per unitCalculate:1) What will be the profit when the sales is $1000002) What will be the amount of sales if it desires to earn a profit of $15000
Find out the Profit volume ratio with the following data:Sales: $50000Variable cost: $10000.
e If the sale price is 30% more than costs, and the profit for each sold unit is GHS 120, the cost price per unit is : A. GHS 360 B. GHS 172 OC. GHS 400 D. GHS 560
Show solution: Selling price Cost Mark-up %markup rate cost (%MUR Cost) %markup rate selling price (%MUR SP) extra space 300 40% extra space 520 23.08% extra space will give thumbs up if correct
If FIFO inventory value is $150,000 and the current cost per unit is $10, how many units does the firm have on hand? O15,000 O 150,000 1,500,000 10 SURA
(e) Product Blue Product Red £ £Selling £12.00 £24.00Variable cost £ 4.00 £ 8.00Contribution margin £ 8.00 £16.00Fixed costs apportioned £200,000 £400,000Budgeted Sales Units 140,000 60,000Required:Calculate the breakeven points, for each product and the company as a wholeand comment on your findings
Calculate total revenue and fill in the table below. Price Quantity Total Revenue S50 60 $40 06 $35 110 S30 140 $25 190
Page of 12 ZOOM - In Class Exercise: Convert tradition income statement to contribution margin income statement (by cost Per behavior) unit Traditional (by Contribution Ratio function) margin 100,000 Sales(10,000 units) Variable Cost of goods 20,000 Variable Costs Sales (10,000 units) 100,000 10.00 1.0 sold Fixed cost of goods 10,000 V CGS sold Total Cost of Goods 30,000 V sell Sold Gross profit 70,000 V admin Total variable costs Selling and Contribution administrative: Margin Variable selling costs 5,000 Fixed selling costs 7,000 Fixed expenses Variable administrative 8,000 Fixed CGS costs Fixed administrative 12,000 Fixed sell costs Total selling and admin 32,000 Fixed admin expenses Total Fixed Exp Net Income 38,000 Net Income