Big Al is about to begin work on the budget for 20x2 and they have requested...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Big Al is about to begin work on the budget for 20x2 and they have requested that you prepare an analysis based on the following assumptions. Note: Remember, that we cannot sell part of a lamp, therefore to find the number of units you have to round up to the next complete unit. Furthuremore, to find the required sales in dollars it may be easier to find the number of units and then multiply by the selling price per unit. 1. For 20x2 the selling price per lamp will be $45.00. What is the projected contribution margin and contribution margin ratio for each lamp sold? 45 minus 25.82 Contribution Margin per unit (Round to two places, S##.##) $19.18 Contribution Margin Ratio (Round to four places,% is two of those places ####%) 42.62% 2. For 20x2 the selling price per lamp will be $45.00. The desired net income in 20x2 is $195,000. What would sales in units have to be in 20x2 to reach the profit goal? cont per unit 19.18 300000 525000 185000 485000 $25,286.76 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 27,373 units 3. For 20x2 the selling price per lamp will be $45.00. If the fixed cost increase by S40,000.00 how many lamps must be sold to breakeven? 370000 340000 $17,726.80 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 19,291 units 4. For 20x2 the selling price per lamp will be $45.00. If the variable cost increase by $4.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.01} 5. For 20x2 the selling price per lamp will be $45.00. If the variable cost decreased by $4.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.02} 6. If for 20x2 the selling price per lamp is increased to $49.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.03} 7. If for 20x2 the selling price per lamp is decreased to S41.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.04} Big Al is about to begin work on the budget for 20x2 and they have requested that you prepare an analysis based on the following assumptions. Note: Remember, that we cannot sell part of a lamp, therefore to find the number of units you have to round up to the next complete unit. Furthuremore, to find the required sales in dollars it may be easier to find the number of units and then multiply by the selling price per unit. 1. For 20x2 the selling price per lamp will be $45.00. What is the projected contribution margin and contribution margin ratio for each lamp sold? 45 minus 25.82 Contribution Margin per unit (Round to two places, S##.##) $19.18 Contribution Margin Ratio (Round to four places,% is two of those places ####%) 42.62% 2. For 20x2 the selling price per lamp will be $45.00. The desired net income in 20x2 is $195,000. What would sales in units have to be in 20x2 to reach the profit goal? cont per unit 19.18 300000 525000 185000 485000 $25,286.76 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 27,373 units 3. For 20x2 the selling price per lamp will be $45.00. If the fixed cost increase by S40,000.00 how many lamps must be sold to breakeven? 370000 340000 $17,726.80 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 19,291 units 4. For 20x2 the selling price per lamp will be $45.00. If the variable cost increase by $4.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.01} 5. For 20x2 the selling price per lamp will be $45.00. If the variable cost decreased by $4.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.02} 6. If for 20x2 the selling price per lamp is increased to $49.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.03} 7. If for 20x2 the selling price per lamp is decreased to S41.00 a unit how many lamps must be sold to breakeven? Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.04}
Expert Answer:
Answer rating: 100% (QA)
Fixed Cost 330000 Contribution Margin per unit 1918 per unit 4 Rev... View the full answer
Related Book For
Statistics for Management and Economics Abbreviated
ISBN: 978-1285869643
10th Edition
Authors: Gerald Keller
Posted Date:
Students also viewed these accounting questions
-
The 21st Century Studios is about to begin the production of its most important (and most expensive) movie of the year. The movies producer, Dusty Hoffmer, has decided to use PERT/CPM to help plan...
-
A company is about to begin production of a new product. The manager of the department that will produce one of the components for the product wants to know' how often his machine will be available...
-
It may be easier to think about setting standards to help manage manufacturing businesses, like the lumber business of Brice, Inc., discussed in this chapter, than to help manage retail...
-
Alpha Corp. (a spinoff of Alpha Beta) makes Product X, which is composed of two Part Ys. Complete the following MRP matrices for X and Y, and construct a planned order report. When are orders placed...
-
Match the following terms with the correct definition. ............ 1. Bonds that all mature at the same time. ............ 2. Interest rate investors are willing to pay for similar bonds of equal...
-
Stacey Ellis is paid at the following differential piece rate: 1-100, $2.58; 101-250, $2.72; 251 and up, $3.15. Find her gross earnings for completing 475 pieces.
-
Review your answers to the previous two questions. Comment on the persuasiveness of evidence from each test. Explain any factors that would affect your assessment. Fellowes and Associates Chartered...
-
If a company wants to implement an enterprise application, it had better do its homework. Discuss the implications of this statement.
-
Create the graph in excel For the following wave functions, assume amplitude A = 20 mm and force frequency f = 10 Hz (= 62.8 rad/sec). Set up your time signal equations so that each sine wave...
-
Telstar uses job order costing. The T-accounts below summarize its production activity for the year. 1. Compute the amount for each of the following. a. Direct materials used b. Indirect materials...
-
Suppose that the market models for stocks A and B are estimated from realized returns with the following results TA = TB = 0.01 +1.1rM + EA -0.04 +1.4rM + EB where standard deviation of market return...
-
Analyzing a company's financial statements, you determine that it has an ROE of 6.50% and a plowback ratio of 10%. You believe that the CAPM is the correct model to estimate the required return on...
-
What is the output of this program? public class Calculate { public int doMath(int x, int y) { return (x-y); } } public class CalculateApp { public static void main() { int x =5; int y = 20;...
-
Explain the factors pertaining to organizational culture as well as the factors to implement successful organization culture change. and Why
-
What are the benefits of sustainability in a company? How does it teache customer loyalty and employee spirit?
-
Think of the problem of climate change as a "game" between two countries called Brazil and Germany, considered as if each were a single individual. Each country has two possible strategies for...
-
In an opinion column in the Washington Post written during the Covid-19 pandemic, former Federal Reserve Bank of New York President Bill Dudley noted, "The Federal Reserve's balance sheet is...
-
What are three disadvantages of using the direct write-off method?
-
Refer to Exercise 4.40, determine the interquartile range.
-
A statistics practitioner took random samples from Canada, Australia, New Zealand, and the United Kingdom, and classified each person as either obese (2) or not (1). Can we conclude from these data...
-
The United States spends more money on health care than any other country. To gauge how fast costs are increasing the following table was produced, which lists the total health care expenditures in...
-
From the following trial balance of G. Foot after his first year's trading, you are required to draw up a statement of profit or loss for the year ending 30 June 2016. A statement of financial...
-
At the beginning of the financial year on 1 April 2017, a company had a balance on plant account of 372,000 and on provision for depreciation of plant account of 205,400. The company's policy is to...
-
(a) Distinguish between capital and revenue expenditure. (b) Drake Ltd took delivery of a computer network on 1 July 2016, the beginning of its financial year. The list price of the equipment was...
Study smarter with the SolutionInn App