Reference no: EM132484303

The Flying store

Mark Richardson has recently opened an online store named The Flying Store. He sells a very popular model of drone called the ‘Rocket Drone'. In an effort to widen his market, Mark has built a small website hosted by a web service provider. At the end of every week, the web service provider sends a data file to Mark that contains data about visitor traffic at his website. Mark would like to utilise this data to get insights on visitor usage of his website and he believes that the data would be valuable for business decision making. However, Mark lacks the technical knowledge to analyse and interpret this data and he is unsure how the results from the analyses can be used for making business decisions.

At the end of first week, Mark received a data file on visitor traffic. He decides to hire you so that you could assist him to analyse and interpret the data. The table 1 shows the first data file that Mark received on visitor usage of his website.

While Mark's website was visited only five times in the first week, Mark is expecting the number of visits to go up over time. Before the he gets more real data from the web service provider in the coming weeks, Mark wants to explore the possible analyses that can be done with this data. Mark handed you a document listing specific instructions on what he expects you to do in Excel. The instructions are listed below
Requirements

(1) Mark noted, "I want to use the data on website visitors to develop my monthly budget. I have gathered the following information that I believe can be useful for budget development.

• 50% of the customers who spend more than 3 minutes on my website end up buying 1 drone. 20% of the customers who spend more than 5 minutes buy 2 drones.
• I buy each drone from a drone manufacturer for $450. The selling price for each drone is $600.
• Each drone is packed and delivered separately. Even for the customers who order multiple drones, I deliver each drone separately. Customers are not charged any additional delivery fees as I pay for the delivery. I deliver drones through StartTrack Delivery Services. The delivery costs vary across states. Their chart of delivery fees is listed below."

Create a ‘Budget Summary Report' worksheet. Include a table with a column for the state, estimated quantity, total incomes, total expenses and expected profit. The values for the estimated quantity column should be linked to the ‘Visitor Data' worksheet. Use appropriate functions to fill out the remaining cells of the table. (A sample table below is shown in figure 2.)

Please prepare table (same as above table).

(2) create a worksheet labelled as ‘Analysis and Recommendation'. This worksheet should contain the following three sections.
a. Findings - Briefly summarise your findings based on the analysis performed in requirement 2 to requirement 6.

b. Recommendation for additional analysis - In this section, you should comment on whether additional analyses can be performed using the types of data that Mark currently gets from the web service provider. You should provide two examples of additional analyses that can be performed using the given data and explain how to perform those analyses. Comment on how these additional analyses would help Mark to make business decisions.

c. Recommendation for additional data - Currently there is an option for Mark to get other types of data on his website visitors by paying an additional fee to the web service provider. Provide practical examples of two additional types of data that Mark should collect on his website visitors. Suggest the types of analyses that can be done using these additional data. Comment on how these analyses on additional data would help Mark to make business decisions.

Attachment:- The Flying store.zip