Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Citrus company buys a variety of citrus fruit from growers and then processes the fruit into a product line of fresh fruit, juices, and
Citrus company buys a variety of citrus fruit from growers and then processes the fruit into a product line of fresh fruit, juices, and fruit flavorings. Current cost structure: Current annual sales revenue Current Variable costs Current Fixed costs totaled Contribution $2,000,000 44% of Sales $600,000 $1,120,000 Required: Answer the following questions below the question and use cell references to make your computations. 1. What is the current contribution margin ratio? $ Contibution Margin Ratio is 56.00% 56.00 What is the current break-even point in sales dollars? $1,071,428.57 Break even point in sales is $1,071,429.00 3. Determine the margin of safety in sales dollars. $928,571 Margin of Safety in dollars is $928,571.00 56% 4. Prepare a Contribution margin income statement for the current sales. Sales Less Variable costs Contribution margin Less Fixed costs Profit $2,000,000 $880,000 $1,120,000 $600,000 $520,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Answer To calculate the required values using cell references in Excel you can follow these steps 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