Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you provide explanations of all the answers please c Data entry in colored cells only. If colour formatting error, scroll up and down to
Can you provide explanations of all the answers please
c Data entry in colored cells only. If colour formatting error, scroll up and down to fix. Do not cut and paste cells. Try Last Month - Sales and Costs Short Long Medium = correct Sales Revenue 130,625 113,050 152.000 Try again Direct Costs 66,500 63,175 72,200 Indirect Costs 31,625 44.275 50,600 SurfCo makes three surfboard products: Short, Long and Medium. Operating Income 32,500 5,600 29,200 67,300 Sales Volume Ratio 25% 35% 40% Fixed Overhead 60,000 Total Sales Volume 9.500 Required: 1) Short Long Medium Calculate sales volumes of each product at breakeven. Sales Volume Unit Selling Price Unit Direct Cost Unit Variable Overhead Product Total Fixed Overhead SurfCo allocates fixed costs based on sales volume ratio. CM (per unit) Weighted Average CM Breakeven Point - Volume 2) Fixed Overhead How many units of each product to be sold to achieve Net Income of $58,800? Operating Income (i.e. pre-tax) Assume the same sales ratio and a tax rate of 30%. Sales Volume 3) Fixed Overhead SurfCo is considering introducing a new kids surfboard product. Total Sales Volume If the kids surfboard were introduced total sales are estimated to be 11,000. Short Long Medium Kids Production of the old surfboard priducts would decrease due to capacity constraints. Sales Volume Ratio 20% 25% 30% 25% Sales ratios of new product mix. Sales Volume Total sales will continue to be 9,500 units if the kids surfboard is not introduced. Selling Price The Kids surfboard would have a selling price of $28. Direct Costs Direct material and Direct labour together for a kids surfboard are estimated to be $15. Variable Overhead The variable overhead per unit of a kids surfboard would be $7. Fixed Overhead (total) Fixed costs would increase by $20,000. The new Kids product would involve expanding it's manufacturing capacity Sales Revenue Direct Costs Variable Overhead Fixed Overhead Operating Income Would Kids surfboards increase profit?Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started