Cox Electric makes electronic components and has estimated the following for a new design of one of its products:Fixed Cost$10,000Material cost per unit = $0.15Labor cost per unit = $0.10Revenue per unit = $0.65Show Transcribed TextImplement your model from part (b) in Excel using the principles of good spreadsheet design and find the profit if Cox Electric makes 18,000new product.If required, round your answer to nearest whole number. For subtractive or negative numbers use a minus sign. (Example: -300)

Contribution margin is defined as what revenue is left with the firm after deduction of its Variable…

Answered: Cox Electric makes electronic…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

(Original question included in the attached image) The Presidio Company has redesigned one of its products and is deciding on the pricing for the redesigned product. The total product cost to produce the normal volume of 10,000 units is $200,000. Total selling costs are estimated to be $80,000. The target return on investment is 25% and annual investment required to make and sell the normal volume of 10,000 units is $100,000. The company uses the absorption costing approach to compute the mark-up percentage when setting the target price. What is the mark-up percentage? _____________________ a) 48.5% b) 50.0% c) 52.5% d) 90.0% _____________________ I got "C" as my final answer for this question, but just want to make sure it is correct.
Suppose that you are the manager of a studio cafe, and you are planning to invest on a new camera and a coffee maker designed to increase the productivity of your employees and output (services) produced. Your analyst provided you the following information: A. Complete the table below. Current Projected Sales and Profit Incremental Situation Revenues and Costs Total Revenue Php1,500,000 Php1,800,000 Variable Cost 575,000 425,000 Direct Fixed Costs 625,000 700,000 Indirect Fixed Costs 100,000 100,000 Profit B. Should the new camera and coffee maker be purchased? Explain your answer based on the incremental analysis.
The production department is proposing the purchase of an automatic insertion machine. It has identified three machines and has asked the accountant to analyze them to determine which one has the best average rate of return. Machine A Machine B Machine C $83,087.40 $73,001.40 322,364.00 276,958.00 486,676.00 Estimated average income $45,130.96 Average investment Oa. Machine B Ob. Machine C Oc. Machine A Od. Machines B and C have the same preferred average rate of return.
Question is in the image Required:a) Calculate the weighted average unit contribution margin, assuming a constant sales mix. b) How many units of each printer must be sold to break even? c) i) Explain what is margin of safety ii) Calculate in sales units the margin of safety for IPM, assuming projected sales are 25,000 units?
Maxim has already spent $31.900 to manufacture a hamster food product called Green Health. Maxim currently has 10,000 bags of Green Health on hand that can be sold for $96,400, Alternatively, Maxim can process it further into a different product, Premium Green, at an additional cost of $6,500. If Maxim processes further. the Premium Green can be sold for $105,000. This would result in revenue of Multiple Choice O $105,000 $102,900 $8.600 $6.500
Topnotch company uses a Freemium model and has 200,000 users, a 5% conversion rate, and a 10% churn rate. The average cost to serve a Paying User is $100/year and the Annual Revenue/ Paying User is $500/year. The Cost to Support a Free user is negligible. Calculate Retention Rate, Lifetime of a Paying User, ARPPU, ARPU, Number of Paying Users, CLV of a paying User, and Annual Contribution for Topnotch. IMPORTANT: Please include managerial perspectives when answering the question (elaborate what the answer means for the company/firm moving forward).
Two inventors recently organized as Innovation Inc., consult you regarding a planned new product. They have estimates of the cost of materials, labor, overhead, and other expenses for 2016 but need to know how much to charge for each unit to earn a profit in 2016 equal to 15% of their estimated total long-term investment of $600,000 (ignore income taxes). Their plans indicate that each unit of the new product requires the following: Direct Material- 4lb of a material costing $7.50 per lb. Direct Labor- 2hrs. Of a metal former's time at $16.50 per hr. And 0.6 hr. Of an assemblers time at $12 per hr. Major items of production overhead would be annual rent of $69,690 for a factory building, $42,990 rent for machinery, and $32,550 of indirect material. Other production overhead is estimated to be $349,920. Selling expenses are an estimated 30% of total sales, and non-factory administrative expenses are 20% of total sales. The consensus at Innovation is that during 2016 10,000 units of…
Morgan Inc. manufactures ergonomically correct office chairs. They have a contribution margin of $110,000 and fixed expenses of $28,500. They are adding a warehouse space that will add $20,000 to their fixed expenses. What is their DOL after adding this new expense? O 2.50 O 1.35 O 1.79 O 2.27
Please provide answer with detailed working, please answer in text form, without image
Alpha Technology produces two products: a high-end laptop under the label Excellent Laptops and an inexpensive desktop under the label Outstanding Computers. The two products use two overhead activities, with the following costs: Setting up equipment $3,000 Machining $15,000 The controller has collected the expected annual prime costs for each product, the machine hours, the setup hours, and the expected production. Excellent Laptops Outstanding Computers Direct labor $25,000 $10,000 Direct materials $20,000 $5,000 Expected production in units 3,000 3,000 Machine hours 850 2,000 Setup hours 80 75 Calculate the overhead cost per unit for Excellent Laptops using a plantwide rate based on direct labor costs. (Note: Round the overhead rateto two decimal places; round the final answer to two decimal places.)
A thermoplastic film manufacturer is trying to decide between 8 types of thermoforming molding processes to be added to its molding operation. The estimated costs and revenues are shown below. Compare them on the basis of the IRR method and determine which process should be selected if the company's MARR is 7% per year. B C D E F G Initial Costs $13,000 $12,00o $11,000 $12,500 $16,000 $26,000 $19,500 Annual expenses $6,550 $9,125 $7,000 $8,000 $7,000 $11,000 $12,000 $13,000 Annual revenue $9,000 $10,000 $9,500 $13,500 $16,000 $16,200 Lifetime(years) 9. 9 9. 9. IRR 11.54% 6.88% 9.17% 11.81% 5.24% 4.86% 6.48% Perform an IRR-incremental analysis to find the best alternative.
Can you help with the CVP Drill #6?

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS