Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Looking for someone to just double check my numbers in Column A. But need help with Column C for the what if section and the
Looking for someone to just double check my numbers in Column A. But need help with Column C for the what if section and the check figures section at the end. Thanks.
Soundbytes, Inc. is a manufacturer of personal sound systems. During 2018, the company sold 28,000 MP3 players at a sales price of $104 each. Following are the 2018 financial results: Soundbytes, Inc. Contribution Format Income Statement For the Year 2018 $ 2,912,000 Sales Less variable costs: Direct materials Direct labor Variable overhead Total variable costs Contribution Margin Less fixed costs: Operating Income 504,000 448,000 616,000 1,568,000 $ 1,344,000 880,000 $ 464,000 You are the top managerial accountant at Soundbytes, Inc., and are scheduled to meet with the company's CEO next week to discuss the financial outlook for 2019. In particular, the CEO will want to know what steps the company might take to improve its 2019 income performance. You expect to be asked questions about the impact that various changes in sales price, sales volume, and costs would have on the company's contribution margin, breakeven point, margin of safety, and income. In addition, the CEO is likely to ask this question: if we decrease our labor costs by increasing automation, can we drop our price on MP3 players and increase our sales volume and be better off than in 2019? You obviously won't be able to do these calculations by hand during the meeting, so you have decided to construct an Excel program to do them for you. Page 2 is an example of how the output of your program should look. Please note that the only area of the program that may contain hard-coded numbers is Section A; the only fields that you may change when doing "what if's" are the shaded ones in Section B; and all cells containing a "?" on the attached example (including those in Section C) must contain only formulas. No hard-coded numbers are allowed in any cell containing a "?"! Inputs: Section C: 2019 What If? 30,800 4 Section A: 2018 Actual 28,000 104.00 18.00 16.00 22.00 880,000 Sales in units Sales price per unit Direct materials cost per unit Direct labor cost per unit Variable overhead cost per unit Fixed costs Section B: Change Factors 10% -5% 5% -20% 5% 30% 4 4 2019 What If? 2018 Actual $ 3,043,040.00 Income Projections: Sales Less variable expenses: Direct materials Direct labor Variable overhead Total variable expenses Contribution margin Less fixed expenses Operating income $ 582,120.00 $ 468,160.00 $ 711,480.00 $ 1,761,760.00 $ 1,281,280.00 $ 1,144,000.00 $ 137,280.00 Contribution margin per unit Contribution margin ratio 41.60 42.11% Break-even sales in units Break-even sales in $$ $ 27,500.00 $ 2,717,000.00 Margin of safety in units Margin of safety in sales $$ $ $ 3,300.00 326,040.00 Degree of operating leverage 9.33 A B F C D E Soundbytes, Inc. Financial Projections - 2019 5 Check figures - 2019 Operating income $_ 2019 Break-even sales revenue
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started