Reference no: EM131381763
Optimal Channel Decision
1. Spark, a new vendor which manufactures electric bikes & boats has provided quotations for a few SKUs and their replacement batteries. Although introducing the products into the assortment seems promising (every Canadian Tire store is expected to order ten units of each product this year), a decision will need to be made as to which channel is most profitable.
You will find relevant information in the spreadsheet shared with you via email. Can you assist our Merchandising team in determining what the optimal channel should be for each SKU?
What would be the estimated difference in cost for shipping an individual unit of bike #2 direct from the vendor to all stores compared to shipping it out from our DCs in the storage channel?
2. If Canadian Tire decided to proceed with only the boat SKU and the channel that would offer the quickest service to stores, how many stores should be serviced from each of the vendor's two available manufacturing facilities?
3. Spark has been growing rapidly and have plans to expand their operations by building new facilities in Vancouver, Montreal, and Halifax. They have offered Canadian Tire the option of shipping product directly to stores from these new locations in the near future. To help determine the optimal vendor facility to Canadian Tire store mapping, could you help outline what a linear program to find the best solution may look like by identifying key variables, constraints and an objective function?
4. Was there any information that you felt was missing which may have helped make a better decision in questions 1 & 2 above?
5. Was there anything in the data provided that appeared to be incorrect?
Attachment:- Assignment.rar
|
Compute the companys weighted average cost of capital
: Calculate the company's weighted average cost of capital. Use the dividend discount model. Show calculations in Microsoft Word.
|
|
What is the new regression equation
: b. Force the regression line through the origin. What is the new regression equation? Predict Y when X 10 with this equation.
|
|
Definition of the tort of negligence
: Definition of the Tort of Negligence. Definition and analysis of the 3 elements of theTort of Negligence.What are the requirements that must be met to establish the Duty of Care, Breach of Duty and Causation/Damage?Discuss at least one case to illust..
|
|
Describe the assumptions used to make these estimates
: Describe the assumptions used to make these estimates. Include an overview of the budget in the report, presenting the actual budget as an appendix with all data and calculations.
|
|
Determining what the optimal channel should be for each sku
: You will find relevant information in the spreadsheet shared with you via email. Can you assist our Merchandising team in determining what the optimal channel should be for each SKU
|
|
What kind of bias may be present here
: If we combine them, considering the overall group to be one larger random sample of 1020 respondents, what is a 95% confidence interval for the proportion of the general public that thinks the death penalty is being fairly applied?
|
|
How is the company organized and managed
: MBA 520- How is the company organized and managed (e.g., by product groups, geographic region, function, etc.)? How does that affect accounting and financial information and subsequent business decisions?
|
|
What was the standard error of the slope estimate
: The sample was of 2,058 firms, and the regression slope estimate was 0.051. The reported p-value was 0.034. What was the standard error of the slope estimate? Interpret the findings.
|
|
Is there statistical evidence of a linear relationship
: A regression analysis was performed to assess the impact of the perception of risk on the frequency of online shopping.- Is there statistical evidence of a linear relationship between frequency of online shopping and the level of perceived risk?
|