Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions