• +44-190-022-0819 +44-190-022-0819
  • +1-248-268-9041 +1-248-268-9041
  • +61288800241 +61288800241

SEARCH SOLUTION

Search your solution from list of 1000+ questions

21-08-2018

Product code: Project report-AW321

 

Final Project Description – Revision 1

You are the lead systems engineer for Solar Photonics Inc., a company that designs, markets, and installs photoelectric cell (“solar cells”) panels for both the commercial and residential marketplace.

 

The company Vice President of Engineering has asked you to now perform a detailed systems engineering analysis, to determine a vendor/source that Solar Photonics shall use to manufacture its single line of photoelectric panels.    You are to return to the VP of Engineering in a month’s time, to present to her your analysis of the problem, and make a recommendation as to the supplier whom you and your team believe will do the best job of manufacturing and supplying the firm with the needed solar panels.

 

Over the course of your initial investigation, you narrow down your alternatives for the supplier that Solar Photonics will use to three (3) companies.   The three suppliers are:  Photonix, Solar Solutions Inc., and Sun Power Ltd.

Some selected metrics/parameters that your team has received from the three possible suppliers as a result of their proposed bids for the solar panels are as follows:

 

Photonix

Solar Solutions, Inc.

Sun Power, Ltd.

Cost per item/unit (Ci)

$195.00

$225.50

$265.00

Lead time to delivery (T)

9 weeks

5 weeks

13 weeks

Procurement Quantity (Q)

100 units per order

Demand rate (D)

25 units per period

Replenishment Rate (R)

200 units per period

Holding Cost (Ch)

$5.00 per unit per period

Shortage Cost (Cs)

$3.95 per unit per period

Procurement Cost (Cp)

$350.00 per procurement

$200.00 per procurement

$130.00 per procurement

           

 

  1.  Prepare an optimization study, for all 3 suppliers, to include the following parameters:  Q*, L*, and TC*.  Show your calculations, and then make a decision as to which supplier you would choose as a final vendor.

 

  1. Given the following estimated demand table for the solar panels (based upon marketing focus group data that your company has provided to you), perform a Break Even Analysis, showing: a) the breakeven point graph related to these parameters below, b) assuming the cost to manufacture the solar panels “in house” (upgrading Solar Photonics’ facility to be able to manufacture the panels yourself), whether it is better to make the panels or buy them from your chosen supplier.

 

 

Projected Demand in Units

 

10

15

20

25

30

35

40

Probability

.02

.02

.25

.35

.20

.15

.01

Cost to Make ($)

$2000

$3000

$4000

$5000

$6000

$7000

$8000

Cost to Buy ($)

TBD**

TBD**

TBD**

TBD**

TBD**

TBD**

TBD**

 

** NOTE:  this cost will be determined by the vendor that you end up choosing from step

 

For the Break Even Calculation, recall that the basic formulais:

TCM = TCB

For the purpose of this analysis, here are the formulas you need to use to do your Break Even Analysis:

                              TCM  =$8500 (fixed cost) + $80per unit

                              TCB  =  $TBD** x Number of units bought

**Again, the cost per unit to buy depends on the supplier you will select above in #1.  Also, the expected demand needs to be calculated as in your textbook example on Pg. 233, using the probabilities in the table above…

 

Be sure to put your team members’ full names and CINs on the cover sheet of your final report/write up, to be sure to include everyone on the project team…

 

 

 

 

Download Questions

Solution 1 Step 1:- Selection of Suppliers

Related Questions in (Other)

13-01-2018

Solution: The Journal of Helene Berr and Rue Ordener, Rue Labat 2 evidences that prove the difficulty and destructiveness that the people had to face in those four years. As mentioned by Berr (2009, p.23), in h ...

18-01-2018

Solution: Employee communication highlights the sharing of ideas and information. In this competitive business world, information exchange is essential among employees to develop team performance effectively. m ...

18-01-2018

Solution: As per Section 1 of the Thirteenth year plan describes about China’s two key objectives that will be accomplished if the National People’s Congress or the standing committee of this party passes t ...

18-01-2018

Solution: (Feldman 2005) reference information extraction to be one of the weightiest pre-processing method that escalates the text mining potential significantly. Pre-processing is an essential part in informa ...

18-01-2018

Solution: The pro forma income statement represents a trending statement that includes the probable net income value for the company considering the current growth and decline rates valid throughout the period ...

18-01-2018

Solution: Mode is defined as the value which occurs more frequently in the data set. The mode for non-business is 82 while for business is only 59. P value can be calculated from z table . As per z table p valu ...

18-01-2018

Solution: ABC assumes that there are different activities involved in different processes that cause costs andthe product, services, and customers are reasons for those activities. The UK customer segment is br ...

19-01-2018

Solution: Residual earnings valuation method is used to calculate the intrinsic value of the stock based on the expected residual income of the company in the coming years. The residual income is discounted bac ...