Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show how you arrived at all answers through Excel. Please assist with formulas where possible. Neptune Company produces toys and other items for use

image text in transcribed

Please show how you arrived at all answers through Excel. Please assist with formulas where possible.

Neptune Company produces toys and other items for use in beach and resort areas. A small, inflat able toy has come onto the market that the company is anxious to produce and sell. The new toy will sell for $3 per nt. Enough capacity exists in the company's plant to produce 16,000 units of the toy each month. Variable expenses to manufacture and sell one unit would be $1.25, and fixed expenses associated with the toy would total $35,000 per month. The company's Marketing Department predicts that demand for the new toy will exceed the 16,000 units that the company is able to produce. Additional manufacturing space can be rented from another company at a fixed expense of $1,000 per month. Variable expenses in the rented facility would total $1.40 per unit, due to somewhat less efficient operations than in the main plant. Required: 1 Compute the monthly break-even point for the new toy in unit sales and in dollar sales. 2. How many units must be sold each month to make a monthly profit of $12,000? 3. If the sales manager receives a bonus of 10 cents for each unit sold in excess of the break-even point, how many units must be sold each month to earn a return of 25% on the monthly invest- ment in fixed expenses

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

Personal Finance An Integrated Approach

Authors: Bernard J. Winger

4th Edition

0198520972, 9780132696302

More Books

Students also viewed these Finance questions

Question

What do you think is the path to becoming a great data scientist?

Answered: 1 week ago