Question: could you please complete this, and show steps on excel thank you Sheridan Sawmill Co, runs rough logs through its cutting facility for the primary

could you please complete this, and show steps on excel thank you

Sheridan Sawmill Co, runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is of high enough quality to be sold as hardwood lumber. The other joint product, lower-grade: lumber, has been sold as-is to other manufacturers to make wood pallets. Last year, the following quantities and sales prices were reported. Paul, the sawmill owner, is meeting with other top managers as they consider avenues for increased profitability. They recognize that selling the lower-grade wood to other companies has certainly helped the mill's bottom line. However, they wonderif they could further process this wood themselves and make even more of a return. Determine the gross margin levels and percentages Paul is looking at for last year's results (assume all products produced were sold). Use the sales value at split-off method to allocate joint costs. (Round proportion to 4 decimal ploces, e. 0.2516, allocated joint costs and gross margin to 0 decimai places, e8.5.125 and gross margin percentage to 2 decimal places, e8. 15.25\%)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Sheridan Sawmill Co . runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is of high enough quality to be...

Oriole \& Sons produces tomato juice and tomato puree from fresh tomatoes grown by local farmers. The company purchases large crates of tomatoes and then washes, sorts, scalds, peels, and crushes...

Current Attempt in Progress Sheridan Sawmill Co . runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is...

Sheridan Sawmill Co. runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is of high enough quality to be...

Bramble Sawmill Co. runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is of high enough quality to be...

Oriole Sawmill Co . runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is of high enough quality to be...

If the outlook for low-grade lumber sales to manufacturers changes such that Bramble Sawmill will only be able to sell these lowgrade products for $1.75 per board foot at the split-off point, does...

Bramble Sawmill Co. runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is of high enough quality to be...

Tamarisk Sawmill Co. runs rough logs through its cutting facility for the primary purpose of producing hardwood lumber. In this process, however, not all of the wood is of high enough quality to be...

Draw the parallelogram spanned by the vectors Then draw its image under the linear transformations defined by the following matrices: 2 2and3 1.2 12 0 0')) 12 24

A study reports that 26% of 4-year college graduates nationwide who majored in biology obtain a job related to biology within 1 year of graduation. Fifteen 4-year colleges in one state compare their...

1. Discuss the differences between statistics as numerical facts and statistics as a discipline or field of study.

Give the analytic solution to the logistic equation that you set up. Hint: separation of variables and partial fraction decomposition. Let the initial condition be P(0)=P0. Solve for the constant in...

Analyse and critically Evaluate Dorian executives decisions concerning the selection of crew, by examining the cultural compatibility.

What expatriate behavior is best for Japanese managers who are sent to Germany?

Identify the difficulties in communication between bidder managers and target employees that are apparent in the case study?