dont give answer in image format 2. Change all of the numbers in the data area of your worksheet so that it looks like this:1234567AChapter 5: Applying ExcelDataUnit salesSelling price per unitVariable expenses per unitFixed expenses$$$BC80,000 units70 per unit35 per unit2,520,000 5 Selling price per unit67Variable expenses per unitFixed expenses$394Break-even in dollar sales$SASA$80,000 units70 per unit35 per unit2,520,000If your formulas are correct, you should get the correct answers to the following questions.(a) What is the break-even in dollar sales?

Break Even Point - Break Even point is a point where company recovered it cost. When company achieve…

Answered: 2. Change all of the numbers in the…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter18: Cost-volume-profit Analysis (cvp)

Section: Chapter Questions

Problem 2R: Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where...

See similar textbooks

Similar questions

Click Submit to complete this assessment. Question 4 When the gross profit percentage of costs is 32%, the gross profit percentage of sales is equal to: O 24.24% 30.07% O 26.78% O 28.65% A Click Submit to complete this assessment. O Type here to search a
Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), 1,616,000; Net income (cell C38), 95,000.
1. Complete the following grid. Submit your answers in a grid/table. Cost $88.00 $2,386.27 $4.78 Markup $1.29 $3.29 $4.62 Retail $108.00 $3.87 $3,800.00 $4.00 $0.39 $5.00 Percentage of Retail Markup 48.2% 64.5% 78.2% Percentage of Cost Markup 48.2% 158% 100% Round percentages to one decimal place, and dollars to two decimal places. 2. What is the cumulative markup percent on three groups of towels when 100 towels are bought at $10.00, 200 towels are bought at $11.50, and 300 towels are bought at $12.00? Each towel retails at $20.00. 3. What is the markdown price of a $20 item that has been marked down 35 percent? What is the price when a 20 percent markdown is taken on the mark-down price? What is the price when a 20 percent markdown is taken on the second markdown price? What is the price when the item is marked 50 percent off the original price? Or 75 percent off?
Activity 2: Complete me! Directions: Fill in the needed data to complete the table below. Unit B.E.P in B.E.P in Selling Price per Unit Variable Cost per Unit Total Fixed Cost Contributio Units Pesos n Margin P19,500.00 P15.00 P13.00 P960.00 P18.00 P15.00 P24.00 P3.00 69 P34.00 P3.00 150 P27.00 P5.00 100 2. 3. 4.
Example 14: CVP Analysis Application: For example, sale price of one laptop is $500, sales revenue=500Q; Assume that expense is Y=a+bx=$80,000+300Q. We can draw two lines to assume Horizontal line (X) is the units sold Q and Vertical line (Y) is dollar sales $. We need to draw a graph using this information
Calculate total revenue and fill in the table below. Price Quantity Total Revenue S50 60 $40 06 $35 110 S30 140 $25 190
1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: Chapter 1: Applying Excel Data Sales $59,500 Variable costs: Cost of goods sold $34,000 Variable selling $3,400 Variable administrative $3,200 Fixed costs: Fixed selling $2,500 Fixed administrative $1,500 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the gross margin now? (b) What is the net operating income now? (c) What is the contribution margin now?
Find expressions for the Revenue, Cost, and Profit from selling x thousand items. 2) Item Price Fixed Cost Variable Cost $3.00 $31,471 3775x
4. Complete the following grid. Submit your answers in a grid/table. Original Retail $20.00 $22.50 $3,999.00 $0.49 Markdown Percent 25% 35% 20% 50% Marked Down Retail $17.55 $16.88 $0.44 $9.99 Units Marked Down 645 249 98 5 1,649 20 Total Markdown Dollars Round percentages to one decimal place; round dollars to two decimal places. Markdown percent is a percentage of retail.
i Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like this: A 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses Net operating income (loss) $ 168,000 Percentage increase in net operating income B C What is net operating income? (Negative amount should be indicated by a minus sign.) 72,000 units $ $ $120,000 What is the break-even in unit sales? By what percentage did the net operating income increase? Break-even in unit sales 10 per unit 6 per unit Thad Morgan, a motorcycle enthusiast, has been exploring the possibility of relaunching the Western Hombre brand of cycle that was popular in the 1930s. The retro-look cycle would be sold for $17,000 and at that price, Thad estimates 400 units would be sold each year. The variable cost to produce and sell the cycles would be $12,750 per unit. The annual fixed cost would be $1,615,000. 40%
Type the formulas to calculate the following: In cell B9, calculate the grand total amount owing for all customers. In ce E KBC DFGHJ1 Cost Retail 2 Mussels R12,40 R21, 70 3 Crabs R25, 60 R44,804 Markup % 75,0% 5 Discount % 8,5% EFT 6 VAT % 15 89 Total Sales 10 Cost of Sales 11 Profit or Loss No of 12 Customers No of Crab 13 Customers Sales of Mussel 14 Customers 15 Can
Assume that markup is based on selling price. Calculate the dollar markup and cost. (Round your answers to the nearest cent.) Selling price Dollar Item Markup percent Cost markup Canon scanner 2$ 105 40 %

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

2. Change all of the numbers in the data area of your worksheet so that it looks like this: 1 Chapter 5: Applying Excel 2 3 A Data Unit sales 7 4 5 Selling price per unit 6 Variable expenses per unit Fixed expenses 14 $ $ $ B C 80,000 units 70 per unit 35 per unit 2,520,000