1. Perform a break-even analysis for the following scenario. Assume you sell children toys. Basicinformation are as follows:itemmoneyfixed costs total$6,000manufacturing and shipping cost$3.5 for each toysell$11 for each toyAnswering two questions according to the given information above:(1) Question 1: List and calculate the three financial elements of break-even analysis in thisscenario.(2) Question 2: What is your break-even point? How many toys do you have to sell torealize a net profit of $7500?

Break-even analysis refers to the point from where the company will be able to be in situation of no…

(1) Question 1: List and calculate the three financial elements of break-even analysis in this scenario. (2) Question 2: What is your break-even point? How many toys do you have to sell to realize a net profit of $7500?

(1) Question 1: List and calculate the three financial elements of break-even analysis in this scenario. (2) Question 2: What is your break-even point? How many toys do you have to sell to realize a net profit of $7500?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 20M

See similar textbooks

Similar questions

Suppose you are the purchasing manager for a company that manufactures scanners and other computer peripherals. Your vendor for scanner motors is now offering "quantity discounts" in the form of instant rebates and lower shipping charges as follows. Quantity Net Price Rebate Shipping 1–500 motors $16 none $1.50 501–1,000 motors 16 $1.30 1.10 1,001–2,000 motors 16 1.90 0.80 (a) Calculate the cost of the motors, including shipping charges, for each category (in $). 1–500 motors$ 501–1,000 motors$ 1,001–2,000 motors$ (b) If you usually purchase 400 motors per month, what percent would be saved per motor by ordering 800 every two months? Round to the nearest tenth of a percent. % (c) What percent would be saved per motor by ordering 1,200 every three months? Round to the nearest tenth of a percent. % (d) How much money (in $) can be saved in a year by purchasing the motors every three months instead of every month? $ (e) What other factors besides price…
Sheridan Bucket Co., a manufacturer of rain barrels, had the following data for 2019. Sales 2,200 units Sales price $75 per unit Variable costs $45 per unit Fixed costs $18,480 (a) Correct answer iconYour answer is correct. What is the contribution margin ratio? Contribution margin ratio Type your answer here 40 % eTextbook and Media Attempts: 2 of 5 used (b) What is the break-even point in dollars? Break-even point
Using this information below, answer the following question: What is the Net Income required? Total sales amount to $2,000,000 Food generates 75% of total sales Food cost is $500,000 Beverages generated sales of $300,000 with a CMR of 0.85 The gift store generated the remaining sales at a cost of 30% Tax rate is 27% Annual fixed costs total $1,500,000 Group of answer choices $1,080,000 $1,010,000 $1,000,000 $1,090,000
Assume that HASF furniture Inc., as described, currently purchases the chair cushions for its lawn set from an outside vendor for $15 per set. Modern Furniture’s chief operations officer wants an analysis of the comparative costs of manufacturing these cushions to determine whether bringing the manufacturing in-house would save the firm money. Additional information shows that if Modern furniture’s were to manufacture the cushions, the materials cost would be $6 and the labor cost would be $4 per set and that it would have to purchase cutting and sewing equipment, which would add $10,000 to annual fixed costs. Calculate Amount company will save if company make 10,000 cushions What amount should have been inccrued if company purchase the units what amount should have been inccrued if company produce the units
The Gorman Manufacturing Company must decide whether to manufacture a component part at its Milan, Michigan, plant or purchase the component part from a supplier. The resulting profit is dependent upon the demand for the product. The following payoff table shows the projected profit (in thousands of dollars): Decision State of Nature Alternative Low Demand (S1) Medium Demand (S2) High Demand )S3) Manufacture, d(1) -20 40 100 Purchase, d(2) 10 45 70 The state-of-nature probabilities are P s1= 0.35, P s2= 0.35, and P s3= 0.30 Use expected value to recommend a decision.
Study the information given below and answer each of the following questions independently:Calculate the total Marginal Income and Net Profit/Loss if all the tables are sold. Use the marginal income ratio to calculate the break-even value.Calculate the new total Marginal Income and Net Profit/Loss, if an increase in advertising expenseby R100 000 is expected to increase sales by 400 units.How many units must be sold if the company wishes to earn a net profit of R298 920.Based on the expected sales volume of 2 400 units, determine the sales price per unit (expressedin rands and cents) that will enable the company to break even.
Meg's Manufacturing Company can make 211 units of a component part for variable costs of $159,896 and fixed costs of $32,104. The compnay decides the buy the part externally instead for $153,734 and $4,789 of the fixed costs will be avoided. How much will net income increase or decrease? If net income increases, make your answer positive; If net income decreases, put a (-) negative sign in front of the answer. Round your answer to the nearest whole dollar and do not type the dollar sign.
A company is negotiating with a potential supplier for the purchase of 100,000 widgets. The company estimates that the supplier’s variable costs are $5 per unit andthat the fixed costs, depreciation, overhead, and so on, are $50,000. The supplierquotes a price of $10 per unit. Calculate the estimated average cost per unit. do youthink $10 is too much to pay? Could the purchasing department negotiate a betterprice? How?
Tim’s Bicycle Shop sells 21-speed bicycles. For purposes of a cost-volume-profit analysis, the shop owner has divided sales into two categories, as follows: product type sales price price invoice cost sales commission high quality 1850 840 100 medium quality 920 620 40 Three-quarters of the shop’s sales are medium-quality bikes. The shop’s annual fixed expenses are $270,400. (In the following requirements, ignore income taxes.)a. What is the shop’s break-even sales volume in dollars? Assume a constant sales mix.b. How many bicycles of each type must be sold to earn a target net income of $126,750? Assume a constant sales mix.
1. Patsy smith is planning to sell her special knife for $15 per unit. She purchases units from alocal distributor for $6 each. She can return any unsold units for a full refund. Fixed costs forbooth rental, including lighting and security is $450. Compute the breakeven point in units sold 2. Suppose the unit purchased is $5 instead of $6 but the selling price is unchanged. Compute the new breakeven point in units sold. 3. Management would like to achieve a target profit after taxes of $300,000. The company’s income tax rate is 25 percent. What target profit before taxes is required to achieve the $300,000 after-tax?
Using this information below, answer the following question: What is the CMRw? Total sales amount to $2,000,000 Food generates 75% of total sales Food cost is $500,000 Beverages generated sales of $300,000 with a CMR of 0.85 The gift store generated the remaining sales at a cost of 30% Tax rate is 27% Annual fixed costs total $1,500,000 Group of answer choices 0.70 0.30 0.20 0.50 DO not give answer in image
Assume that HASF furniture Inc., as described, currently purchases the chair cushions for its lawn set from an outside vendor for $30 per set. Modern Furniture’s chief operations officer wants an analysis of the comparative costs of manufacturing these cushions to determine whether bringing the manufacturing in-house would save the firm money. Additional information shows that if Modern furniture’s were to manufacture the cushions, the materials cost would be $16 and the labor cost would be $10 per set and that it would have to purchase cutting and sewing equipment, which would add $25,000 to annual fixed costs. Required Computation for 10,000 units What amount should have been inccrued if company produce 10,000 units What amount should have been inccrued if company purhcase 10,000 units from outside What amount company save if company make 10,000 cushions