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


Search your solution from list of 1000+ questions


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:



Solar Solutions, Inc.

Sun Power, Ltd.

Cost per item/unit (Ci)




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

















Cost to Make ($)








Cost to Buy ($)









** 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:


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)


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 ...


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 ...


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 ...


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 ...


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 ...


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 ...


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 ...


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 ...