Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need answer in excel please. Part 1: The sales manager of Jumanji Sales is considering expanding sales by producing three different versions of their

image text in transcribedI need answer in excel please.

Part 1: The sales manager of Jumanji Sales is considering expanding sales by producing three different versions of their product. Each will be targeted by the marketing department to different income levels and will be produced from three different qualities of materials. After reviewing the sales forecasts, the sales department feels that 65% of units sold will be the original product, 20% will be new model #1 and the remainder will be new model #2. The following information has been assembled by the sales department and the production department. Original Model #1 Model #2 Sales proce (per unit) $50.00 $ 35.00 $ 25.00 Material cost $21.75 $ 15.00 $ 10.00 Direct labor $10.50 $ 7.75 $ 5.00 Variable overhead $ 7.25 $ 5.00 $ 3.00 The fixed costs associated with the manufacture of these three products are $250,000 per year. Required: (a) Determine the number of units of each product that would be sold at the break-even point. (b) Determine the break-even point if the sales estimates are instead 50% original product, 30% model #1 and the remainder model #2

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_2

Step: 3

blur-text-image_3

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

Financial Markets And Institutions

Authors: Peter Howells, Keith Bain

5th Edition

0273709194, 9780273709190

More Books

Students also viewed these Accounting questions

Question

What has been your desire for leadership in CVS Health?

Answered: 1 week ago

Question

Question 5) Let n = N and Y Answered: 1 week ago

Answered: 1 week ago

Question

Explain the development of human resource management (HRM)

Answered: 1 week ago