Lyndia Company is a merchandiser that sells a total of 15 products to its customers. The company provided the following information from last year: Selling Price Variable Cost Product Unit Sales per Unit per Unit 1234 1 9,000 $ 29 $ 12.95 16,500 $ 99 $ 68.55 6,000 $ 85 $ 42.50 19,500 $ 109 $ 85.00 5 4,500 $ 19 $ 6.35 6 27,000 $ 119 $ 92.00 7 3,000 $ 39 $ 14.30 8 7,500 $ 79 $ 33.18 9 9,000 $ 69 $ 30.36 10 15,000 $ 95 $ 77.60 11 10,500 $ 59 $ 25.40 12 1,500 $ 65 $ 29.00 13 3,000 $ 44 $ 12.40 14 6,000 $ 49 $ 13.48 15 12,000 150,000 $ 89 $ 61.83 Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The company would like your assistance in developing some financial projections for this year. Click here for a brief tutorial on Goal Seek in Excel. Continue working on the "Requirements 5 and 6" tab of the Excel workbook to complete requirement 6f. 6-f. In the Excel template, using Goal Seek, calculate the total unit sales required to break even given the revised sales mix used in requirements 6a through 6e. How does your answer compare to the break-even point that you calculated in requirement 3a? Save your work in Excel and enter your answers for questions 6F1 and 6F2 in the tabs below. Required 6F1 Required 6F2 In the Excel template, using Goal Seek, calculate the total unit sales required to break even given the revised sales mix. Unit sales to break even
Lyndia Company is a merchandiser that sells a total of 15 products to its customers. The company provided the following information from last year: Selling Price Variable Cost Product Unit Sales per Unit per Unit 1234 1 9,000 $ 29 $ 12.95 16,500 $ 99 $ 68.55 6,000 $ 85 $ 42.50 19,500 $ 109 $ 85.00 5 4,500 $ 19 $ 6.35 6 27,000 $ 119 $ 92.00 7 3,000 $ 39 $ 14.30 8 7,500 $ 79 $ 33.18 9 9,000 $ 69 $ 30.36 10 15,000 $ 95 $ 77.60 11 10,500 $ 59 $ 25.40 12 1,500 $ 65 $ 29.00 13 3,000 $ 44 $ 12.40 14 6,000 $ 49 $ 13.48 15 12,000 150,000 $ 89 $ 61.83 Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The company would like your assistance in developing some financial projections for this year. Click here for a brief tutorial on Goal Seek in Excel. Continue working on the "Requirements 5 and 6" tab of the Excel workbook to complete requirement 6f. 6-f. In the Excel template, using Goal Seek, calculate the total unit sales required to break even given the revised sales mix used in requirements 6a through 6e. How does your answer compare to the break-even point that you calculated in requirement 3a? Save your work in Excel and enter your answers for questions 6F1 and 6F2 in the tabs below. Required 6F1 Required 6F2 In the Excel template, using Goal Seek, calculate the total unit sales required to break even given the revised sales mix. Unit sales to break even
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
None
Transcribed Image Text:Lyndia Company is a merchandiser that sells a total of 15 products to its customers. The company provided the following
information from last year:
Selling Price Variable Cost
Product Unit Sales
per Unit
per Unit
1234
1
9,000
$ 29
$ 12.95
16,500
$ 99
$ 68.55
6,000
$ 85
$ 42.50
19,500
$ 109
$ 85.00
5
4,500
$ 19
$ 6.35
6
27,000
$ 119
$ 92.00
7
3,000
$ 39
$ 14.30
8
7,500
$ 79
$ 33.18
9
9,000
$ 69
$ 30.36
10
15,000
$ 95
$ 77.60
11
10,500
$ 59
$ 25.40
12
1,500
$ 65
$ 29.00
13
3,000
$ 44
$ 12.40
14
6,000
$ 49
$ 13.48
15
12,000
150,000
$ 89
$ 61.83
Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The
company would like your assistance in developing some financial projections for this year.
Click here for a brief tutorial on Goal Seek in Excel.
Continue working on the "Requirements 5 and 6" tab of the Excel workbook to complete requirement 6f.
6-f. In the Excel template, using Goal Seek, calculate the total unit sales required to break even given the revised sales mix used in
requirements 6a through 6e. How does your answer compare to the break-even point that you calculated in requirement 3a?
Save your work in Excel and enter your answers for questions 6F1 and 6F2 in the tabs below.
Required 6F1 Required 6F2
In the Excel template, using Goal Seek, calculate the total unit sales required to break even given the revised sales mix.
Unit sales to break even
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Accounting
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,
Accounting
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