Reference no: EM133114827
Electro-cycle Inc. is a privately-owned business located in Vancouver. It has found success with the production of electronic bikes (e-bikes), a growing trend in the cycling industry. E-bikes give people the option to use battery power as an alternative to pedalling. Electro-cycle was founded eight years ago by two brothers, Ryan and Rob, who love the outdoors. Ryan suffers from severe asthma and had to stop cycling until he discovered e-bikes, so he is very passionate about the business. Both brothers are very involved with the business and have a hard time giving up any control. Given that the business is seasonal, growth is heavily dependent on the weather; however, the company is seeing a steady growth pattern overall.
Third-quarter results are in, and cost of goods sold is higher than anticipated. A direct material that had some variance in the period is the aluminum used in the bikes. In order to offset the higher cost of aluminum, the board wants to look at the motor suppliers to see if material costs can be reduced in this area. Electro-cycle currently uses a local supplier, Cumba, with a cost of $125 per unit. Use Power BI, by referring to Appendix I, to provide an analysis of the supplier options to present to the board. The data is found in the file called "IF1-2102E-PP06.Data-03.xlsx".
Required:
The board would like you to:
i. Create a card visualization of how many suppliers there are.
ii. Create a map visualization of the supplier locations.
iii. Create a table of the average cost per bike for each supplier location.
iv. Conclude on whether Electro-cycle could reduce costs by changing to local suppliers.
Hint: Your visualization must be selected before you can work on it. To select your visualization, simply click on it in Power BI.
|
Supplier
|
Location
|
Unit Motor Cost
|
Unit Shipping Cost
|
|
Schwimm
|
Vancouver
|
130
|
0
|
|
Bacchella
|
Sudbury
|
120
|
10
|
|
BNC
|
Charlottetown
|
105
|
15
|
|
Borel
|
Gatineau
|
125
|
10
|
|
Cumba
|
Vancouver
|
125
|
0
|
|
Cycle Pro
|
Guelph
|
115
|
10
|
|
Torco
|
Edmonton
|
120
|
5
|
|
What is the break--even ebit
: Rolston Corporation is comparing two different capital structures, an all--equity plan (Plan I) and a levered plan (Plan II). Under Plan I, Rolston would have 2
|
|
Explain the great recession impact
: Certainly, Alan Greenspan is highly regarded as one of the most well-known Federal Reserve chairmen. How does the impact of his leadership during the Great Rece
|
|
Real interest rate in a small open economy
: How would each of the following affect national saving, investment, the current account balance, and the real interest rate in a small open economy?
|
|
Explain your judgments with evidence-based research
: Discuss the policies and programs that support your selection. Explain your judgments with evidence-based research.
|
|
Create a card visualization
: Electro-cycle Inc. is a privately-owned business located in Vancouver. It has found success with the production of electronic bikes (e-bikes), a growing trend i
|
|
Determine hyeyoung maximum rrsp deduction
: In 2020 she has several periods of part time employment and has earned income of $17,300. Determine Hyeyoung's maximum RRSP deduction for 2021
|
|
Compute the personal tax rate
: You are a shareholder in a C corporation. The corporation earns $1.77 per share before taxes. Once it has paid? taxes, it will distribute the rest of its earnin
|
|
Journal entries for the lessee
: Journal Entries for the Lessee for 2019, 2020, and 2024. And show the solutions of arrived amounts in good form
|
|
Explain the fundamental trade-off between risk and return
: Briefly explain the fundamental trade-off between risk and return.
|