Question

The Big Easy Company is a fictitious conglomerate with divisions in the retailing, manufacturing, and insurance industries. The retailing division consists of a chain of office supply stores known as Super Broke. You are the divisional controller of Super Broke. Pricing and product-line strategy decisions at Super Broke are made by the CEO, Steve Rogers, with input from the Vice President of Marketing. Fallout’s VP of Marketing has just resigned, and the CEO wants to reevaluate the pricing and product-line strategy decisions for each division. Big Easy’s CFO has asked you to complete this assignment for Super Broke without her assistance. For the purpose of deciding about pricing and product-line strategy at Super Broke, you are to provide the CEO with an interactive report presenting the sales and profits of Super Broke for the last three years. Be sure to compare sales and profits side-by-side in the same chart. You want the CEO to get the best impression of Super Broke’s performance.

. Write a one-page memo to the CEO describing the data and how Tableau can be used to assist management in making additional pricing and product line strategy decisions. Note - The memo should not read like a marketing piece for Tableau. The focus of the memo is the output of your review of the data, your recommendations to the CEO, and how Tableau could be used to make additional decisions.

I just need an idea on how to start and what to include. Thank you.

Answer 1

Dear Friend,

The question stresses on asking us to prepare the memo by considering the Financials of last three years. So, it would be better if you can take some real financials of any company or a partnership firm to be simple and then make percentages of each. It can be as the below image:

While preparing Financials make sure that there is a growth in every aspect and it should impress your CEO. Based on the financials, make your review and prepare a memo out of it like how there is a growth taking place, how you are able to minimise the cost or the cost cutting measures you are taking place in your Super Broke should be explained. If in case when there are low sales in any period, how did you manage to maintain the same level of profit as of last period, etc etc can be measured and I am sure that you will be reaching to two pages of memo :)