Question

In: Accounting

cost value pricing Must show work CVP Question Catalonia Company (CC) makes silicon wafers that its...

cost value pricing

Must show work

CVP Question Catalonia Company (CC) makes silicon wafers that its salespeople sell B-to-B for $100/wafer. All salespeople get a commission equal to 10% of the revenue from the wafers they sell, and in addition, the salespeople receive a base salary of $40,000 per person. In 2017, CC had 10 sales people, and its total sales revenue was $10,000,000. The manufacturing facility used to make the wafers has a fixed cost of $2,000,000, and a variable cost of $30/wafer. CC has no other costs or revenues other than those just described. For 2018, CC plans on modifying both its production facilities and the method by which it compensates its salespeople. The modified production facilities will increase its 2017 fixed manufacturing costs by $1,000,000 (for a total of $3,000,000 in fixed manufacturing costs), but it will reduce the variable cost per wafer to $20/wafer. CC intends to retain its existing sales staff, and not hire any more, but it intends to increase their commissions to 15% of sales revenue they generate (instead of the previous 10%). The salespeople’s base salary will remain unchanged from its 2017 levels, as will the wafer’s selling price. Please answer both of the following questions: 1. Will CC’s breakeven level of sales (expressed in dollars of sales revenue) for 2018 be higher or lower than in 2017? Support your answer with computations. 2. What level of sales also (expressed in dollars) will CC have to achieve in 2018 to generate the same direct (aka: variable) costing income that it achieved in 2017?

Solutions

Expert Solution

1. calculation of contribution margin for 2018

Selling price 100
Varriable Sales commission - 15
Varriable Cost of sales - 20
contribution margin 65

Contribution Margin Ratio = Contribution / sales

                                             65 / 100 = .65%

Fixed Cost Calculation

Fixed Manufacturing Cost 3000000
Fixed Selling Cost (10 * 40000) 400000
Total Fixed Cost 3400000

Break Even Point In $ = Fixed Cost / Contribution margin Ratio

                                      3400000 / 65 = $5230769.23

2.

Selling price 100
Varriable Sales commission [100*.10] - 10
Varriable Cost of sales - 30
contribution margin 60

Fixed Cost Calculation

Fixed Manufacturing Cost 2000000
Fixed Selling Cost (10 * 40000) 400000
Total Fixed Cost 2400000

Unit Sold in 2017 = price / sales

                            = 10000000 / 100 = 100000 units

Contribution for 2017 = 100000 * 60 = 6000000

Net income for 2017 = contribution - fixed cost

                                    6000000 - 2400000 = 3600000

Dollar sales Required in 2018 = (Fixed Cost + income of 2017) / Contribution margin of 2018

                                                     (3400000 + 3600000) / .65 = $10769230.76


Related Solutions

Question 3: Pricing Multiple Product Versions (show all work) Casey’s company produces two versions of a...
Question 3: Pricing Multiple Product Versions (show all work) Casey’s company produces two versions of a software program, “Advanced” and “Basic”. There are 3 segments of customers, the Managers, Executives and Students, and the respective segment sizes are 2000, 1000 and 5000. The per-unit cost of producing the Advanced version is $20, while the per-unit cost of producing the Basic version is $10. The willingness to pay (WTP) for each version, by segment, is given as follows: WTP (Managers) =...
can someone show the work to this question Roger has a levered cost of equity of...
can someone show the work to this question Roger has a levered cost of equity of 0.18. He is thinking of investing in a project with upfront costs of $8 million, which pays $1 million per year for the next 8 years. He is going to borrow $2 million to offset the startup costs at a rate of 0.08. His tax rate is 0.3. He will repay this loan at the end of the project. What is the NPV of...
For this question, you must show all work to receive any credit. DONOT USE MATLAB FOR...
For this question, you must show all work to receive any credit. DONOT USE MATLAB FOR THIS QUESTION. for k = 3*1:6:21 j = k/3; if rem(j,6) >= 3 disp(k) elseif rem(j,3) < 2 disp(j) else disp(3) end end write out the solution
Question: Transfer Pricing The Battery Division of Parker Company makes a standard 12 -volt battery. The...
Question: Transfer Pricing The Battery Division of Parker Company makes a standard 12 -volt battery. The Division has the following data: Production capacity (number of batteries) 200,000 Selling price per battery to outsiders       $ 50 Variable costs per battery $20 Fixed costs per battery (based on capacity)   $ 7 Parker Company has a Vehicle Division that could use this battery in its forklift trucks. The Vehicle Division is now buying 100.000 batteries per year from an outside supplier at $48 per...
Can you assist with below and show all work? question 1) Grey Corp makes a special-purpose...
Can you assist with below and show all work? question 1) Grey Corp makes a special-purpose D4H machine used in the textile industry. Grey has designed the D4H machine in 2018 to be distinct from its competitors. It has been generally regarded as a superior machine. Grey presents the following data or the years 2018 and 2019. 2018 2019 Units of D4H produced and sold 200   210 Selling Price $40,000 $42,000 Direct Materials(Kilograms) 300,000 310,000 DM cost per Kilogram $8.00...
The Sunrise Mattress Company uses transfer pricing for all work in process transfers between its divisions....
The Sunrise Mattress Company uses transfer pricing for all work in process transfers between its divisions. Senior management believes that the transfer price is an important tool to motivate appropriate behaviour and believes that each division should negotiate its prices when a transfer takes place. To make the mattresses that the company sells, the Spring Division buys processed cloth padding from an outside supplier. Cost information on the foam produced in the Foam Division is as follows:        Raw material...
Please show all work! You have just been hired by a start-up company that makes two...
Please show all work! You have just been hired by a start-up company that makes two different electronic components (one intended for DVDs and the other for cell phones) with the flow of work proceeding through two different departments: machining and assembly. During the month, three jobs were placed in production (Jobs #1 and #2 are completed; Job #3 is in Assembly) and there was no beginning work-in-process inventory. The owner is looking for your help with product costing and...
Blue Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis....
Blue Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis. Item No. Quantity Cost per Unit Cost to Replace Estimated Selling Price Cost of Completion and Disposal Normal Profit 1320 1,300 $3.23 $3.03 $4.55 $0.35 $1.26 1333 1,000 2.73 2.32 3.54 0.51 0.51 1426 900 4.55 3.74 5.05 0.40 1.01 1437 1,100 3.64 3.13 3.23 0.25 0.91 1510 800 2.27 2.02 3.28 0.81 0.61 1522 600 3.03 2.73 3.84 0.40 0.51 1573 3,100 1.82...
Martinez Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis....
Martinez Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis. Item No. Quantity Cost per Unit Cost to Replace Estimated Selling Price Cost of Completion and Disposal Normal Profit 1320 1,600 $3.46 $3.24 $4.86 $0.38 $1.35 1333 1,300 2.92 2.48 3.78 0.54 0.54 1426 1,200 4.86 4.00 5.40 0.43 1.08 1437 1,400 3.89 3.35 3.46 0.27 0.97 1510 1,100 2.43 2.16 3.51 0.86 0.65 1522 900 3.24 2.92 4.10 0.43 0.54 1573 3,400 1.94...
Martinez Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis....
Martinez Company follows the practice of pricing its inventory at the lower-of-cost-or-market, on an individual-item basis. Item No. Quantity Cost per Unit Cost to Replace Estimated Selling Price Cost of Completion and Disposal Normal Profit 1320 1,600 $3.46 $3.24 $4.86 $0.38 $1.35 1333 1,300 2.92 2.48 3.78 0.54 0.54 1426 1,200 4.86 4.00 5.40 0.43 1.08 1437 1,400 3.89 3.35 3.46 0.27 0.97 1510 1,100 2.43 2.16 3.51 0.86 0.65 1522 900 3.24 2.92 4.10 0.43 0.54 1573 3,400 1.94...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT