For this excel problem you will not be provided with an excel template. Rather you will create your own excel worksheet that will display a differential analysis when a user inputs the appropriate data. Data set #1 Inputs: Total cost(s) to selling point $4 per unit Sales price without further processing $7 per unit The template you create will address a "sell or process further" problem. When the user inputs the data, a differential report will be displayed. There are examples of these reports in your text (Chapter 25) but you are free to experiment with alternative formats if you wish. Total cost(s) if processed further $7 per unit Sales price if processed further $11 per unit Check figure: All data, both input and output, will be in per unit amounts. The input data will consist of: Differential Income if processed further $1 per unit • Sales price per unit before processing further • Cost per unit before further processing • Cost per unit of additional processing • Sales price per unit after additional processing Data Set #2 Inputs: Total cost(s) to selling point $28 per unit Sales price without further processing $30 per unit Total cost(s) if processed further $34 per unit Sales price if processed further $35 per unit The output data (the data computed and displayed by your template) will consist of (at minimum): • The differential revenue of processing further • The differential cost of processing further • The differential income of processing further Check figure: Differential Income if processed further ($1) per unit Check data is provided on the next page:
For this excel problem you will not be provided with an excel template. Rather you will create your own excel worksheet that will display a differential analysis when a user inputs the appropriate data. Data set #1 Inputs: Total cost(s) to selling point $4 per unit Sales price without further processing $7 per unit The template you create will address a "sell or process further" problem. When the user inputs the data, a differential report will be displayed. There are examples of these reports in your text (Chapter 25) but you are free to experiment with alternative formats if you wish. Total cost(s) if processed further $7 per unit Sales price if processed further $11 per unit Check figure: All data, both input and output, will be in per unit amounts. The input data will consist of: Differential Income if processed further $1 per unit • Sales price per unit before processing further • Cost per unit before further processing • Cost per unit of additional processing • Sales price per unit after additional processing Data Set #2 Inputs: Total cost(s) to selling point $28 per unit Sales price without further processing $30 per unit Total cost(s) if processed further $34 per unit Sales price if processed further $35 per unit The output data (the data computed and displayed by your template) will consist of (at minimum): • The differential revenue of processing further • The differential cost of processing further • The differential income of processing further Check figure: Differential Income if processed further ($1) per unit Check data is provided on the next page:
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
FYI: THIS IS AN ACCOUNTING EXCEL PROBLEM - NOT A COMPUTER SCIENCE PROBLEM!
Please read the instructions carefully in the picture that I posted.
For this accounting practice problem, please create an excel worksheet based off of the information in the picture.
Thank you!!!
Transcribed Image Text:For this excel problem you will not be provided with an excel
template. Rather you will create your own excel worksheet that
will display a differential analysis when a user inputs the
appropriate data.
Data set #1
Inputs:
The template you create will address a "sell or process further"
problem. When the user inputs the data, a differential report will
be displayed. There are examples of these reports in your text
(Chapter 25) but you are free to experiment with alternative
formats if you wish.
Total cost(s) to selling point $4 per unit
Sales price without further processing $7 per unit
Total cost(s) if processed further $7 per unit
Sales price if processed further $11 per unit
Check figure:
All data, both input and output, will be in per unit amounts. The
input data will consist of:
Differential Income if processed further $1 per unit
• Sales price per unit before processing further
• Cost per unit before further processing
• Cost per unit of additional processing
• Sales price per unit after additional processing
Data Set #2
Inputs:
Total cost(s) to selling point $28 per unit
Sales price without further processing $30 per unit
Total cost(s) if processed further $34 per unit
Sales price if processed further $35 per unit
The output data (the data computed and displayed by your
template) will consist of (at minimum):
• The differential revenue of processing further
• The differential cost of processing further
• The differential income of processing further
Check figure:
Check data is provided on the next page:
Differential Income if processed further ($1) per unit
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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