Question: Part#2 - Perform the appropriate calculations (in Excel) required to analyze and determine the answers to the following key questions. Note any assumptions in

Part#2 - Perform the appropriate calculations (in Excel) required to analyze and

Part#2 - Perform the appropriate calculations (in Excel) required to analyze and determine the answers to the following key questions. Note any assumptions in the "...Assumptions.." tab. Use the "supporting calculations" tab for all calculations. Populate the "summary" tab with the finals costs. Include answers to all questions in your written report. 1. Calculate relevant costs for the remaining sanding alternatives. Evaluate options for reducing sanding time on the imminent opportunities, recommending the best option with calculations and reasoned explanations. Discuss whether this option is also optimal long term. 2. Using normal costing, determine the cost of making a 1 small & 1 medium cutiting board for all scenarios (ex: Adam does all the sanding or avails one of the three options outlined in the case). Calculate profit margins for each size board for all scenarios. Consider Suzie's price and analyze profitability on an hourly basis. Determine which size board is most profitable. Recommend whether to produce small or medium cutting boards. 3. Advise on whether Adam should commit to making the headboard for his friend. Identify qualitative factors influencing the decision. If committed, suggest an appropriate charge for the headboard.

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!