Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Everything you type in the cells should be a formula or reference to other cells (e.g., they should all start out with the equals sign

Everything you type in the cells should be a formula or reference to other cells (e.g., they should all start out with the equals sign "=").

DON'T DISPLAY NUMBER VALUES, REFER TO OTHER EXCEL CELLS OR SHOW FORMULAS TO GET ANSWERS.

image text in transcribedimage text in transcribed

Below is information for Excel Problem \#4. The information has also been input into the spreadsheet provided for you to submit your solution. The three questions asked on the spreadsheet are: 1. Complete chart provided (similar to the example in the text on page 535) to illustrate the financial advantage or disadvantage of further processing of each product (be sure disadvantages appear as negative numbers). ( 3 points) 2. Based on the chart in question \#1 which product(s) should be sold at split-off and which processed further? (1 point) 3. Complete the schedule provided to compute the total profits earned if units are sold as indicated by your answer to question \#2. (6 points) Excelsior Company manufactures three products in a joint process that costs $90,000. Initial processing results in the following number of units of each product: At the initial split off point the products can be sold for the prices below: Instead of selling the products at split off, Excelsior could spend an additional $150,000 to process Product A further, which would result in a new sales price for Product A of $50 per unit. Excelsior could also process Product B further at a cost of $45,000, which would result in a new sales price for Product B of $40 per unit and could process Product C further at a cost of (use the last five digits of your student ID for the cost of further processing Product C), resulting in a new sales price for Product C of $25 per unit. REQUIRED 1 Complete the chart below (example on page 535 of text) to illustrate the financial aduantage or disaduantage af further processing of each product. Be sure disadvantages appear as negative nunbers. Product A Product B Product C Total Sales value after further processing Less sales value at split off Incremental reverue from further processing Less cost of further processing Financial advantage (disadvantage) of further processing 2 Based on your chart in question 1 , which of the product(s) should be sold at the split off point and which processed further? (1 POINT) 5old at split off Processed further Product A Praduct B Praduct C 3 Complete the schedule provided to compute the total profit earned if units are sold as indicated by your answer to question 2 (6 POINTS) Total Sales Total joint costs Total further processing costs Profit Sheet1 Below is information for Excel Problem \#4. The information has also been input into the spreadsheet provided for you to submit your solution. The three questions asked on the spreadsheet are: 1. Complete chart provided (similar to the example in the text on page 535) to illustrate the financial advantage or disadvantage of further processing of each product (be sure disadvantages appear as negative numbers). ( 3 points) 2. Based on the chart in question \#1 which product(s) should be sold at split-off and which processed further? (1 point) 3. Complete the schedule provided to compute the total profits earned if units are sold as indicated by your answer to question \#2. (6 points) Excelsior Company manufactures three products in a joint process that costs $90,000. Initial processing results in the following number of units of each product: At the initial split off point the products can be sold for the prices below: Instead of selling the products at split off, Excelsior could spend an additional $150,000 to process Product A further, which would result in a new sales price for Product A of $50 per unit. Excelsior could also process Product B further at a cost of $45,000, which would result in a new sales price for Product B of $40 per unit and could process Product C further at a cost of (use the last five digits of your student ID for the cost of further processing Product C), resulting in a new sales price for Product C of $25 per unit. REQUIRED 1 Complete the chart below (example on page 535 of text) to illustrate the financial aduantage or disaduantage af further processing of each product. Be sure disadvantages appear as negative nunbers. Product A Product B Product C Total Sales value after further processing Less sales value at split off Incremental reverue from further processing Less cost of further processing Financial advantage (disadvantage) of further processing 2 Based on your chart in question 1 , which of the product(s) should be sold at the split off point and which processed further? (1 POINT) 5old at split off Processed further Product A Praduct B Praduct C 3 Complete the schedule provided to compute the total profit earned if units are sold as indicated by your answer to question 2 (6 POINTS) Total Sales Total joint costs Total further processing costs Profit Sheet1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Audit Customer Satisfaction Marketing Added Value

Authors: Cindy E. Cosmas

1st Edition

089413373X, 978-0894133732

More Books

Students also viewed these Accounting questions

Question

3. Identify cultural universals in nonverbal communication.

Answered: 1 week ago

Question

2. Discuss the types of messages that are communicated nonverbally.

Answered: 1 week ago