Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Include a screen shot of an excel workbook and any related formulas please :) FAE Technologies is deciding whether it should begin production of a

Include a screen shot of an excel workbook and any related formulas please :)

image text in transcribed

FAE Technologies is deciding whether it should begin production of a new toy robot. It has manufactured children's toys before but nothing as advanced as its latest robot so historical data is at a minimum. the company believes that they can secure the materials for manufacture for between $65-85 per unit and labor costs would be between $15-25 per unit. Management's expectations are that materials will cost $70 per unit and labor $25 per unit and that 800 units will be sold monthly. Should FAE decide to manufacture the robots in-house, maintenance of the factory machine would cost $15,000 per month. However, management has found that another alternative is for the company to outsource the labor for a flat rate of $35 per unit. the company expects to sell between 750-1000 units per month initially at a price of $149. Provide recommendations for FAE technologies that will maximize profit. Also, include base, worst, and best case scenario calculations and provide a scenario summary. Be sure to also consider the outsourcing alternative and make a recommendation on which alternative has the most profit potential. Lastly, include a breakeven number of units sold for the worst-case without outsourcing

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

Step: 3

blur-text-image

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part I Lnai 8724

Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo

2014th Edition

3662448475, 978-3662448472

More Books

Students also viewed these Databases questions

Question

4. Compare and contrast the practices of the two companies.

Answered: 1 week ago