Please assist with drawing a break-even chart in excel from the data in the attached schedule. ABC Ltd has the following details for the year ending December 31, 2009Fixed costVariable cost per unitSelling price per unitProduction$10,000$ 3$ 52000 units per periodThe below schedule shows the profit and loss for each period up to ten (10) periods,increasing by 2000 units respectively.# ofUnitsTotal VariableTotal FixedTotalTotalPeriodsProducedCostCostCostRevenueProfit/Loss120006000100001600010000-6000400012000100002200020000-200036000180001000028000300002000480002400010000340004000060001000030000100004000050000100006.12000360001000046000600001400071400042000100005200070000180008.1600048000100005800080000220009.180005400010000640009000026000102000060000100007000010000030000Draw a break-even chart from the data in this schedule clearly identifying the breakevenpointA.Using the Goal Seek Function in Excel complete the following:В.Calculate the breakeven units and breakeven salesC.How many units the company needs to sell to make a profit of $8,000 and $20,000respectively

Answer to Part a. i.e. Making a Break Even Chart as asked by student to help upon is in Step - 2

# of Units Total Variable Total Fixed Total Total Periods Produced Cost Cost Cost Revenue Profit/Loss 1 2000 6000 10000 16000 10000 -6000 2 4000 12000 10000 22000 20000 -2000 3 6000 18000 10000 28000 30000 2000 8000 24000 10000 34000 40000 6000 5 10000 30000 10000 40000 50000 10000 12000 36000 10000 46000 60000 14000 7 14000 42000 10000 52000 70000 18000 8. 16000 48000 10000 58000 80000 22000 9. 18000 54000 10000 64000 90000 26000 10 20000 60000 10000 70000 100000 30000 Draw a break-even chart from the data in this schedule clearly identifying the breakeven point А.

# of Units Total Variable Total Fixed Total Total Periods Produced Cost Cost Cost Revenue Profit/Loss 1 2000 6000 10000 16000 10000 -6000 2 4000 12000 10000 22000 20000 -2000 3 6000 18000 10000 28000 30000 2000 8000 24000 10000 34000 40000 6000 5 10000 30000 10000 40000 50000 10000 12000 36000 10000 46000 60000 14000 7 14000 42000 10000 52000 70000 18000 8. 16000 48000 10000 58000 80000 22000 9. 18000 54000 10000 64000 90000 26000 10 20000 60000 10000 70000 100000 30000 Draw a break-even chart from the data in this schedule clearly identifying the breakeven point А.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter16: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 4CE: Olivian Company wants to earn 420,000 in net (after-tax) income next year. Its product is priced at...

See similar textbooks

Similar questions

Break-even sales under present and proposed conditions Kearney Company, operating at full capacity, sold 400,000 units at a price of $246.60 per unit during 20Y5. Its income statement for 20Y5 is as follows: The division of costs between fixed and variable is as follows: Management is considering a plant expansion program that will permit an increase of $8,631,000 (35.000 units at $246.60) in yearly sales. The expansion will increase fixed costs by $3,600,000 but will not affect the relationship between sales and variable costs. Instructions Determine for 20Y5 the total fixed costs and the total variable costs.
Break-even sales under present and proposed conditions Kearney Company, operating at full capacity, sold 400,000 units at a price of $246.60 per unit during 20Y5. Its income statement for 20Y5 is as follows: The division of costs between fixed and variable is as follows: Management is considering a plant expansion program that will permit an increase of $8,631,000 (35.000 units at $246.60) in yearly sales. The expansion will increase fixed costs by $3,600,000 but will not affect the relationship between sales and variable costs. Instructions Determine the maximum operating income possible with the expanded plant.
Starling Co. manufactures one product with a selling price of 18 and variable cost of 12. Starlings total annual fixed costs are 38,400. If operating income last year was 28,800, what was the number of units Starling sold? a. 4,800 b. 6,400 c. 5,600 d. 11,200
The following data were adapted from a recent income statement of Caterpillar Inc. (CAT) for the year ended December 31: Assume that 8,500 million of cost of goods sold and 4,000 million of selling, administrative, and other expenses were fixed costs. Inventories at the beginning and end of the year were as follows: Also, assume that 30% of the beginning and ending inventories were fixed costs. a. Prepare an income statement according to the variable costing concept for Caterpillar Inc. Round numbers to nearest million. b. Explain the difference between the amount of operating income reported under the absorption costing and variable costing concepts. Round numbers to nearest million.
When prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Olivian Company wants to earn 420,000 in net (after-tax) income next year. Its product is priced at 275 per unit. Product costs include: Variable selling expense is 14 per unit; fixed selling and administrative expense totals 290,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of 420,000. 2. Calculate the number of units that will yield operating income calculated in Requirement 1 above. (Round to the nearest unit.) 3. Prepare an income statement for Olivian Company for the coming year based on the number of units computed in Requirement 2. 4. What if Olivian had a 35 percent tax rate? Would the units sold to reach a 420,000 target net income be higher or lower than the units calculated in Requirement 3? Calculate the number of units needed at the new tax rate. (Round dollar amounts to the nearest dollar and unit amounts to the nearest unit.)