Recent Question/Assignment

Unit Title: Business Data Analysis
Unit Code: BSS002-6
Assessment 1: Individual Report (50%) – It is expected that each student work independently on all the tasks set out in this assignment, applying problem solving strategies and selecting appropriate techniques in modelling and simulation in order to produce an individual report according to the guidelines provided. This individual work must be your own work only with no consultation with others. The individual report must not exceed 2,000 words.
There will be an oral viva ONLY for those individual reports which exceed the similarity index of 25% produced by Turnitin.
Assignment Title: “A Solar-Powered Camping Tent”
Issued date: Week One: Monday 17/11/2014
Submission due date:
Week Nine: Friday 02/02/2015: A single report per student should be submitted via the TURNITIN link in the Assessment folder.
Unit co-ordinator’s name: C F Shooshtarian
Grading/
Criteria A+ A A- B+ B B- C+ C C- D+ D D- E
80-100 75-79 70-74 67-69 64-66 60-63 57-59 54-56 50-53 47-49 44-46 40-43 35-39
LO1: Conduct an Exploratory Data Analysis to critically appraise the data Task 2:Critically appraise the discrepancy between the empirical distributions of model and data Task 2: Construct appropriate charts and statistical summary measures according to the nature of the data
Assess the hidden features of the data and its distribution
Task 2: Construct appropriate charts and statistical summary measures according to the nature of the data with minor errors
Assess the hidden features of the data and its distribution with minor errors Task 2: Construct appropriate charts and statistical summary measures according to the nature of the data with minor errors
Task 2: Construct charts and statistical summary measures with errors
Grading/
Criteria A+ A A- B+ B B- C+ C C- D+ D D- E
80-100 75-79 70-74 67-69 64-66 60-63 57-59 54-56 50-53 47-49 44-46 40-43 35-39
LO3: Plan, design, formulate and construct business models where there is uncertainty present Tasks 1 and 2:
(a) Develop a financial planning model and consider different scenarios as fully as you can
(b) Use Monte Carlo Simulation to develop a profit model using the given probability distributions and conduct a “what if” analysis to consider alternativeswith clear discussions Tasks 1 and 2:
(a) Develop a financial planning model and consider different scenarios
(b) Use Monte Carlo Simulation to develop a profit model using the given probability distributions and conduct a “what if” analysis to consider alternatives Tasks 1 and 2:
(a) Develop a financial planning model and consider different scenarios
(b) Use Monte Carlo Simulation to develop a profit model using the given probability distributions Tasks 1 and 2:
(a) Develop a financial planning model with minor errors
(b) Use Monte Carlo Simulation to develop a profit model using the given probability distributions with minor errors Tasks 1 and 2:
Develop a financial planning model with errors and attempt at using Monte Carlo Simulation to develop a profit model with errors
Grading/
Criteria A+ A A- B+ B B- C+ C C- D+ D D- E
80-100 75-79 70-74 67-69 64-66 60-63 57-59 54-56 50-53 47-49 44-46 40-43 35-39
LO5: Research, synthesise and produce a technical report Communicate your findings clearly and concisely. Recommend solutions to provide a better insight to the problem.Justifying your choice in a technical report which has a
clear structure and logical sequence;
tables, diagrams and figures are appropriate, clearly labelled and interpreted;
accuracy;
objectivity;
continuity;
conciseness. Communicate your findings clearly and concisely. Recommend solutions to provide a better insight to the problem. Justifying your choice in a technical report which has a clear structure and logical sequence.
Communicate your findings clearly and concisely. Recommend solutions to provide a better insight to the problem.A report which has a clear structure and logical sequence.
Communicate your finding in your report and recommend solutions to provide a better insight to the problem.
Communicate your finding in your report.

A Solar-Powered Camping Tent


The Concept Tent (also known as the solar powered tent) was thought up because of demand by nomads, recreational campers, and disaster victims. Tents are typically used as overhead shelter for festivals, weddings, backyard parties, and major corporate eventsand the fact that all tent users need to keep in touch with their families, friends and colleagues while they’re for example, camping and roaming around the festival site.
Kaleidoscope and OrangeCompany designed it in partnership to celebrate Glastonbury Festival. Its design is the revolutionary new way it collects direct sunlight. The idea is that specially coated solar threads are woven into conventional fabric so designers wouldn’t have to use fixed solar panels to harness the energy. It would also have three directional glides that can be moved throughout the day to maximise solar efficiency and energy collection.
But the most amazing bit about this concept solar powered tent is its central wireless control hub which lets you see the amount of energy being generated and used, as well as sending out a wireless internet signal for anyone who needs to surf the internet.
The control hub also has a wireless charging pouch which powers mobile phones and other portable devices without the need for messy wires and multiple chargers. The ‘magnetic induction’ technology passes an electric current through a coil embedded in the charging pouch and this in turn generates a magnetic field which creates a charge and powers the battery.
Also controlled by the central hub is the most amazing bonus for the ultimate posh camping experience… an internal heating system. This takes the form of a heating element that’s embedded within the tent’s groundsheet giving under floor heating that can be triggered automatically once the temperature falls below a set level.
The market demand for the Concept Tent is estimated to be 2,000 units in its first year of production and expect to increase sales by as much as 10% per annum thereafter. The variable costs per unit are estimated as follows: raw materials, £8.00; packaging, £2.00; direct labour, £5.00; distribution, £3.00.
The inflation rates for the next three years are forecast to be 3%, 5% and 6%. Inflation will affect variable costs for the product but fixed costs are likely to remain at the same level of £10,000 over the next four years. In calculating profits over the next four years, the tax rate can be taken as 20%. Kaleidoscope and Orange intend to sell the Concept Tent at £65 for the first year with an annual increase of £2.00 thereafter.
Task 1
(a) Kaleidoscope and Orange have asked you to develop a financial planning model so that they can determine how net profits would be affected by changes in planned sales volume and product price over years 2 to 4.
(b) Having built the financial planning model, Kaleidoscope and Orange now want to look at three ‘what-if’ scenarios.
• Scenario 1: Suppose inflation is predicted to be 2.5% during the second year and 3% thereafter. What would be the profitability of the new concept tent in these circumstances?
• Scenario 2: Suppose the Company decides to sell 3% more units per year as well as increasing the current selling price by 10% per year. What would be the effect on the ‘net profit after tax’ for each year?
• Scenario 3:Suppose that Kaleidoscope and Orange decides to vary the projected sales volume over a range from -5% to 10% of the initial assumption. The company wants to see how the ‘Net profit after tax’ would change as the projected sales volume changes.
Kaleidoscope and Orange have decided to make a major capital investment in the introduction of a Rainwear that acts as smart as it looks. Effective rainwear keeps out the rain, but no membrane breathes well enough to keep you comfortable during exertion. When rainwear is necessary, this design offer unique physical venting approaches to keep you more comfortable.
There is usually a large amount of uncertainty associated with the development and marketing of any new product, e.g., the size of potential sales, the ideal selling price of the product, and the manufacturing costs. These uncertain factors are best represented by appropriate probability distributions, and the project’s profitability can then be investigated using simulation. Such an approach is generally referred to as ‘risk analyses.
Kaleidoscope and Orange has asked you to perform a risk analysis on the marketing of their new rainwear product. The capital investment required to market the product is £12,000. The factors associated with the new product and their respective probabilities are provided in Table 1.0 below:

Table 1.0: The factors associated with the new product and their respective probabilities
Selling Price Probability Variable Cost Probability Sales volume Probability
£32
£34
£37 0.3
0.4
0.3 £8
£10
£12 0.4
0.4
0.2 10,000
15,000
20,000 0.25
0.50
0.25
Task 2
Prepare a report that discusses the general development of the spreadsheet simulationmodel, and make any recommendations that you have regarding:
(a) The worst and best results obtained in a simulation of 1000 trials;
(b) The mean profit and its corresponding risk;
(c) How the profit values are distributed over their range, and what profit values are most likely;
(d) The probability of a loss;
(e) Critically appraise the simulation approach to risk analysis.