Question: please help me solve on excel with this same template! please show formulas. thanks in advance!!! Flextrola, Inc., an electronics systems integrator, is planning to

please help me solve on excel with this same
please help me solve on excel with this same
please help me solve on excel with this same template! please show formulas. thanks in advance!!!
Flextrola, Inc., an electronics systems integrator, is planning to design a key component for their next-generation product with Solectrics. Flextrola will integrate the component with some software and then sell it to consumers. Given the short life cycles of such products and the long lead times quoted by Solectrics, Flextrola only has one opportunity to place an order with Solectrics prior to the beginning of its selling season Flextrola's demand during the season is normally distributed with a mean of 1,000 and a standard deviation of 600. Solectrics production cost for the component is $52 per unit and it plans to sell the component for $72 per unit to Flextrola. Flextrola incurs essentially no cost associated with the software integration and handling of each unit Flextrola sells these units to consumers for $121 each Flextrola can sell unsold inventory at the end of the season in a secondary electronics market for $50 each. The existing contract specifies that once Flextrola places the order, no changes are allowed to it. Also, Solectrics does not accept any returns of unsold inventory, so Flextrola must dispose of excess inventory in the secondary market. a What is the probability that Flextrola's demand will be within 25 percent of its forecast? 6. What is the probability that Flextrola's demand will be more than 40 percent greater than its forecast? c. Under this contract, how many units should Flextrola order to maximize its expected profit? For remaining parts, assume Flextrola orders your answer in part.c... d. What are Flextroia's expected sales? e. How many units of inventory can Flextrola expect to sell in the secondary electronics market? g. What is Flextrola's expected profit? h. What is Solectrics' expected profit? Alignment B18 B D 1000 600 52 72 $ $ $ $ 121 50 1 demand mean 2 demand stddev 3 production cost 4 wholesale price 5 final price 6 salvage value 7 Cu 8 Co 9 Critical ratio 10 Prob demand within 25% of mean 11 Prob demand more than 40% of mean 12 optimal order quantity 13 Expected lost sales if Q=Q* 14 Expected sales 15 Expected leftover inventory 16 Expected profit for Flextrola 17 Expected profit for Solectric 18 1011.90 19 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!